Question: The table below gives the average weight (in kilograms ) of certain people ages 1-201-20 . Use Excel to find the best fit linear regression

The table below gives the average weight (in kilograms) of certain people ages 1-201-20 . Use Excel to find the best fit linear regression equation, where age is the explanatory variable. Round the slope and intercept to two decimal places.Age Weight 11 9.29.2 22 12.012.0 33 14.214.2 44 15.4515.45 17.917.9 66 19.919.9 7 22.422.4 88 25.825.8 99 28.128.1 1010 31.931.9 1111 36.936.9 12 41.541.5 1313 45.845.8 1414 47.647.6 1515 52.152.1 1616 53.553.5 1717 54.454.4 1818 56.756.7 1919 57.157.1 2020 58.058.0

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!

Determine the internal normal force, shear force, and bending moment at point D. Assume the reactions at the supports A and B are vertical. 1.5 kN/m 0.5 kN/m B 3 m -

The table below gives the average weight (in kilograms) of certain people ages 1-20. Use Excel to find thebest fit linear regression equation, where age is the explanatory variable. Round the slope...

The table below gives the average weight in kilograms of certain people ages 1 20 Use Excel to find the best fit linear regression equation where age is the explanatory variable Round the slope and...

The table below represents the number of young people in a certain city enrolled in the academic support and enrichment program of youth services. Here, x represents the number of months from January...

The table below gives the average life expectancy (in years) of a person from a certain country based on various years of birth. Here, a represents the year of birth after 1990, and y represents the...

The table below represents the number of young people in a certain city enrolled in the academic support and enrichment program of youth services. Here, I represents the number of months from January...

Mathematics 1670 Statistics Assignment #2 (Value: 10%) Due: June 9th@12 noon Directions: Answer all questions, show all workings. Submit your completed work via one of the approved methods (pdf...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Location Income ($1,000) Urban 27 Rural 25 Suburban 25 Suburban 26 Rural 30 Urban 29 Rural 33 Urban 30 Suburban 32 Urban 34 Urban 35 Urban 40 Rural 30 Rural 33 Urban 42 Suburban 32 Urban 43 Urban 43...

A container of internal volume 22.0 m3 was punctured, and a hole of radius 0.050 mm was formed. If the nitrogen pressure within the vehicle is initially 122 kPa and its temperature 293 K, how long...

A single stage double acting air compressor is required to deliver 14m of air per minute measured at 1,013 bur and 15c. Delivery pressure is 7 bar at 300 rpm. Take Clearance volume as 5% with n=103...

I am searching for the correct answer to this General accounting problem with proper accounting rules. Granite Dcor Ltd. is a merchandiser of decorative tiles. The company sold 10,000 units during...

Core Market Offerings and Defining the Product From the case study, take a position on whether Tropicana did or did not make a major mistake in changing its product packaging. Next, suggest the next...