{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":8,"macros":0,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":100,"n_cols":11,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,4],[0,6,2,6],[2,1,2,4]]}
["Standard Deviation",null,null,null,null,null,"If candidate used/calculated an incorrect value as part of their calculation, enter it into a pink cell and the spreadsheet will re-calculate the other values as a follow through",null,"Enter data values in yellow column (up to 100 values):"]
[null,"Work out the sample standard deviation of a data set",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(I2),\"\",I2^2)","v":""},{"$f":"IF(ISBLANK(I2),\"\",(I2-IF(OR(ISBLANK($G$10),$G$10=\"\",$G$10=0),$E$10,$G$10))^2)","v":""}]
[null,"Enter raw data into yellow cells (column I)",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(I3),\"\",I3^2)","v":""},""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,"sample standard deviation",null,"s = ",{"$f":"IF(COUNTA(Data)<=1,\"\",IF(OR(NOT(ISBLANK(G12)),NOT(ISBLANK(G14))),SQRT(E18/(IF(OR(G8=0,G8=\"\",ISBLANK(G8)),E8,G8)-1)),SQRT(IF(OR(G16=0,G16=\"\",ISBLANK(G16)),E16,G16)/(IF(OR(G8=0,G8=\"\",ISBLANK(G8)),E8,G8)-1))))","v":""},{"$f":"IF(COUNTA(Data)<=1,\"\",CONCATENATE(\"=√\",ROUND(IF(OR(NOT(ISBLANK(G12)),NOT(ISBLANK(G14))),E18,IF(OR(G16=0,G16=\"\",ISBLANK(G16)),E16,G16))/(IF(OR(G8=0,G8=\"\",ISBLANK(G8)),E8,G8)-1),3)))","v":""},null,null,null,"",""]
[null,null,null,{"$f":"IF(COUNTA(Data)<=1,\"\",IF(ROUND(E5,4)=ROUND(STDEV(I2:I101),4),\"\",\"Correct standard deviation (with no error):\"))","v":""},{"$f":"IF(COUNTA(Data)<=1,\"\",IF(ROUND(E5,4)=ROUND(STDEV(I2:I101),4),\"\",STDEV(I2:I101)))","v":""},{"$f":"IF(COUNTA(Data)<=1,\"\",CONCATENATE(\"=√\",ROUND(IF(OR(NOT(ISBLANK(G12)),NOT(ISBLANK(G14))),E18,IF(OR(G16=0,G16=\"\",ISBLANK(G16)),E16,G16)),3),\"/\",IF(OR(G8=0,G8=\"\",ISBLANK(G8)),E8,G8)-1))","v":""},null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,"size of data set",null,"n = ",{"$f":"IF(COUNTA(Data)<=1,\"\",COUNTA(I2:I101))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,"mean",null,null,{"$f":"IF(COUNTA(Data)<=1,\"\",AVERAGE(I2:I101))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,"sums of squares",null,null,{"$f":"IF(COUNTA(Data)<=1,\"\",SUM(I2:I101))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF(COUNTA(Data)<=1,\"\",SUM(J2:J101))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF(COUNTA(Data)<=1,\"\",SUM(K2:K101)+SUM(L2:L101)-SUMIFS(K2:K101,L2:L101,\"<>\"))","v":""},null,null,null,null,"",""]
[null,null,null,{"$f":"IF(COUNTA(Data)<=1,\"\",IF(AND(ROUND(E18,4)=ROUND(SUM(K2:K101),4),ROUND(E16,4)=ROUND(SUM(K2:K101),4)),\"\",\"Correct sum of squares (with no error): \"))","v":""},{"$f":"IF(COUNTA(Data)<=1,\"\",IF(AND(ROUND(E18,4)=ROUND(SUM(K2:K101),4),ROUND(E16,4)=ROUND(SUM(K2:K101),4)),\"\",SUM(K2:K101)))","v":""},null,null,null,null,"",""]
[null,null,null,null,{"$f":"IF(COUNTA(Data)<=1,\"\",IF(OR(G14=0,G14=\"\",ISBLANK(G14)),E14,G14)-IF(OR(G12=0,G12=\"\",ISBLANK(G12)),E12,G12)^2/IF(OR(G8=0,G8=\"\",ISBLANK(G8)),E8,G8))","v":""},null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
["© Dynamic Maths, all rights reserved",null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(I34),\"\",(I34-IF(OR(ISBLANK($G$10),$G$10=\"\",$G$10=0),$E$10,$G$10))^2)","v":""}]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(ISBLANK(I66),\"\",(I66-IF(OR(ISBLANK($G$10),$G$10=\"\",$G$10=0),$E$10,$G$10))^2)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(I67),\"\",I67^2)","v":""},""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,"",""]