Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help find the equations using excel. all info is provided. please and thank you For each country, use Excel to graph the EDR data

image text in transcribed

please help find the equations using excel. all info is provided. please and thank you

image text in transcribed
For each country, use Excel to graph the EDR data and find the best fit regression model with the input being the number of years since 1960 and the output being the EDR. Each country can have a different type of model (such as quadratic, cubic, 4th degree, exponential, etc). Round all values to 2 decimal places, if necessary. Note: Don't exceed a 4th degree polynomial as it will make Part II more difficult. Belgium (BEL) Thailand (THA) United States (USA) Year Years Since 1960 EDR Year Years Since 1960 EDR Year Years Since 1960 EDR 1960 0 54.80% 1960 85.40% 1960 0 66.10% 1965 5 57.30% 1965 5 89% 1965 5 65.40% 1970 10 58.70% 1970 10 90 40% 1970 10 61 70% 1975 15 56.90% 1975 15 85.20% 1975 15 55 60% 1980 20 52.90% 1980 20 76% 1980 20 52% 1985 25 48% 1985 25 63.40% 1985 25 50.90% 1990 30 49.10% 1990 30 53 20% 1990 30 52 20% 1995 35 51.10% 1995 35 48 30% 1995 35 53.10% 2000 40 52.50% 2000 40 43.90% 2000 40 51.60% 2010 50 52% 2010 50 39% 2010 50 49.70% 2011 51 52.30% 2011 51 39.20% 2011 51 49 90% 2012 52 52.70% 2012 52 39 40% 2012 52 50.10% 2013 53 53 20% 2013 53 39 50% 2013 53 50 40% 2014 54 53.70% 2014 54 39 70% 2014 54 50.80% 2015 55 54.20% 2015 55 40% 2015 55 51.20% 2016 56 54.80% 2016 56 40 20% 2016 56 51 60% 2017 57 55.30% 2017 57 40 40% 2017 57 52.20% 2018 58 55.90% 2018 58 40.80% 2018 58 52 70% 2019 59 56 40% 2019 59 41.30% 2019 59 53.30% 2020 60 57% 2020 60 41,90% 2020 60 53.90%

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_2

Step: 3

blur-text-image_3

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

Measure And Integration A First Course

Authors: M Thamban Nair

1st Edition

1000739872, 9781000739879

More Books

Students also viewed these Mathematics questions

Question

What is the cerebrum?

Answered: 1 week ago