Question

I want the step-by-step for all of these by hand, and then if you know a short-cut with excel too I would be very grateful. Yes, this is one long problem. If you can't see chart, then just help with the rest! Thanks!

Pearson Courses Do Homework - Cayenne Sims https://www.mathxl.com Stat 2103 - Statistical Business Analytics, Sect 011, CRN 26082 Cayenne Sims 04/05/20 3:15 PM Homework: Chapter 11(11.6-11.7) Save Score: 0.54 of 1 pt 1 of 4 (1 complete) HW Score: 13.46%, 0.54 of 4 pts % 11.6.82 Question Help O Consider the pairs of measurements in the table below. Complete parts a through f. X-2 0 2 4 6 8 10 - Y 2 3 3 4 9 10 13 a. Construct a scatterplot for these data. Choose the correct scatterplot below. OA b. Find the least squares line, and plot it on your scatterplot. The least squares line is y = 2.5 + .946 x. (Round to three decimal places as needed.) Plot the least squares line on the scatterplot. Choose the correct graph below. ОА. Question is complete. Tap on the red indicators to see incorrect answers. All parts showing Similar Question

Answer 1

we have: x= Independent 4 y = dependent variable, n= * x= [-2,0,2,4,6,8,10] + ya [ 2,3,3,4, 9, 10, 13) © scattere lot: 2,) - correct graph @ clast)

८ - ० . . . . ल - -2' - ०८ । 2 , ५ 6 + 8 १ 0 11 12 13 5 २ →

© least square line where [a= 9-b2 û = afbx. bassay - 3xy - (EX:Ey) SSXR $5** Eq? EE G4 Eli= (-2+02+4 +6+8 +10) =28 E4; = (2+3 3 +4+9+10+13] = ${i2= 6 4+0+4 +16+36 +64 +100] =2241 Ey; ²= [4+9+9+ 16 + 8 lt 100 ti 388 ) Ex4 = C4 to +6+16+54 +80 +130) =[ 282]

112 b = (282 – ( 28 *44)) = 100 -15.9464] (224 - (282) ¢ q= ģ- bž - Evi -(0.9464+ EX) = 44 - (0.9464 * ) = [2.500 y = 2.5 +0.9462

O correct scattereplot with line is ® © Eind 12 = {(4:23)? 0-2 .. 214,- 9,2 (2-12570.94646-2)]2+ [(3.-17.5*10.94640)+ [3 - (2.5 t (0.946+2012+ [(4 - 12.5 +10.946* 4)]2+ [9:- (2.5+ (0.946 *6)] + C10 -12.5+ (0.946*8)]2+ [ 13- 12.5+ (0.946 *10))?

= (1.9400 to.25 +1.9400 t 52244 fotos 0.0051 f 1.0727) = | 11:1071 5.52 111041 = 2.221 | 2 -2 5 for interval the mean value of - 90% confidence 4 when x=t. X df error 21df S5 x - ŷ when a= 1 » 25+(0.946* 7) = 19.122

:. Eller af error = to.10,5 = 1 2.0150.). (from table) se = Syz = 1:490) 552 = 112), Ž= = 2 = 14) 112 > C 9.122 † (2-0150 * 1.490* ++ (7-412) 112 = ( 9.122 † (2.0150 * 1.440 * 0.4+24)] = (9.122 [ 1.418]

1 = [ 7-704, 10.54) upper limit on plot Den - plot » lower of - correct option is © gol prediction internal va for a when a=7 1. y I tala,df error * se * Ri-x12 Sox

® option is correct upper limit value on plot f lower plot - + [ 5-802, 12.442] = I 3.3 = 79.122 (rosale! * obh.) * 2510-2) I 22116] = r all Slz1h-ta) + F+ * obfil * oslo z] F 72116 ] E
now Excel :

we have to use Regression (simple) here x is independent variable and y is dependent variable Scatter plot y = 0.9464x + 2.5 R=0.9003 -4 - 2 0 2 6 8 10 12

SUMMARY OUTPUT Regression Statistics Multiple R 0.948852 R Square 0.900321 Adjusted R Square 0.880385 Standard Error 1.490446 Observations ANOVA df Regression Residual Total SS MS F gnificance F 1 100.3214 100.3214 45.16077 0.001105 5 11.10714 2.221429 6 111.4286 Intercept Coefficientandard Errt Stat P-value Lower 95%Upper 95%ower 95.09pper 95.0% 2.5 0.796677 3.138036 0.025723 0.452077 4.547923 0.452077 4.547923 0.946429 0.140834 6.720176 0.001105 0.584404 1.308454 0.584404 1.308454

##b estimated equation is :yhat = a + bx yhat = 2.5 +0.946 *x ## C S^2 mse 2.221429 ## d 90 % confidence interval when x = 7 yhat I critical value * se * SQRT((1/n) + (x - xbar)^2 / ssx)) yhat = 9.125 se = SQRT(5^2) 1.490446 xbar SSX 112 critical value 2.015048 LOWER limit 7.704 Upper limit 10.54

#e 90 % prediction interval; yhat I critical value * se * SQRT((1+1/n) + (x - xbar)^2 / ssx)) lower limit 5.802 upper limit 12.442