Assignment 03 - Regression - Need in 14 Hours Max to Max

Sheet4

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.7721873425
R Square	0.5962732919
Adjusted R Square	0.5674356699
Standard Error	2.1547290184
Observations	16
ANOVA
	df	SS	MS	F	Significance F
Regression	1	96	96	20.6769230769	0.0004561386
Residual	14	65	4.6428571429
Total	15	161
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	29.75	2.2641749259	13.1394441566	0.0000000029	24.8938277597	34.6061722403	24.8938277597	34.6061722403
X	-2	0.4398322191	-4.5471884805	0.0004561386	-2.9433462884	-1.0566537116	-2.9433462884	-1.0566537116

Sheet1

				Cylinders	City MPG
		n		X	Y	XY	X2	Y2
		1	Ford Edge SE	4	20	80	16	400
		2	Toyota Sienna L	6	18	108	36	324
		3	Infiniti Q70L 3.7	6	18	108	36	324
		4	Jaguar XF 2.0T	4	19	76	16	361
		5	Ford F-150 XL V6	6	18	108	36	324
		6	Chevrolet Tahoe LS	6	16	96	36	256
		7	Nissan Juke	4	25	100	16	625
		8	BMW X1	4	22	88	16	484
		9	Ford Escape	4	22	88	16	484
		10	Hyundai Santa Fe	4	18	72	16	324
		11	Porsche Macan	6	17	102	36	289
		12	Mini Cooper Countryman	4	26	104	16	676
		13	Land Rover Range Rover	6	17	102	36	289
		14	Honda Accord	4	24	96	16	576
		15	Cadillac ATS	4	21	84	16	441
		16	Dodge Charger SRT Hellcat	8	15	120	64	225
				80	316	1532	424	6402
				5.0	19.75
			1532	1580	-48

Sheet2

Sheet3

1

2

3

4

5

6

7

8

9

10

11

A

B

C

D

n 

1

Ford Edge SE

2

Toyota Sienna L

3

Infiniti Q70L 3.7

4

Jaguar XF 2.0T

5

Ford F-150 XL V6

6

Chevrolet Tahoe LS

7

Nissan Juke