Stat2040Final_Joseph_Angulo.xlsx - STAT 2040 Section 2 –...

This preview shows page 1 - 3 out of 16 pages.

STAT 2040 Section 2 – Spring 2021 Name: Joseph Angulo Final Exam (Learning Sections 1, 2, 3, 4, 5, 6, 7) Final Exam but others may need more work. · You will have 2 1/2 hours to complete this exam · This exam is closed book, individual effort. · You may use a pre-prepared review document containing equations, variable descrip This document can be up to two pages, two-sided (8 ½ x 11 inches) original and hand-writt · Show all your work. I shall check the cell content to look for appropriate Excel comm · If the provided space is not enough, you can insert more rows. Some of the questions Once completed you will upload the file. Make sure that you change the name Answer all questions and show your work. Points for each question is listed at the beginning of th exam is on a total of 88 points. Without the related work and explanation, you may not earn any answers. 1. (6 points) Nine pairs of data yield r = 0.867 and the regression equation is y = 19.4 + 0.93x. Also, y the best predicted value of y for x = 57?
Age Weight 39 140 2 72 27 129 6 88 41 137 4 63 48 125 9 84 56 162 0 47 59 152 3 52 22 118 11 90 64 142 3 31 35 126 4 64 2. (6 points) A fitness rating was obtained for 9 randomly selected adult women. Each person was also weight, and the number of hours she spent exercising each week. The results are shown below. Exercise Hrs./Wk Fitness rating Identify the multiple regression equation that predicts fitness in terms of age and hours of exercise pe
SUMMARY OUTPUT Regression Statistics 93.20 - 0.862A + 2.19H Multiple R 0.913006 R Square 0.833579 Adjusted R 0.733727 Standard E 10.34289 Observatio 9 ANOVA df SS MS F ignificance F Regression 3 2679.123 893.0411 8.348103 0.021601 Residual 5 534.8767 106.9753 Total 8 3214 Coefficients tandard Erro t Stat P-value Lower 95%Upper 95% Intercept 36.06705 85.1502 0.42357 0.689483 -182.8185 254.9526 Age -1.022846 0.385895 -2.650583 0.045395 -2.01482 -0.030872 Weight 0.428653 0.623931 0.68702 0.52263 -1.175213 2.032519 Exercise Hr 3.301363 2.080407 1.586883 0.1734 -2.046494 8.64922 x y 62 158 53 176 64 151 -0.774939 52 164 52 164 54 174 58 162 SUMMARY OUTPUT x y 3 4 Regression Statistics 2 1 Multiple R 1 5 10 R Square 1 8 19 Adjusted R 1 3. (6 points)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture