Students in a management science class have just received th

Students in a management science class have just received their grades on the first test. The instructor has provided information about the first test grades in some previous classes as well as the final average for the same students. Some of these grades have been sampled and are as follows:

STUDENT 1 2 3 4 5 6 7 8 9

1st test grade 98 77 88 80 96 61 66 95 69

Final average 93 78 84 73 84 64 64 95 76

D) Conduct F-test for the above model using F-table (in the lecture note) as well as p-value (in the ANOVA table) and interpret the results (Basically, you are asked to conduct F test in two different ways.) PLEASE USE EXCEL, NOT MINITAB I DO NOT HAVETHAT SOFTWARE AND I AM REQUIRED TO USE EXCEL. Also please have step by step instructions for the graphs so I can fully understand how to make these graphs

E) Conduct t-test for 1st test grad using t-table (in the lecture note) as well as p-value (in the EXCEL output) and interpret the results (Basically, you are asked to conduct a t test in two different ways). PLEASE USE EXCEL, NOT MINITAB I DO NOT HAVETHAT SOFTWARE AND I AM REQUIRED TO USE EXCEL. Also please have step by step instructions for the graphs so I can fully understand how to make these graphs

Solution