Question

PROBLEM 1: Analyze the following data using LINEAR TRENDANALYSIS. How many cars will be sold in time period 13?

TIME PERIOD	NUMBER OF CARS SOLD
1	70
2	80
3	66
4	74
5	64
6	76
7	72
8	83
9	82
10	76
11	84
12	80

PROBLEM 2: A sample of 20 cars was taken, and the miles pergallon (MPG), horsepower, and total weight were recorded.

Develop a simple regression model to predict the dependentvariable, MPG, using horsepoweras the independent variable.

Develop a simple regression model to predict the dependentvariable, MPG, using weight asthe independent variable.

Using R², which of the 2 causal forecasting models, A or B, isbetter?

Develop a multiple regression model to predict the dependentvariable, MPG, using horsepowerand weight as the 2 independent variables.

Using R², how does the multiple regression model compare witheach of the 2 simple regression models?

MPG (Y)	HORSEPOWER (X1)	WEIGHT (X2)
44	67	1844
44	50	1998
40	62	1752
37	69	1980
37	66	1797
34	63	2199
35	90	2404
32	99	2611
30	63	3236
28	91	2606
26	94	2580
26	88	2507
25	124	2922
22	97	2434
20	114	3248
21	102	2812
18	114	3382
18	142	3197
16	153	4380
16	139	4036

give answer to the problem 1 and 2 in excel.