{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Mean","Std Error","LINEST","Trendlines","Gaussian","Poisson"],"read":"whole","date_system":"1900"}

{"sheet":"Mean","index":0,"n_rows":28,"n_cols":4,"rows_kept":28,"merged":[[2,1,2,5],[3,1,3,5]]}
[null,"Using Excel to Calculate the Mean"]
[]
[null,"Exercise: "]
[null,"Compute the mean of the following data set."]
{"$rows_empty":8}
[{"$nulls":3},"Current (A)"]
[{"$nulls":3},{"v":1.2,"d":"1.20"}]
[{"$nulls":3},1.02]
[{"$nulls":3},0.98]
[{"$nulls":3},1.12]
[{"$nulls":3},1.01]
[{"$nulls":3},0.87]
[{"$nulls":3},0.98]
[{"$nulls":3},1.12]
[{"$nulls":3},1.04]
[{"$nulls":3},1.23]
[{"$nulls":3},0.78]
[{"$nulls":3},1.01]
[{"$nulls":3},1.21]
[{"$nulls":3},1.06]
[null,null,"Mean:"]

{"sheet":"Std Error","index":1,"n_rows":28,"n_cols":4,"rows_kept":28,"merged":[[2,1,2,5],[3,1,3,5],[4,1,4,5]]}
[null,"Using Excel to Calculate the Standard Error"]
[]
[null,"Exercises:"]
[null," Compute the Standard Deviation of the following data set. "]
[null,"Compute the Standard Error of the following data set."]
[]
[]
[]
[]
[]
[{"$nulls":3},"Current (A)"]
[{"$nulls":3},{"v":1.2,"d":"1.20"}]
[{"$nulls":3},1.02]
[{"$nulls":3},0.98]
[{"$nulls":3},1.12]
[{"$nulls":3},1.01]
[{"$nulls":3},0.87]
[{"$nulls":3},0.98]
[{"$nulls":3},1.12]
[{"$nulls":3},1.04]
[{"$nulls":3},1.23]
[{"$nulls":3},0.78]
[{"$nulls":3},1.01]
[{"$nulls":3},1.21]
[{"$nulls":3},1.06]
[null,null,"Mean:"]
[null,null,"Standard Deviation:"]
[null,null,"Standard Error:"]

{"sheet":"LINEST","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"merged":[[2,1,2,5],[3,1,3,5],[4,1,4,5]]}
[null,"Using Excel to Calculate the Gradient "]
[]
[null,"Exercises:"]
[null,"Create a graph for the following data set."]
[null,"Compute the gradient of the line of best fit."]
[]
[null,null,"Current/A","Current Error/A","Potential Difference /V","P.D. Error/V"]
[null,null,{"v":0.1,"d":"0.10"},0.01,0.56,0.01]
[null,null,{"v":0.2,"d":"0.20"},0.01,1.1,0.1]
[null,null,{"v":0.3,"d":"0.30"},0.01,1.6,0.1]
[null,null,{"v":0.4,"d":"0.40"},0.01,2.1,0.1]
[null,null,{"v":0.5,"d":"0.50"},0.01,2.6,0.1]

{"sheet":"Trendlines","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[2,1,2,6],[3,1,3,6],[4,1,4,6]]}
[null,null,"Using Excel to Add Trendlines"]
[]
[null,"Exercise:"]
[null,"Create the graphs for both the quadratic and"]
[null," linearised data for a ball falling under Earth's gravity."]
[]
[{"$nulls":3},"Time /s","Distance / m","Time2 / s2"]
[{"$nulls":3},{"v":0,"d":"0.00"},0,{"$f":"D8^2","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},{"v":0.1,"d":"0.10"},0.05,{"$f":"D9^2","v":{"v":0.010000000000000002,"d":"0.01"}}]
[{"$nulls":3},{"v":0.2,"d":"0.20"},0.11,{"v":0.04000000000000001,"d":"0.04"}]
[{"$nulls":3},{"v":0.3,"d":"0.30"},0.43,0.09]
[{"$nulls":3},{"v":0.4,"d":"0.40"},0.75,{"v":0.16000000000000003,"d":"0.16"}]
[{"$nulls":3},{"v":0.5,"d":"0.50"},1.14,0.25]
[{"$nulls":3},{"v":0.6,"d":"0.60"},1.84,0.36]
[{"$nulls":3},{"v":0.7,"d":"0.70"},2.53,{"v":0.48999999999999994,"d":"0.49"}]
[{"$nulls":3},{"v":0.8,"d":"0.80"},3.45,{"v":0.6400000000000001,"d":"0.64"}]
[{"$nulls":3},{"v":0.9,"d":"0.90"},4.02,0.81]
[{"$nulls":3},{"v":1,"d":"1.00"},4.99,{"v":1,"d":"1.00"}]

{"sheet":"Gaussian","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"merged":[[2,1,2,6],[3,1,3,6],[4,1,4,6]]}
[null,"Calculations of a Gaussian Distribution Using Excel"]
[]
[null,"Exercises:"]
[null,"a) Calculate the probability of selecting a resistor with the value of 95 Ω or less."]
[null,"b) Calculate the probability of finding a resistor in the range 99-101 Ω."]
[]
[null,null,"Mean / Ω",100]
[null,null,"Standard Deviation σ / Ω",2]
[]
[null,"a)","Range 1"]
[null,null,"Highest Value Resistance / Ω",95]
[null,null,"Probability"]
[]
[null,"b)","Range 2"]
[null,null,"Highest Value Resistance / Ω",101]
[null,null,"Lowest Value Resistance / Ω",99]
[null,null,"Probability"]

{"sheet":"Poisson","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4]]}
[null,"Calculations of a Poisson Distribution Using Excel"]
[]
[null,"Exercises:"]
[null,"Calculate the count rate per minute and its error."]
[null,"Calculate the probability of of 13 counts being recorded in a random 1 min interval."]
[null,"Calculate the probability that the safety system will trip."]
[]
[null,"Time / hours ",10,null,"Count limit ",13]
[null,"Time / mins",null,null,"Probability of reaching the count limit"]
[null,"Total Counts / counts",1980,null,"Probability of reaching the count limit or higher "]
[null,"Error in Number of Counts / counts "]
[null,"Mean Count Rate / counts per min"]
[null,"Error in count rate / counts per min"]