Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started