[solved]-1 Using Excel Give Average Standard Deviation Following Set Numbers 1519 0582 2333 3580 17 Q39065136

1. Using Excel, give the average and standard deviation of thefollowing set of numbers: {1.519, 0.582, 2.333, 3.580, 1.771,2.072, 11.282, 3.859, 0.659, 1.791, 2.311, 2.685}.In Excel, plot both the histogram, bucketing the data into 10evenly spaced bins, and the fitted Gaussian of the latter data inthe same spreadsheet, superimposed or overlaid on each other withthe same x-axis, on the same printed page.

2. Using Excel, give the average and standard deviation of thefollowing set of numbers: {1.519, 0.582, 2.333, 3.580, 1.771,2.072, 1.996, 3.859, 0.659, 1.791, 2.311, 2.685}.In Excel, plot both the histogram, bucketing the data into 10evenly spaced bins, and the fitted Gaussian of the latter data inthe same spreadsheet, superimposed or overlaid on each other withthe same x-axis, on the same printed page

Which set of data is more precise, that from question 1 or fromquestion 2? Discuss and explain your answer using a graphicalcomparison as an aide of the fitted Gaussians for each set of data.Advice: it is best to plot both histograms on the same graph sothat they have the same scale. What can you say about the accuracyof the data?

Expert Answer

---

Answer to 1. Using Excel, give the average and standard deviation of the following set of numbers: {1.519, 0.582, 2.333, 3.580, 1…. . . .