Question

Find the regression​ equation, letting the first variable be the predictor​ (x) variable. Using the listed​ lemon/crash data, where lemon imports are in metric tons and the fatality rates are per​ 100,000 people, find the best predicted crash fatality rate for a year in which there are 450 metric tons of lemon imports. Is the prediction​ worthwhile? Lemon Imports 231 268 350 461 550 Crash Fatality Rate 15.9 15.6 15.2 15.3 15 Find the equation of the regression line. y =_______+_______x (Round the constant three decimal places as needed. Round the coefficient to six decimal places as​ needed.) The best predicted crash fatality rate for a year in which there are 450 metric tons of lemon imports is ______fatalities per​ 100,000 population. ​(Round to one decimal place as​ needed.)

Answer 1

X is the Lemon Imports and Y is the crash Fatality rate.

Y	X
15.9	231
15.6	268
15.2	350
15.3	461
15	550

The following regression analysis is performed in excel:

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.887682755
R Square	0.787980674
Adjusted R Square	0.717307566
Standard Error	0.187980197
Observations	5
ANOVA
	df	SS
Regression	1	0.393990337
Residual	3	0.106009663
Total	4	0.5
	Coefficients	Standard Error
Intercept	16.27763117	0.275951013
Slope	-0.002359224	0.000706543

The obtained regression equation is:

The best predicted crash fatality rate for a year in which there are 450 metric tons of lemon imports is calculated as:

The best predicted crash fatality rate for a year in which there are 450 metric tons of lemon imports is ____15.2__fatalities per​ 100,000 population. ​