Ismael Molina

Answered

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?

Recalculate according to your conditions!

Answer & Explanation

nuramaaji2000fh

Expert

2022-07-25Added 18 answers

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

Help you to address certain mathematical problems

Ask your question.
Get your answer.

Let our experts help you. Answer in as fast as 15 minutes.

Didn't find what you were looking for?