HLT-362V Week 1 Mean, Variance and Standard Deviation Excel Worksheet

# HLT-362V Week 1 Mean, Variance and Standard Deviation Excel Worksheet

A
0 points

#### HLT-362V Week 1 Mean, Variance and Standard Deviation Excel Worksheet

##### Topic: What Is Statistics and Why It Is Important to Health Sciences?

1. Identify the sampling technique being used. Every 20th patient that comes into the emergency room is given a satisfaction survey upon their discharge. a. random sampling b. cluster sampling c. systematic sampling d. stratified sampling e. none of the above

2. The formula for finding the sample mean is _________________.

3. The formula for finding sample standard deviation is ________________.

4. The computation form for sample variance is ___________________.

5. The following is the heart rate for 10 randomly selected patients on the unit. Find the mean, variance, and standard deviation of the data using the descriptive statistics option in the data analysis toolpak.

75, 80, 62, 97, 107, 59, 76, 83, 84, 69

1. The following is a frequency distribution for the number of times patients use the call light in a days time. X is the number of times the call light is used and f is the frequency (meaning the number of patients). Create a histogram of the data.

X f 1 2 2 4 3 7 4 5 5 7 6 3 7 15 8 13 9 10 10 6

HLT-362V
ajotatxe

A
0 points

#### Oh Snap! This Answer is Locked

Thumbnail of first page

Filename: hlt-362v-week-1-mean-variance-and-standard-deviation-excel-worksheet-10.xlsx

Filesize: < 2 MB

Print Length: 9 Pages/Slides

Words: 198

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$$

Use LaTeX to type formulas and markdown to format text. See example.