Question

ed folde Remaining Time: 1 hour, 59 minutes, 08 seconds Question Completion Status: The length and weights of a sample of 7 seabreams are follows. folder [3 Marks) 320 Length (x) cm Weights (y)g 23 290 25 320 32 410 290 / 2321 440 350 502 400 / 35 Find the regression line equation then use it to predict the weighty when the seabream's length is x 390 422 322 OO 2245 another

Answer 1

Using Excel we fit regression model

Go to excel => enter data => Go to Data option => Data Analysis => Regression => input y variable => input X variable => lables => output range => ok

Using coefficints of intercept and x variable we form a model

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.98277041
R Square	0.96583768
Adjusted R Square	0.96014396
Standard Error	15.14849319
Observations	8
ANOVA
	df	SS	MS	F	Significance F
Regression	1	38926.63892	38926.63892	169.6321	1.26222E-05
Residual	6	1376.861076	229.4768461
Total	7	40303.5
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	76.64956195	23.54369923	3.255629509	0.017344	19.04020529	134.2589186	19.04020529	134.2589186
Length (x) cm	9.871088861	0.757898494	13.02428879	1.26E-05	8.016578053	11.72559967	8.016578053	11.72559967
Regression Equation
weights(y) g=76.6 + 9.871 Length (x) cm

We want to predict Weight (y) when length x =35

weights(y) g=76.6 + 9.871 Length (x) cm

weights(y) g=76.6 + 9.871 * 35

Weighs (y)=422.1376 in gram

option is 2

422 in gram