80.2K

Verified Solution

Link Copied!

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

Patient #	Annual Number ofvisits
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 usingExcel,  data analysis,  five numbers summary,and the Rubric.docx

Answer the followingQuestion, 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]