Hello! I need help with this 2 part Assignment.

Please see attached and help me solve PROBLEM 2 in Excel. I will ask in another question to help me solve PROBLEM 1.

Thank you.

PROBLEM 1: Analyze the following data using LINEAR 'IREND ANALYSIS. How many cars will be sold in time period 13? W TIME PERIOD NUMBER OF CARS SOLD 3'0 80 66 3'4 64 3'6 72 83 LUM'HJUWU'IJDILHMH 82 H O 3'6 H H 84 H N 80 _J PROBLEM 2: As you can see below, a sample of 20 cars was taken, and the miles per gallon (MPG), horsepower, and total weight were recorded. NOTE: You will get negative independent variables [horsepower &weight] and that is OK. A. Develop a simple regression model to predict the dependent variable, MPG [Y], using Ci horsepower {XI} as the independent variable. Predict the dependent variable, MPG [Y], if horsepower {XI} is forecasted to be 11?. . Develop a simple regression model to predict the dependent variable, MPG [Y], using weight [XZI as the independent variable. Predict the dependent variable, MPG [Y], if weight {X2} is forecasted to be 3426. Using R2, which of the 2 causal forecasting models, A or B, is better? . Develop a multiple regression model to predict the dependent variable, MPG [Y], using horsepower {XI} and weight {X2} as the 2 independent variables. Using R2, how does the multiple regression model compare with each of the 2 simple regression models? Using the multiple regression model, predict the dependent variable, MPG [Y], if horsepower [X1] is forecasted to be 11? and weight {X2} is forecasted to be 3426. MPG {Y} HORSEPOWER {x1} WEIGHT [x21 44 6? 1844 44 50 1998 40 62 1252 37 69 1980 3? 66 1292 34 63 2199 35 90 2404 32 99 2611 30 63 3236 28 91 2606 26 94 2580 26 88 250? 25 124 2922 22 9? 2434 20 114 3248 21 102 2812 18 114 3382 18 142 3192 16 153 4380 16 139 4036