HLT 362 Module 1 Descriptive Statistics Excel Worksheet

Module 1 Descriptive Statistics Excel Worksheet

A formula for the sample mean is

A formula for the sample variance is

A formula for the sample standard deviation is

A computational formula for the sample variance is

For the following sample of scores:

2, 6, 1, 4, 2, 2, 4, 3, 2

Find the mean, variance and standard deviation

A sample of size 7 (n = 7) has a mean of M = 9.

One of the sample scores is changed from x = 19 to x = 5. What is the value for the new sample mean?

Using Excel create a histogram and a line graph using the scores in the following table:

A computational

ninetynine

**Excerpt from file: **More Frequency 1 3 2 1 3 0 4 2 5 0 6 1 7 1 8 0 0 Histogram Frequency X 4 3 2 1 0 Frequency 1 2 3 4 5 X 6 7 8 More m Frequency 8 More Name: Date: Descriptive Statistics Excel Worksheet Directions: Answer all problems and submit to instructor at the end of module 1 Q1 b Q2 d Q3 c Q4 e 5. For the

**Filename: **
HLT 362 Module 1 Descriptive Statistics Excel Worksheet.xlsx

**Filesize: **
< 2 MB

**Downloads: **
0

**Print Length: **
7 Pages/Slides

**Words: **
279

Surround your text in `*italics*`

or `**bold**`

, to write a math equation use, for example, `$x^2+2x+1=0$`

or `$$\beta^2-1=0$$`

Stats

Views: 2

Asked: 2 years ago