Question: Explain what type of analysis and hypothesis test was conducted on the data collected. Summarize the survey results based on the results of the data
- Explain what type of analysis and hypothesis test was conducted on the data collected.
- Summarize the survey results based on the results of the data you analyzed.
- Include the Excel analysis as part of the document.
| NO | Patients ID | Diagnosis | Age | Sex | Marital status | Weight (Pounds) lb | Height (m) | Medicare cost ( $) |
| 1 | 10 | Diabetes | 35 | F | SINGLE | 300 | 1.52 | 2000 |
| 2 | 223 | Hypertension/Diabetes | 80 | M | MARRIED | 250 | 1.73 | 3500 |
| 3 | 345 | Diabetes | 69 | M | MARRIED | 320 | 1.54 | 2500 |
| 4 | 456 | Diabetes | 45 | M | MARRIED | 360 | 1.35 | 2000 |
| 5 | 658 | Diabetes | 50 | M | MARRIED | 380 | 1.55 | 2500 |
| 6 | 78 | Diabetes | 48 | M | SINGLE | 350 | 1.56 | 2000 |
| 7 | 667 | Hypertension | 45 | F | MARRIED | 230 | 1.87 | 1500 |
| 8 | 739 | Diabetes | 40 | M | MARRIED | 370 | 1.48 | 2000 |
| 9 | 65 | Hypertension | 85 | F | MARRIED | 230 | 1.39 | 1000 |
| 10 | 442 | Diabetes | 40 | M | MARRIED | 340 | 1.61 | 2000 |
| 11 | 53 | Diabetes | 42 | M | MARRIED | 390 | 1.52 | 2500 |
| 12 | 356 | Hypertension/Diabetes | 78 | F | MARRIED | 250 | 1,73 | 4000 |
| 13 | 345 | Hypertension | 45 | F | MARRIED | 240 | 1.54 | 1000 |
| 14 | 456 | Hypertension | 49 | F | MARRIED | 200 | 1.45 | 1500 |
| 15 | 344 | Diabetes | 39 | M | SINGLE | 390 | 1.86 | 2000 |
| 16 | 77 | Hypertension/Diabetes | 87 | F | MARRIED | 250 | 1.97 | 3000 |
| 17 | 909 | Diabetes | 44 | M | MARRIED | 300 | 1.38 | 2500 |
| 18 | 124 | Diabetes | 48 | M | MARRIED | 350 | 1.29 | 2000 |
| 19 | 567 | Diabetes | 37 | M | SINGLE | 370 | 1.50 | 2000 |
| 20 | 465 | Hypertension | 50 | F | MARRIED | 230 | 1.84 | 1500 |
| 21 | 543 | Diabetes | 45 | F | MARRIED | 360 | 1.92 | 2000 |
| 22 | 456 | Hypertension | 49 | F | MARRIED | 220 | 1.23 | 1000 |
| 23 | 23 | Diabetes | 36 | F | SINGLE | 360 | 2.05 | 2000 |
| 24 | 234 | Diabetes | 39 | M | SINGLE | 370 | 2.16 | 2500 |
| 25 | 235 | Diabetes | 41 | F | MARRIED | 380 | 1.67 | 2000 |
| 26 | 67 | Hypertension | 55 | M | MARRIED | 220 | 1.58 | 1500 |
| 27 | 567 | Hypertension | 58 | F | MARRIED | 210 | 1.88 | 1000 |
| 28 | 989 | Diabetes | 49 | F | MARRIED | 330 | 1.39 | 2500 |
| 29 | 785 | Hypertension/Diabetes | 88 | F | MARRIED | 210 | 1.96 | 4000 |
| 30 | 126 | Diabetes | 44 | M | MARRIED | 400 | 1.54 | 2000 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
