Question

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	8
2	7
3	7
4	6
5	6
6	5
7	5
8	5
9	4
10	3
11	3
12	2
13	2
14	1
15	1

By using Excel,  data analysis,  five numbers summary, and the Rubric.docx

Answer the following Question, Submit both (Excel file and word document)

1. The mean, mode, median of the annual number of visits.

2. Five points summary [ first Quartile, Second Quartile, third quartile, Maximum and Minimum]

3. Draw the box and whisker plot                                                                                                                                      

4. Range,  IQR                                                                                                                                                        

5. What is variance and standard deviation?

• Why would knowing the variance and standard deviation of a distribution for a given data point be important for a Healthcare Administrator? 

6. The skewness (Indicate if it is positively/negatively skewed) look over the video.

• What would it mean if the distribution was negatively or positively skewed? 

• Why would this information be important for a Healthcare Administrator to know?  

7. Do you have outiler in the number of visit? (if no explain how can you tell?)

8.Write a summary regarding the number of visits using the above information. [at least 500 words]

Answer 1