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

HLT-362V Week 1 Mean, Variance and Standard Deviation Excel  Worksheet                    Applied Statistics for Health Care Professionals - What Is Statistics and Why It Is Important to Health Sciences?                                                            Grand Canyon University

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 _________________.

a. 𝜇=𝜎∙𝑛

b. 𝑥 ̅=(∑1▒𝑥)/𝑛

c. 𝑥 ̅=𝑠/𝑛

d. 𝜇=𝑠/𝑛

e. None of the above

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

a.𝑠=∑1▒𝑥−𝑥 ̅^2

b.𝜎^2=(∑1▒(𝑋−𝜇)^2)/𝑁

c.𝑠^2=(∑1▒(𝑋−𝜇)^2)/𝑁

d.𝑠^2=(∑1▒(𝑋−𝑋 ̅)^2 )/(𝑁−1)

e. none of the above

4. The computation form for sample variance is ___________________.

a. 𝑠^2=𝑠∙𝑛

b.𝑆^2=(∑1▒𝑋^2 −(∑1▒𝑋)^2)/𝑁

c.𝑠=√((𝑠^2) )

d.𝜇=𝑠/𝑛

e. none of the above

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

6. 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   .........................................................