Question

Use Excel, and show code for how to calculate. Thank You

5.1 Consider the following response time data measured in seconds.* 1.49 1.70 1.61 1.43 1.29 1.36 1.66 1.42 1.56 1.25 1.80 1.51 1.50 1.44 1.35 1.58 1.31 1.32 1.48 1.47 1.29 1.46 1.62 1.48 1.48 1.34 1.59 1.66 1.55 1.61 1.52 1.80 1.64 1.46 1.38 1.56 1.62 1.30 1.56 1.27 1.37 1.46 1.42 1.59 1.58 1.60 1.67 1.37 1.55 1.55 1.57 1.66 1.38 1.49 1.58 1.48 1.30 1.68 1.65 1.65 1.59 1.57 1.26 1.43 1.53 1.72 1.77 1.54 1.59 1.46 1.48 1.53 1.33 1.59 1.48 1.62 1.53 1.47 1.61 1.39 1.43 1.39 1.40 1.66 1.33 (a) Compute the mean and the variance. (b) Use the Sturges formula to make a histogram approximating f(x).

Answer 1

Mean is equals to	Sum of terms/number of terms
i.e,	128.02/85
	1.51
	I-N t(X-X)3 =zS
Numerator of each term
0.0009	0.0025	0.0004	0.0081	0.0256
0.0289	0.0081	0.0361	0.0025	0.0049
0.0064	0.0064	0.01	0.0676	0.04
0.0225	0.0049	0.0064	0.0841	0.0361
0.0016	0.0081	0.0484	0	0.0009
0.01	0.0256	0.0225	0.0001	0.0016
0.0001	0.0196	0.0225	0.0049	0.0484
0.0841	0.0016	0.0025	0.0121	0.0009
0.0169	0.0016	0.0196	0.0009	0.0004
0.0025	0.0036	0.0196	0.0064	0.0016
0.0169	0.0225	0.0064	0.0025	0.01
0.0025	0.0169	0.0036	0.0009	0.0144
0.0121	0.0004	0.0625	0.0004	0.0064
0.0441	0.0049	0.0064	0.0324	0.0144
0.0025	0.0009	0.0004	0.0064	0.0121
0.0576	0.0441	0.0441	0.0009	0.0225
0.0196	0.0289	0.0676	0.0121	0.0324
sum of squares of each term		1.4237
No. of terms		85
Variance	is euals to	1.4237/84
		0.016949