Changes

This page is mainly for DIYers with at least some knowledge of [[Excel]] or other spreadsheet software.  Previous steps would be choosing a [[:Category:Tools|Tool]] or [[Aggregators|Aggregator]]. Some tools give data straight to the user. This page is the set of steps after receiving data. Check if the device or app produces correct data soon after first use.  

This page is mainly for DIYers with at least some knowledge of [[Excel]] or other statistical analysis software.  Previous steps would be choosing a [[:Category:Tools|Tool]] or [[Aggregators|Aggregator]]. Some tools give data straight to the user. This page is the set of steps after receiving data. Check if the device or app produces correct data soon after first use.  

==== File Format ====

==== File Format ====

==== Structure ====

==== Structure ====

Statistical analysis of self tracking data is usually done on tabular data, like spreadsheets, with rows representing individual observations.<ref>https://r4ds.had.co.nz/tidy-data.html</ref><ref>https://en.wikipedia.org/wiki/Relational_database</ref> In all but a few cases this is sufficient structure.  

Statistical analysis of self tracking data is usually done on tabular data, like spreadsheets, with rows representing individual observations.<ref>https://r4ds.had.co.nz/tidy-data.html</ref><ref>https://en.wikipedia.org/wiki/Relational_database</ref> In all but a few cases this is sufficient structure. See also [[Dates and Times]].  

* A variable that depends on previous values of this same variable is not independent and is called auto-correlative? and non-stationary. For example skills at playing the guitar.

* A variable that depends on previous values of this same variable is not independent and is called auto-correlative? and non-stationary. For example skills at playing the guitar.

* Randomness of Missingness. Similar to independence but its not the value of the variable but whether other measured variables could correlate with higher incidence of missing values. For example forgetting to charge the smart band because of tiredness and having a night without it on.

* Randomness of Missingness. Similar to independence but its not the value of the variable but whether other measured variables could correlate with higher incidence of missing values. For example forgetting to charge the smart band because of tiredness and having a night without it on.

* Target. Level. Is this variable something you want to improve, or a variable likely to affect those or just an intermediary background variable measured because it was easy and provided context?

* Target. Level. Is this variable something you want to improve, or a variable likely to affect those, or just an intermediary background variable measured because it was easy and provided context? If this is a target variable, mention the purpose of of tracking such as [[Life extension]], your doctor told you based on [[Lab tests]], or are you trying to improve performance [[Sports]].

* Similarity. Proxy. Is this variable measuring something very similar to what another variable is measuring. The most common example is [[Tools for heart rate or pulse|heart rate]] as many wearable measure it and the avid self tracker always has a few.

* Similarity. Proxy. Is this variable measuring something very similar to what another variable is measuring. The most common example is [[Tools for heart rate or pulse|heart rate]] as many wearable measure it and the avid self tracker always has a few.

* Sign. Positivity. If variable is a target, are higher values better or the opposite. Sometimes some middle value is best like with BMI.

* Sign. Positivity. If variable is a target, are higher values better or the opposite. Sometimes some middle value is best like with BMI.

== References ==

== References ==

<references />

<references />

 

[[Category:Topics]]

[[Category:Data analysis]]