Homework2

.xlsx
School
University of Central Arkansas **We aren't endorsed by this school
Course
MATH 4362
Subject
Statistics
Date
Aug 26, 2023
Pages
4
Uploaded by gnelouatt23 on coursehero.com
OBS x y x-xbar y-ybar (x-xbar)^2 (y-ybar)^2 (x-xbar)(y- 1 15.5 2,158 2.16 26 5 678.6 56.13775 2 23.8 1,678 10.46 -454 109 206,070.6 -4746.047 3 8.0 2,316 -5.35 184 29 33,874.4 -983.7473 4 17.0 2,061 3.66 -71 13 5,033.9 -259.3223 5 5.0 2,207 -8.35 75 70 5,632.5 -626.2923 6 19.0 1,708 5.66 -424 32 179,733.6 -2397.437 7 24.0 1,784 10.66 -348 114 121,069.2 -3707.407 8 2.5 2,575 -10.85 443 118 196,293.3 -4804.877 9 7.5 2,357 -5.85 225 34 50,647.5 -1315.417 10 11.0 2,277 -2.35 145 5 21,039.5 -340.1423 11 13.0 2,165 -0.35 33 0 1,092.3 -11.40225 12 3.8 2,399 -9.55 267 91 71,315.7 -2548.992 13 25.0 1,779 11.66 -353 136 124,573.7 -4113.632 14 9.8 2,336 -3.55 204 13 41,636.4 -723.3573 15 22.0 1,765 8.66 -367 75 134,652.3 -3175.952 16 18.0 2,053 4.66 -79 22 6,233.1 -367.5122 17 6.0 2,414 -7.35 282 54 79,552.2 -2071.657 18 12.5 2,200 -0.85 68 1 4,630.8 -57.50225 19 2.0 2,654 -11.35 522 129 272,536.2 -5922.657 20 21.5 1,753 8.16 -379 67 143,603.1 -3090.337 Sum 267 42,639 0.00 0 1114 1,699,899.0 -41207.56 Sxx Syy Sxy Mean 13.345 2,132 (xbar) (ybar) SUMMARY OUTPUT Regression Statistics Multiple R 0.946775 R Square 0.896383 Adjusted R 0.890626 Standard E 98.92156 Observatio 20 ANOVA df SS MS F Significance F Regression 1 1523760 1523760.3989 155.7165 2.681831861836E-10 Residual 18 176138.6 9785.4750597 Total 19 1699899
Coefficients tandard Erro t Stat P-value Lower 95% Upper 95% Lower 95.0% Intercept 2625.417 45.31089 57.942302596 6.486E-22 2530.22269035533 2720.6119881839 2530.223 x -36.97769 2.963278 -12.478643685 2.682E-10 -43.2033118084233 -30.752078115836 -43.20331
yhat (y-ybar)^2 ybar (yhat-ybar (y-yhat)^2 2,052 679 2,132 6,400 11,236 1,745 206,116 2,132 149,769 4,489 2,330 33,856 2,132 39,204 196 1,997 5,041 2,132 18,225 4,096 2,441 5,625 2,132 95,481 54,756 1,923 179,776 2,132 43,681 46,225 1,738 121,104 2,132 155,236 2,116 2,533 196,249 2,132 160,801 1,764 2,348 50,625 2,132 46,656 81 2,219 21,025 2,132 7,569 3,364 2,145 1,089 2,132 169 400 2,485 71,289 2,132 124,609 7,396 1,701 124,609 2,132 185,761 6,084 2,263 41,616 2,132 17,161 5,329 1,812 134,689 2,132 102,400 2,209 1,960 6,241 2,132 29,584 8,649 2,404 79,524 2,132 73,984 100 2,163 4,624 2,132 961 1,369 2,551 272,484 2,132 175,561 10,609 1,830 143,641 2,132 91,204 5,929 42,639 1,699,902 2,132 1,524,416 176,397 SST SSR SSE 0.0 5.0 10.0 15.0 20.0 25.0 30.0 0 500 1,000 1,500 2,000 2,500 3,000 f(x) = − 36.9776949621295 x + 2625.41733926962 R² = 0.89638292848241 Chart Title X Y
Page1of 4
Uploaded by gnelouatt23 on coursehero.com