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

  1. Explain what type of analysis and hypothesis test was conducted on the data collected.
  2. Summarize the survey results based on the results of the data you analyzed.
  3. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!