Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make a number collection,any7-12numbers of your choice. then Arrange them in order and find Median and Mean. and Calculate Sample Variance and Standard Deviation for

Make a number collection,any7-12numbers of your choice.

then Arrange them in order and find Median and Mean.

and Calculate Sample Variance and Standard Deviation for your sample.

To findVariance and Standard Deviation on Excel:One way sample variance and sample standard deviation can be calculated on Excel:Open a spreadsheet. enter data in first column.Lets say data is3,6,8,12,16,17,20,23,24.It would be entered in cells A1 to A9. Go toFormulas at top ribbon,More Functions, Statistical,Scroll to var.s for sample variance.In No.1 dialog box enter cell range A1:A9.Note the variance value appears in bottom right of dialog box. (56.75)Repeat to find standard deviation. Scroll tostdev.s for sample standard deviation. (7.533).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra

Authors: Robert F Blitzer

7th Edition

013449492X, 9780134453262

More Books

Students also viewed these Mathematics questions

Question

4. Briefly explain the principle behind minimax evaluation.

Answered: 1 week ago