Question

Question 9

1. Suppose the administrator of a clinic is interested in the number of visits per person per year for those that are insured. After selecting 15 people the number of visits was recorded as the following:

   Patient #	Annual Number of visits
   1	1
   2	1
   3	2
   4	2
   5	2
   6	2
   7	3
   8	3
   9	3
   10	4
   11	4
   12	5
   13	6
   14	7
   15	8

   By using Excel

2. 5. Standard deviation and variance

   6. The skewness (Indicate if it is positively/negatively skewed)

   7. Write a summary regarding the number of visits using the above information.

Answer 1

EXCEL FUNCTION IN DATA ANALYSIS:

Click on DATA editor - Data analysis - Descriptive statistics - input range - output range

5) The standard deviation and variance is given by

s = 2.1336; s² = 4.5524

6) Skewness = 0.8634

It is positively skewed

7) The maen number of visits = 3.5 and the minimum and maximum number of visits are 1 , 8. The data is positively skewed (mean > median > mode)