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