Answered step by step
Verified Expert Solution
Link Copied!

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

  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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Statistics For Contemporary Decision Making

Authors: Black Ken

8th Edition

978-1118494769, 1118800842, 1118494768, 9781118800843, 978-1118749647

More Books

Students also viewed these Mathematics questions

Question

2. What do the others in the network want to achieve?

Answered: 1 week ago

Question

1. What do I want to achieve?

Answered: 1 week ago