{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Scatterdata11"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Scatterdata11","index":0,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Independent Value","Dependent Value"]
["X Axis","Y Axis"]
[182.5,20,null,"Slope(m)=",{"$f":"INDEX(LINEST($B$3:$B$22,$A$3:$A$22),1)","v":-0.36453900019636498}]
[176.4,25,null,"b=",{"$f":"INDEX(LINEST($B$3:$B$22,$A$3:$A$22),2)","v":84.079757741985901}]
[150.19999999999999,35,null,"R2=",{"$f":"INDEX(LINEST($B$3:$B$22,$A$3:$A$22,TRUE,TRUE),3)","v":0.69615202735982351}]
[110.4,50,null,"R2Adj",{"$f":"1-(1-E5)*(COUNT($A$2:$A$22)-1)/(COUNT($A$2:$A$22)-2)","v":0.67927158443536917}]
[130.4,28,null,"F=",{"$f":"INDEX(LINEST($B$3:$B$22,$A$3:$A$22,TRUE,TRUE),4)","v":41.240151723230355}]
[180.5,18,null,"df=",{"$f":"INDEX(LINEST($B$3:$B$22,$A$3:$A$22,TRUE,TRUE),4,2)","v":18}]
[160.4,21,null,"SumSq=",{"$f":"INDEX(LINEST($B$3:$B$22,$A$3:$A$22,TRUE,TRUE),5)","v":1257.3897918173129}]
[155.30000000000001,34]
[120.4,48]
[170.4,19]
[185.2,15]
[140.30000000000001,22]
[160.5,20]
[175.4,19]
[165.4,22]
[184.5,20]
[170.3,19]
[184.5,22]
[170.3,17]
[184.5,20]
[null,null,null,null,null,null,null,null,null,"Correlation Coefficient (r): "]
[null,null,null,null,null,null,null,null,null,"Strong correlation: the dots nearly form a line"]
[null,null,null,null,null,null,null,null,null,"r-value range: 0.85 to 1.0 or -0.85 to -1.0"]
[null,null,null,null,null,null,null,null,null,"Moderate correlation: dots roughly form a line"]
[null,null,null,null,null,null,null,null,null,"r-value range: 0.75 to 0.84 or -0.75 to -0.84"]
[null,null,null,null,null,null,null,null,null,"Weak correlation: Hard to tell if dots form a line"]
[null,null,null,null,null,null,null,null,null,"r-value range:0.60 to 0.74 or -0.60 to -0.74"]
[null,null,null,null,null,null,null,null,null,"No correlation: dots do not form a line. Shotgun Effect"]
[null,null,null,null,null,null,null,null,null,"r-range: 0.59 and below"]