q3: please help

A B | C I D | E | F | G | H I | | J | K | L | M I N Elam Problem #3 - Simple Linear Regression Model for Hybrid Automobiles [2015} The values shown below in Column A represent the weight [in pounds} of 16 different hybrid cars made in 2013. The numbers in Column B are the corresponding gas mileages for each of the 16 hybrid cars in Column A. Please provide direct answers to Parts AH in Rows 2M9 below. Hybrid Car Weight [in lbs} Car MPG 3250 38 3575 33 3840 29 3935 30 2140 53 4-010 32 2555 44 3450 32 2900 3S 3345 35 3545 34 3050 41 2540 44 2410 45 2855 4-0 3810 32 Part A Before we do any computational work, what is the general relationship we expect to nd between these two variables? [2 pts.} Part B - In the empty space to the right of the raw data, produce a graph WITH the regression model and the associated lt-squared value for this data set. [6 pts.} Part C Which of these variables do we presume is the "dependent" variable and which is "independent'.. nd wlly? [4 pts.} Part D- What is the regression modelfequation? [2 pts.} Part E What is the associated Kscuared value? [2 pts.} Part F - What does the graph tell us about the general relationship between these two variables? [4 pts.} Part E A close friend of your. knows that you havejust nished your rst stats dass in that awesome business program at UM. She is planning to purchase a new [2015} hybrid car but is concerned about getting the best gas mileage possible. During the discussion, she tells you the car is somewhat heavy at 3,353 pounds. Using this regression equation, tell your friend what her expected gas mileage will be. Please show your work for this computation. [15 pts.} Part H - Your friend winces when you give her the answer from Part 6. Then she asks 'How sure are you?? That MPG sounds so low for a hybrid!" How will you respond .- and, most importantly, what is the rationale for your response? [15 pts.}