Question

with x - burner-area liberation rate (MBtu/hr-ft2) and y No, emission rate (ppm) x |100 125 125 150 150 200 200 250 250 300 300 350 400 400 y 150 140 180 210 190 320 280 400 430 440 390 600 610 670 The equation of the estimated regression line is y -45.55190539 +1.71143233x (a) Obtain SSE for the data from the defining formula SSE- (Round your answer to two decimal places.) -45.55 Compare to the value calculated from the computational formula. (Whe Rounded to two decimal places the value from the computational formula is Select n comparing, round your value from the computational formula to two decimal places.) the d efining formula ..-Select less than equal to greater than (b) Calculate the value of total sum of squares. (Round your answer to two deci greater in emission rate? Justify your assertion. (Assume that a value of Does the simple linear regression model appear to do an effective job of exp than 0.85 is large enough to consider the model successful.) ISelect..to do an effective job of explaining variation in the simple linear regression model Select... Since, rounded to two decimal places, emission rate Need Help? Read it Talk to a Tuter

please answer part a

Answer 1

data

x	y
100	150
125	140
125	180
150	210
150	190
200	320
200	280
250	400
250	430
300	440
300	390
350	600
400	610
400	670

Using Excel

data -> data analysis -> regression

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.9802
R Square	0.9609
Adjusted R Square	0.9576
Standard Error	36.7485
Observations	14
ANOVA
	df	SS	MS	F	Significance F
Regression	1	398030.2609	398030.2609	294.7380	0.0000
Residual	12	16205.4534	1350.4544
Total	13	414235.7143
	Coefficients	Standard Error	t Stat	P-value	Lower 95%
Intercept	-45.5519	25.4678	-1.7886	0.0989	-101.0415
x	1.7114	0.0997	17.1679	0.0000	1.4942

SSE = 16205.45

b)

SST = 414235.71

r^2 = 0.9609

Please rate