HIMS 11

 

Assignment Instructions: 

Using the Patient Healthcare Data in the attached Excel file (attached below), construct a 3-D Clustered Column Chart depicting the three healthcare parameters (weight, height, age), and title this chart ” Patient Healthcare Data” at the top center and show Legend at the bottom. After reviewing the data displayed in the chart, answer the following questions supporting your conclusions with logical explanations.

1. Is there any relationship between the Weight and Height of patients? Why did you make this conclusion?

2. Is there any relationship between the Weight and Age of patients? Why did you make this conclusion? 

Save this file and submit it to the Week 11 Assignment folder.   

Week 11 Patient Healthcare Data File:

Patient Healthcare Data – Week 11 (Excel Worksheet)

Revised

Using the Patient Healthcare Data in the attached Excel file, construct a Clustered Column – Line Chart depicting the three healthcare parameters (weight, height, age), and title this chart ” Patient Healthcare Data” at the top center and show Legend at the bottom. After reviewing the data displayed in the chart, answer the following questions supporting your conclusions with logical explanations.

1. Is there any relationship between the Weight and Height of patients? Why did you make this conclusion?
2. Is there any relationship between the Weight and Age of patients? Why did you make this conclusion? 
Save this file and submit it to the Week 11 Assignment folder.   

Week 11 Patient Healthcare Data File: Patient Healthcare Data – Week 11 (Excel Worksheet)

Sheet1

60

65

45

55
55

65

65
70

60

110

115
45
85

55
75

160
62
65

55
60

65
75

55
45

120

55

65

65
35

110
55
45

Patient	Weight (lbs)	Height (Inches)	Age
Alfred	100								55	50
Benjamin			110				60
Carmen		115					45			75
David		120								65
Elsa	90	39
Fauto		85
Gabrielle	95	57
Ian	1	70
James		160		62
Holland	52	80
Kamal
Loyall	155
Manzoor
Nazir	130
Opal	140
Qattar	1	35
Rasul	58
Stacey	200	63
Umar	150
Xavier