Ismael Molina

2022-07-24

Given the following set of numbers, find the average and sample standard deviation in excel. Important Once you have completed your calculation, report your numbers in a separate cell and obey the rounding requirement from last pre-lab:
$\begin{array}{|c|}\hline \text{Data}\\ 1\\ 1.25\\ 1.33\\ 1.5\\ 1.552\\ 1.347\\ 1.9\\ 1.1\\ 1.67\\ 1.32\\ 1\\ 1.5\\ \hline\end{array}$

Do you have a similar question?

nuramaaji2000fh

Expert

Step 1
No. of samples = 12
$\frac{\text{average}}{\text{mean}}=\frac{\left(1+1.25+1.33+1.5+1.552+1.347+1.9+1.1+1.67+1.32+1+1.5\right)}{12}\phantom{\rule{0ex}{0ex}}=\frac{16.469}{12}=1.372416667\simeq 1.37242$
Sample standard deviation $=\sigma =\sqrt{\frac{\sum \left(x-\overline{x}{\right)}^{2}}{\eta }}$

Still Have Questions?

Free Math Solver