Healthcare Statistics

Assignment-Statistical_Calculations-Data_File.xlsx

Patient Satisfaction

This Excel spreadsheet contains 3 data sets, each on its own worksheet (see tabs at the bottom).
Patient Satisfaction Scores (based on 100 points)	Create functions in Excel to calculate the following:
92	1. Mean
88	2. Median
75	3. Mode
43	4. Score at the 70th Percentile
56
95
98
87
85
75
72
71
77
82
84
34
99
96
94
83
97
55
81
86

This Excel spreadsheet contains 3 data sets, each on its own worksheet (see tabs at the bottom).
Female Patients in the "Weight Off" program	Weight (in lbs.)	Create functions in Excel to calculate the following statistics for these patients:
1	110	5. Range
2	115	6. Mean
3	120	7. Median
4	122	8. Mode
5	125
6	227

This Excel spreadsheet contains 3 data sets, each on its own worksheet (see tabs at the bottom).
Male Patients in the "Weight Off" program	Weight (in lbs.)	Create functions in Excel to calculate the following statistics for these patients:
1	185	9. Standard Deviation
2	186	10. Mean
3	189	11. Variance
4	193	12. Range
5	198
6	200