Question

1. A certain device has made 9 measurements of the acceleration of gravity in units of m/s2 , x: 8.69, 9.95, 10.60, 9.88, 8.85, 10.31, 9.52, 9.29 and 10.65. Compute the average and σx . .

2. A different device makes measurements of the same quantity as in question #1 with the following results: 8.75, 8.50, 10.00, 9.90, 10.90, 8.54, 10.51, 9.56, 9.89, and 10.30 (m/s2 ). Find σx using the N-1 equation and compare these results to the results found in #1 (using N-1). Which device would you say have a higher precision? Explain.

3. Make a graph of the data in #1 and #2. Add error bars (estimated as the σx calculated). How many of the data points in data set from #1 agree with data set #2? Explain.

PLEASE ANSWER QUESTION 3 IT'S THE ONE I COULDN'T DO

Answer 1

The plot of both data, with error bars has been plotted in a same graph.

After plotting a scatter chart, error bar can be added from Chart tools --> Design --> Add chart element --> Error bars --> Standard deviation.

The separate graphs are

Since all the standard deviations on the mean value in both the graphs match, All the data points in set 1 and set 2 agree.