{"text_format":"3","workbook":"xls","n_sheets":6,"sheets":["0-50m","50-100m","100-150m","150-200m","1-way","2-way"],"not_rendered":{"charts":80,"external_links":1,"defined_names":1,"comments":226},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"0-50m","index":0,"n_rows":154,"n_cols":30,"rows_kept":154,"merged":[[75,9,75,10],[85,9,85,10],[92,24,92,25],[102,24,102,25]],"flags":["formulas_cached_only"]}
[null,"CONSECUTIVE PAIRWISE ANALYSIS OF TRIALS FOR RELIABILITY"]
[null,"Hover cursor for citation:"]
[null,"Hover cursor for updates:",null,2019,2018,2015,2012,2010,2009]
[]
[null,"This spreadsheet calculates reliability statistics for consecutive pairs of trials and for the means of these statistics when there are >2 trials.  "]
[null,"    For trials spaced at equal intervals, these means are better estimates of test-retest reliability than the more usual ANOVA-based reliablity statistics."]
[null,"   But see the 1-way and 2-way spreadsheets in this workbook for such analyses."]
[null,"The reliability statistics are calculated for raw data and after log transformation."]
[null,"    See the instructions in dark red to help you decide between which is better for your data."]
[null,"    The data shown here are what you would expect for countermovement-jump height (best of three jumps) of team-sport athletes in trials separated by only a day or two."]
[null,"    I generated the data by putting appropriate means and SD into the 2-way spreadsheet."]
[null,"Delete and replace the numbers in blue. Stats you might want are in red. Don't change any cells with a colored background. "]
[null,"Missing values must be blanks or the graphs will display incorrectly. (The X values will plot as consecutive integers.)"]
[null,"Clear all the \"delete\" and #NUM! corresponding to missing values. Restore the formula (by copying an adjacent cell) if you restore a missing value or for new data."]
[null,"Check the graphs (especially of the change scores) for outliers and non-uniformity of scatter. The log-transformed variables may show less non-uniformity."]
[null,"For more than 20 subjects, COPY any number of rows after the first data row and INSERT in the same place without deselecting. "]
[null,"    Do NOT copy and insert the first data row.  ",{"$nulls":10},"Use analysis of RAW data in one or more of the following situations:",{"$nulls":6},"Use LOG transformation in one or more of the following situations:"]
[null,"    Double-click on any of the red mean or SD cells to check that you have done this operation properly. ",{"$nulls":10},"   the data can be zero or negative;",{"$nulls":6},"   the data can only be positive and non-zero;"]
[null,"    Colored boxes should enclose all rows of your data.",{"$nulls":10},"   the data were measured from an arbitrary reference value;",{"$nulls":6},"   the between-subject SD or change-score SD is more than ~20% of the mean;"]
[null,"For less than 20 subjects, delete or clear any unwanted or empty rows.",{"$nulls":10},"   the magnitude of the error is expected to be similar for all subjects.",{"$nulls":6},"   the magnitude of the percent or factor error is expected to be similar for all subjects."]
[null,"To remove a trial, clear its data, or set the corrresponding \"Include which trials?\" cell to 0 or blank."]
[null,"For more than 6 trials, copy and insert the entire column(s) for Trials 5 and/or 6 and their change scores for the RAW and the LOG data. ",{"$nulls":10},"Missing values produce delete in the panel of change scores.",{"$nulls":6},"Missing values produce #NUM! in the panel of log-transformed data.",{"$nulls":6},"Missing values produce delete in the panel of change scores."]
[null,"    And follow the instructions in the cells indicated by \"Hover cursor for >6 trials\". If such editing is too difficult for you, contact me. ",{"$nulls":10},"Clear delete from these cells to stop them plotting as zeros.",{"$nulls":6},"Clear #NUM! from these cells to get complete analyses.",{"$nulls":6},"Clear delete from these cells to stop them plotting as zeros."]
[{"$nulls":12},"Copy-paste or drag a corner to restore formulae to those cells if you enter new data.",{"$nulls":6},"Copy-paste or drag a corner to restore formulae to those cells if you enter new data.",{"$nulls":6},"Copy-paste or -drag to restore formulae to those cells if you enter new data."]
[]
[null,null,"Choose smallest effect:",0.2]
[null,null,"Choose conf. limits (%):",90,null,null,"Hover cursor for >6 trials:","Read","me",{"$nulls":3},"Hover cursor for >6 trials:","Do not",{"$nulls":6},"Hover cursor for >6 trials:","Read me","Read","me","Do not",null,null,"Hover cursor for >6 trials:","Do not"]
[null,null,"RAW Data",{"$nulls":8},"Change scores of raw data",null,"modify","Any",{"$nulls":3},"100*LOG-Transformed Data",{"$nulls":5},"modify",null,"Change scores of Log-transformed data",null,"modify","Any"]
[null,null,"Trial:",1,2,3,4,5,6,"Mean",null,"2-1","3-2","this col.","subject?",{"$nulls":3},1,2,3,4,5,6,"this col.",null,"2-1","3-2","this col.","subject?"]
[null,null,"AB",{"v":109.7237269772481,"d":"109.7"},{"v":105.90223608944358,"d":"105.9"},{"v":107.05329153605014,"d":"107.1"},{"$nulls":5},-3.8214908878045293,1.1510554466065628,null,1,null,null,"AB",{"v":469.79656335680386,"d":"469.8"},{"v":466.2516367487779,"d":"466.3"},{"v":467.33267622140914,"d":"467.3"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-3.5449266080259463,1.0810394726312325,null,{"$error":"#NUM!"}]
[null,null,"CP",{"v":107.72125225767608,"d":"107.7"},{"v":111.34531928084317,"d":"111.3"},{"v":107.7664057796508,"d":"107.8"},{"$nulls":5},3.624067023167086,-3.5789135011923747,null,1,null,null,"CP",{"v":467.9546892993503,"d":"468.0"},{"v":471.2636356725028,"d":"471.3"},{"v":467.99659752095965,"d":"468.0"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,3.30894637315248,-3.2670381515431473,null,{"$error":"#NUM!"}]
[null,null,"CM",{"v":110.6835885038947,"d":"110.7"},{"v":110.59979317476731,"d":"110.6"},{"v":110.03176283748017,"d":"110.0"},{"$nulls":5},-0.08379532912738341,-0.5680303372871407,null,1,null,null,"CM",{"v":470.6675576726839,"d":"470.7"},{"v":470.59182190572574,"d":"470.6"},{"v":470.0769077179274,"d":"470.1"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-0.07573576695818929,-0.5149141877983539,null,{"$error":"#NUM!"}]
[null,null,"DK",{"v":108.7906233351092,"d":"108.8"},{"v":108.6342229199372,"d":"108.6"},{"v":108.78164556962024,"d":"108.8"},{"$nulls":5},-0.15640041517200132,0.14742264968303687,null,1,null,null,"DK",{"v":468.9425148126193,"d":"468.9"},{"v":468.79864860335977,"d":"468.8"},{"v":468.934262138196,"d":"468.9"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-0.1438662092595564,0.13561353483623861,null,{"$error":"#NUM!"}]
[null,null,"ER",{"v":109.45443273403596,"d":"109.5"},{"v":110.19038701622972,"d":"110.2"},{"v":107.33015494636471,"d":"107.3"},{"$nulls":5},0.7359542821937595,-2.860232069865006,null,1,null,null,"ER",{"v":469.5508323231324,"d":"469.6"},{"v":470.22096607562435,"d":"470.2"},{"v":467.59096441368956,"d":"467.6"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.6701337524919495,-2.6300016619347844,null,{"$error":"#NUM!"}]
[null,null,"FC",{"v":109.60648148148147,"d":"109.6"},{"v":111.54859484777519,"d":"111.5"},{"v":106.75182481751821,"d":"106.8"},{"$nulls":5},1.942113366293725,-4.79677003025698,null,1,null,null,"FC",{"v":469.6896510370114,"d":"469.7"},{"v":471.44603241858033,"d":"471.4"},{"v":467.0506746271932,"d":"467.1"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,1.7563813815689286,-4.395357791387141,null,{"$error":"#NUM!"}]
[null,null,"JC",{"v":109.14925373134328,"d":"109.1"},{"v":108.37750294464075,"d":"108.4"},{"v":108.49739432541983,"d":"108.5"},{"$nulls":5},-0.7717507867025262,0.11989138077908024,null,1,null,null,"JC",{"v":469.2716245879985,"d":"469.3"},{"v":468.5620530055614,"d":"468.6"},{"v":468.6726157258221,"d":"468.7"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-0.7095715824370927,0.11056272026070246,null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
{"$rows_empty":9}
[null,null,"Mean",{"v":109.30419414582698,"d":"109.3"},{"v":109.514008039091,"d":"109.5"},{"v":108.03035425887201,"d":"108.0"},"","","",{"v":108.94951881459667,"d":"108.9"},"Mean of change",{"v":0.20981389326401864,"d":"0.2"},{"v":-1.4836537802189744,"d":"-1.5"},"Mean",7,null,null,"Mean",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},"","","",{"$error":"#NUM!"},"Mean",{"v":0.18019447721893908,"d":"0.2"},{"v":-1.3542994378478934,"d":"-1.4"},null,0]
[null,null,"SD",{"v":0.911605944594283,"d":"0.9"},{"v":2.009984433176297,"d":"2.0"},{"v":1.1501766769753647,"d":"1.2"},"","","",{"v":1.4368912285542896,"d":"1.4"},"SD of change",{"v":2.3227145169024235,"d":"2.3"},{"v":2.2462430402352704,"d":"2.2"},{"v":2.2847987354288617,"d":"2.28"},{"$nulls":3},"SD",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},"","","",{"$error":"#NUM!"},"SD",{"v":2.1351120359466114,"d":"2.1"},{"v":2.0629722278129465,"d":"2.1"},{"$error":"#DIV/0!"}]
[null,null,"Total no. of subjects",7,7,7,0,0,0,7,"Total no. of subjects",7,7,7,{"$nulls":3},"N",7,7,7,0,0,0,null,"N",7,7]
[null,null,"Include which trials?",1,1,1,1,0,0,{"$nulls":5},"%",null,null,"Include which trials?",1,1,1,1,0,0]
[null,null,"DF",6,6,6,0,0,0,6,"SDCind (68%)",{"v":2.3157941317836164,"d":"2.32"},{"v":2.2395504971802596,"d":"2.24"},{"v":2.277991318050157,"d":"2.28"},{"v":2.090868636076032,"d":"2.09"},null,null,"DF",6,6,6,0,0,0,"Mean","Factor change in mean",{"v":1.0018035692502638,"d":"1.0"},{"v":0.986548299374923,"d":"1.0"},"Mean"]
[{"$nulls":10},"SDCgroup (68%)",{"v":0.8752879086174554,"d":"0.88"},{"v":0.8464705234442896,"d":"0.85"},{"v":0.8609997880464225,"d":"0.86"},{"v":0.790274062165999,"d":"0.79"},null,null,"Back-transformed mean","","","","","","","","SD of change as a factor",{"v":1.021580686449702,"d":"1.02"},{"v":1.020843985861711,"d":"1.02"},""]
[{"$nulls":10},"SWC",{"v":0.4645429033804847,"d":"0.46"},{"v":0.44924860804705413,"d":"0.45"},{"v":0.45695974708577236,"d":"0.46"},{"v":0.41942337337294466,"d":"0.42"},null,null,"SD as a ×/÷ factor","","","","","","","","Change in mean (%)",{"v":0.18035692502638767,"d":"0.2"},{"v":-1.345170062507691,"d":"-1.3"}]
[null,"For your data, you may have to set max and min values of X and Y axes to appropriate values.",{"$nulls":8},"CV",{"v":1.5011613926652962,"d":"1.50"},{"v":1.4602388856834272,"d":"1.46"},{"v":1.4828855575007316,"d":"1.48"},{"$nulls":3},"SD as a CV (%)","","","","","","","","SD of change as CV (%)",{"v":2.158068644970186,"d":"2.2"},{"v":2.0843985861711047,"d":"2.1"},""]
[{"$nulls":9},"Measures of reliability via the RAW variable",{"$nulls":7},"Total no. of subjects",7,7,7,0,0,0,"","Total no. of subjects",7,7,""]
[{"$nulls":9},"Raw","Trials","2-1","3-2","Mean",{"$nulls":10},"Measures of reliability via the LOG-TRANSFORMED variable"]
[{"$nulls":10},"Change in mean",{"v":0.20981389326401864,"d":"0.21"},{"v":-1.4836537802189744,"d":"-1.48"},{"$nulls":3},"Clear #NUM! and \"delete\" from the log-transformed cells to stop them plotting as zeros.",{"$nulls":7},"Factors","Trials","2-1","3-2","Mean"]
[{"$nulls":10},"Lower conf. limit",{"v":-1.4961110089125609,"d":"-1.50"},{"v":-3.1334139684785436,"d":"-3.13"},null," ",null,"Restore the log-transformation formula to those cells if you enter new data.",{"$nulls":8},"Factor change in mean","",""]
[{"$nulls":10},"Upper conf. limit",{"v":1.915738795440598,"d":"1.92"},{"v":0.1661064080405945,"d":"0.17"},{"$nulls":12},"Lower conf. limit","",""]
[{"$nulls":10},"Conf. limits as ±value",{"v":1.7059249021765794,"d":"1.71"},{"v":1.649760188259569,"d":"1.65"},{"$nulls":12},"Upper conf. limit","",""]
[{"$nulls":10},"Typical error",{"v":1.6424071856621394,"d":"1.64"},{"v":1.5883336859434465,"d":"1.59"},{"v":1.6155966794681964,"d":"1.62"},{"$nulls":11},"Conf. limits as ×/÷factor","",""]
[{"$nulls":10},"Lower conf. limit",{"v":1.1337471860725843,"d":"1.13"},{"v":1.0964204630270753,"d":"1.10"},{"v":1.2016661247642808,"d":"1.20"},{"$nulls":11},"Factor typical error","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":3.1459132038661144,"d":"3.15"},{"v":3.0423392922141717,"d":"3.04"},{"v":2.710614031209229,"d":"2.71"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Conf. limits as approx. ×/÷factor",{"v":1.665770846569144,"d":"1.67"},{"v":1.6657708465691439,"d":"1.67"},{"v":1.5019031625840351,"d":"1.50"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.0416666666666667,"d":"1.04"},{"v":1.0416666666666667,"d":"1.04"},{"v":1.0267094017094016,"d":"1.03"},{"$nulls":11},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":10},"Smallest effect from pure SD","",{"v":0.07966630580913643,"d":"0.08"},"",{"$nulls":11},"Bias correction factor","","",""]
[{"$nulls":10},"Lower conf. limit","",{"v":-0.16784440186288374,"d":"-0.17"},"",{"$nulls":11},"Smallest effect from pure SD","","",""]
[{"$nulls":10},"Upper conf. limit","",{"v":0.20215138831890048,"d":"0.20"},"",{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Smallest effect from observed SD",{"v":0.31212378377274214,"d":"0.31"},{"v":0.32750400943711,"d":"0.33"},{"v":0.28737824571085796,"d":"0.29"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":0.21545781377960246,"d":"0.22"},{"v":0.2260747227412547,"d":"0.23"},{"v":0.19837606670102842,"d":"0.20"},{"$nulls":11},"Smallest effect from observed SD","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.597850728603249,"d":"0.60"},{"v":0.6273104481042135,"d":"0.63"},{"v":0.5504524246958846,"d":"0.55"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Degrees of freedom",6,6,{"v":9.36,"d":"9"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":9},"Standardized (when ICC>0)",{"$nulls":15},"Degrees of freedom",0,0,""]
[{"$nulls":10},"Change in mean","",{"v":-3.724670712794175,"d":"-3.72"},{"$nulls":11},"Percents"]
[{"$nulls":10},"Lower conf. limit","",{"v":-7.8663468492829045,"d":"-7.87"},{"$nulls":12},"Change in mean (%)","",""]
[{"$nulls":10},"Upper conf. limit","",{"v":0.41700542369455473,"d":"0.42"},{"$nulls":12},"Lower conf. limit","",""]
[{"$nulls":10},"Conf. limits as ±value","",{"v":4.14167613648873,"d":"4.14"},{"$nulls":12},"Upper conf. limit","",""]
[{"$nulls":10},"Typical error","",{"v":3.987466645557175,"d":"3.99"},{"v":1.1243695050555143,"d":"1.12"},{"$nulls":11},"Conf. limits as approx. ±value","",""]
[{"$nulls":10},"Lower conf. limit","",{"v":2.752532458713138,"d":"2.75"},{"v":0.8362958175848302,"d":"0.84"},{"$nulls":11},"Typical error as a CV (%)","","",""]
[{"$nulls":10},"Upper conf. limit","",{"v":7.637706458996533,"d":"7.64"},{"v":1.8864434393802236,"d":"1.89"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Conf. limits as approx. ×/÷factor","",{"v":1.6657708465691439,"d":"1.67"},{"v":1.5019031625840351,"d":"1.50"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.0416666666666667,"d":"1.04"},{"v":1.0416666666666667,"d":"1.04"},{"v":1.0267094017094016,"d":"1.03"},{"$nulls":11},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":9},"Correlations",{"$nulls":15},"Bias correction factor","","",""]
[{"$nulls":10},"Pearson correlation",{"v":-0.16047842723649153,"d":"-0.16"},{"v":0.0771715592940233,"d":"0.08"},{"v":-0.04225104421357711,"d":"-0.04"},{"$nulls":11},"Smallest effect from pure SD","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":-0.7549232745140473,"d":"-0.75"},{"v":-0.6322174840213399,"d":"-0.63"},{"$nulls":12},"Lower conf. limit","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.5787287087294274,"d":"0.58"},{"v":0.7161771515132365,"d":"0.72"},{"$nulls":12},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.1224448682744437,"d":"1.12"},{"v":1.124411191263815,"d":"1.12"},{"$nulls":12},"Smallest effect from observed SD","","",""]
[{"$nulls":10},"Intraclass correlation (ICC)",{"v":-0.13414104361100593,"d":"-0.13"},{"v":0.07391318231675961,"d":"0.07"},{"v":-0.3256477263969129,"d":"-0.33"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":-0.6974830672571233,"d":"-0.70"},{"v":-0.5739407472430909,"d":"-0.57"},{"v":-0.5329290883204862,"d":"-0.53"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.531672235583457,"d":"0.53"},{"v":0.6648611986140353,"d":"0.66"},{"v":0.1691747021148176,"d":"0.17"},{"$nulls":10},"Standardized (when ICC>0)"]
[{"$nulls":10},"Effective no. of trials",{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2.5599999999999996,"d":"2.6"},{"$nulls":11},"Change in mean","",""]
[{"$nulls":10},"F",{"v":0.7634490976820439,"d":"0.8"},{"v":1.159624736915413,"d":"1.2"},{"v":0.371131437880586,"d":"0.4"},{"$nulls":11},"Lower conf. limit","",""]
[{"$nulls":10},"Numerator DF",6,6,6,{"$nulls":11},"Upper conf. limit","",""]
[{"$nulls":10},"Denominator DF",6,6,{"v":9.36,"d":"9"},{"$nulls":11},"Conf. limits as ±value","",""]
[{"$nulls":10},"F lower",{"v":0.17821499287866147,"d":"0.2"},{"v":0.27069586545948005,"d":"0.3"},{"v":0.1100054943864347,"d":"0.1"},{"$nulls":11},"Typical error","","",""]
[{"$nulls":10},"F upper",{"v":3.2705134138089402,"d":"3.3"},{"v":4.967676651372537,"d":"5.0"},{"v":1.5212735318921216,"d":"1.5"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Fisher r",{"v":-0.16187773149984924,"d":"-0.16"},{"v":0.07732530615781509,"d":"0.08"},{"v":-0.042276212671017076,"d":"-0.04"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Fisher SE^-2",4,4,{"$nulls":12},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":10},"Pure variance","",{"v":0.15866800703187112,"d":"0.2"},"",{"$nulls":11},"Bias correction factor","","",""]
[{"$nulls":10},"SE of pure variance","",{"v":0.524643393071389,"d":"0.5"},"",{"$nulls":10},"Correlations"]
[{"$nulls":10},"LCL","",{"v":-0.7042935809177301,"d":"-0.7"},"",{"$nulls":11},"Pearson correlation","","",""]
[{"$nulls":10},"UCL","",{"v":1.0216295949814724,"d":"1.0"},"",{"$nulls":11},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Bias correction factor","",""]
[{"$nulls":25},"Intraclass correlation","","",""]
[{"$nulls":25},"Lower conf. limit","","",""]
[{"$nulls":25},"Upper conf. limit","","",""]
[]
[{"$nulls":24},"Measures of reliability of log-transformed variable"]
[{"$nulls":26},"2-1","3-2","Mean"]
[{"$nulls":25},"Change in mean","",""]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Typical error","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Bias correction factor","","",""]
[{"$nulls":25},"Smallest effect from pure SD","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Smallest effect from observed SD","","",{"$error":"#NUM!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"DF",0,0,{"$error":"#DIV/0!"}]
[]
[{"$nulls":25},"Stdized change in mean","",""]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Stdized typical error","","",""]
[{"$nulls":25},"Lower conf. limit","","",""]
[{"$nulls":25},"Upper conf. limit","","",""]
[]
[{"$nulls":25},"Pearson r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Bias correction factor","",""]
[{"$nulls":25},"Intraclass r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Effective no. of trials","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"F","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Numerator DF",0,"",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Denominator DF",0,0,{"$error":"#DIV/0!"}]
[{"$nulls":25},"F lower","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"F upper","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Fisher r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Fisher SE^-2","",""]
[{"$nulls":25},"Pure variance","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"SE of pure variance","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"LCL","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"UCL","","",{"$error":"#DIV/0!"}]

{"sheet":"50-100m","index":1,"n_rows":154,"n_cols":30,"rows_kept":154,"merged":[[75,9,75,10],[85,9,85,10],[92,24,92,25],[102,24,102,25]],"flags":["formulas_cached_only"]}
[null,"CONSECUTIVE PAIRWISE ANALYSIS OF TRIALS FOR RELIABILITY"]
[null,"Hover cursor for citation:"]
[null,"Hover cursor for updates:",null,2019,2018,2015,2012,2010,2009]
[]
[null,"This spreadsheet calculates reliability statistics for consecutive pairs of trials and for the means of these statistics when there are >2 trials.  "]
[null,"    For trials spaced at equal intervals, these means are better estimates of test-retest reliability than the more usual ANOVA-based reliablity statistics."]
[null,"   But see the 1-way and 2-way spreadsheets in this workbook for such analyses."]
[null,"The reliability statistics are calculated for raw data and after log transformation."]
[null,"    See the instructions in dark red to help you decide between which is better for your data."]
[null,"    The data shown here are what you would expect for countermovement-jump height (best of three jumps) of team-sport athletes in trials separated by only a day or two."]
[null,"    I generated the data by putting appropriate means and SD into the 2-way spreadsheet."]
[null,"Delete and replace the numbers in blue. Stats you might want are in red. Don't change any cells with a colored background. "]
[null,"Missing values must be blanks or the graphs will display incorrectly. (The X values will plot as consecutive integers.)"]
[null,"Clear all the \"delete\" and #NUM! corresponding to missing values. Restore the formula (by copying an adjacent cell) if you restore a missing value or for new data."]
[null,"Check the graphs (especially of the change scores) for outliers and non-uniformity of scatter. The log-transformed variables may show less non-uniformity."]
[null,"For more than 20 subjects, COPY any number of rows after the first data row and INSERT in the same place without deselecting. "]
[null,"    Do NOT copy and insert the first data row.  ",{"$nulls":10},"Use analysis of RAW data in one or more of the following situations:",{"$nulls":6},"Use LOG transformation in one or more of the following situations:"]
[null,"    Double-click on any of the red mean or SD cells to check that you have done this operation properly. ",{"$nulls":10},"   the data can be zero or negative;",{"$nulls":6},"   the data can only be positive and non-zero;"]
[null,"    Colored boxes should enclose all rows of your data.",{"$nulls":10},"   the data were measured from an arbitrary reference value;",{"$nulls":6},"   the between-subject SD or change-score SD is more than ~20% of the mean;"]
[null,"For less than 20 subjects, delete or clear any unwanted or empty rows.",{"$nulls":10},"   the magnitude of the error is expected to be similar for all subjects.",{"$nulls":6},"   the magnitude of the percent or factor error is expected to be similar for all subjects."]
[null,"To remove a trial, clear its data, or set the corrresponding \"Include which trials?\" cell to 0 or blank."]
[null,"For more than 6 trials, copy and insert the entire column(s) for Trials 5 and/or 6 and their change scores for the RAW and the LOG data. ",{"$nulls":10},"Missing values produce delete in the panel of change scores.",{"$nulls":6},"Missing values produce #NUM! in the panel of log-transformed data.",{"$nulls":6},"Missing values produce delete in the panel of change scores."]
[null,"    And follow the instructions in the cells indicated by \"Hover cursor for >6 trials\". If such editing is too difficult for you, contact me. ",{"$nulls":10},"Clear delete from these cells to stop them plotting as zeros.",{"$nulls":6},"Clear #NUM! from these cells to get complete analyses.",{"$nulls":6},"Clear delete from these cells to stop them plotting as zeros."]
[{"$nulls":12},"Copy-paste or drag a corner to restore formulae to those cells if you enter new data.",{"$nulls":6},"Copy-paste or drag a corner to restore formulae to those cells if you enter new data.",{"$nulls":6},"Copy-paste or -drag to restore formulae to those cells if you enter new data."]
[]
[null,null,"Choose smallest effect:",0.2]
[null,null,"Choose conf. limits (%):",90,null,null,"Hover cursor for >6 trials:","Read","me",{"$nulls":3},"Hover cursor for >6 trials:","Do not",{"$nulls":6},"Hover cursor for >6 trials:","Read me","Read","me","Do not",null,null,"Hover cursor for >6 trials:","Do not"]
[null,null,"RAW Data",{"$nulls":8},"Change scores of raw data",null,"modify","Any",{"$nulls":3},"100*LOG-Transformed Data",{"$nulls":5},"modify",null,"Change scores of Log-transformed data",null,"modify","Any"]
[null,null,"Trial:",1,2,3,4,5,6,"Mean",null,"2-1","3-2","this col.","subject?",{"$nulls":3},1,2,3,4,5,6,"this col.",null,"2-1","3-2","this col.","subject?"]
[{"$nulls":3},{"v":100.02469135802468,"d":"100.0"},{"v":97.72072936660267,"d":"97.7"},{"v":97.80429594272077,"d":"97.8"},{"$nulls":5},-2.303961991422014,0.08356657611810192,null,1,null,null,0,{"v":460.5417069090197,"d":"460.5"},{"v":458.2113710203301,"d":"458.2"},{"v":458.29685018707534,"d":"458.3"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-2.3303358886896035,0.08547916674524458,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":97.5068119891008,"d":"97.5"},{"v":99.83324068927182,"d":"99.8"},{"v":97.54768392370569,"d":"97.5"},{"$nulls":5},2.3264287001710215,-2.2855567655661275,null,1,null,null,0,{"v":457.9922242118127,"d":"458.0"},{"v":460.35012008997035,"d":"460.4"},{"v":458.03413243342214,"d":"458.0"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,2.357895878157649,-2.3159876565482023,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":98.96133525456293,"d":"99.0"},{"v":95.83333333333333,"d":"95.8"},{"v":96.99020065328978,"d":"97.0"},{"$nulls":5},-3.128001921229597,1.1568673199564472,null,1,null,null,0,{"v":459.47292208646974,"d":"459.5"},{"v":456.26105715692955,"d":"456.3"},{"v":457.4609949207207,"d":"457.5"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-3.2118649295401838,1.1999377637911266,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":97.23809523809524,"d":"97.2"},{"v":96.82835820895522,"d":"96.8"},{"v":96.87646782527007,"d":"96.9"},{"$nulls":5},-0.4097370291400182,0.04810961631484645,null,1,null,null,0,{"v":457.7162561001188,"d":"457.7"},{"v":457.29399080831786,"d":"457.3"},{"v":457.34366393034475,"d":"457.3"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-0.4222652918009544,0.04967312202688845,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":98.02887284841754,"d":"98.0"},{"v":97.09845984598459,"d":"97.1"},{"v":97.93365959760739,"d":"97.9"},{"$nulls":5},-0.9304130024329424,0.8351997516227954,null,1,null,null,0,{"v":458.5262056180576,"d":"458.5"},{"v":457.57255136471235,"d":"457.6"},{"v":458.4290306559726,"d":"458.4"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-0.9536542533452348,0.856479291260257,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":98.54318418314256,"d":"98.5"},{"v":99.33524504692389,"d":"99.3"},{"v":97.25063938618926,"d":"97.3"},{"$nulls":5},0.7920608637813302,-2.084605660734624,null,1,null,null,0,{"v":459.04948702038774,"d":"459.0"},{"v":459.8500443090935,"d":"459.9"},{"v":457.72915571421277,"d":"457.7"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.800557288705761,-2.120888594880739,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":99.09214092140921,"d":"99.1"},{"v":97.1108179419525,"d":"97.1"},{"v":97.38825363825364,"d":"97.4"},{"$nulls":5},-1.9813229794567064,0.27743569630113996,null,1,null,null,0,{"v":459.60501336645245,"d":"459.6"},{"v":457.585277941038,"d":"457.6"},{"v":457.8705604179247,"d":"457.9"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-2.019735425414467,0.2852824768867208,null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
{"$rows_empty":9}
[null,null,"Mean",{"v":98.48501882753612,"d":"98.5"},{"v":97.68002634757487,"d":"97.7"},{"v":97.39874299529095,"d":"97.4"},"","","",{"v":97.85459605680064,"d":"97.9"},"Mean of change",{"v":-0.8049924799612752,"d":"-0.8"},{"v":-0.28128335228391727,"d":"-0.3"},"Mean",7,null,null,"Mean",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},"","","",{"$error":"#NUM!"},"Mean",{"v":-0.8256289459895763,"d":"-0.8"},{"v":-0.280003490102672,"d":"-0.3"},null,0]
[null,null,"SD",{"v":0.9737577981022894,"d":"1.0"},{"v":1.424521509824353,"d":"1.4"},{"v":0.394654969314541,"d":"0.4"},"","","",{"v":1.0219618920034697,"d":"1.0"},"SD of change",{"v":1.895405456780305,"d":"1.9"},{"v":1.362453504649458,"d":"1.4"},{"v":1.6505819273704874,"d":"1.65"},{"$nulls":3},"SD",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},"","","",{"$error":"#NUM!"},"SD",{"v":1.9297046462055634,"d":"1.9"},{"v":1.3891076984788229,"d":"1.4"},{"$error":"#DIV/0!"}]
[null,null,"Total no. of subjects",7,7,7,0,0,0,7,"Total no. of subjects",7,7,7,{"$nulls":3},"N",7,7,7,0,0,0,null,"N",7,7]
[null,null,"Include which trials?",1,1,1,1,0,0,{"$nulls":5},"%",null,null,"Include which trials?",1,1,1,1,0,0]
[null,null,"DF",6,6,6,0,0,0,6,"SDCind (68%)",{"v":1.889758212738148,"d":"1.89"},{"v":1.3583941581865027,"d":"1.36"},{"v":1.6456641199841626,"d":"1.65"},{"v":1.6817443291359775,"d":"1.68"},null,null,"DF",6,6,6,0,0,0,"Mean","Factor change in mean",{"v":0.9917777000910791,"d":"1.0"},{"v":0.997203881540453,"d":"1.0"},"Mean"]
[{"$nulls":10},"SDCgroup (68%)",{"v":0.7142614669924332,"d":"0.71"},{"v":0.5134247321377743,"d":"0.51"},{"v":0.6220025718600077,"d":"0.62"},{"v":0.6356396090981361,"d":"0.64"},null,null,"Back-transformed mean","","","","","","","","SD of change as a factor",{"v":1.0194844378893364,"d":"1.02"},{"v":1.01398800629215,"d":"1.01"},""]
[{"$nulls":10},"SWC",{"v":0.379081091356061,"d":"0.38"},{"v":0.2724907009298916,"d":"0.27"},{"v":0.3301163854740975,"d":"0.33"},{"v":0.33735399130611937,"d":"0.34"},null,null,"SD as a ×/÷ factor","","","","","","","","Change in mean (%)",{"v":-0.8222299908920832,"d":"-0.8"},{"v":-0.27961184595469035,"d":"-0.3"}]
[null,"For your data, you may have to set max and min values of X and Y axes to appropriate values.",{"$nulls":8},"CV",{"v":1.3664555276817358,"d":"1.37"},{"v":0.9877037008530228,"d":"0.99"},{"v":1.1927264745645232,"d":"1.19"},{"$nulls":3},"SD as a CV (%)","","","","","","","","SD of change as CV (%)",{"v":1.9484437889336448,"d":"1.9"},{"v":1.3988006292150033,"d":"1.4"},""]
[{"$nulls":9},"Measures of reliability via the RAW variable",{"$nulls":7},"Total no. of subjects",7,7,7,0,0,0,"","Total no. of subjects",7,7,""]
[{"$nulls":9},"Raw","Trials","2-1","3-2","Mean",{"$nulls":10},"Measures of reliability via the LOG-TRANSFORMED variable"]
[{"$nulls":10},"Change in mean",{"v":-0.8049924799612752,"d":"-0.80"},{"v":-0.28128335228391727,"d":"-0.28"},{"$nulls":3},"Clear #NUM! and \"delete\" from the log-transformed cells to stop them plotting as zeros.",{"$nulls":7},"Factors","Trials","2-1","3-2","Mean"]
[{"$nulls":10},"Lower conf. limit",{"v":-2.197078913706474,"d":"-2.20"},{"v":-1.2819415669399654,"d":"-1.28"},null," ",null,"Restore the log-transformation formula to those cells if you enter new data.",{"$nulls":8},"Factor change in mean","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.5870939537839234,"d":"0.59"},{"v":0.7193748623721308,"d":"0.72"},{"$nulls":12},"Lower conf. limit","",""]
[{"$nulls":10},"Conf. limits as ±value",{"v":1.3920864337451986,"d":"1.39"},{"v":1.000658214656048,"d":"1.00"},{"$nulls":12},"Upper conf. limit","",""]
[{"$nulls":10},"Typical error",{"v":1.3402540515873391,"d":"1.34"},{"v":0.963400112189009,"d":"0.96"},{"v":1.167137673747633,"d":"1.17"},{"$nulls":11},"Conf. limits as ×/÷factor","",""]
[{"$nulls":10},"Lower conf. limit",{"v":0.9251720723548426,"d":"0.93"},{"v":0.6650312880943453,"d":"0.67"},{"v":0.8681063927046309,"d":"0.87"},{"$nulls":11},"Factor typical error","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":2.567160539865666,"d":"2.57"},{"v":1.845323839300933,"d":"1.85"},{"v":1.9581989707075969,"d":"1.96"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Conf. limits as approx. ×/÷factor",{"v":1.6657708465691439,"d":"1.67"},{"v":1.6657708465691439,"d":"1.67"},{"v":1.5019031625840351,"d":"1.50"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.0416666666666667,"d":"1.04"},{"v":1.0416666666666667,"d":"1.04"},{"v":1.0267094017094016,"d":"1.03"},{"$nulls":11},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":10},"Smallest effect from pure SD","",{"v":0.08108446514904388,"d":"0.08"},"",{"$nulls":11},"Bias correction factor","","",""]
[{"$nulls":10},"Lower conf. limit","",{"v":-0.12376190628116926,"d":"-0.12"},"",{"$nulls":11},"Smallest effect from pure SD","","",""]
[{"$nulls":10},"Upper conf. limit","",{"v":0.16871985782166232,"d":"0.17"},"",{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Smallest effect from observed SD",{"v":0.24402728459405,"d":"0.24"},{"v":0.20904612298518793,"d":"0.21"},{"v":0.20439237840069394,"d":"0.20"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":0.1684510696547518,"d":"0.17"},{"v":0.1443037121140523,"d":"0.14"},{"v":0.14109125062859945,"d":"0.14"},{"$nulls":11},"Smallest effect from observed SD","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.4674167669319596,"d":"0.47"},{"v":0.40041286001253895,"d":"0.40"},{"v":0.39149894593350515,"d":"0.39"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Degrees of freedom",6,6,{"v":9.36,"d":"9"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":9},"Standardized (when ICC>0)",{"$nulls":15},"Degrees of freedom",0,0,""]
[{"$nulls":10},"Change in mean","",{"v":-0.6938033118104229,"d":"-0.69"},{"$nulls":11},"Percents"]
[{"$nulls":10},"Lower conf. limit","",{"v":-3.1619905602968186,"d":"-3.16"},{"$nulls":12},"Change in mean (%)","",""]
[{"$nulls":10},"Upper conf. limit","",{"v":1.7743839366759724,"d":"1.77"},{"$nulls":12},"Lower conf. limit","",""]
[{"$nulls":10},"Conf. limits as ±value","",{"v":2.4681872484863954,"d":"2.47"},{"$nulls":12},"Upper conf. limit","",""]
[{"$nulls":10},"Typical error","",{"v":2.376287764661587,"d":"2.38"},{"v":1.1420559640042534,"d":"1.14"},{"$nulls":11},"Conf. limits as approx. ±value","",""]
[{"$nulls":10},"Lower conf. limit","",{"v":1.640342047942058,"d":"1.64"},{"v":0.8494508449848183,"d":"0.85"},{"$nulls":11},"Typical error as a CV (%)","","",""]
[{"$nulls":10},"Upper conf. limit","",{"v":4.551608833847485,"d":"4.55"},{"v":1.9161174071458906,"d":"1.92"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Conf. limits as approx. ×/÷factor","",{"v":1.665770846569144,"d":"1.67"},{"v":1.5019031625840351,"d":"1.50"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.0416666666666667,"d":"1.04"},{"v":1.0416666666666667,"d":"1.04"},{"v":1.0267094017094016,"d":"1.03"},{"$nulls":11},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":9},"Correlations",{"$nulls":15},"Bias correction factor","","",""]
[{"$nulls":10},"Pearson correlation",{"v":-0.2480658274526004,"d":"-0.25"},{"v":0.3257892715832937,"d":"0.33"},{"v":0.04235439924895502,"d":"0.04"},{"$nulls":11},"Smallest effect from pure SD","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":-0.7916280183640658,"d":"-0.79"},{"v":-0.4496939254806642,"d":"-0.45"},{"$nulls":12},"Lower conf. limit","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.5146804077409219,"d":"0.51"},{"v":0.8212148332991769,"d":"0.82"},{"$nulls":12},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.1188553663043688,"d":"1.12"},{"v":1.1143151733185026,"d":"1.11"},{"$nulls":12},"Smallest effect from observed SD","","",""]
[{"$nulls":10},"Intraclass correlation (ICC)",{"v":-0.2560256090209109,"d":"-0.26"},{"v":0.18721065749471302,"d":"0.19"},{"v":-0.37332091875531126,"d":"-0.37"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":-0.7570544915974257,"d":"-0.76"},{"v":-0.4914596251566024,"d":"-0.49"},{"v":-0.5513878753569441,"d":"-0.55"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.43461897400912414,"d":"0.43"},{"v":0.7244146816633342,"d":"0.72"},{"v":0.087827973033166,"d":"0.09"},{"$nulls":10},"Standardized (when ICC>0)"]
[{"$nulls":10},"Effective no. of trials",{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2.5599999999999996,"d":"2.6"},{"$nulls":11},"Change in mean","",""]
[{"$nulls":10},"F",{"v":0.5923242214456338,"d":"0.6"},{"v":1.4606621856474336,"d":"1.5"},{"v":0.30409452083509925,"d":"0.3"},{"$nulls":11},"Lower conf. limit","",""]
[{"$nulls":10},"Numerator DF",6,6,6,{"$nulls":11},"Upper conf. limit","",""]
[{"$nulls":10},"Denominator DF",6,6,{"v":9.36,"d":"9"},{"$nulls":11},"Conf. limits as ±value","",""]
[{"$nulls":10},"F lower",{"v":0.13826862488578862,"d":"0.1"},{"v":0.34096824765873307,"d":"0.3"},{"v":0.09013536631578617,"d":"0.1"},{"$nulls":11},"Typical error","","",""]
[{"$nulls":10},"F upper",{"v":2.53743742371764,"d":"2.5"},{"v":6.257280656572282,"d":"6.3"},{"v":1.2464881670539103,"d":"1.2"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Fisher r",{"v":-0.25335075514120226,"d":"-0.25"},{"v":0.33811026112919057,"d":"0.34"},{"v":0.04237975299399416,"d":"0.04"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Fisher SE^-2",4,4,{"$nulls":12},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":10},"Pure variance","",{"v":0.16436726221266273,"d":"0.2"},"",{"$nulls":11},"Bias correction factor","","",""]
[{"$nulls":10},"SE of pure variance","",{"v":0.33273021343894466,"d":"0.3"},"",{"$nulls":10},"Correlations"]
[{"$nulls":10},"LCL","",{"v":-0.382925236158723,"d":"-0.4"},"",{"$nulls":11},"Pearson correlation","","",""]
[{"$nulls":10},"UCL","",{"v":0.7116597605840485,"d":"0.7"},"",{"$nulls":11},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Bias correction factor","",""]
[{"$nulls":25},"Intraclass correlation","","",""]
[{"$nulls":25},"Lower conf. limit","","",""]
[{"$nulls":25},"Upper conf. limit","","",""]
[]
[{"$nulls":24},"Measures of reliability of log-transformed variable"]
[{"$nulls":26},"2-1","3-2","Mean"]
[{"$nulls":25},"Change in mean","",""]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Typical error","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Bias correction factor","","",""]
[{"$nulls":25},"Smallest effect from pure SD","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Smallest effect from observed SD","","",{"$error":"#NUM!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"DF",0,0,{"$error":"#DIV/0!"}]
[]
[{"$nulls":25},"Stdized change in mean","",""]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Stdized typical error","","",""]
[{"$nulls":25},"Lower conf. limit","","",""]
[{"$nulls":25},"Upper conf. limit","","",""]
[]
[{"$nulls":25},"Pearson r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Bias correction factor","",""]
[{"$nulls":25},"Intraclass r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Effective no. of trials","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"F","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Numerator DF",0,"",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Denominator DF",0,0,{"$error":"#DIV/0!"}]
[{"$nulls":25},"F lower","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"F upper","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Fisher r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Fisher SE^-2","",""]
[{"$nulls":25},"Pure variance","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"SE of pure variance","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"LCL","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"UCL","","",{"$error":"#DIV/0!"}]

{"sheet":"100-150m","index":2,"n_rows":154,"n_cols":30,"rows_kept":154,"merged":[[75,9,75,10],[85,9,85,10],[92,24,92,25],[102,24,102,25]],"flags":["formulas_cached_only"]}
[null,"CONSECUTIVE PAIRWISE ANALYSIS OF TRIALS FOR RELIABILITY"]
[null,"Hover cursor for citation:"]
[null,"Hover cursor for updates:",null,2019,2018,2015,2012,2010,2009]
[]
[null,"This spreadsheet calculates reliability statistics for consecutive pairs of trials and for the means of these statistics when there are >2 trials.  "]
[null,"    For trials spaced at equal intervals, these means are better estimates of test-retest reliability than the more usual ANOVA-based reliablity statistics."]
[null,"   But see the 1-way and 2-way spreadsheets in this workbook for such analyses."]
[null,"The reliability statistics are calculated for raw data and after log transformation."]
[null,"    See the instructions in dark red to help you decide between which is better for your data."]
[null,"    The data shown here are what you would expect for countermovement-jump height (best of three jumps) of team-sport athletes in trials separated by only a day or two."]
[null,"    I generated the data by putting appropriate means and SD into the 2-way spreadsheet."]
[null,"Delete and replace the numbers in blue. Stats you might want are in red. Don't change any cells with a colored background. "]
[null,"Missing values must be blanks or the graphs will display incorrectly. (The X values will plot as consecutive integers.)"]
[null,"Clear all the \"delete\" and #NUM! corresponding to missing values. Restore the formula (by copying an adjacent cell) if you restore a missing value or for new data."]
[null,"Check the graphs (especially of the change scores) for outliers and non-uniformity of scatter. The log-transformed variables may show less non-uniformity."]
[null,"For more than 20 subjects, COPY any number of rows after the first data row and INSERT in the same place without deselecting. "]
[null,"    Do NOT copy and insert the first data row.  ",{"$nulls":10},"Use analysis of RAW data in one or more of the following situations:",{"$nulls":6},"Use LOG transformation in one or more of the following situations:"]
[null,"    Double-click on any of the red mean or SD cells to check that you have done this operation properly. ",{"$nulls":10},"   the data can be zero or negative;",{"$nulls":6},"   the data can only be positive and non-zero;"]
[null,"    Colored boxes should enclose all rows of your data.",{"$nulls":10},"   the data were measured from an arbitrary reference value;",{"$nulls":6},"   the between-subject SD or change-score SD is more than ~20% of the mean;"]
[null,"For less than 20 subjects, delete or clear any unwanted or empty rows.",{"$nulls":10},"   the magnitude of the error is expected to be similar for all subjects.",{"$nulls":6},"   the magnitude of the percent or factor error is expected to be similar for all subjects."]
[null,"To remove a trial, clear its data, or set the corrresponding \"Include which trials?\" cell to 0 or blank."]
[null,"For more than 6 trials, copy and insert the entire column(s) for Trials 5 and/or 6 and their change scores for the RAW and the LOG data. ",{"$nulls":10},"Missing values produce delete in the panel of change scores.",{"$nulls":6},"Missing values produce #NUM! in the panel of log-transformed data.",{"$nulls":6},"Missing values produce delete in the panel of change scores."]
[null,"    And follow the instructions in the cells indicated by \"Hover cursor for >6 trials\". If such editing is too difficult for you, contact me. ",{"$nulls":10},"Clear delete from these cells to stop them plotting as zeros.",{"$nulls":6},"Clear #NUM! from these cells to get complete analyses.",{"$nulls":6},"Clear delete from these cells to stop them plotting as zeros."]
[{"$nulls":12},"Copy-paste or drag a corner to restore formulae to those cells if you enter new data.",{"$nulls":6},"Copy-paste or drag a corner to restore formulae to those cells if you enter new data.",{"$nulls":6},"Copy-paste or -drag to restore formulae to those cells if you enter new data."]
[]
[null,null,"Choose smallest effect:",0.2]
[null,null,"Choose conf. limits (%):",90,null,null,"Hover cursor for >6 trials:","Read","me",{"$nulls":3},"Hover cursor for >6 trials:","Do not",{"$nulls":6},"Hover cursor for >6 trials:","Read me","Read","me","Do not",null,null,"Hover cursor for >6 trials:","Do not"]
[null,null,"RAW Data",{"$nulls":8},"Change scores of raw data",null,"modify","Any",{"$nulls":3},"100*LOG-Transformed Data",{"$nulls":5},"modify",null,"Change scores of Log-transformed data",null,"modify","Any"]
[null,null,"Trial:",1,2,3,4,5,6,"Mean",null,"2-1","3-2","this col.","subject?",{"$nulls":3},1,2,3,4,5,6,"this col.",null,"2-1","3-2","this col.","subject?"]
[{"$nulls":3},{"v":96.68257756563247,"d":"96.7"},{"v":98.19189971070395,"d":"98.2"},{"v":97.52498810090435,"d":"97.5"},{"$nulls":5},1.5093221450714793,-0.6669116097995982,null,1,null,null,0,{"v":457.1433216274599,"d":"457.1"},{"v":458.6923724287086,"d":"458.7"},{"v":458.01086333819904,"d":"458.0"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,1.5490508012487112,-0.6815090905095644,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":98.47275729223993,"d":"98.5"},{"v":96.19710765934654,"d":"96.2"},{"v":97.81420765027322,"d":"97.8"},{"$nulls":5},-2.2756496328933906,1.6170999909266754,null,1,null,null,0,{"v":458.9779934210627,"d":"459.0"},{"v":456.6399291308514,"d":"456.6"},{"v":458.30698389874254,"d":"458.3"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-2.338064290211321,1.667054767891159,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":95.764582849175,"d":"95.8"},{"v":97.67123287671234,"d":"97.7"},{"v":96.80950163018166,"d":"96.8"},{"$nulls":5},1.9066500275373386,-0.861731246530681,null,1,null,null,0,{"v":456.18929177609573,"d":"456.2"},{"v":458.1607072259951,"d":"458.2"},{"v":457.2745146802003,"d":"457.3"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,1.971415449899382,-0.8861925457948132,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":97.3307912297426,"d":"97.3"},{"v":97.51056834194458,"d":"97.5"},{"v":96.83098591549296,"d":"96.8"},{"$nulls":5},0.17977711220197534,-0.679582426451617,null,1,null,null,0,{"v":457.811539575646,"d":"457.8"},{"v":457.99607653803906,"d":"458.0"},{"v":457.29670454934563,"d":"457.3"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.18453696239305373,-0.6993719886934286,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":96.84585847504114,"d":"96.8"},{"v":96.93849533223504,"d":"96.9"},{"v":98.63088718510406,"d":"98.6"},{"$nulls":5},0.09263685719389514,1.6923918528690223,null,1,null,null,0,{"v":457.3120626677869,"d":"457.3"},{"v":457.407670865694,"d":"457.4"},{"v":459.13844700091335,"d":"459.1"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.09560819790709729,1.7307761352193438,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":95.8502024291498,"d":"95.9"},{"v":95.78934137757668,"d":"95.8"},{"v":96.8049898167006,"d":"96.8"},{"$nulls":5},-0.060861051573127156,1.0156484391239218,null,1,null,null,0,{"v":456.2786581426302,"d":"456.3"},{"v":456.2151419680346,"d":"456.2"},{"v":457.2698540647183,"d":"457.3"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-0.06351617459563386,1.0547120966837156,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":96.274354923644,"d":"96.3"},{"v":97.47086864406779,"d":"97.5"},{"v":96.13904566444332,"d":"96.1"},{"$nulls":5},1.1965137204237948,-1.3318229796244765,null,1,null,null,0,{"v":456.7201979326866,"d":"456.7"},{"v":457.9553550221461,"d":"458.0"},{"v":456.57955358973385,"d":"456.6"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,1.2351570894595056,-1.3758014324122314,null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
{"$rows_empty":9}
[null,null,"Mean",{"v":96.74587496637498,"d":"96.7"},{"v":97.1099305632267,"d":"97.1"},{"v":97.22208656615716,"d":"97.2"},"","","",{"v":97.02596403191961,"d":"97.0"},"Mean of change",{"v":0.36405559685170935,"d":"0.4"},{"v":0.11215600293046382,"d":"0.1"},"Mean",7,null,null,"Mean",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},"","","",{"$error":"#NUM!"},"Mean",{"v":0.3763125765858279,"d":"0.4"},{"v":0.1156668489120258,"d":"0.1"},null,0]
[null,null,"SD",{"v":0.9421383063186529,"d":"0.9"},{"v":0.8547022815658663,"d":"0.9"},{"v":0.8263584012086181,"d":"0.8"},"","","",{"v":0.8757870337768463,"d":"0.9"},"SD of change",{"v":1.39286539920106,"d":"1.4"},{"v":1.280991028669111,"d":"1.3"},{"v":1.3380979104352333,"d":"1.34"},{"$nulls":3},"SD",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},"","","",{"$error":"#NUM!"},"SD",{"v":1.4337681098600297,"d":"1.4"},{"v":1.318153135096587,"d":"1.3"},{"$error":"#DIV/0!"}]
[null,null,"Total no. of subjects",7,7,7,0,0,0,7,"Total no. of subjects",7,7,7,{"$nulls":3},"N",7,7,7,0,0,0,null,"N",7,7]
[null,null,"Include which trials?",1,1,1,1,0,0,{"$nulls":5},"%",null,null,"Include which trials?",1,1,1,1,0,0]
[null,null,"DF",6,6,6,0,0,0,6,"SDCind (68%)",{"v":1.3887154423677996,"d":"1.39"},{"v":1.2771743946455938,"d":"1.28"},{"v":1.3341111299680273,"d":"1.33"},{"v":1.3750042509540346,"d":"1.38"},null,null,"DF",6,6,6,0,0,0,"Mean","Factor change in mean",{"v":1.0037702152136616,"d":"1.0"},{"v":1.001157337688106,"d":"1.0"},"Mean"]
[{"$nulls":10},"SDCgroup (68%)",{"v":0.5248851003343212,"d":"0.52"},{"v":0.48272654701310064,"d":"0.48"},{"v":0.5042466101741101,"d":"0.50"},{"v":0.519702757097289,"d":"0.52"},null,null,"Back-transformed mean","","","","","","","","SD of change as a factor",{"v":1.0144409586447796,"d":"1.01"},{"v":1.0132687907178468,"d":"1.01"},""]
[{"$nulls":10},"SWC",{"v":0.278573079840212,"d":"0.28"},{"v":0.25619820573382224,"d":"0.26"},{"v":0.26761958208704667,"d":"0.27"},{"v":0.27582264681132684,"d":"0.28"},null,null,"SD as a ×/÷ factor","","","","","","","","Change in mean (%)",{"v":0.3770215213661601,"d":"0.4"},{"v":0.11573376881059971,"d":"0.1"}]
[null,"For your data, you may have to set max and min values of X and Y axes to appropriate values.",{"$nulls":8},"CV",{"v":1.016120787679771,"d":"1.02"},{"v":0.9322163752440141,"d":"0.93"},{"v":0.9751803198255564,"d":"0.98"},{"$nulls":3},"SD as a CV (%)","","","","","","","","SD of change as CV (%)",{"v":1.4440958644779585,"d":"1.4"},{"v":1.3268790717846741,"d":"1.3"},""]
[{"$nulls":9},"Measures of reliability via the RAW variable",{"$nulls":7},"Total no. of subjects",7,7,7,0,0,0,"","Total no. of subjects",7,7,""]
[{"$nulls":9},"Raw","Trials","2-1","3-2","Mean",{"$nulls":10},"Measures of reliability via the LOG-TRANSFORMED variable"]
[{"$nulls":10},"Change in mean",{"v":0.36405559685170935,"d":"0.36"},{"v":0.11215600293046382,"d":"0.11"},{"$nulls":3},"Clear #NUM! and \"delete\" from the log-transformed cells to stop them plotting as zeros.",{"$nulls":7},"Factors","Trials","2-1","3-2","Mean"]
[{"$nulls":10},"Lower conf. limit",{"v":-0.6589387283596444,"d":"-0.66"},{"v":-0.8286718428375626,"d":"-0.83"},null," ",null,"Restore the log-transformation formula to those cells if you enter new data.",{"$nulls":8},"Factor change in mean","",""]
[{"$nulls":10},"Upper conf. limit",{"v":1.3870499220630632,"d":"1.39"},{"v":1.0529838486984902,"d":"1.05"},{"$nulls":12},"Lower conf. limit","",""]
[{"$nulls":10},"Conf. limits as ±value",{"v":1.0229943252113538,"d":"1.02"},{"v":0.9408278457680264,"d":"0.94"},{"$nulls":12},"Upper conf. limit","",""]
[{"$nulls":10},"Typical error",{"v":0.9849045690551771,"d":"0.98"},{"v":0.9057974430110595,"d":"0.91"},{"v":0.9461781063603031,"d":"0.95"},{"$nulls":11},"Conf. limits as ×/÷factor","",""]
[{"$nulls":10},"Lower conf. limit",{"v":0.6798757296389725,"d":"0.68"},{"v":0.625268393325688,"d":"0.63"},{"v":0.7037586749565816,"d":"0.70"},{"$nulls":11},"Factor typical error","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":1.8865140845627826,"d":"1.89"},{"v":1.734990056590535,"d":"1.73"},{"v":1.587477669220911,"d":"1.59"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Conf. limits as approx. ×/÷factor",{"v":1.665770846569144,"d":"1.67"},{"v":1.665770846569144,"d":"1.67"},{"v":1.501903162584035,"d":"1.50"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.0416666666666667,"d":"1.04"},{"v":1.0416666666666667,"d":"1.04"},{"v":1.0267094017094016,"d":"1.03"},{"$nulls":11},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":10},"Smallest effect from pure SD","","","",{"$nulls":11},"Bias correction factor","","",""]
[{"$nulls":10},"Lower conf. limit","","","",{"$nulls":11},"Smallest effect from pure SD","","",""]
[{"$nulls":10},"Upper conf. limit","","","",{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Smallest effect from observed SD",{"v":0.1798966691379736,"d":"0.18"},{"v":0.16812996147991954,"d":"0.17"},{"v":0.17515740675536928,"d":"0.18"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":0.12418195938224817,"d":"0.12"},{"v":0.11605944761225777,"d":"0.12"},{"v":0.12091046529890298,"d":"0.12"},{"$nulls":11},"Smallest effect from observed SD","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.3445791711782639,"d":"0.34"},{"v":0.3220408863298684,"d":"0.32"},{"v":0.33550145388855884,"d":"0.34"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Degrees of freedom",6,6,{"v":9.36,"d":"9"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":9},"Standardized (when ICC>0)",{"$nulls":15},"Degrees of freedom",0,0,""]
[{"$nulls":10},"Change in mean","","",{"$nulls":11},"Percents"]
[{"$nulls":10},"Lower conf. limit","","",{"$nulls":12},"Change in mean (%)","",""]
[{"$nulls":10},"Upper conf. limit","","",{"$nulls":12},"Lower conf. limit","",""]
[{"$nulls":10},"Conf. limits as ±value","","",{"$nulls":12},"Upper conf. limit","",""]
[{"$nulls":10},"Typical error","","",{"v":1.0803746457399512,"d":"1.08"},{"$nulls":11},"Conf. limits as approx. ±value","",""]
[{"$nulls":10},"Lower conf. limit","","",{"v":0.8035728411296642,"d":"0.80"},{"$nulls":11},"Typical error as a CV (%)","","",""]
[{"$nulls":10},"Upper conf. limit","","",{"v":1.8126297923992856,"d":"1.81"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Conf. limits as approx. ×/÷factor","","",{"v":1.5019031625840351,"d":"1.50"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.0416666666666667,"d":"1.04"},{"v":1.0416666666666667,"d":"1.04"},{"v":1.0267094017094016,"d":"1.03"},{"$nulls":11},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":9},"Correlations",{"$nulls":15},"Bias correction factor","","",""]
[{"$nulls":10},"Pearson correlation",{"v":-0.22388582014681502,"d":"-0.22"},{"v":-0.18070464112647866,"d":"-0.18"},{"v":-0.20239360489822544,"d":"-0.20"},{"$nulls":11},"Smallest effect from pure SD","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":-0.7818724709840036,"d":"-0.78"},{"v":-0.76374348514262,"d":"-0.76"},{"$nulls":12},"Lower conf. limit","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.5332557031915234,"d":"0.53"},{"v":0.5647060087078759,"d":"0.56"},{"$nulls":12},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.1200051418782637,"d":"1.12"},{"v":1.1217562180286915,"d":"1.12"},{"$nulls":12},"Smallest effect from observed SD","","",""]
[{"$nulls":10},"Intraclass correlation (ICC)",{"v":-0.2467221334591449,"d":"-0.25"},{"v":-0.200205776360562,"d":"-0.20"},{"v":-0.20784296825632753,"d":"-0.21"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":-0.7527832449374657,"d":"-0.75"},{"v":-0.7307685999868262,"d":"-0.73"},{"v":-0.4833413802367543,"d":"-0.48"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.4426392719180737,"d":"0.44"},{"v":0.4811510416418354,"d":"0.48"},{"v":0.3356379361651982,"d":"0.34"},{"$nulls":10},"Standardized (when ICC>0)"]
[{"$nulls":10},"Effective no. of trials",{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2.5599999999999996,"d":"2.6"},{"$nulls":11},"Change in mean","",""]
[{"$nulls":10},"F",{"v":0.6042067003742178,"d":"0.6"},{"v":0.6663809151666392,"d":"0.7"},{"v":0.5594808160332965,"d":"0.6"},{"$nulls":11},"Lower conf. limit","",""]
[{"$nulls":10},"Numerator DF",6,6,6,{"$nulls":11},"Upper conf. limit","",""]
[{"$nulls":10},"Denominator DF",6,6,{"v":9.36,"d":"9"},{"$nulls":11},"Conf. limits as ±value","",""]
[{"$nulls":10},"F lower",{"v":0.14104239972430493,"d":"0.1"},{"v":0.15555597670030713,"d":"0.2"},{"v":0.16583333419270055,"d":"0.2"},{"$nulls":11},"Typical error","","",""]
[{"$nulls":10},"F upper",{"v":2.5883403677950207,"d":"2.6"},{"v":2.8546863548281194,"d":"2.9"},{"v":2.293320560212724,"d":"2.3"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Fisher r",{"v":-0.22774326309092444,"d":"-0.23"},{"v":-0.1827110201729497,"d":"-0.18"},{"v":-0.20522714163193706,"d":"-0.21"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Fisher SE^-2",4,4,{"$nulls":12},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":10},"Pure variance","","","",{"$nulls":11},"Bias correction factor","","",""]
[{"$nulls":10},"SE of pure variance","","","",{"$nulls":10},"Correlations"]
[{"$nulls":10},"LCL","","","",{"$nulls":11},"Pearson correlation","","",""]
[{"$nulls":10},"UCL","","","",{"$nulls":11},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Bias correction factor","",""]
[{"$nulls":25},"Intraclass correlation","","",""]
[{"$nulls":25},"Lower conf. limit","","",""]
[{"$nulls":25},"Upper conf. limit","","",""]
[]
[{"$nulls":24},"Measures of reliability of log-transformed variable"]
[{"$nulls":26},"2-1","3-2","Mean"]
[{"$nulls":25},"Change in mean","",""]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Typical error","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Bias correction factor","","",""]
[{"$nulls":25},"Smallest effect from pure SD","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Smallest effect from observed SD","","",{"$error":"#NUM!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"DF",0,0,{"$error":"#DIV/0!"}]
[]
[{"$nulls":25},"Stdized change in mean","",""]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Stdized typical error","","",""]
[{"$nulls":25},"Lower conf. limit","","",""]
[{"$nulls":25},"Upper conf. limit","","",""]
[]
[{"$nulls":25},"Pearson r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Bias correction factor","",""]
[{"$nulls":25},"Intraclass r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Effective no. of trials","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"F","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Numerator DF",0,"",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Denominator DF",0,0,{"$error":"#DIV/0!"}]
[{"$nulls":25},"F lower","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"F upper","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Fisher r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Fisher SE^-2","",""]
[{"$nulls":25},"Pure variance","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"SE of pure variance","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"LCL","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"UCL","","",{"$error":"#DIV/0!"}]

{"sheet":"150-200m","index":3,"n_rows":154,"n_cols":30,"rows_kept":154,"merged":[[75,9,75,10],[85,9,85,10],[92,24,92,25],[102,24,102,25]],"flags":["formulas_cached_only"]}
[null,"CONSECUTIVE PAIRWISE ANALYSIS OF TRIALS FOR RELIABILITY"]
[null,"Hover cursor for citation:"]
[null,"Hover cursor for updates:",null,2019,2018,2015,2012,2010,2009]
[]
[null,"This spreadsheet calculates reliability statistics for consecutive pairs of trials and for the means of these statistics when there are >2 trials.  "]
[null,"    For trials spaced at equal intervals, these means are better estimates of test-retest reliability than the more usual ANOVA-based reliablity statistics."]
[null,"   But see the 1-way and 2-way spreadsheets in this workbook for such analyses."]
[null,"The reliability statistics are calculated for raw data and after log transformation."]
[null,"    See the instructions in dark red to help you decide between which is better for your data."]
[null,"    The data shown here are what you would expect for countermovement-jump height (best of three jumps) of team-sport athletes in trials separated by only a day or two."]
[null,"    I generated the data by putting appropriate means and SD into the 2-way spreadsheet."]
[null,"Delete and replace the numbers in blue. Stats you might want are in red. Don't change any cells with a colored background. "]
[null,"Missing values must be blanks or the graphs will display incorrectly. (The X values will plot as consecutive integers.)"]
[null,"Clear all the \"delete\" and #NUM! corresponding to missing values. Restore the formula (by copying an adjacent cell) if you restore a missing value or for new data."]
[null,"Check the graphs (especially of the change scores) for outliers and non-uniformity of scatter. The log-transformed variables may show less non-uniformity."]
[null,"For more than 20 subjects, COPY any number of rows after the first data row and INSERT in the same place without deselecting. "]
[null,"    Do NOT copy and insert the first data row.  ",{"$nulls":10},"Use analysis of RAW data in one or more of the following situations:",{"$nulls":6},"Use LOG transformation in one or more of the following situations:"]
[null,"    Double-click on any of the red mean or SD cells to check that you have done this operation properly. ",{"$nulls":10},"   the data can be zero or negative;",{"$nulls":6},"   the data can only be positive and non-zero;"]
[null,"    Colored boxes should enclose all rows of your data.",{"$nulls":10},"   the data were measured from an arbitrary reference value;",{"$nulls":6},"   the between-subject SD or change-score SD is more than ~20% of the mean;"]
[null,"For less than 20 subjects, delete or clear any unwanted or empty rows.",{"$nulls":10},"   the magnitude of the error is expected to be similar for all subjects.",{"$nulls":6},"   the magnitude of the percent or factor error is expected to be similar for all subjects."]
[null,"To remove a trial, clear its data, or set the corrresponding \"Include which trials?\" cell to 0 or blank."]
[null,"For more than 6 trials, copy and insert the entire column(s) for Trials 5 and/or 6 and their change scores for the RAW and the LOG data. ",{"$nulls":10},"Missing values produce delete in the panel of change scores.",{"$nulls":6},"Missing values produce #NUM! in the panel of log-transformed data.",{"$nulls":6},"Missing values produce delete in the panel of change scores."]
[null,"    And follow the instructions in the cells indicated by \"Hover cursor for >6 trials\". If such editing is too difficult for you, contact me. ",{"$nulls":10},"Clear delete from these cells to stop them plotting as zeros.",{"$nulls":6},"Clear #NUM! from these cells to get complete analyses.",{"$nulls":6},"Clear delete from these cells to stop them plotting as zeros."]
[{"$nulls":12},"Copy-paste or drag a corner to restore formulae to those cells if you enter new data.",{"$nulls":6},"Copy-paste or drag a corner to restore formulae to those cells if you enter new data.",{"$nulls":6},"Copy-paste or -drag to restore formulae to those cells if you enter new data."]
[]
[null,null,"Choose smallest effect:",0.2]
[null,null,"Choose conf. limits (%):",90,null,null,"Hover cursor for >6 trials:","Read","me",{"$nulls":3},"Hover cursor for >6 trials:","Do not",{"$nulls":6},"Hover cursor for >6 trials:","Read me","Read","me","Do not",null,null,"Hover cursor for >6 trials:","Do not"]
[null,null,"RAW Data",{"$nulls":8},"Change scores of raw data",null,"modify","Any",{"$nulls":3},"100*LOG-Transformed Data",{"$nulls":5},"modify",null,"Change scores of Log-transformed data",null,"modify","Any"]
[null,null,"Trial:",1,2,3,4,5,6,"Mean",null,"2-1","3-2","this col.","subject?",{"$nulls":3},1,2,3,4,5,6,"this col.",null,"2-1","3-2","this col.","subject?"]
[{"$nulls":3},{"v":94.82677902621724,"d":"94.8"},{"v":98.61985472154961,"d":"98.6"},{"v":98.2262703739214,"d":"98.2"},{"$nulls":5},3.7930756953323765,-0.39358434762822014,null,1,null,null,0,{"v":455.2051848550751,"d":"455.2"},{"v":459.1272607681425,"d":"459.1"},{"v":458.7273698666274,"d":"458.7"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,3.922075913067374,-0.3998909015151071,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":97.03091106290672,"d":"97.0"},{"v":94.27821522309712,"d":"94.3"},{"v":97.60087241003271,"d":"97.6"},{"$nulls":5},-2.752695839809604,3.3226571869355865,null,1,null,null,0,{"v":457.5029598490259,"d":"457.5"},{"v":454.62501472894354,"d":"454.6"},{"v":458.08864320064816,"d":"458.1"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-2.8779451200823587,3.4636284717046237,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":95.98765432098764,"d":"96.0"},{"v":97.22727272727273,"d":"97.2"},{"v":97.3536299765808,"d":"97.4"},{"$nulls":5},1.2396184062850892,0.12635724930807157,null,1,null,null,0,{"v":456.42195823749955,"d":"456.4"},{"v":457.705125572409,"d":"457.7"},{"v":457.83500190180587,"d":"457.8"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,1.2831673349094217,0.1298763293968932,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":97.56330625895842,"d":"97.6"},{"v":97.9245283018868,"d":"97.9"},{"v":98.44868735083533,"d":"98.4"},{"$nulls":5},0.36122204292837523,0.5241590489485333,null,1,null,null,0,{"v":458.0501462266702,"d":"458.1"},{"v":458.41970626078125,"d":"458.4"},{"v":458.95354718406895,"d":"459.0"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.3695600341110321,0.5338409232876984,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":96.73972602739725,"d":"96.7"},{"v":96.99175824175825,"d":"97.0"},{"v":96.77592692101021,"d":"96.8"},{"$nulls":5},0.25203221436099454,-0.21583132074803757,null,1,null,null,0,{"v":457.2024135339941,"d":"457.2"},{"v":457.46260083137065,"d":"457.5"},{"v":457.2398274521797,"d":"457.2"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.26018729737654667,-0.22277337919092588,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":97.12820512820512,"d":"97.1"},{"v":94.97756729810568,"d":"95.0"},{"v":99.8031496062992,"d":"99.8"},{"$nulls":5},-2.1506378300994413,4.825582308193518,null,1,null,null,0,{"v":457.6031808176323,"d":"457.6"},{"v":455.36407300124375,"d":"455.4"},{"v":460.31997420007923,"d":"460.3"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-2.2391078163885254,4.955901198835477,null,{"$error":"#NUM!"}]
[{"$nulls":3},{"v":96.5285110876452,"d":"96.5"},{"v":97.88563829787233,"d":"97.9"},{"v":98.87862796833772,"d":"98.9"},{"$nulls":5},1.3571272102271337,0.9929896704653913,null,1,null,null,0,{"v":456.98384163931286,"d":"457.0"},{"v":458.37998411029116,"d":"458.4"},{"v":459.38931178883723,"d":"459.4"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,1.3961424709783046,1.0093276785460716,null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
[{"$nulls":11},"delete","delete",null,0,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,"delete","delete",null,{"$error":"#NUM!"}]
{"$rows_empty":9}
[null,null,"Mean",{"v":96.54358470175966,"d":"96.5"},{"v":96.84354783022036,"d":"96.8"},{"v":98.15530922957389,"d":"98.2"},"","","",{"v":97.18081392051798,"d":"97.2"},"Mean of change",{"v":0.2999631284607034,"d":"0.3"},{"v":1.3117613993535489,"d":"1.3"},"Mean",7,null,null,"Mean",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},"","","",{"$error":"#NUM!"},"Mean",{"v":0.3020114448531136,"d":"0.3"},{"v":1.3528443315806757,"d":"1.4"},null,0]
[null,null,"SD",{"v":0.9050118810276574,"d":"0.9"},{"v":1.6146084844932673,"d":"1.6"},{"v":1.0150910858781816,"d":"1.0"},"","","",{"v":1.218799542668688,"d":"1.2"},"SD of change",{"v":2.21858082279124,"d":"2.2"},{"v":1.9899538838718176,"d":"2.0"},{"v":2.107370082258167,"d":"2.11"},{"$nulls":3},"SD",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},"","","",{"$error":"#NUM!"},"SD",{"v":2.3036340588622752,"d":"2.3"},{"v":2.052498536368794,"d":"2.1"},{"$error":"#DIV/0!"}]
[null,null,"Total no. of subjects",7,7,7,0,0,0,7,"Total no. of subjects",7,7,7,{"$nulls":3},"N",7,7,7,0,0,0,null,"N",7,7]
[null,null,"Include which trials?",1,1,1,1,0,0,{"$nulls":5},"%",null,null,"Include which trials?",1,1,1,1,0,0]
[null,null,"DF",6,6,6,0,0,0,6,"SDCind (68%)",{"v":2.211970697612623,"d":"2.21"},{"v":1.98402493860332,"d":"1.98"},{"v":2.101091302644507,"d":"2.10"},{"v":2.1620433271560606,"d":"2.16"},null,null,"DF",6,6,6,0,0,0,"Mean","Factor change in mean",{"v":1.003024679588764,"d":"1.0"},{"v":1.0136203667643893,"d":"1.0"},"Mean"]
[{"$nulls":10},"SDCgroup (68%)",{"v":0.8360463390350078,"d":"0.84"},{"v":0.7498909403563682,"d":"0.75"},{"v":0.7941378669483018,"d":"0.79"},{"v":0.8171755667716567,"d":"0.82"},null,null,"Back-transformed mean","","","","","","","","SD of change as a factor",{"v":1.0233037263312732,"d":"1.02"},{"v":1.0207370714115482,"d":"1.02"},""]
[{"$nulls":10},"SWC",{"v":0.44371616455824797,"d":"0.44"},{"v":0.39799077677436356,"d":"0.40"},{"v":0.4214740164516334,"d":"0.42"},{"v":0.43370085045423434,"d":"0.43"},null,null,"SD as a ×/÷ factor","","","","","","","","Change in mean (%)",{"v":0.3024679588764059,"d":"0.3"},{"v":1.3620366764389331,"d":"1.4"}]
[null,"For your data, you may have to set max and min values of X and Y axes to appropriate values.",{"$nulls":8},"CV",{"v":1.6224177109060667,"d":"1.62"},{"v":1.4431980851075397,"d":"1.44"},{"v":1.533364061812809,"d":"1.53"},{"$nulls":3},"SD as a CV (%)","","","","","","","","SD of change as CV (%)",{"v":2.3303726331273253,"d":"2.3"},{"v":2.073707141154827,"d":"2.1"},""]
[{"$nulls":9},"Measures of reliability via the RAW variable",{"$nulls":7},"Total no. of subjects",7,7,7,0,0,0,"","Total no. of subjects",7,7,""]
[{"$nulls":9},"Raw","Trials","2-1","3-2","Mean",{"$nulls":10},"Measures of reliability via the LOG-TRANSFORMED variable"]
[{"$nulls":10},"Change in mean",{"v":0.2999631284607034,"d":"0.30"},{"v":1.3117613993535489,"d":"1.31"},{"$nulls":3},"Clear #NUM! and \"delete\" from the log-transformed cells to stop them plotting as zeros.",{"$nulls":7},"Factors","Trials","2-1","3-2","Mean"]
[{"$nulls":10},"Lower conf. limit",{"v":-1.3294804581486004,"d":"-1.33"},{"v":-0.1497664207795637,"d":"-0.15"},null," ",null,"Restore the log-transformation formula to those cells if you enter new data.",{"$nulls":8},"Factor change in mean","",""]
[{"$nulls":10},"Upper conf. limit",{"v":1.9294067150700072,"d":"1.93"},{"v":2.7732892194866614,"d":"2.77"},{"$nulls":12},"Lower conf. limit","",""]
[{"$nulls":10},"Conf. limits as ±value",{"v":1.6294435866093038,"d":"1.63"},{"v":1.4615278201331126,"d":"1.46"},{"$nulls":12},"Upper conf. limit","",""]
[{"$nulls":10},"Typical error",{"v":1.5687735444061157,"d":"1.57"},{"v":1.4071098855342696,"d":"1.41"},{"v":1.4901356756344022,"d":"1.49"},{"$nulls":11},"Conf. limits as ×/÷factor","",""]
[{"$nulls":10},"Lower conf. limit",{"v":1.082918174665989,"d":"1.08"},{"v":0.971322390175883,"d":"0.97"},{"v":1.108349370526077,"d":"1.11"},{"$nulls":11},"Factor typical error","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":3.004873243557686,"d":"3.00"},{"v":2.695218096240967,"d":"2.70"},{"v":2.500118205312001,"d":"2.50"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Conf. limits as approx. ×/÷factor",{"v":1.6657708465691439,"d":"1.67"},{"v":1.665770846569144,"d":"1.67"},{"v":1.501903162584035,"d":"1.50"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.0416666666666667,"d":"1.04"},{"v":1.0416666666666667,"d":"1.04"},{"v":1.0267094017094016,"d":"1.03"},{"$nulls":11},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":10},"Smallest effect from pure SD","","","",{"$nulls":11},"Bias correction factor","","",""]
[{"$nulls":10},"Lower conf. limit","","","",{"$nulls":11},"Smallest effect from pure SD","","",""]
[{"$nulls":10},"Upper conf. limit","","","",{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Smallest effect from observed SD",{"v":0.2617635216373307,"d":"0.26"},{"v":0.26971727682249025,"d":"0.27"},{"v":0.2437599085337376,"d":"0.24"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":0.18069432395543794,"d":"0.18"},{"v":0.18618476971006329,"d":"0.19"},{"v":0.16826650101754131,"d":"0.17"},{"$nulls":11},"Smallest effect from observed SD","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.5013892573036829,"d":"0.50"},{"v":0.5166241050781855,"d":"0.52"},{"v":0.46690462725924176,"d":"0.47"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Degrees of freedom",6,6,{"v":9.36,"d":"9"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":9},"Standardized (when ICC>0)",{"$nulls":15},"Degrees of freedom",0,0,""]
[{"$nulls":10},"Change in mean","","",{"$nulls":11},"Percents"]
[{"$nulls":10},"Lower conf. limit","","",{"$nulls":12},"Change in mean (%)","",""]
[{"$nulls":10},"Upper conf. limit","","",{"$nulls":12},"Lower conf. limit","",""]
[{"$nulls":10},"Conf. limits as ±value","","",{"$nulls":12},"Upper conf. limit","",""]
[{"$nulls":10},"Typical error","","",{"v":1.222625725943083,"d":"1.22"},{"$nulls":11},"Conf. limits as approx. ±value","",""]
[{"$nulls":10},"Lower conf. limit","","",{"v":0.9093779015532211,"d":"0.91"},{"$nulls":11},"Typical error as a CV (%)","","",""]
[{"$nulls":10},"Upper conf. limit","","",{"v":2.05129565427776,"d":"2.05"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Conf. limits as approx. ×/÷factor","","",{"v":1.5019031625840351,"d":"1.50"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.0416666666666667,"d":"1.04"},{"v":1.0416666666666667,"d":"1.04"},{"v":1.0267094017094016,"d":"1.03"},{"$nulls":11},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":9},"Correlations",{"$nulls":15},"Bias correction factor","","",""]
[{"$nulls":10},"Pearson correlation",{"v":-0.5591469653287594,"d":"-0.56"},{"v":-0.11057945817886766,"d":"-0.11"},{"v":-0.3551391188562229,"d":"-0.36"},{"$nulls":11},"Smallest effect from pure SD","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":-0.8964845360385377,"d":"-0.90"},{"v":-0.7322031364660955,"d":"-0.73"},{"$nulls":12},"Lower conf. limit","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.18855215726192542,"d":"0.19"},{"v":0.6115497940967946,"d":"0.61"},{"$nulls":12},"Upper conf. limit","","",""]
[{"$nulls":10},"Bias correction factor",{"v":1.0922414516351968,"d":"1.09"},{"v":1.1237897117286808,"d":"1.12"},{"$nulls":12},"Smallest effect from observed SD","","",""]
[{"$nulls":10},"Intraclass correlation (ICC)",{"v":-0.5250405264518957,"d":"-0.53"},{"v":-0.11067017113655309,"d":"-0.11"},{"v":-0.5882294679483985,"d":"-0.59"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Lower conf. limit",{"v":-0.8644527523523102,"d":"-0.86"},{"v":-0.6850420070379951,"d":"-0.69"},{"v":-0.6250141062649438,"d":"-0.63"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Upper conf. limit",{"v":0.14316420752886583,"d":"0.14"},{"v":0.5485484097596405,"d":"0.55"},{"v":-0.4442341288675642,"d":"-0.44"},{"$nulls":10},"Standardized (when ICC>0)"]
[{"$nulls":10},"Effective no. of trials",{"v":2,"d":"2.0"},{"v":2,"d":"2.0"},{"v":2.5599999999999996,"d":"2.6"},{"$nulls":11},"Change in mean","",""]
[{"$nulls":10},"F",{"v":0.3114405586670722,"d":"0.3"},{"v":0.8007146063474382,"d":"0.8"},{"v":0.05185776467608927,"d":"0.1"},{"$nulls":11},"Lower conf. limit","",""]
[{"$nulls":10},"Numerator DF",6,6,6,{"$nulls":11},"Upper conf. limit","",""]
[{"$nulls":10},"Denominator DF",6,6,{"v":9.36,"d":"9"},{"$nulls":11},"Conf. limits as ±value","",""]
[{"$nulls":10},"F lower",{"v":0.07270082198472162,"d":"0.1"},{"v":0.18691403041971943,"d":"0.2"},{"v":0.015370939938545694,"d":"0.0"},{"$nulls":11},"Typical error","","",""]
[{"$nulls":10},"F upper",{"v":1.3341695311676394,"d":"1.3"},{"v":3.430153848688783,"d":"3.4"},{"v":0.21256578336596793,"d":"0.2"},{"$nulls":11},"Lower conf. limit","","",""]
[{"$nulls":10},"Fisher r",{"v":-0.6315912841981138,"d":"-0.63"},{"v":-0.11103350920545164,"d":"-0.11"},{"v":-0.37131239670178273,"d":"-0.37"},{"$nulls":11},"Upper conf. limit","","",""]
[{"$nulls":10},"Fisher SE^-2",4,4,{"$nulls":12},"Conf. limits as approx. ×/÷factor","","",""]
[{"$nulls":10},"Pure variance","","","",{"$nulls":11},"Bias correction factor","","",""]
[{"$nulls":10},"SE of pure variance","","","",{"$nulls":10},"Correlations"]
[{"$nulls":10},"LCL","","","",{"$nulls":11},"Pearson correlation","","",""]
[{"$nulls":10},"UCL","","","",{"$nulls":11},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Bias correction factor","",""]
[{"$nulls":25},"Intraclass correlation","","",""]
[{"$nulls":25},"Lower conf. limit","","",""]
[{"$nulls":25},"Upper conf. limit","","",""]
[]
[{"$nulls":24},"Measures of reliability of log-transformed variable"]
[{"$nulls":26},"2-1","3-2","Mean"]
[{"$nulls":25},"Change in mean","",""]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Typical error","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Bias correction factor","","",""]
[{"$nulls":25},"Smallest effect from pure SD","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Smallest effect from observed SD","","",{"$error":"#NUM!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"DF",0,0,{"$error":"#DIV/0!"}]
[]
[{"$nulls":25},"Stdized change in mean","",""]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Stdized typical error","","",""]
[{"$nulls":25},"Lower conf. limit","","",""]
[{"$nulls":25},"Upper conf. limit","","",""]
[]
[{"$nulls":25},"Pearson r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","",""]
[{"$nulls":25},"Upper conf. limit","",""]
[{"$nulls":25},"Bias correction factor","",""]
[{"$nulls":25},"Intraclass r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Lower conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Upper conf. limit","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Effective no. of trials","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"F","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Numerator DF",0,"",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Denominator DF",0,0,{"$error":"#DIV/0!"}]
[{"$nulls":25},"F lower","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"F upper","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Fisher r","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"Fisher SE^-2","",""]
[{"$nulls":25},"Pure variance","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"SE of pure variance","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"LCL","","",{"$error":"#DIV/0!"}]
[{"$nulls":25},"UCL","","",{"$error":"#DIV/0!"}]

{"sheet":"1-way","index":4,"n_rows":87,"n_cols":36,"rows_kept":87,"merged":[[1,1,1,2]],"flags":["formulas_cached_only"]}
[null,"SIMULATION AND ANALYSIS FOR 1-WAY RELIABILITY"]
[null,"Hover cursor for citation:"]
[null,"This spreadsheet simulates and analyzes data for a 1-way reliability study. It was adapted from a spreadsheet in the article Understanding Stats via Simulations."]
[{"$nulls":4},"Sequence of development of the simulation:"]
[null,"The data are 10 repeated measurements on each of 20 subjects.  The data could be something like distance of high-speed running in games"]
[null,"     or values of repeated tests on athletes, when you are confident that the tests are in some sense all similar (no habituation or order effects).  "]
[null,"Such data are unusual, but I have provided this spreadsheet to help you understand reliability, even if you don't use it for your own data."]
[null,"All subjects have been given the same variability from measurement to measurement, the within-subject random error."]
[null,"For this 1-way analysis of reliability, the measurements are not associated with particular games."]
[null,"The data are simulated by assigning percent standard deviations (coefficients of variation) to the differences between subjects and to the within-subject random error."]
[null,"The data therefore need log transformation before analysis, the aim of which is to estimate the two CVs and to express them as intraclass correlations. coefficient."]
[null,"An analysis is also shown for the raw data, and for the mean of a chosen number of repeated measurements. "]
[null,"Change the values in bold blue and see what happens to the outcomes in red.   "]
[null,"To generate a whole new set of data, click in a blank cell away from other cells and hit Ctrl-D."]
[null,"This spreadsheet works with missing data. Try deleting some. Copy-drag or copy-paste from adjacent cells to reinstate those cells."]
[null,"To analyze your own data, replace the main block of data shown in plum color."]
[null,"You can also delete or copy-and-insert whole rows and whole columns.  "]
[null,"   Don't delete and don't copy-and-insert the first data row or the first five data columns (or you will corrupt the spreadsheet)."]
[null,"For data requiring log transformation, whatever deletions and insertions you do to the block of raw data"]
[null,"   will have to be done to the block of log-transformed data. Check that the right cells have been transformed."]
[null,"Read the article for an explanation of the analyses."]
[{"$nulls":5},"Do not use log transformation in one or more of the following situations:",{"$nulls":11},"Use log transformation in one or more of the following situations:"]
[null,null,"Choose confidence level (%):",90,null,"   the data can be zero or negative;",{"$nulls":11},"   the data can only be positive and non-zero;"]
[null,"Simulation to create raw observed values",{"$nulls":3},"   the data were measured from an arbitrary reference value;",{"$nulls":11},"   the within-subject, between-subject or between-trial SD is more than ~20% of the mean;"]
[{"$nulls":3},"Depedent variable",null,"   the magnitude of the error is expected to be similar for all subjects.",{"$nulls":11},"   the magnitude of the percent or factor error is expected to be similar for all subjects."]
[{"$nulls":3},"True values"]
[null,null,"Mean",400]
[null,null,"Between-subject CV (%)",30,{"$nulls":7},"<– Insert or delete whole columns here –>",{"$nulls":16},"<– Insert or delete whole columns here –>"]
[null,null,"Equivalent ´¤¸ factor SD",1.3,{"$nulls":17},"100*log(observed values)"]
[null,null,"Within-subject random error (%)",null,10,10,10,10,10,10,10,10,10,10,{"$nulls":7},"If you have missing raw data, you will have to delete #NUM! from the corresponding cells here."]
[]
[{"$nulls":17},"For sums of",{"$nulls":16},"For sums of"]
[{"$nulls":15},"Mean",null,"squares",{"$nulls":14},"Mean",null,"squares"]
[null,"Do not copy/insert this row",{"v":328.3842700570984,"d":"328"},"Alex",{"v":374.11259785425045,"d":"374"},{"v":385.851536464543,"d":"386"},{"v":323.5378042433186,"d":"324"},{"v":288.14000423579574,"d":"288"},{"v":324.1188758929677,"d":"324"},{"v":273.3349673946819,"d":"273"},{"v":333.98750575152184,"d":"334"},{"v":304.5075221642456,"d":"305"},{"v":348.4228177954446,"d":"348"},{"v":352.0466188173035,"d":"352"},null,{"v":330.80602506140724,"d":"331"},null,77031.94006779235,10,null,null,{"v":592.4556815885344,"d":"592.5"},{"v":595.5452674921194,"d":"595.5"},{"v":577.9315967216339,"d":"577.9"},{"v":566.3446487833805,"d":"566.3"},{"v":578.1110349404873,"d":"578.1"},{"v":561.0698029845546,"d":"561.1"},{"v":581.1103584347431,"d":"581.1"},{"v":571.8695790175685,"d":"571.9"},{"v":585.341673593206,"d":"585.3"},{"v":586.3763606650604,"d":"586.4"},null,{"v":579.6156004221288,"d":"580"},null,4056.425395396727,10]
[null,null,{"v":514.1767083718727,"d":"514"},"Ariel",{"v":488.7326770448264,"d":"489"},{"v":444.38820363689814,"d":"444"},{"v":668.7760252109186,"d":"669"},{"v":446.95484767376365,"d":"447"},{"v":536.1034668919228,"d":"536"},{"v":457.96305141809586,"d":"458"},{"v":560.8596473079698,"d":"561"},{"v":590.1970532331121,"d":"590"},{"v":519.2775666774455,"d":"519"},{"v":493.5109567841407,"d":"494"},null,{"v":520.6763495879093,"d":"521"},null,104249.17034116082,10,null,null,{"v":619.18156672849,"d":"619.2"},{"v":609.6698512941738,"d":"609.7"},{"v":650.5449213656243,"d":"650.5"},{"v":610.2457577596005,"d":"610.2"},{"v":628.4327177688021,"d":"628.4"},{"v":612.6788507100266,"d":"612.7"},{"v":632.9470691169948,"d":"632.9"},{"v":638.045646966871,"d":"638.0"},{"v":625.2438550759538,"d":"625.2"},{"v":620.1545060823912,"d":"620.2"},null,{"v":624.7144742868927,"d":"625"},null,6229.169570673766,10]
[null,null,{"v":491.5772556782346,"d":"492"},"Ashley",{"v":445.6027737588268,"d":"446"},{"v":512.2950937418404,"d":"512"},{"v":484.39912145633286,"d":"484"},{"v":564.0754457887532,"d":"564"},{"v":553.1617358656688,"d":"553"},{"v":478.3330944631288,"d":"478"},{"v":521.4672735602978,"d":"521"},{"v":503.2984640236443,"d":"503"},{"v":547.752791455948,"d":"548"},{"v":536.3548608870909,"d":"536"},null,{"v":514.6740655001532,"d":"515"},null,92352.48230361815,10,null,null,{"v":609.9427913366651,"d":"609.9"},{"v":623.8900813975308,"d":"623.9"},{"v":618.2909198003331,"d":"618.3"},{"v":633.5188011680762,"d":"633.5"},{"v":631.565042868118,"d":"631.6"},{"v":617.0307340145268,"d":"617.0"},{"v":625.6646518033139,"d":"625.7"},{"v":622.1183361966897,"d":"622.1"},{"v":630.5824074685224,"d":"630.6"},{"v":628.479599590363,"d":"628.5"},null,{"v":624.1083365644139,"d":"624"},null,5930.280204694431,10]
[null,null,{"v":365.52757728497306,"d":"366"},"Bernie",{"v":330.1792294587821,"d":"330"},{"v":405.4071162661402,"d":"405"},{"v":416.1048649663274,"d":"416"},{"v":364.7394567090547,"d":"365"},{"v":307.8719355381789,"d":"308"},{"v":361.8017678804534,"d":"362"},{"v":343.6823843769352,"d":"344"},{"v":388.0352927095666,"d":"388"},{"v":340.4014950524661,"d":"340"},{"v":293.02281406157107,"d":"293"},null,{"v":355.1246357019475,"d":"355"},null,40258.04900423518,10,null,null,{"v":579.9635626596539,"d":"580.0"},{"v":600.4891787554363,"d":"600.5"},{"v":603.0937307740608,"d":"603.1"},{"v":589.9183281458198,"d":"589.9"},{"v":572.9683902800191,"d":"573.0"},{"v":589.1096459296557,"d":"589.1"},{"v":583.971792963843,"d":"584.0"},{"v":596.1096296078276,"d":"596.1"},{"v":583.0125788735596,"d":"583.0"},{"v":568.0250469677217,"d":"568.0"},null,{"v":586.6661884957597,"d":"587"},null,1713.476135836766,10]
[null,null,{"v":325.24857446232306,"d":"325"},"Casey",{"v":356.20493753702993,"d":"356"},{"v":363.59032371698726,"d":"364"},{"v":271.9997513158441,"d":"272"},{"v":363.29688808622507,"d":"363"},{"v":325.4565007038849,"d":"325"},{"v":402.30619899117414,"d":"402"},{"v":326.794924558005,"d":"327"},{"v":297.6637915275278,"d":"298"},{"v":360.9165529265296,"d":"361"},{"v":301.0247366448166,"d":"301"},null,{"v":336.92546060080247,"d":"337"},null,66664.6220075457,10,null,null,{"v":587.5506232458057,"d":"587.6"},{"v":589.6027749509677,"d":"589.6"},{"v":560.5801152015595,"d":"560.6"},{"v":589.522037350433,"d":"589.5"},{"v":578.5228814327696,"d":"578.5"},{"v":599.7213487713921,"d":"599.7"},{"v":578.9332832136986,"d":"578.9"},{"v":569.5964633239663,"d":"569.6"},{"v":588.8646776284197,"d":"588.9"},{"v":570.7192442916398,"d":"570.7"},null,{"v":581.3613449410652,"d":"581"},null,3383.695858605075,10]
[null,null,{"v":311.55556731575666,"d":"312"},"Chris",{"v":268.5941452308304,"d":"269"},{"v":382.11203539796884,"d":"382"},{"v":297.42530749793116,"d":"297"},{"v":328.82098216206026,"d":"329"},{"v":299.08232488913336,"d":"299"},{"v":326.1593129199711,"d":"326"},{"v":267.3993831664983,"d":"267"},{"v":352.9166036593816,"d":"353"},{"v":339.0325054439782,"d":"339"},{"v":328.0195784834782,"d":"328"},null,{"v":318.9562178851231,"d":"319"},null,99236.75933705117,10,null,null,{"v":559.3201486497999,"d":"559.3"},{"v":594.5713851988648,"d":"594.6"},{"v":569.5163126229186,"d":"569.5"},{"v":579.5513475507472,"d":"579.6"},{"v":570.0718869570585,"d":"570.1"},{"v":578.738595193523,"d":"578.7"},{"v":558.8743357883201,"d":"558.9"},{"v":586.62317787651,"d":"586.6"},{"v":582.6095989049079,"d":"582.6"},{"v":579.3073297101146,"d":"579.3"},null,{"v":575.9184118452765,"d":"576"},null,5682.387098409645,10]
[null,null,{"v":321.07388659765513,"d":"321"},"Corey",{"v":321.10418376811737,"d":"321"},{"v":335.9808040921471,"d":"336"},{"v":320.9945133099862,"d":"321"},{"v":270.16141896124316,"d":"270"},{"v":317.6099566626476,"d":"318"},{"v":321.19107784228333,"d":"321"},{"v":332.8713310736874,"d":"333"},{"v":299.5747022500559,"d":"300"},{"v":316.7332556887323,"d":"317"},{"v":293.88306289169634,"d":"294"},null,{"v":313.01043065405963,"d":"313"},null,111436.3900683119,10,null,null,{"v":577.1765630497092,"d":"577.2"},{"v":581.7054027653052,"d":"581.7"},{"v":577.1424030491683,"d":"577.1"},{"v":559.9019628363056,"d":"559.9"},{"v":576.0824078575064,"d":"576.1"},{"v":577.2036204109852,"d":"577.2"},{"v":580.7756022139257,"d":"580.8"},{"v":570.2363809660237,"d":"570.2"},{"v":575.8059954942813,"d":"575.8"},{"v":568.3181942950713,"d":"568.3"},null,{"v":574.4348532938282,"d":"574"},null,6411.690754830615,10]
[null,null,{"v":560.0729420084939,"d":"560"},"Courtney",{"v":548.7633899143384,"d":"549"},{"v":608.5039343986443,"d":"609"},{"v":567.0973784499058,"d":"567"},{"v":520.0119882642404,"d":"520"},{"v":509.0713862519553,"d":"509"},{"v":569.8194500406855,"d":"570"},{"v":548.5473617308597,"d":"549"},{"v":527.5643760485366,"d":"528"},{"v":685.8526453738878,"d":"686"},{"v":647.5658194292294,"d":"648"},null,{"v":573.2797729902283,"d":"573"},null,239339.17474779402,10,null,null,{"v":630.7667364846747,"d":"630.8"},{"v":641.1003378139866,"d":"641.1"},{"v":634.0531032279454,"d":"634.1"},{"v":625.3851865664034,"d":"625.4"},{"v":623.2588254755891,"d":"623.3"},{"v":634.5319556336765,"d":"634.5"},{"v":630.7273623719275,"d":"630.7"},{"v":626.8270897806398,"d":"626.8"},{"v":653.0662801990518,"d":"653.1"},{"v":647.3220440035669,"d":"647.3"},null,{"v":634.7038921557462,"d":"635"},null,12213.432897426062,10]
[null,null,{"v":505.40429961786964,"d":"505"},"Devon",{"v":484.676376977202,"d":"485"},{"v":473.04262326943405,"d":"473"},{"v":601.3242188600155,"d":"601"},{"v":453.55961790055477,"d":"454"},{"v":517.007739703876,"d":"517"},{"v":490.07748973314636,"d":"490"},{"v":521.1946532000101,"d":"521"},{"v":556.2146380522478,"d":"556"},{"v":533.0883313256068,"d":"533"},{"v":557.9536510289511,"d":"558"},null,{"v":518.8139340051044,"d":"519"},null,100480.7111516647,10,null,null,{"v":618.3481404253271,"d":"618.3"},{"v":615.9185497052403,"d":"615.9"},{"v":639.9134254733185,"d":"639.9"},{"v":611.7126722658084,"d":"611.7"},{"v":624.8057844810061,"d":"624.8"},{"v":619.4563520914039,"d":"619.5"},{"v":625.6123586564167,"d":"625.6"},{"v":632.115425941876,"d":"632.1"},{"v":627.8687135248526,"d":"627.9"},{"v":632.4275896259286,"d":"632.4"},null,{"v":624.8179012191179,"d":"625"},null,6280.903759069207,10]
[null,null,{"v":319.16019354732697,"d":"319"},"Drew",{"v":302.16181664954587,"d":"302"},{"v":311.49073100244374,"d":"311"},{"v":307.9532623330311,"d":"308"},{"v":339.97018265266644,"d":"340"},{"v":297.5196716500393,"d":"298"},{"v":316.62393514288715,"d":"317"},{"v":308.02713541617607,"d":"308"},{"v":303.5609599400625,"d":"304"},{"v":289.63002889780097,"d":"290"},{"v":324.78345742810865,"d":"325"},null,{"v":310.1721181112762,"d":"310"},null,117509.39073480485,10,null,null,{"v":571.0962690596698,"d":"571.1"},{"v":574.1369581773372,"d":"574.1"},{"v":572.9948025787058,"d":"573.0"},{"v":582.8857915684113,"d":"582.9"},{"v":569.5480345993052,"d":"569.5"},{"v":575.7714745166992,"d":"575.8"},{"v":573.0187881093393,"d":"573.0"},{"v":571.5582446805263,"d":"571.6"},{"v":566.8604346081472,"d":"566.9"},{"v":578.3158675426762,"d":"578.3"},null,{"v":573.6186665440816,"d":"574"},null,6831.690825199192,10]
[null,null,{"v":340.2026068323249,"d":"340"},"Dylan",{"v":367.982118307435,"d":"368"},{"v":315.52807343938264,"d":"316"},{"v":298.36844442058583,"d":"298"},{"v":348.64940273861157,"d":"349"},{"v":334.0777621198532,"d":"334"},{"v":339.1632554648429,"d":"339"},{"v":313.5495991916939,"d":"314"},{"v":288.2663637431642,"d":"288"},{"v":284.0236145728097,"d":"284"},{"v":405.36345764477136,"d":"405"},null,{"v":329.497209164315,"d":"329"},null,79346.50898326757,10,null,null,{"v":590.803434543244,"d":"590.8"},{"v":575.4247658813148,"d":"575.4"},{"v":569.8329113476987,"d":"569.8"},{"v":585.4066840596892,"d":"585.4"},{"v":581.1373786596287,"d":"581.1"},{"v":582.6481571000547,"d":"582.6"},{"v":574.7957558696693,"d":"574.8"},{"v":566.3884926811625,"d":"566.4"},{"v":564.9057384608705,"d":"564.9"},{"v":600.4784090943717,"d":"600.5"},null,{"v":579.1821727697703,"d":"579"},null,4232.893585753302,10]
[null,null,{"v":364.4858727994021,"d":"364"},"Frances",{"v":353.4898983860609,"d":"353"},{"v":430.12460596794955,"d":"430"},{"v":393.6447639731482,"d":"394"},{"v":349.03144849883756,"d":"349"},{"v":379.7401165929352,"d":"380"},{"v":398.9945669060026,"d":"399"},{"v":306.62068438261,"d":"307"},{"v":350.960983243456,"d":"351"},{"v":384.87269721702967,"d":"385"},{"v":295.794362436578,"d":"296"},null,{"v":364.3274127604608,"d":"364"},null,29426.777531984197,10,null,null,{"v":586.7854908934156,"d":"586.8"},{"v":606.4074948029923,"d":"606.4"},{"v":597.5448888317952,"d":"597.5"},{"v":585.5162028454592,"d":"585.5"},{"v":593.9487115048811,"d":"593.9"},{"v":598.8947800020219,"d":"598.9"},{"v":572.5611427901897,"d":"572.6"},{"v":586.067505843671,"d":"586.1"},{"v":595.29126230297,"d":"595.3"},{"v":568.9664491395208,"d":"569.0"},null,{"v":589.1983928956917,"d":"589"},null,1114.6665561171235,10]
[null,null,{"v":585.4396542124354,"d":"585"},"Gene",{"v":604.8551164783075,"d":"605"},{"v":600.742923640045,"d":"601"},{"v":575.4087294901947,"d":"575"},{"v":568.4424136851944,"d":"568"},{"v":624.2539359802076,"d":"624"},{"v":532.0647971808352,"d":"532"},{"v":592.147480522056,"d":"592"},{"v":580.4841951120035,"d":"580"},{"v":645.9069769858548,"d":"646"},{"v":573.7349603227567,"d":"574"},null,{"v":589.8041529397456,"d":"590"},null,293198.10963043105,10,null,null,{"v":640.4988952456312,"d":"640.5"},{"v":639.8167095337956,"d":"639.8"},{"v":635.5080622170588,"d":"635.5"},{"v":634.2900012871135,"d":"634.3"},{"v":643.6557234274499,"d":"643.7"},{"v":627.6765281136819,"d":"627.7"},{"v":638.375572636162,"d":"638.4"},{"v":636.3862574431391,"d":"636.4"},{"v":647.0655494939917,"d":"647.1"},{"v":635.2167548086103,"d":"635.2"},null,{"v":637.8490054206634,"d":"638"},null,14510.641167811535,10]
[null,null,{"v":590.9959418386813,"d":"591"},"Jaimie",{"v":543.2089715066378,"d":"543"},{"v":490.8753855482067,"d":"491"},{"v":671.1173784602164,"d":"671"},{"v":596.9810446129912,"d":"597"},{"v":646.8712028311909,"d":"647"},{"v":658.1570573678028,"d":"658"},{"v":608.9242021361026,"d":"609"},{"v":546.6747665646045,"d":"547"},{"v":595.707206115639,"d":"596"},{"v":646.9541364782373,"d":"647"},null,{"v":600.5471351621629,"d":"601"},null,331142.70474440395,10,null,null,{"v":629.7494092136518,"d":"629.7"},{"v":619.6190298328386,"d":"619.6"},{"v":650.8944052314258,"d":"650.9"},{"v":639.188536182151,"d":"639.2"},{"v":647.214720641709,"d":"647.2"},{"v":648.9443591852447,"d":"648.9"},{"v":641.1693797133055,"d":"641.2"},{"v":630.3854048926837,"d":"630.4"},{"v":638.9749281448564,"d":"639.0"},{"v":647.2275405555939,"d":"647.2"},null,{"v":639.3367713593461,"d":"639"},null,15666.2401061266,10]
[null,null,{"v":426.7012151643992,"d":"427"},"Jean",{"v":419.82077127486275,"d":"420"},{"v":374.9098066146674,"d":"375"},{"v":498.16239489263273,"d":"498"},{"v":389.1641200308895,"d":"389"},{"v":425.8049363197429,"d":"426"},{"v":450.16143197949714,"d":"450"},{"v":359.03696159171045,"d":"359"},{"v":360.1828337973331,"d":"360"},{"v":481.7014792866535,"d":"482"},{"v":401.8989833568804,"d":"402"},null,{"v":416.084371914487,"d":"416"},null,61.975837448269715,10,null,null,{"v":603.9827885140246,"d":"604.0"},{"v":592.6685481347653,"d":"592.7"},{"v":621.0926118029421,"d":"621.1"},{"v":596.4001157035689,"d":"596.4"},{"v":605.3981345439956,"d":"605.4"},{"v":610.9606256165586,"d":"611.0"},{"v":588.3425340268536,"d":"588.3"},{"v":588.6611774186252,"d":"588.7"},{"v":617.73245846023,"d":"617.7"},{"v":599.620077185972,"d":"599.6"},null,{"v":602.4859071407536,"d":"602"},null,74.51465315905347,10]
[null,null,{"v":240.18880221085317,"d":"240"},"Jesse",{"v":222.38933793062145,"d":"222"},{"v":221.50311445210485,"d":"222"},{"v":242.72446375029153,"d":"243"},{"v":215.23074064942216,"d":"215"},{"v":193.7295450846363,"d":"194"},{"v":211.43346891006072,"d":"211"},{"v":228.00871738373982,"d":"228"},{"v":225.92957781985274,"d":"226"},{"v":235.32599251726643,"d":"235"},{"v":239.13061218936272,"d":"239"},null,{"v":223.54055706873592,"d":"224"},null,380379.91823241767,10,null,null,{"v":540.4429620267787,"d":"540.4"},{"v":540.0436650118189,"d":"540.0"},{"v":549.1926905964621,"d":"549.2"},{"v":537.1710664969917,"d":"537.2"},{"v":526.6463088903439,"d":"526.6"},{"v":535.3910381198373,"d":"535.4"},{"v":542.9383862362745,"d":"542.9"},{"v":542.0223348147096,"d":"542.0"},{"v":546.0971755069206,"d":"546.1"},{"v":547.7009897173926,"d":"547.7"},null,{"v":540.764661741753,"d":"541"},null,34799.98036678739,10]
[null,null,{"v":318.48908877747857,"d":"318"},"Jo",{"v":400.288232520341,"d":"400"},{"v":304.54892574023563,"d":"305"},{"v":354.07345133329136,"d":"354"},{"v":314.10151399674476,"d":"314"},{"v":332.79586463290644,"d":"333"},{"v":343.97533915092646,"d":"344"},{"v":338.2040472311073,"d":"338"},{"v":301.9763606301732,"d":"302"},{"v":295.46939066013107,"d":"295"},{"v":366.60349335563114,"d":"367"},null,{"v":335.2036619251488,"d":"335"},null,69505.91026040664,10,null,null,{"v":599.2184868914779,"d":"599.2"},{"v":571.8831749908798,"d":"571.9"},{"v":586.9504381252842,"d":"587.0"},{"v":574.9716226643601,"d":"575.0"},{"v":580.7529282886998,"d":"580.8"},{"v":584.0569966288905,"d":"584.1"},{"v":582.3649403368356,"d":"582.4"},{"v":571.034873825211,"d":"571.0"},{"v":568.8565246574373,"d":"568.9"},{"v":590.42808644263,"d":"590.4"},null,{"v":581.0518072851706,"d":"581"},null,3498.5318142762335,10]
[null,null,{"v":413.0152579447755,"d":"413"},"Jody",{"v":479.5083551223404,"d":"480"},{"v":389.71062035912286,"d":"390"},{"v":381.47919003474266,"d":"381"},{"v":414.09218459085656,"d":"414"},{"v":360.6429200990893,"d":"361"},{"v":388.0589388306529,"d":"388"},{"v":440.67384808643425,"d":"441"},{"v":481.6707775522288,"d":"482"},{"v":430.0817794629127,"d":"430"},{"v":413.628762235486,"d":"414"},null,{"v":417.95473763738664,"d":"418"},null,3.8332066131190774,10,null,null,{"v":617.2761318827244,"d":"617.3"},{"v":596.5404464626955,"d":"596.5"},{"v":594.4056301490315,"d":"594.4"},{"v":602.608861713231,"d":"602.6"},{"v":588.7888327810339,"d":"588.8"},{"v":596.1157232289712,"d":"596.1"},{"v":608.83050283273,"d":"608.8"},{"v":617.7260846552512,"d":"617.7"},{"v":606.3975375402243,"d":"606.4"},{"v":602.4968861964655,"d":"602.5"},null,{"v":603.1186637442358,"d":"603"},null,113.06364744554276,10]
[null,null,{"v":458.29977783477034,"d":"458"},"Jordan",{"v":416.7437439657017,"d":"417"},{"v":523.5827583514096,"d":"524"},{"v":435.37153682235754,"d":"435"},{"v":470.2891755567398,"d":"470"},{"v":504.5618529610129,"d":"505"},{"v":446.084783048566,"d":"446"},{"v":405.2590951703312,"d":"405"},{"v":493.67506963032383,"d":"494"},{"v":447.65476419430587,"d":"448"},{"v":454.0377634829086,"d":"454"},null,{"v":459.72605431836564,"d":"460"},null,16935.025547410627,10,null,null,{"v":603.247151003821,"d":"603.2"},{"v":626.0695104447371,"d":"626.1"},{"v":607.6199774183917,"d":"607.6"},{"v":615.3347772646878,"d":"615.3"},{"v":622.3690434778122,"d":"622.4"},{"v":610.0509030475458,"d":"610.1"},{"v":600.4526603720708,"d":"600.5"},{"v":620.1877546988228,"d":"620.2"},{"v":610.4022319700414,"d":"610.4"},{"v":611.8180374059899,"d":"611.8"},null,{"v":612.755204710392,"d":"613"},null,1689.749055843849,10]
[null,null,{"v":544.7246290597883,"d":"545"},"Kade",{"v":552.7070113659723,"d":"553"},{"v":505.0706794177741,"d":"505"},{"v":609.4458404849153,"d":"609"},{"v":544.4356674905607,"d":"544"},{"v":545.4246388924427,"d":"545"},{"v":531.783445747227,"d":"532"},{"v":547.8715389826177,"d":"548"},{"v":562.9184206404196,"d":"563"},{"v":540.3718500147136,"d":"540"},{"v":483.5011952928984,"d":"484"},null,{"v":542.3530288329541,"d":"542"},null,153212.81005298102,10,null,null,{"v":631.4828044421813,"d":"631.5"},{"v":622.4698378725096,"d":"622.5"},{"v":641.2550086047651,"d":"641.3"},{"v":629.974978569685,"d":"630.0"},{"v":630.1564645211486,"d":"630.2"},{"v":627.6236349605394,"d":"627.6"},{"v":630.604084155291,"d":"630.6"},{"v":633.3134716468956,"d":"633.3"},{"v":629.2257513712816,"d":"629.2"},{"v":618.1053787057612,"d":"618.1"},null,{"v":629.4211414850058,"d":"629"},null,8800.105381866604,10]
[]
[{"$nulls":14},"Mean",{"v":418.57386659108863,"d":"418.6"},"SD",2401772.2637913437,10,{"$nulls":12},"Mean",{"v":599.7561699160545,"d":"599.8"},"SD",143233.53883532874,10]
[{"$nulls":3},"Mean",{"v":414.0562842526016,"d":"414.1"},{"v":418.9629647758973,"d":"419.0"},{"v":435.9704220652993,"d":"436.0"},{"v":407.50742721426025,"d":"407.5"},{"v":416.74531847821464,"d":"416.7"},{"v":414.87437152064604,"d":"414.9"},{"v":410.2563887410183,"d":"410.3"},{"v":415.813637617097,"d":"415.8"},{"v":431.11118708325785,"d":"431.1"},{"v":420.4406641625948,"d":"420.4"},{"v":418.5738665910887,"d":"418.6"},{"v":418.57386659108846,"d":"418.6"},{"v":8.820208252011613,"d":"8.8"},{"$nulls":3},"Mean",{"v":599.464481894264,"d":"599.5"},{"v":600.8786485259654,"d":"600.9"},{"v":602.9178977570061,"d":"602.9"},{"v":597.4924690390962,"d":"597.5"},{"v":598.6717626698683,"d":"598.7"},{"v":599.3837563129895,"d":"599.4"},{"v":597.6035280820953,"d":"597.6"},{"v":598.8636666139336,"d":"598.9"},{"v":602.2102686639863,"d":"602.2"},{"v":600.075219601342,"d":"600.1"},{"v":599.7561699160548,"d":"599.8"},{"v":599.756169916055,"d":"599.8"},{"v":1.8054041737570241,"d":"1.8"}]
[{"$nulls":14},"SD",{"v":112.43178665988314,"d":"112.4"},{"v":116.58257739195899,"d":"116.6"},{"$nulls":14},"SD",{"v":27.456524374222177,"d":"27.5"},{"v":28.340031216075573,"d":"28.3"}]
[null,null,"Analysis of raw data",null,null,"LCL","UCL","±CL","´¤¸CL",{"$nulls":12},"Analysis of log-transformed data","LCL","UCL","±CL","´¤¸CL",{"$nulls":5},"Back-transformed:"]
[{"$nulls":3},"Observed subject SD",{"v":118.97724655232237,"d":"119.0"},{"v":94.45907312803742,"d":"94.5"},{"v":163.04765576290512,"d":"163.0"},null,{"v":1.3138187018590246,"d":"1.31"},{"$nulls":11},"Observed subject factor SD",{"v":1.3354668610935685,"d":"1.34"},{"v":1.2581816228780653,"d":"1.26"},{"v":1.4865137409019482,"d":"1.49"},null,{"v":1.0869580799828984,"d":"1.09"},{"$nulls":5},"Mean",{"v":402.44631100759943,"d":"402.4"},"CV (%)"]
[{"$nulls":3},"True subject SD",{"v":111.68083557778124,"d":"111.7"},{"v":75.674217675142,"d":"75.7"},{"v":138.63127659355243,"d":"138.6"},{"v":31.478529459205213,"d":"31.5"},{"$nulls":12},"True subject factor SD",{"v":1.3137441426845575,"d":"1.31"},{"v":1.2032451611601032,"d":"1.20"},{"v":1.4030754790694138,"d":"1.40"},null,{"v":1.0798500567415952,"d":"1.08"},{"$nulls":5},{"v":402.4463110076002,"d":"402.4"},{"v":402.44631100760125,"d":"402.4"},{"v":1.8218001172971583,"d":"1.8"}]
[{"$nulls":3},"Error SD",{"v":41.0240924557838,"d":"41.0"},{"v":37.774283523673255,"d":"37.8"},{"v":44.944320209439454,"d":"44.9"},null,{"v":1.0907853342680311,"d":"1.09"},{"$nulls":11},"Error factor SD",{"v":1.1007781016928666,"d":"1.10"},{"v":1.092437114143021,"d":"1.09"},{"v":1.1109245836154271,"d":"1.11"},null,{"v":1.008426072140982,"d":"1.01"},{"$nulls":5},"CV (%)",{"v":31.595842932084537,"d":"31.6"},{"v":32.763652450041036,"d":"32.8"}]
[{"$nulls":3},"ICC",{"v":0.8811086833657064,"d":"0.88"},{"v":0.8170845691161179,"d":"0.82"},{"v":0.9345121184187567,"d":"0.93"},{"v":0.058713774651319384,"d":"0.06"},{"$nulls":12},"Observed subject CV (%)",{"v":33.54668610935684,"d":"33.5"},{"v":25.81816228780653,"d":"25.8"},{"v":48.65137409019482,"d":"48.7"},null,{"v":1.3727292643408509,"d":"1.37"}]
[{"$nulls":4},"Error and ICC for mean of",2,"trials",{"$nulls":13},"True subject CV (%)",{"v":31.37441426845575,"d":"31.4"},{"v":20.324516116010315,"d":"20.3"},{"v":40.30754790694138,"d":"40.3"},{"v":9.991515895465533,"d":"10.0"}]
[{"$nulls":5},"LCL","UCL","±CL","´¤¸CL",{"$nulls":11},"Error CV (%)",{"v":10.077810169286664,"d":"10.1"},{"v":9.243711414302098,"d":"9.2"},{"v":11.092458361542711,"d":"11.1"},null,{"v":1.0954453453278121,"d":"1.10"}]
[{"$nulls":3},"Error SD",{"v":29.00841396750861,"d":"29.0"},{"v":26.71045203405263,"d":"26.7"},{"v":31.78043359591423,"d":"31.8"},null,{"v":1.0907853342680311,"d":"1.09"},{"$nulls":11},"ICC",{"v":0.8898310285777863,"d":"0.89"},{"v":0.8296977877043944,"d":"0.83"},{"v":0.9395552456984335,"d":"0.94"},{"v":0.05492872899701956,"d":"0.05"}]
[{"$nulls":3},"ICC",{"v":0.936797210237969,"d":"0.94"},{"v":0.8993357634571421,"d":"0.90"},{"v":0.9661475981681767,"d":"0.97"},{"v":0.033405917355517345,"d":"0.03"},{"$nulls":13},"Error and ICC for mean of",2,"trials"]
[{"$nulls":4},"Subjects",{"$nulls":17},"LCL","UCL","±CL","´¤¸CL"]
[{"$nulls":4},"(rows)",null,"total","error",{"$nulls":12},"Error factor SD",{"v":1.0702523698599244,"d":"1.07"},{"v":1.0645115736449018,"d":"1.06"},{"v":1.0772186764393668,"d":"1.08"},null,{"v":1.0059508071643128,"d":"1.01"}]
[{"$nulls":3},"n",20,null,200,{"$nulls":13},"Error CV (%)",{"v":7.02523698599245,"d":"7.0"},{"v":6.451157364490172,"d":"6.5"},{"v":7.721867643936676,"d":"7.7"},null,{"v":1.094063070098692,"d":"1.09"}]
[{"$nulls":3},"DegFree",19,null,199,180,{"$nulls":12},"ICC",{"v":0.9417043271296468,"d":"0.94"},{"v":0.9069233108111953,"d":"0.91"},{"v":0.9688357656036756,"d":"0.97"},{"v":0.030956227396240155,"d":"0.03"}]
[{"$nulls":3},"SumSquares",2401772.2637913437,null,2704707.972919069,302935.70912772557,{"$nulls":13},"Subjects"]
[{"$nulls":3},"SD^2",{"v":12472.609035351408,"d":"12473"},null,null,{"v":1682.9761618206976,"d":"1683"},{"$nulls":13},"(rows)",null,"total","error"]
[{"$nulls":3},"SE^2 of SD^2",16820580.077640723,null,null,31471.208458408077,{"$nulls":12},"n",20,null,200]
[{"$nulls":3},"SE of SD^2",{"v":4101.2900504159325,"d":"4101"},null,null,{"v":177.40126397071717,"d":"177"},{"$nulls":12},"DegFree",19,null,199,180]
[{"$nulls":5},"LCL","UCL",{"$nulls":13},"SumSquares",143233.53883532874,null,159828.31649629946,16594.77766097072]
[{"$nulls":3},"F ratio",{"v":75.11043197342765,"d":"75.1"},{"v":45.67007322278992,"d":"45.7"},{"v":143.7000073684494,"d":"143.7"},{"$nulls":13},"SD^2",{"v":744.6414097894949,"d":"744.6"},null,null,{"v":92.19320922761511,"d":"92.2"}]
[{"$nulls":3},"Obsvd subj variance",{"v":14155.585197172106,"d":"14156"},{"v":8922.51649620792,"d":"8923"},{"v":26584.538049778806,"d":"26585"},{"$nulls":13},"SE^2 of SD^2",59822.62874707038,null,null,94.43986475207575]
[{"$nulls":3},"True subj variance",{"v":12472.609035351408,"d":"12473"},{"v":5726.587220744774,"d":"5727"},{"v":19218.63084995804,"d":"19219"},{"$nulls":13},"SE of SD^2",{"v":244.58664875064292,"d":"244.59"},null,null,{"v":9.718017531990553,"d":"9.72"}]
[{"$nulls":22},"LCL","UCL"]
[{"$nulls":20},"F ratio",{"v":81.76965928705829,"d":"81.8"},{"v":49.71914325248043,"d":"49.7"},{"v":156.44032837173486,"d":"156.4"}]
[{"$nulls":20},"Obsvd subj variance",{"v":836.8346190171101,"d":"836.8"},{"v":527.4717073702942,"d":"527"},1571.5960492454117]
[{"$nulls":20},"True subj variance",{"v":744.6414097894949,"d":"744.6"},342.33217348809404,1146.9506460908958]
[{"$nulls":22},"LCL","UCL"]
[{"$nulls":20},"Observed subject SD",{"v":28.92809394027042,"d":"28.9"},{"v":22.966752216416978,"d":"23.0"},{"v":39.64336072087496,"d":"39.6"}]
[{"$nulls":20},"True subject SD",{"v":27.288118472871943,"d":"27.3"},{"v":18.50222077179099,"d":"18.5"},{"v":33.866659801210034,"d":"33.9"}]
[{"$nulls":20},"Error SD",{"v":9.601729491483038,"d":"9.6"},{"v":8.841108490573326,"d":"8.8"},{"v":10.519262681916821,"d":"10.5"}]
[{"$nulls":20},"Error for mean of 2 trials",{"v":6.789448034546516,"d":"6.8"},{"v":6.25160776689036,"d":"6.3"},{"v":7.4382419754659725,"d":"7.4"}]

{"sheet":"2-way","index":5,"n_rows":97,"n_cols":34,"rows_kept":97,"merged":[[1,1,1,2],[60,7,60,8],[66,24,66,25]],"flags":["formulas_cached_only"]}
[null,"SIMULATION AND ANALYSIS FOR 2-WAY RELIABILITY"]
[null,"Hover cursor for citation:"]
[null,"See the previous spreadsheet (1-way reliability) for an explanation of the generation of the data and for detailed instructions."]
[null,"Most straightforward reliability analyses can be done with this spreadsheet or the earlier one for consecutive pairwise analysis of repeated measurements."]
[null,"When familiarization or other habituation or order effects occur with only a few repeated measurements, use the consecutive-pairwise spreadsheet."]
[null,"Use this spreadsheet when there are no such effects, and when you can assume that the errors on each measurement are equal and independent of each other."]
[null,"The repeated measurements are nevertheless associated with known measuring occasions, such as multiple games or items in a psychometric inventory."]
[null,"Here the subjects are players in a team. They all experience a given increase or decrease in their scores from game to game,"]
[null,"   depending on whether the team lost, tied, or won the game."]
[null,"The effects of losing, tieing or winning are shown as percents.  Losing and winning have been given the same factor effect (´1.05 and ¸1.05, which equal 5% and -4.5%)."]
[null,"The aim of the analysis is the same as before, but now the mean score in each game can be adjusted for, and the differences in the means can be expressed as an SD."]
[null,"To analyze your own data, replace the main block of data shown in plum color."]
[null,"You can also delete or copy-and-insert whole rows and whole columns.  Don't delete and don't copy-and-insert the first data row or the first five data columns (or you will corrupt the spreadsheet)."]
[null,"This spreadsheet does NOT work with missing data.  Use mixed modeling instead, with data in \"long\" format. "]
[null,"   Effects of losing, tieing or winning (and any other within- or between-subject factors) can be estimated by including appropriate variables in the mixed model."]
[{"$nulls":5},"Do not use log transformation in one or more of the following situations:",{"$nulls":11},"Use log transformation in one or more of the following situations:"]
[null,null,"Choose confidence level (%):",90,null,"   the data can be zero or negative;",{"$nulls":11},"   the data can only be positive and non-zero;"]
[null,"Simulation to create raw observed values",{"$nulls":3},"   the data were measured from an arbitrary reference value;",{"$nulls":11},"   the within-subject, between-subject or between-trial SD is more than ~20% of the mean;"]
[{"$nulls":3},"Depedent variable",null,"   the magnitude of the error is expected to be similar for all subjects.",{"$nulls":11},"   the magnitude of the percent or factor error is expected to be similar for all subjects."]
[{"$nulls":3},"True values"]
[null,null,"Mean",400]
[null,null,"Between-subject CV (%)",30,{"$nulls":7},"<– Insert or delete whole columns here –>",{"$nulls":16},"<– Insert or delete whole columns here –>"]
[null,null,"Equivalent ´¤¸ factor SD",1.3,{"$nulls":17},"100*log(observed values)"]
[null,null,"Within-subject random error (%)",null,10,10,10,10,10,10,10,10,10,10,{"$nulls":7},"If you have missing raw data, you will have to delete #NUM! from the corresponding cells here."]
[null,null,"Effect of lose/tie/win (%)",null,5,0,{"v":-4.761904761904759,"d":"-4.8"},5,0,{"v":-4.761904761904759,"d":"-4.8"},5,0,{"v":-4.761904761904759,"d":"-4.8"},0]
[null,null,"Lose/tie/win",null,"L","T","W","L","T","W","L","T","W","T"]
[{"$nulls":4},"Game1","Game2","Game3","Game4","Game5","Game6","Game7","Game8","Game9","Game10",null,"Mean",{"$nulls":5},"Game1","Game2","Game3","Game4","Game5","Game6","Game7","Game8","Game9","Game10",null,"Mean"]
[null,"Do not copy/insert this row",{"v":374.22856405543337,"d":"374"},"Alex",{"v":361.6510671336415,"d":"362"},{"v":347.7148515618126,"d":"348"},{"v":302.8857769652133,"d":"303"},{"v":422.56153559917425,"d":"423"},{"v":359.51256247503767,"d":"360"},{"v":273.6905846846507,"d":"274"},{"v":356.36986217034405,"d":"356"},{"v":424.5363507245531,"d":"425"},{"v":348.7237734379914,"d":"349"},{"v":365.95111694389516,"d":"366"},null,{"v":356.3597481696314,"d":"356"},{"$nulls":5},{"v":589.0679844026845,"d":"589.1"},{"v":585.1382751825547,"d":"585.1"},{"v":571.335576072475,"d":"571.3"},{"v":604.6335082580401,"d":"604.6"},{"v":588.4749120848304,"d":"588.5"},{"v":561.1998215325782,"d":"561.2"},{"v":587.5969130209498,"d":"587.6"},{"v":605.0997633945163,"d":"605.1"},{"v":585.4280128696298,"d":"585.4"},{"v":590.2499764218819,"d":"590.2"},null,{"v":586.8224743240141,"d":"587"}]
[null,null,{"v":333.9285661178858,"d":"334"},"Ariel",{"v":383.58750336903734,"d":"384"},{"v":332.3262313538969,"d":"332"},{"v":367.5848989034614,"d":"368"},{"v":365.07755062516424,"d":"365"},{"v":348.9680299334441,"d":"349"},{"v":328.29866720509466,"d":"328"},{"v":388.1127291037879,"d":"388"},{"v":293.61969923499413,"d":"294"},{"v":379.9930065303678,"d":"380"},{"v":304.4018315725519,"d":"304"},null,{"v":349.19701478318007,"d":"349"},{"$nulls":5},{"v":594.9567765234204,"d":"595.0"},{"v":580.6117111016931,"d":"580.6"},{"v":590.695430939686,"d":"590.7"},{"v":590.0109798480679,"d":"590.0"},{"v":585.4980313231222,"d":"585.5"},{"v":579.3923764813333,"d":"579.4"},{"v":596.1295836352301,"d":"596.1"},{"v":568.2285389976596,"d":"568.2"},{"v":594.0152848683625,"d":"594.0"},{"v":571.8348642962044,"d":"571.8"},null,{"v":585.137357801478,"d":"585"}]
[null,null,{"v":340.39910417543115,"d":"340"},"Ashley",{"v":343.9566482495957,"d":"344"},{"v":340.3263570997288,"d":"340"},{"v":332.6653350757574,"d":"333"},{"v":308.7577545092562,"d":"309"},{"v":407.18007594594405,"d":"407"},{"v":318.6093161102388,"d":"319"},{"v":341.8132921524683,"d":"342"},{"v":324.5402214210035,"d":"325"},{"v":338.597044749182,"d":"339"},{"v":322.21992438590235,"d":"322"},null,{"v":337.8665969699077,"d":"338"},{"$nulls":5},{"v":584.0515626901647,"d":"584.1"},{"v":582.9905031048645,"d":"583.0"},{"v":580.7136984857059,"d":"580.7"},{"v":573.2557003446243,"d":"573.3"},{"v":600.9255534633396,"d":"600.9"},{"v":576.3965637821323,"d":"576.4"},{"v":583.4264658610156,"d":"583.4"},{"v":578.2409477372215,"d":"578.2"},{"v":582.481074180856,"d":"582.5"},{"v":577.5234307396754,"d":"577.5"},null,{"v":582.00055003896,"d":"582"}]
[null,null,{"v":400.78475106188966,"d":"401"},"Bernie",{"v":379.12005547035255,"d":"379"},{"v":423.2911311960227,"d":"423"},{"v":343.51469661051686,"d":"344"},{"v":409.9322735146584,"d":"410"},{"v":505.41545477816766,"d":"505"},{"v":388.1036281634597,"d":"388"},{"v":351.24045924349946,"d":"351"},{"v":385.98482717848435,"d":"386"},{"v":358.8715713170272,"d":"359"},{"v":410.47148176104224,"d":"410"},null,{"v":395.5945579233231,"d":"396"},{"$nulls":5},{"v":593.7852923972765,"d":"593.8"},{"v":604.8060195727005,"d":"604.8"},{"v":583.9229895639492,"d":"583.9"},{"v":601.5991959503939,"d":"601.6"},{"v":622.5380773786453,"d":"622.5"},{"v":596.1272386858501,"d":"596.1"},{"v":586.1471057982967,"d":"586.1"},{"v":595.5798060864497,"d":"595.6"},{"v":588.2964584420046,"d":"588.3"},{"v":601.730645452071,"d":"601.7"},null,{"v":597.4532829327637,"d":"597"}]
[null,null,{"v":346.04917025205543,"d":"346"},"Casey",{"v":402.55175175960386,"d":"403"},{"v":381.6084895234801,"d":"382"},{"v":338.99220472135767,"d":"339"},{"v":380.493663290394,"d":"380"},{"v":337.98712075035706,"d":"338"},{"v":347.4530384855814,"d":"347"},{"v":328.68956260646195,"d":"329"},{"v":294.82736645164397,"d":"295"},{"v":360.0844922924795,"d":"360"},{"v":390.12769227978555,"d":"390"},null,{"v":356.2815382161145,"d":"356"},{"$nulls":5},{"v":599.7823664393717,"d":"599.8"},{"v":594.4395186505598,"d":"594.4"},{"v":582.5977112193814,"d":"582.6"},{"v":594.1469523524155,"d":"594.1"},{"v":582.3007790468148,"d":"582.3"},{"v":585.0629514823786,"d":"585.1"},{"v":579.511372661099,"d":"579.5"},{"v":568.6389986575361,"d":"568.6"},{"v":588.6338704724672,"d":"588.6"},{"v":596.6474101636751,"d":"596.6"},null,{"v":587.17619311457,"d":"587"}]
[null,null,{"v":329.1138313738157,"d":"329"},"Chris",{"v":330.41894183222405,"d":"330"},{"v":319.2026512722194,"d":"319"},{"v":276.45590103274384,"d":"276"},{"v":369.3308816748509,"d":"369"},{"v":383.84716920243267,"d":"384"},{"v":320.1574984362203,"d":"320"},{"v":376.13845398822724,"d":"376"},{"v":273.340092535477,"d":"273"},{"v":319.9913890208277,"d":"320"},{"v":328.3136732639481,"d":"328"},null,{"v":329.71966522591714,"d":"330"},{"$nulls":5},{"v":580.0361370004199,"d":"580.0"},{"v":576.5826171531821,"d":"576.6"},{"v":562.2051318306691,"d":"562.2"},{"v":591.1692940552604,"d":"591.2"},{"v":595.0244476497287,"d":"595.0"},{"v":576.8813057324826,"d":"576.9"},{"v":592.9957304302442,"d":"593.0"},{"v":561.0716780072768,"d":"561.1"},{"v":576.8294086121797,"d":"576.8"},{"v":579.3969472327283,"d":"579.4"},null,{"v":579.2192697704171,"d":"579"}]
[null,null,{"v":399.6547771084294,"d":"400"},"Corey",{"v":467.1471081532189,"d":"467"},{"v":449.41174174100905,"d":"449"},{"v":436.1206828181901,"d":"436"},{"v":478.0655691561484,"d":"478"},{"v":423.41464634988444,"d":"423"},{"v":403.1345016107528,"d":"403"},{"v":455.9720871334184,"d":"456"},{"v":403.0134962300313,"d":"403"},{"v":445.9402340881811,"d":"446"},{"v":344.661244977979,"d":"345"},null,{"v":430.68813122588136,"d":"431"},{"$nulls":5},{"v":614.6644214816762,"d":"614.7"},{"v":610.79394870045,"d":"610.8"},{"v":607.7919000502804,"d":"607.8"},{"v":616.9747897050805,"d":"617.0"},{"v":604.8351950331764,"d":"604.8"},{"v":599.927025715941,"d":"599.9"},{"v":612.2431595214115,"d":"612.2"},{"v":599.897005079047,"d":"599.9"},{"v":610.0184938754098,"d":"610.0"},{"v":584.2562036038571,"d":"584.3"},null,{"v":606.1402142766331,"d":"606"}]
[null,null,{"v":452.0434575729767,"d":"452"},"Courtney",{"v":420.5994495239102,"d":"421"},{"v":433.94488536326116,"d":"434"},{"v":461.3354643349624,"d":"461"},{"v":454.92945096741545,"d":"455"},{"v":459.2807027954288,"d":"459"},{"v":468.4218887742864,"d":"468"},{"v":558.6557198397524,"d":"559"},{"v":485.15319262395633,"d":"485"},{"v":431.1791883066738,"d":"431"},{"v":492.5166986957528,"d":"493"},null,{"v":466.60166412253994,"d":"467"},{"$nulls":5},{"v":604.1680954480083,"d":"604.2"},{"v":607.2917533785655,"d":"607.3"},{"v":613.4125466722021,"d":"613.4"},{"v":612.0142354110152,"d":"612.0"},{"v":612.9661576069474,"d":"613.0"},{"v":614.9369361575955,"d":"614.9"},{"v":632.5533397623027,"d":"632.6"},{"v":618.4464702144196,"d":"618.4"},{"v":606.6523753835102,"d":"606.7"},{"v":619.9528366018573,"d":"620.0"},null,{"v":614.2394746636425,"d":"614"}]
[null,null,{"v":397.3658495563654,"d":"397"},"Devon",{"v":428.3666455511099,"d":"428"},{"v":449.45319313949494,"d":"449"},{"v":413.0479884081962,"d":"413"},{"v":373.11435580450245,"d":"373"},{"v":395.81092570616903,"d":"396"},{"v":392.06961788808866,"d":"392"},{"v":355.84903036772874,"d":"356"},{"v":398.27160128516925,"d":"398"},{"v":334.8112475709191,"d":"335"},{"v":362.0758870745895,"d":"362"},null,{"v":390.2870492795968,"d":"390"},{"$nulls":5},{"v":605.9979477351801,"d":"606.0"},{"v":610.8031717543053,"d":"610.8"},{"v":602.3563780903921,"d":"602.4"},{"v":592.1884956582848,"d":"592.2"},{"v":598.0936636896041,"d":"598.1"},{"v":597.1439420675331,"d":"597.1"},{"v":587.4506568907308,"d":"587.5"},{"v":598.7134187834372,"d":"598.7"},{"v":581.3566932946243,"d":"581.4"},{"v":589.1853822658619,"d":"589.2"},null,{"v":596.3289750229953,"d":"596"}]
[null,null,{"v":295.64978575967666,"d":"296"},"Drew",{"v":316.04929138226856,"d":"316"},{"v":327.2571842284006,"d":"327"},{"v":285.7953738505583,"d":"286"},{"v":330.54840345507046,"d":"331"},{"v":311.98527492490535,"d":"312"},{"v":349.7846758050611,"d":"350"},{"v":321.6947373892872,"d":"322"},{"v":304.4347485840301,"d":"304"},{"v":269.7672638274976,"d":"270"},{"v":280.28035830994924,"d":"280"},null,{"v":309.7597311757029,"d":"310"},{"$nulls":5},{"v":575.5898186809383,"d":"575.6"},{"v":579.0746357882578,"d":"579.1"},{"v":565.5276078697716,"d":"565.5"},{"v":580.0753103802926,"d":"580.1"},{"v":574.2955990942219,"d":"574.3"},{"v":585.7317753177374,"d":"585.7"},{"v":577.360307535857,"d":"577.4"},{"v":571.8456773822057,"d":"571.8"},{"v":559.7559601450882,"d":"559.8"},{"v":563.5790381901506,"d":"563.6"},null,{"v":573.2835730384521,"d":"573"}]
[null,null,{"v":400.2402984996488,"d":"400"},"Dylan",{"v":418.3782023727525,"d":"418"},{"v":414.2900001814068,"d":"414"},{"v":428.75599417726,"d":"429"},{"v":427.4187234405261,"d":"427"},{"v":349.6054656927334,"d":"350"},{"v":404.2328206767646,"d":"404"},{"v":447.68969364667663,"d":"448"},{"v":408.6462533708293,"d":"409"},{"v":444.0868433121117,"d":"444"},{"v":427.0257863288317,"d":"427"},null,{"v":417.01297831998926,"d":"417"},{"$nulls":5},{"v":603.6385813814123,"d":"603.6"},{"v":602.6566212131205,"d":"602.7"},{"v":606.0887978970784,"d":"606.1"},{"v":605.7764149694644,"d":"605.8"},{"v":585.6805277791701,"d":"585.7"},{"v":600.19910007744,"d":"600.2"},{"v":610.410034431336,"d":"610.4"},{"v":601.2849875611848,"d":"601.3"},{"v":609.6020136351696,"d":"609.6"},{"v":605.6844400934131,"d":"605.7"},null,{"v":603.102151903879,"d":"603"}]
[null,null,{"v":480.3458222016348,"d":"480"},"Frances",{"v":571.2789204864976,"d":"571"},{"v":480.3685286134516,"d":"480"},{"v":491.53298410378676,"d":"492"},{"v":463.96742938214175,"d":"464"},{"v":423.7263566300773,"d":"424"},{"v":545.7098851982435,"d":"546"},{"v":418.0971470251825,"d":"418"},{"v":442.7987911865517,"d":"443"},{"v":422.8042931925204,"d":"423"},{"v":461.9179126348204,"d":"462"},null,{"v":472.2202248453274,"d":"472"},{"$nulls":5},{"v":634.7877567599133,"d":"634.8"},{"v":617.455357726359,"d":"617.5"},{"v":619.752904639713,"d":"619.8"},{"v":613.9814354465342,"d":"614.0"},{"v":604.908786157479,"d":"604.9"},{"v":630.2087488739943,"d":"630.2"},{"v":603.5713814673088,"d":"603.6"},{"v":609.3115470899752,"d":"609.3"},{"v":604.6909408136867,"d":"604.7"},{"v":613.5387197015474,"d":"613.5"},null,{"v":615.2207578676512,"d":"615"}]
[null,null,{"v":351.6550198617248,"d":"352"},"Gene",{"v":428.05500713396515,"d":"428"},{"v":286.24726349413356,"d":"286"},{"v":350.5067122867462,"d":"351"},{"v":377.92905957499863,"d":"378"},{"v":376.94895250247373,"d":"377"},{"v":367.07759733238436,"d":"367"},{"v":372.9743922021428,"d":"373"},{"v":355.9952600053214,"d":"356"},{"v":320.06180068065623,"d":"320"},{"v":346.31078548918515,"d":"346"},null,{"v":358.21068307020073,"d":"358"},{"$nulls":5},{"v":605.9251708664677,"d":"605.9"},{"v":565.6855994976933,"d":"565.7"},{"v":585.93798568954,"d":"585.9"},{"v":593.4706504924777,"d":"593.5"},{"v":593.2109773777271,"d":"593.2"},{"v":590.5573262577927,"d":"590.6"},{"v":592.150976367349,"d":"592.2"},{"v":587.4917416171596,"d":"587.5"},{"v":576.851410427418,"d":"576.9"},{"v":584.733659585317,"d":"584.7"},null,{"v":587.6015498178942,"d":"588"}]
[null,null,{"v":649.3848139182262,"d":"649"},"Jaimie",{"v":740.5803241098803,"d":"741"},{"v":557.2999882373387,"d":"557"},{"v":690.0436999952667,"d":"690"},{"v":728.9073579982767,"d":"729"},{"v":597.8652426299038,"d":"598"},{"v":560.8292815752679,"d":"561"},{"v":685.9850039968364,"d":"686"},{"v":770.480330051445,"d":"770"},{"v":598.7985938007212,"d":"599"},{"v":700.96846189447,"d":"701"},null,{"v":663.1758284289407,"d":"663"},{"$nulls":5},{"v":660.7434100627104,"d":"660.7"},{"v":632.3103673468975,"d":"632.3"},{"v":653.6754928912308,"d":"653.7"},{"v":659.1546642998044,"d":"659.2"},{"v":639.3365381783497,"d":"639.3"},{"v":632.9416548293208,"d":"632.9"},{"v":653.085576742403,"d":"653.1"},{"v":664.7014125623721,"d":"664.7"},{"v":639.4925304180526,"d":"639.5"},{"v":655.2462895857695,"d":"655.2"},null,{"v":649.068793691691,"d":"649"}]
[null,null,{"v":374.50200235578916,"d":"375"},"Jean",{"v":415.0051562772476,"d":"415"},{"v":402.44635493862444,"d":"402"},{"v":382.9869222883826,"d":"383"},{"v":348.1224016238505,"d":"348"},{"v":379.72070269617467,"d":"380"},{"v":308.0949654014855,"d":"308"},{"v":427.8358525854216,"d":"428"},{"v":348.1340316486489,"d":"348"},{"v":341.37599417865295,"d":"341"},{"v":368.6119447241655,"d":"369"},null,{"v":372.2334326362654,"d":"372"},{"$nulls":5},{"v":602.8290944917964,"d":"602.8"},{"v":599.7561808320504,"d":"599.8"},{"v":594.8000843136534,"d":"594.8"},{"v":585.2554146736568,"d":"585.3"},{"v":593.9435989575918,"d":"593.9"},{"v":573.0408064675489,"d":"573.0"},{"v":605.8739600021748,"d":"605.9"},{"v":585.258755403952,"d":"585.3"},{"v":583.2984492066898,"d":"583.3"},{"v":590.9744450364946,"d":"591.0"},null,{"v":591.5030789385607,"d":"592"}]
[null,null,{"v":419.7394970432846,"d":"420"},"Jesse",{"v":419.69914242853645,"d":"420"},{"v":431.80820910714885,"d":"432"},{"v":447.2377094601402,"d":"447"},{"v":448.41713515330116,"d":"448"},{"v":425.7829336004379,"d":"426"},{"v":396.6409805984112,"d":"397"},{"v":495.7423538730419,"d":"496"},{"v":389.0895094297183,"d":"389"},{"v":346.2253362845833,"d":"346"},{"v":419.2386734369575,"d":"419"},null,{"v":421.98819833722763,"d":"422"},{"$nulls":5},{"v":603.9538127041143,"d":"604.0"},{"v":606.7981529264396,"d":"606.8"},{"v":610.3090241765606,"d":"610.3"},{"v":610.5723904458282,"d":"610.6"},{"v":605.3929670868048,"d":"605.4"},{"v":598.3031540546862,"d":"598.3"},{"v":620.6056343928552,"d":"620.6"},{"v":596.3809418510932,"d":"596.4"},{"v":584.7089824017452,"d":"584.7"},{"v":603.8440384087825,"d":"603.8"},null,{"v":604.0869098448909,"d":"604"}]
[null,null,{"v":398.7940818021031,"d":"399"},"Jo",{"v":391.71449460056573,"d":"392"},{"v":416.12566627604906,"d":"416"},{"v":375.1045865864034,"d":"375"},{"v":442.8928156723127,"d":"443"},{"v":382.02322170045903,"d":"382"},{"v":412.05120857728434,"d":"412"},{"v":421.4821069356358,"d":"421"},{"v":348.0465828848135,"d":"348"},{"v":297.5453370012028,"d":"298"},{"v":432.42363039730253,"d":"432"},null,{"v":391.94096506320295,"d":"392"},{"$nulls":5},{"v":597.0533244328642,"d":"597.1"},{"v":603.0987297037913,"d":"603.1"},{"v":592.7204884649458,"d":"592.7"},{"v":609.332778969195,"d":"609.3"},{"v":594.5481396550729,"d":"594.5"},{"v":602.1147634289144,"d":"602.1"},{"v":604.3777325617086,"d":"604.4"},{"v":585.2336329680583,"d":"585.2"},{"v":569.5566606656362,"d":"569.6"},{"v":606.9405733664296,"d":"606.9"},null,{"v":596.4976824216617,"d":"596"}]
[null,null,{"v":561.1425630215917,"d":"561"},"Jody",{"v":511.004334539659,"d":"511"},{"v":556.9385829354459,"d":"557"},{"v":529.941739709494,"d":"530"},{"v":581.3676646044444,"d":"581"},{"v":554.1044782359883,"d":"554"},{"v":599.6151708760628,"d":"600"},{"v":574.5687175197369,"d":"575"},{"v":487.5266199358914,"d":"488"},{"v":519.4052477449982,"d":"519"},{"v":543.8258589928108,"d":"544"},null,{"v":545.8298415094531,"d":"546"},{"$nulls":5},{"v":623.6378072632815,"d":"623.6"},{"v":632.2454969818039,"d":"632.2"},{"v":627.2767075427537,"d":"627.3"},{"v":636.53833701427,"d":"636.5"},{"v":631.7353257840263,"d":"631.7"},{"v":639.6288067569574,"d":"639.6"},{"v":635.3619702876833,"d":"635.4"},{"v":618.9344893943803,"d":"618.9"},{"v":625.2684402652768,"d":"625.3"},{"v":629.8629083463544,"d":"629.9"},null,{"v":630.0490289636789,"d":"630"}]
[null,null,{"v":462.2070393431138,"d":"462"},"Jordan",{"v":463.5230286551743,"d":"464"},{"v":477.7816397307277,"d":"478"},{"v":373.5750167244623,"d":"374"},{"v":513.896020507414,"d":"514"},{"v":495.66301372791776,"d":"496"},{"v":517.5061984419044,"d":"518"},{"v":414.8540989831043,"d":"415"},{"v":415.82321237868626,"d":"416"},{"v":464.2502439841917,"d":"464"},{"v":473.59971538699045,"d":"474"},null,{"v":461.04721885205726,"d":"461"},{"$nulls":5},{"v":613.8856068033122,"d":"613.9"},{"v":616.9153807470103,"d":"616.9"},{"v":592.3118832396143,"d":"592.3"},{"v":624.2020950258168,"d":"624.2"},{"v":620.5896288016236,"d":"620.6"},{"v":624.9021502733308,"d":"624.9"},{"v":602.7926889700518,"d":"602.8"},{"v":603.0260199692275,"d":"603.0"},{"v":614.0423725777516,"d":"614.0"},{"v":616.0362482613092,"d":"616.0"},null,{"v":612.8704074669048,"d":"613"}]
[null,null,{"v":581.1504193478271,"d":"581"},"Kade",{"v":724.3410428983457,"d":"724"},{"v":547.5005475709175,"d":"548"},{"v":498.70418771722433,"d":"499"},{"v":589.059037756704,"d":"589"},{"v":600.0781280692142,"d":"600"},{"v":587.1201511351586,"d":"587"},{"v":794.8451699328062,"d":"795"},{"v":488.38703175946625,"d":"488"},{"v":657.6971463400962,"d":"658"},{"v":554.6221338994837,"d":"555"},null,{"v":604.2354577079417,"d":"604"},{"$nulls":5},{"v":658.5262335201735,"d":"658.5"},{"v":630.5363461819685,"d":"630.5"},{"v":621.2013109784164,"d":"621.2"},{"v":637.8526412510856,"d":"637.9"},{"v":639.7059860187801,"d":"639.7"},{"v":637.5229485654609,"d":"637.5"},{"v":667.8147340885652,"d":"667.8"},{"v":619.110818938498,"d":"619.1"},{"v":648.874456145054,"d":"648.9"},{"v":631.8287042049001,"d":"631.8"},null,{"v":639.2974179892902,"d":"639"}]
[]
[{"$nulls":14},"Mean",{"v":421.5125262931201,"d":"421.5"},"SD",{"$nulls":14},"Mean",{"v":601.8549571945013,"d":"601.9"},"SD"]
[{"$nulls":3},"Mean",{"v":445.85140579637937,"d":"445.9"},{"v":418.7671748782285,"d":"418.8"},{"v":406.3393937885062,"d":"406.3"},{"v":440.73945421553026,"d":"440.7"},{"v":425.94602291735754,"d":"425.9"},{"v":414.4300838488201,"d":"414.4"},{"v":444.43052353477805,"d":"444.4"},{"v":402.13246094603574,"d":"402.1"},{"v":400.0105023830441,"d":"400.0"},{"v":416.47824062252073,"d":"416.5"},{"v":421.51252629312,"d":"421.5"},{"v":421.51252629311995,"d":"421.5"},{"v":17.185705285252745,"d":"17.2"},{"$nulls":3},"Mean",{"v":607.3540600542593,"d":"607.4"},{"v":601.9995193772135,"d":"602.0"},{"v":598.231682531401,"d":"598.2"},{"v":606.6102642275804,"d":"606.6"},{"v":603.7002446083528,"d":"603.7"},{"v":600.1109698270502,"d":"600.1"},{"v":606.5729662214287,"d":"606.6"},{"v":596.8248325847835,"d":"596.8"},{"v":596.4926944350307,"d":"596.5"},{"v":600.652338077914,"d":"600.7"},{"v":601.8549571945014,"d":"601.9"},{"v":601.8549571945016,"d":"601.9"},{"v":4.085347662836283,"d":"4.09"}]
[{"$nulls":14},"SD",{"v":92.93833035263422,"d":"92.9"},{"v":100.76880621993627,"d":"100.8"},{"$nulls":14},"SD",{"v":20.17945765181504,"d":"20.18"},{"v":22.022709941841278,"d":"22.02"}]
[null,null,"Analysis of raw data",null,null,"LCL","UCL","±CL","´¤¸CL",{"$nulls":12},"Analysis of log-transformed data","LCL","UCL","±CL","´¤¸CL",{"$nulls":5},"Back-transformed:"]
[{"$nulls":3},"Observed subject SD",{"v":101.76219402384687,"d":"101.8"},{"v":80.79160348311535,"d":"80.8"},{"v":139.4559687812365,"d":"139.5"},null,{"v":1.3138187018590248,"d":"1.31"},{"$nulls":11},"Observed subject factor SD",{"v":1.2483806060054152,"d":"1.25"},{"v":1.1925932670547956,"d":"1.19"},{"v":1.3552984716933596,"d":"1.36"},null,{"v":1.0660345926936732,"d":"1.07"},{"$nulls":5},"Mean",{"v":410.9820633028521,"d":"411.0"},"CV (%)"]
[{"$nulls":3},"True subject SD",{"v":91.90562088650549,"d":"91.9"},{"v":61.94355146981061,"d":"61.9"},{"v":114.26409205159366,"d":"114.3"},{"v":26.16027029089153,"d":"26.2"},{"$nulls":12},"True subject factor SD",{"v":1.2207215178771305,"d":"1.22"},{"v":1.1437732421914895,"d":"1.14"},{"v":1.2814729352493786,"d":"1.28"},null,{"v":1.058485109859019,"d":"1.06"},{"$nulls":5},{"v":410.9820633028525,"d":"411.0"},{"v":410.9820633028536,"d":"411.0"},{"v":4.16994610454941,"d":"4.2"}]
[{"$nulls":3},"Observed game SD",{"v":17.185705285252745,"d":"17.2"},{"v":12.534342477758726,"d":"12.5"},{"v":28.273880649551764,"d":"28.3"},null,{"v":1.5019031625840351,"d":"1.50"},{"$nulls":11},"Observed game factor SD",{"v":1.0416994610454942,"d":"1.04"},{"v":1.0302447139125737,"d":"1.03"},{"v":1.0695222363278274,"d":"1.07"},null,{"v":1.0188839281576552,"d":"1.02"},{"$nulls":5},"CV (%)",{"v":22.35966268129718,"d":"22.4"},{"v":24.635974602329895,"d":"24.6"}]
[{"$nulls":3},"True game SD",{"v":14.138720488464118,"d":"14.1"},{"v":-5.453051138482639,"d":"-5.5"},{"v":20.725409545307826,"d":"20.7"},{"v":13.089230341895233,"d":"13.1"},{"$nulls":12},"True game factor SD",{"v":1.0352039734533,"d":"1.04"},{"v":0.9900598055853516,"d":"0.99"},{"v":1.0512070234838038,"d":"1.05"},null,{"v":1.0304179421931283,"d":"1.03"}]
[{"$nulls":3},"Error SD (same raters)",{"v":43.690971401572,"d":"43.7"},{"v":40.14798520163926,"d":"40.1"},{"v":47.98581210404051,"d":"48.0"},null,{"v":1.093262739755447,"d":"1.09"},{"$nulls":11},"Error factor SD (same raters)",{"v":1.102030814337195,"d":"1.10"},{"v":1.0933826182649315,"d":"1.09"},{"v":1.1126060065938255,"d":"1.11"},null,{"v":1.008752484426859,"d":"1.01"}]
[{"$nulls":3},"Error SD different raters)",{"v":45.9217203408572,"d":"45.9"},"not yet available",{"$nulls":14},"Error factor SD (different raters)",{"v":1.108637073137701,"d":"1.11"},"not yet available"]
[{"$nulls":3},"ICC (same raters)",{"v":0.8156638649230045,"d":"0.82"},{"v":0.7257395159618725,"d":"0.73"},{"v":0.8954532981896638,"d":"0.90"},{"v":0.08485689111389566,"d":"0.08"},{"$nulls":12},"Observed subject CV (%)",{"v":24.838060600541525,"d":"24.8"},{"v":19.259326705479566,"d":"19.3"},{"v":35.529847169335966,"d":"35.5"},null,{"v":1.3582387592308394,"d":"1.36"}]
[{"$nulls":3},"ICC (different raters)",{"v":0.800216486401449,"d":"0.80"},"not yet available",{"$nulls":14},"True subject CV (%)",{"v":22.07215178771304,"d":"22.1"},{"v":14.377324219148946,"d":"14.4"},{"v":28.14729352493785,"d":"28.1"},{"v":6.8849846528944525,"d":"6.9"}]
[{"$nulls":4},"Error and ICC for mean of",2,"trials","Read comment.",{"$nulls":12},"Observed game CV (%)",{"v":4.16994610454941,"d":"4.2"},{"v":3.0244713912573644,"d":"3.0"},{"v":6.952223632782733,"d":"7.0"},null,{"v":1.5161323916979474,"d":"1.52"}]
[{"$nulls":5},"LCL","UCL","±CL","´¤¸CL",{"$nulls":11},"True game CV (%)",{"v":3.520397345330011,"d":"3.5"},{"v":-0.9940194414648431,"d":"-1.0"},{"v":5.120702348380377,"d":"5.1"},{"v":3.05736089492261,"d":"3.1"}]
[{"$nulls":3},"Error SD (same raters)",{"v":30.894182154679076,"d":"30.9"},{"v":28.38891258705628,"d":"28.4"},{"v":33.93109313951056,"d":"33.9"},null,{"v":1.093262739755447,"d":"1.09"},{"$nulls":11},"Error CV (%) (same raters)",{"v":10.203081433719504,"d":"10.2"},{"v":9.338261826493152,"d":"9.3"},{"v":11.260600659382547,"d":"11.3"},null,{"v":1.0981148264259382,"d":"1.10"}]
[{"$nulls":3},"Error SD (different raters)",{"v":32.47155985677234,"d":"32.5"},"not yet available",{"$nulls":14},"Error CV (%) different raters)",{"v":10.863707313770107,"d":"10.9"},"not yet available"]
[{"$nulls":3},"ICC (same raters)",{"v":0.8984745256882597,"d":"0.90"},{"v":0.8410765463145443,"d":"0.84"},{"v":0.9448434303761596,"d":"0.94"},{"v":0.051883442030807636,"d":"0.05"},{"$nulls":12},"ICC (same raters)",{"v":0.8082128542092739,"d":"0.81"},{"v":0.7157684492121865,"d":"0.72"},{"v":0.890847591393943,"d":"0.89"},{"v":0.08753957109087823,"d":"0.09"}]
[{"$nulls":3},"ICC (different raters)",{"v":0.8890225063998224,"d":"0.89"},"not yet available",{"$nulls":14},"ICC (different raters)",{"v":0.7890219553602142,"d":"0.79"},"not yet available"]
[{"$nulls":4},"Subjects","Games",{"$nulls":15},"Error and ICC for mean of",2,"trials","Read comment."]
[{"$nulls":4},"(rows)","(columns)","total","error",{"$nulls":14},"LCL","UCL","±CL","´¤¸CL"]
[{"$nulls":3},"n",20,10,200,{"$nulls":13},"Error factor SD (same raters)",{"v":1.0711134637942383,"d":"1.07"},{"v":1.0651629730240832,"d":"1.07"},{"v":1.0783712935629497,"d":"1.08"},null,{"v":1.0061810380544802,"d":"1.01"}]
[{"$nulls":3},"DegFree",19,9,199,171,{"$nulls":12},"Error factor SD (different raters)",{"v":1.0756497649303187,"d":"1.08"},"not yet available"]
[{"$nulls":3},"SumSquares",1641131.3172597205,53162.72390728154,2020716.109091222,326422.06792422,{"$nulls":12},"Error CV (%) (same raters)",{"v":7.111346379423836,"d":"7.1"},{"v":6.516297302408319,"d":"6.5"},{"v":7.837129356294966,"d":"7.8"},null,{"v":1.0966753003954417,"d":"1.10"}]
[{"$nulls":3},"SD^2",{"v":8446.643150534073,"d":"8447"},{"v":199.903417050915,"d":"200"},null,{"v":1908.9009820129825,"d":"1909"},{"$nulls":12},"Error CV (%) (different raters)",{"v":7.564976493031878,"d":"7.6"},"not yet available"]
[{"$nulls":3},"SE^2 of SD^2",7853792.568849971,19491.150527501475,null,42618.748060001504,{"$nulls":12},"ICC (same raters)",{"v":0.8939355257074566,"d":"0.89"},{"v":0.8343415447939252,"d":"0.83"},{"v":0.9422732910347421,"d":"0.94"},{"v":0.05396587312040846,"d":"0.05"}]
[{"$nulls":3},"SE of SD^2",{"v":2802.4618764311444,"d":"2802"},{"v":139.61071064750539,"d":"140"},null,{"v":206.44308673336946,"d":"206"},{"$nulls":12},"ICC (different raters)",{"v":0.8820707347902246,"d":"0.88"},"not yet available"]
[{"$nulls":5},"LCL","UCL",{"$nulls":14},"Subjects","Games"]
[{"$nulls":3},"F ratio",{"v":45.24872337603851,"d":"45.2"},{"v":27.46168727176099,"d":"27.5"},{"v":86.65103276181338,"d":"86.7"},{"$nulls":14},"(rows)","(columns)","total","error"]
[{"$nulls":3},"Obsvd subj variance",{"v":10355.544132547057,"d":"10356"},{"v":6527.283193372938,"d":"6527"},{"v":19447.967228713205,"d":"19448"},{"$nulls":13},"n",20,10,200]
[{"$nulls":3},"True subject variance",{"v":8446.643150534073,"d":"8447"},{"v":3837.003568693076,"d":"3837"},{"v":13056.282732375072,"d":"13056"},{"$nulls":13},"DegFree",19,9,199,171]
[{"$nulls":3},"Obsvd game variance",{"v":295.34846615156414,"d":"295"},{"v":157.10974134974677,"d":"157"},{"v":799.4123269850976,"d":"799"},{"$nulls":13},"SumSquares",77369.99711306534,3004.2117947235383,96514.95088331246,16140.741975523575]
[{"$nulls":3},"True game variance",{"v":199.903417050915,"d":"200"},{"v":-29.735766718906802,"d":"-30"},{"v":429.5426008207368,"d":"430"},{"$nulls":13},"SD^2",{"v":397.7714807263535,"d":"398"},{"v":11.970550328720368,"d":"12"},null,{"v":94.39030395043027,"d":"94"}]
[{"$nulls":20},"SE^2 of SD^2",{"v":17455.8210363104,"d":"17456"},{"v":62.16235417350108,"d":"62"},null,{"v":104.20502315619429,"d":"104"}]
[{"$nulls":20},"SE of SD^2",{"v":132.12047924644537,"d":"132"},{"v":7.884310634006063,"d":"8"},null,{"v":10.208086165202285,"d":"10"}]
[{"$nulls":22},"LCL","UCL"]
[{"$nulls":20},"F ratio",{"v":43.141137815939864,"d":"43.1"},{"v":26.182582553846284,"d":"26.2"},{"v":82.61501910682611,"d":"82.6"}]
[{"$nulls":20},"Observed subject variance",{"v":492.1617846767838,"d":"492.2"},{"v":310.2183047479378,"d":"310"},924.2919673854814]
[{"$nulls":20},"True subject variance",{"v":397.7714807263535,"d":"398"},{"v":180.45263124327107,"d":"180"},{"v":615.0903302094359,"d":"615"}]
[{"$nulls":20},"Observed game variance",{"v":16.69006552624188,"d":"17"},{"v":8.87823089825212,"d":"9"},{"v":45.17458408949357,"d":"45"}]
[{"$nulls":20},"True game variance",{"v":11.970550328720368,"d":"12.0"},{"v":-0.99798661363657,"d":"-1.0"},{"v":24.939087271077305,"d":"24.9"}]
[{"$nulls":22},"LCL","UCL"]
[{"$nulls":20},"Observed subject SD",{"v":22.18471962132458,"d":"22.2"},{"v":17.613015208871474,"d":"17.6"},{"v":30.40217043872824,"d":"30.4"}]
[{"$nulls":20},"True subject SD",{"v":19.944209202832624,"d":"19.9"},{"v":13.43326584428638,"d":"13.4"},{"v":24.801014701205997,"d":"24.8"}]
[{"$nulls":20},"Observed game SD",{"v":4.085347662836283,"d":"4.1"},{"v":2.979636034527056,"d":"3.0"},{"v":6.721204065455353,"d":"6.7"}]
[{"$nulls":20},"True game SD",{"v":3.4598483100737765,"d":"3.5"},{"v":-0.9989927995919541,"d":"-1.0"},{"v":4.993905012220127,"d":"5.0"}]
[{"$nulls":20},"Error SD same raters",{"v":9.715467253324992,"d":"9.7"},{"v":8.927621039331443,"d":"8.9"},{"v":10.67050173446676,"d":"10.7"}]
[{"$nulls":20},"Error SD different raters",{"v":10.313139884591434,"d":"10.3"}]
[{"$nulls":20},"Error for mean of 2 trials same raters",{"v":6.869872777221942,"d":"6.9"},{"v":6.312781376774956,"d":"6.3"},{"v":7.545184135104262,"d":"7.5"}]
[{"$nulls":20},"Error for mean of 2 trials different raters",{"v":7.2924911477200505,"d":"7.3"}]