Question

Using Excel, give the average and standard deviation of the following set of numbers: {2.777, 1.318,...

Using Excel, give the average and standard deviation of the following set of numbers: {2.777, 1.318, 3.993, 0.310, 1.763, 2.938, 3.431, 3.146, 10.705, 2.526, 1.976, 3.864}. 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.

Homework Answers

Answer #1

Average = AVERAGE(A2:A13)

Standard deviation = =STDEV.S(A2:A13)

The results are

Average = 3.23

Std Dev = 2.59

Plotting of Histogram

GIven number of bins = 10

Size of each bin = (Max - Min)/10 = (10.705 - 0.31)/10 = 1.0395

we consider bin size as 1.05

Calss Frequency
0 - 1.05 1
1.05 - 2.1 3
2.1 - 3.15 4
3.15 - 4.2 4
4.2 - 5.25 0
5.25 - 6.3 0
6.3 - 7.35 0
7.35 - 8.4 0
8.4 - 9.45 0
9.45 - 10.5 0
10.5 - 11.55 1

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions