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

PLDZ-19 In Stock
\$ 17.00 USD
Description

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

Name: Date: Topic One: Mean, Variance, and Standard Deviation  Please type you answer in the cell beside the question.

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 _b ________________.

a. ??=??·??

b. ?? ¯=(∑??)/??

c. ?? ¯=??/??

d. ??=??/??

e. None of the above

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

a.??=∑??−?? ¯^2

b.??^2=(∑(??−??)^2 )/??

c.??^2=(∑(??−??)^2 )/??

d.??^2=(∑(??−?? ¯ )^2 )/(??−1)

e. none of the above

4. The computation form for sample variance is __e_________________.

a. ??^2=??·??

b.??^2=(∑??^2 −(∑??)^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 fo the number of times patience 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

Recent Reviews
Write a Review
4 4 4 1 reviews

mean, variance and standard deviation excel worksheet

purchased answer for mean, variance and standard deviation excel worksheet.

4