Question

Student stress at final exam time comes partly from the uncertainty of grades and the consequences of those grades. Can knowledge of a midterm grade be used to predict a final exam grade? A random sample of 200 BCOM students from recent years was taken and their percentage grades on assignments, midterm exam, and final exam were recorded. Let’s examine the ability of midterm and assignment grades to predict final exam grades.

The data are shown here:

Assignment	Midterm	FinalExam
92	87	88
90	55	67
92	82	81
95	66	57
91	44	43
95	72	65
84	85	75
84	87	82
29	77	65
12	41	42
92	83	79
94	81	76
48	50	37
78	84	86
88	89	85
96	73	54
92	81	76
93	81	84
67	55	62
84	59	61
90	90	84
90	62	52
72	75	65
92	59	68
95	84	88
94	85	68
90	86	82
84	81	83
91	72	76
87	68	70
96	82	79
91	54	45
84	87	85
44	61	55
93	59	41
71	77	48
89	75	65
21	70	63
68	86	65
53	81	70
69	66	36
92	84	81
66	70	40
70	82	89
81	58	60
92	74	87
63	50	55
90	84	70
89	78	79
83	68	62
87	85	81
53	52	59
90	60	57
88	82	83
85	94	76
43	55	54
68	52	52
89	74	62
85	75	63
93	94	88
91	84	85
82	73	63
74	68	48
87	85	78
92	82	79
96	75	75
44	71	53
82	78	70
93	81	76
90	94	95
87	86	66
89	91	73
68	61	45
85	73	72
84	82	84
41	47	47
79	61	39
87	83	85
97	83	89
89	89	86
84	89	69
56	66	54
81	70	75
30	53	69
51	70	67
79	62	47
31	63	40
83	83	88
91	77	69
88	92	95
78	82	78
96	89	96
45	73	63
90	89	72
73	65	71
81	80	80
86	81	82
89	68	54
64	73	62
87	69	77
65	68	64
95	95	85
98	79	65
85	68	71
86	91	91
91	76	61
76	62	58
69	89	79
83	79	68
93	77	75
88	86	93
42	72	53
93	81	90
58	76	56
87	82	78
72	63	61
71	78	40
81	91	81
81	77	57
28	43	54
91	96	90
66	57	55
74	50	37
86	75	72
87	66	63
62	62	54
93	81	53
96	87	90
86	89	84
85	86	84
82	69	70
92	71	63
83	63	42
81	88	60
8	78	69
91	85	71
89	84	72
43	83	74
97	77	75
79	78	70
91	75	81
73	67	64
82	75	77
69	64	49
35	74	54
92	81	82
87	80	91
93	75	74
95	96	94
86	60	30
88	84	76
67	40	41
70	49	67
79	86	73
87	83	78
82	80	82
77	84	86
53	88	83
86	72	76
65	93	76
68	79	67
96	81	78
85	79	80
92	73	71
90	90	89
81	53	61
89	71	51
85	88	70
82	67	52
78	88	73
83	75	73
88	83	80
60	75	74
88	64	54
96	80	75
69	58	64
95	66	64
78	44	51
89	61	60
85	80	76
80	70	73
79	91	90
82	63	54
92	79	84
76	59	66
86	64	66
86	85	82
74	70	58
71	78	64
87	78	66
87	76	77
90	78	82
41	66	71
90	72	74
90	88	84
35	60	57
92	69	59
92	89	81
11	59	39
94	94	91

