Question

On Moodle, you will find a file “Data for Q2 Ass3” which has data on grades in past sections of this course. The variables are Assignment1 = Grade on Assignment 1 as a percentage Assignment2 = Grade on Assignment 2 as a percentage Assignment3 = Grade on Assignment 3 as a percentage Midterm = Midterm Grade as a percentage Project = Project Grade as a percentage Participation = Participation Grade as a number out of 5. AssignmentDum = A dummy variable equal to 1 for a given format for assignments and zero otherwise. F.Exam = Final Examination Grade out of 100. Use Excel to answer the following questions. Don’t forget to both attach computer output and provide a written answer. F.Exam should be your dependent variable.

(a) What is the estimated regression equation for the most general model for F.Exam?

(b) Test the overall significance of the model.

(c) Use the t-test to determine the significance of each independent variable. What is your conclusion at the 0.05 level of significance?

Ass1	Ass2	Ass3	Midterm	Project	Participation/5	AssDum	F.Exam
76	80	42.5	44.5	58	5	1	52.5
87	100	43	43	60	5	1	42
76	100	37	68.5	75	6	1	28
72	100	63	51	87	5	1	57
0.00	100	96	39	66	5	1	54
100	100	68.5	12	92	5	1	40
96	80	79	81.5	80	0	1	71.5
97	100	83	79.5	72	0	1	52.5
96	100	83	83	78	5	1	59
86	100	92	89.5	88	5	1	72
80.5	90	51	41.5	55	5	1	39
56	100	31	90	68	5	1	63
81	95	41.5	38	72	5	1	44
94	100	64.5	84	90	5	1	74

I really need to understand how to do this is excel please, if possible, take pictures of the steps you must do to solve this in Excel, I will rate immediately. Many thanks.

Answer 1

AFter entering the data in Excel we can perform the regression analysis from data tab as shown below:

AS we can see that output of regression output in Excel

here we can see that all values in variable AssDum are 1 so it is not considerd by Excel

A)

SO the estimated regression equation is:

B)

To test the overall significance of the model we can see that p value given in ANOVA table by the name of Significance F = 0.20744 > which implies that we do not have enough evidence to reject H0

i.e., Model is not significant.

C)

As we can see that p value corresponding to only Midterm varibable is significant at

All others variables have p value >

which also indicates that they are not statistically significant.

please hit the like button if you liked the solution.