Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The excel file attached in this homework contains personal medical cost data. Explore the relationship between Age and Charges (individual medical costs billed by health

The excel file attached in this homework contains personal medical cost data. Explore the relationship between Age and Charges (individual medical costs billed by health insurance) by plotting the data and adding curve fitting trendline with linear and polynomial (order 2) using Excel.

Age Charges
19 16884.924
33 21984.47061
60 28923.13692
62 27808.7251
27 39611.7577
30 36837.467
34 37701.8768
31 38711
22 35585.576
28 51194.55914
62 15612.19335
35 39774.2763
60 48173.361
55 20630.28351
36 38709.176
48 23568.272
36 37742.5757
58 47496.49445
18 34303.1672
53 23244.7902
64 30166.61817
28 17663.1442
27 16577.7795
22 37165.1638
37 39836.519
45 21098.55405
57 43578.9394
59 30184.9367
64 47291.055
56 22412.6485
38 15820.699
18 21344.8467
61 30942.1918
20 17560.37975
63 47055.5321
60 30259.99556
29 19107.7796
44 39556.4945
19 17081.08
32 32734.1863
54 27322.73386
34 27375.90478
34 18972.495
29 18157.876
30 20745.9891
46 40720.55105
42 19964.7463
48 21223.6758
18 15518.18025
30 36950.2567
50 19749.38338
42 21348.706
18 36149.4835
63 48824.45
36 43753.33705
27 37133.8982
35 20984.0936
24 25081.76784
19 34779.615
42 19515.5416
58 24227.33724
40 19444.2658
19 17352.6803
23 38511.6283
55 35160.13457
63 29523.1656
54 24476.47851
63 47305.305
54 44260.7499
50 41097.16175
56 43921.1837
19 33750.2918
20 17085.2676
52 24869.8368
19 36219.40545
53 20462.99766
46 46151.1245
40 17179.522
50 42856.838
40 22331.5668
54 48549.17835
59 47896.79135
52 25992.82104
29 20277.80751
25 42112.2356
19 16297.846
47 21978.6769
31 38746.3551

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

More Books

Students also viewed these Databases questions