Ismael Molina

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:
Data 1 1.25 1.33 1.5 1.552 1.347 1.9 1.1 1.67 1.32 1 1.5

Do you have a similar question?

Recalculate according to your conditions!

Answer & Explanation

nuramaaji2000fh

nuramaaji2000fh

Expert

2022-07-25Added 18 answers

Step 1
No. of samples = 12
average mean = ( 1 + 1.25 + 1.33 + 1.5 + 1.552 + 1.347 + 1.9 + 1.1 + 1.67 + 1.32 + 1 + 1.5 ) 12 = 16.469 12 = 1.372416667 1.37242
Sample standard deviation = σ = ( x x ¯ ) 2 η
x ¯ = mean average of samples ;   x = sample η = no. of samples σ = ( 1 1.37242 ) 2 + ( 1.25 1.37242 ) 2 + ( 1.33 1.37242 ) 2 + ( 1.5 1.37242 ) 2 + ( 1.552 1.37242 ) 2 + ( 1.347 1.37242 ) 2 + ( 1.9 1.37242 ) 2 + ( 1.1 1.37242 ) 2 + ( 1.67 1.37242 ) 2 + ( 1.32 1.37242 ) 2 + ( 1 1.37242 ) 2 + ( 1.5 1.37242 ) 2 12 1 σ = 0.803485 11 = 0.27027 Standard deviation = 0.27027

Still Have Questions?

Ask Your Question

Free Math Solver

Help you to address certain mathematical problems

Try Free Math SolverMath Solver Robot

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?