AutoSave OM Simple Regression Grades and Hours (1) Brcel e Search File Home Insert Page Layout Formulas Data Review View Help R7 D E N G H K M Questions 1 Run a regression of grades using hours of studying as an independent variable. 2 What is the square? Explain the square for this regression 3 Interpret the meaning of the intercept and the coefficient the hours variable B student grade (y) hours (x) 2 1 86 3 3 2 95 6 4 3 92 4 5 4 83 4 0 5 78 3 6 79 2 B 7 70 1 9 93 5 10 9 72 3 11 10 83 3 12 11 71 2 13 12 95 6 14 13 78 4 15 14 72 2 15 85 4 17 16 78 1 18 17 76 2 18 19 85 3 20 19 92 5 20 74 2 22 21 99 6 Sheet 4 is the coefficient of studying statistically significant it -0.05? 5 Can you confirm this using the confidence interval? Type here to search O DELL FO FB F12 F11 F6 F4 FS F3 FO P F1 F2 ESC A * # $ % 5 & 7 0 6 9 8 2 3 AutoSave OM Simple Regression Grades and Hours (1) - Excel e Search ile Home Insert Page Layout Formulas Data Review Help 27 fo A B C D F G H 7 8 19 5 Can you confirm this using the 95% confidence interval? 20 21 22 85 78 76 85 92 74 99 72 83 70 95 23 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 5 2 6 3 3 2 6 4 2 4 1 24 6 What is the prediction equation? 25 26 27 7 Make a grade prediction for a student who studied for 4.2 hours. 28 29 78 70 88 78 76 86 30 31 3 32 33 35 37 Sheet I Type here to search DELL AutoSave OM Simple Regression Grades and Hours (1) Brcel e Search File Home Insert Page Layout Formulas Data Review View Help R7 D E N G H K M Questions 1 Run a regression of grades using hours of studying as an independent variable. 2 What is the square? Explain the square for this regression 3 Interpret the meaning of the intercept and the coefficient the hours variable B student grade (y) hours (x) 2 1 86 3 3 2 95 6 4 3 92 4 5 4 83 4 0 5 78 3 6 79 2 B 7 70 1 9 93 5 10 9 72 3 11 10 83 3 12 11 71 2 13 12 95 6 14 13 78 4 15 14 72 2 15 85 4 17 16 78 1 18 17 76 2 18 19 85 3 20 19 92 5 20 74 2 22 21 99 6 Sheet 4 is the coefficient of studying statistically significant it -0.05? 5 Can you confirm this using the confidence interval? Type here to search O DELL FO FB F12 F11 F6 F4 FS F3 FO P F1 F2 ESC A * # $ % 5 & 7 0 6 9 8 2 3 AutoSave OM Simple Regression Grades and Hours (1) - Excel e Search ile Home Insert Page Layout Formulas Data Review Help 27 fo A B C D F G H 7 8 19 5 Can you confirm this using the 95% confidence interval? 20 21 22 85 78 76 85 92 74 99 72 83 70 95 23 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 1 2 3 5 2 6 3 3 2 6 4 2 4 1 24 6 What is the prediction equation? 25 26 27 7 Make a grade prediction for a student who studied for 4.2 hours. 28 29 78 70 88 78 76 86 30 31 3 32 33 35 37 Sheet I Type here to search DELL