Fit a regression model to predict FinalExam from Assignment and Midterm. What is the value of R-squared? Report your answer as a proportion to four decimal places. Do NOT report it as a percentage.) Question 28 1 pts Continue with "Exam Grades" Test the hypothesis that the coefficients for Assignment and Midterm are both zero. Use a 5% significance level. Report your answers here and in the following two questions. Degrees of freedom: and Question 29 2 pts Continue with "Exam Grades" Test statistic: F-stat- (Report the test statistic to two decimal places.) Question 30 1 pts Continue with "Exam Grades" P-value (Report your answer to four decimal places. Type 0.0001 if the P-value is less than this amount.) Question 31 2 pts Continue with "Exam Grades" Complete the following one-sentence conclusion for the previous test I Select ] do do not We conclude that Assignment and Midter contain information that can be used to predict FinalExam Question 32 1 pts Continue with "Exam Grades" Use the multiple regression output (not a separate simple regression analysis!) to test the hypothesis that the coefficient for Assignment is zero. Use a 5% significance level. Test statistic: t-stat- Report the test statistic to two decimal places.) Question 33 1 pts Continue with "Exam Grades" For the t-stat you computed in the previous questions, the degrees of freedom Question 34 1 pts Continue with "Exam Grades" For the t-stat you computed in Question 32, the P-value Report the P-value to four decimal places.) Question 35 2 pts Continue with "Exam Grades" Complete the following one-sentence conclusion for the previous test There is Select ] evidence that the coefficient of Assignment Select I significantly different from zero. Question 35 2 pts Continue with "Exam Grades" Complete the following one-sentence conclusion for the previous test. [ Select] no There evidence that the coefficient of Assignment [Select ] nifid weak moderate strong is is not Question 35 2 pts Continue with "Exam Grades" Complete the following one-sentence conclusion for the previous test. There is [Select ] evidence that the coefficient of Assignme I Select ] no weak moderate strong iS is not significantly different from zero. Question 36 4 pts Continue with "Exam Grades" Create a plot of the distribution of the residuals. Also plot the residuals versus each of the explanatory variables. Then answer the following True/False questions: A histogram of residuals is reasonably close to Normal. Both residual plots look good with basically horizontal bands around the x-axis. Only one of the residual plots looks good. Neither residual plot suggests any issues with the equal spread condition. [ Select ] [ Select ] [ Select ] [Select ] Question 37 2 pts Continue with Exam Grades: Give an approximate 95% prediction interval for the final exam grade for a student whose assignment grade is 90% and whose midterm grade is 85%. Note: The same formula for an approximate 95% prediction interval in simple regression works also for multiple regression. For the approximate 95% prediction interval: Point estimate = Carry all precision in Excel and then round your answer to one decimal place) Question 38 2 pts Continue with "Exam Grades" For the approximate 95% prediction interval: Margin of error Carry all precision in Excel and then round your answer to one decimal place.) Question 39 2 pts Continue with "Exam Grades" If you did a simple linear regression using Midterm as the single predictor, the coefficient for Midterm and the results of a significance test for this coefficient Select ] two explanatory variables: Midterm and Assignment) because the two predictor variables are [Select ] with each other. (Note: You don't need to do the simple linear regression!) differ from what was found with the previous model (with Question 39 2 pts Continue with "Exam Grades" If you did a simple linear regression using Midterm as the single predictor, the coefficient for Midterm and the results ofa significance test for this coefficie two explanatory variables: Midter with each other. (Note: You don't I Select ] would would not not correlated correlated differ from what was found with the previous model (with wo predictor variables are Select l gression!) Question 39 2 pts Continue with "Exam Grades" If you did a simple linear regression using Midterm as the single predictor, the coefficient for Midterm and the results of a significance test for this coefficient [Select] two explanatory variables: Midterm and Assignment) because the two predictor variables a with each other. (Note: You don't need to do the simple linear regression!) differ from what was found with the previous model (with Select ] does does not not correlated correlated

Answer 1

Solution:

install analysis tool pak in excel

go to data >data analysis regression

select the data

Slalıstics and Probability questi × 。 (36) GAYA TRI MAN IRA Mednir × M inbUx(44,099) shiree hb k@g eyg India-Expert Login Book2 Excel Home Insert Page Layout Formulas Data Review View Tell me what you want to do. Adabala Naveenkumarvenkat C1 Sensitivity Not set Regression 1 Assignmer Midterm FinalExa 92 87 Scs1sc$201 SAS1$B$201 Constant is Zero Input Y Range: 67 Input XRange: 92 95 91 95 81 431 Confdence Level: Output optioris 87 Cutput Hanger New Worksheet Ply Now Workhook 41 92 81 76 37 Residuals Standardized Residuals Residual Plots ine Fit Plots Normal Probability 73 81 811 Normal Probability Plots 92 93 67 2 23 52 Sheet2Sheet G 3:38 PM 4/7/2019 Type here to search

click on ok

Yu will get

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.767005365
R Square	0.58829723
Adjusted R Square	0.584117506
Standard Error	9.317061425
Observations	200
ANOVA
	df	SS	MS	F	Significance F
Regression	2	24436.39618	12218.19809	140.7503	1.08769E-38
Residual	197	17101.10382	86.8076336
Total	199	41537.5
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	-0.791240512	4.262420844	-0.18563172	0.852925	-9.197071291	click on oj
Assignment	0.114220349	0.040101142	2.848306624	0.004862	0.035137727	0.193303
Midterm	0.816135191	0.058887499	13.8592266	6.19E-31	0.700004389	0.932266

ANSWERS ARE:

solution27:

r sq=0.5883

Solution28:

Degrees of freedom 2 and 197

Solution29:

F stat=140.75

Solution30:

p=0.0000

Solution31:

we can use regression eq to predict final exam

DO CONTAIN INFORMATION to predict final exam