Question

Save Homework: Chapter 14 Homework Score: 0 of 5 pts 12 of 20 (10 complete) 14.5.37-T HW Score: 41.74%, 52.18 of 125 pts Question Help Rating Increase A university would like to examine the relationship between a faculty member's performance rating (measured on a scale of 1-20) and his or her annual salary increase. The table to the right shows these data for eight randomly selected faculty members. Construct a 95% confidence interval for the regression slope. Rating Increase $2000 $2700 $2100 15 $2000 $2600 $1900 S1700 12 18 12 ONGERER Construct a 95% confidence interval for the slope LCL - and UCL = (Round to three decimal places as needed) Enter your answer in the edit fields and then click Check Answer All parts showing ClearA Check Annel

please show work. If excel could be used to find the answer, please show steps.

Answer 1

(x-x)2 (y-) (x-X)(y- X Y S.No 0.0156 18906.2500 -17.1875 15 2300 2 19 2600 15.0156 191406.2500 1695.3125 1900 3 12 9.7656 68906.2500 820.3125 12. 1700 9.7656 213906.2500 1445.3125 5 16 2000 0.7656 26406.2500 -142.1875 2700 6 14 1.2656 288906.2500 -604.6875 8.2656 7 18 2100 3906.2500 -179.6875 15 2000 0.0156 26406.2500 20.3125 Total 3037.5000 121 17300 44.8750 838750.0000 2162.500 Mean 15.125 SSX SSY SXY sample size n= here 2162.5000 15.1250 from above '(X-X)2 44,8750 '(X-X)(Y-= 3037.5000 Sxy/Spm slope= 67.688 SSE =Syy-(Sxy)/Sxx 6,33,147.6323 s2-sSE/(n-2) error Variance o= 105524.6054 se -Vs std error o 324.8455 s/VSponm estimated standard error of slope =se(B) 48,4925 for 95 % Cl value of t 2.4469 margin of error E=t"std error 118.657 lower confidence bound-estimated slope-margin of error -50.969 Upper confidence bound-estimated slope+margin of error= 186.345 st

LCL = -50.969 , UCL =186.345

( you can use excel also: with data: data analysis: regression: choose x and y column and run )