Question

Using Excel, give the average and standard deviation of the following set of numbers: {0.350, 0.117, 3.645, 0.948, 0.145, 3.392, 3.695, 1.426, 1.640, 0.814, 10.190, 1.486}. Then plot both the histogram, bucketing the data into 10 evenly spaced bins, and the fitted Gaussian of the latter data in the same spreadsheet, superimposed or overlaid on each other with the same x-axis, on the same printed page.

Answer 1

Solution:-

	x	(x- u)	(x - u)^2
	0.35	-1.97066667	3.883527
	0.117	-2.20366667	4.856147
	3.645	1.324333333	1.753859
	0.948	-1.37266667	1.884214
	0.145	-2.17566667	4.733525
	3.392	1.071333333	1.147755
	3.695	1.374333333	1.888792
	1.426	-0.89466667	0.800428
	1.64	-0.68066667	0.463307
	0.814	-1.50666667	2.270044
	10.19	7.869333333	61.92641
	1.486	-0.83466667	0.696668
Sum	27.848	-7.03466667	23.6816
Mean	2.32066667	-0.70346667	2.36816

The average and standard deviation is 2.321 and 1.4673.