Medical amount spent for alcohol cost weight Age 2100 200 185 50 2378 250 200 42 1657 100 175 37 2584 200 225 54 2658 250 220 32 Which of the following factors has a significant effect on medical...


Please help me to derive the
REGRESSION EQUATION
as the medical cost being the Y value and weight as the X value. I provided the excel file i just don't know where to get it


Medical<br>amount spent<br>for alcohol<br>cost<br>weight<br>Age<br>2100<br>200<br>185<br>50<br>2378<br>250<br>200<br>42<br>1657<br>100<br>175<br>37<br>2584<br>200<br>225<br>54<br>2658<br>250<br>220<br>32<br>Which of the following factors has a significant<br>effect on medical expenses? Create the regression<br>equation for the problem.<br>

Extracted text: Medical amount spent for alcohol cost weight Age 2100 200 185 50 2378 250 200 42 1657 100 175 37 2584 200 225 54 2658 250 220 32 Which of the following factors has a significant effect on medical expenses? Create the regression equation for the problem.
SUMMARY OUTPUT<br>Regression Statistics<br>Multiple R 0.948553<br>R Square 0.899753<br>Adjusted R 0.866337<br>Standard E 149.1055<br>Chart Area<br>Observatic<br>ANOVA<br>df<br>S<br>MS<br>ignificance F<br>Regressior<br>1 598629.8 598629.8 26.92594 0.013899<br>Residual<br>3 66697.38 22232.46<br>Total<br>4 665327.2<br>Coefficientsandard Erre<br>t Stat<br>P-value Lower 95%Upper 95%ower 95.0%pper 95.0%<br>Intercept -1320.89 696.2576 -1.89713 0.154068 -3536.69 894.9147 -3536.69 894.9147<br>Weight<br>17.89198 3.448045 5.189021 0.013899<br>6.91876<br>28.8652<br>6.91876<br>28.8652<br>

Extracted text: SUMMARY OUTPUT Regression Statistics Multiple R 0.948553 R Square 0.899753 Adjusted R 0.866337 Standard E 149.1055 Chart Area Observatic ANOVA df S MS ignificance F Regressior 1 598629.8 598629.8 26.92594 0.013899 Residual 3 66697.38 22232.46 Total 4 665327.2 Coefficientsandard Erre t Stat P-value Lower 95%Upper 95%ower 95.0%pper 95.0% Intercept -1320.89 696.2576 -1.89713 0.154068 -3536.69 894.9147 -3536.69 894.9147 Weight 17.89198 3.448045 5.189021 0.013899 6.91876 28.8652 6.91876 28.8652

Jun 07, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here