Assignment
July 26/2021
No. of Questions
Total Marks
Note: Solve all questions using Excel functions
, Mark %
0
Assignment 2
July 26/2021
f Questions 4
35
using Excel functions and the Excel Data Analysis Pack.
, Q1 5 Marks
The table below indicate the norm for students grades in MGSC 301.
Grade Excellent Very Good Good Accepted Fail
Proportion of Students 0.4 0.3 0.15 0.1 0.05
Q1
The new cohort of 75 students in MGSC 301 indicated the following results:
Grade Excellent Very Good Good Accepted Fail
Number of Students 31 23 12 7 2
Using p = .05, does the actual rating of the new cohort deviate significantly
from the norm in MGSC 301?
July 26/2021
No. of Questions
Total Marks
Note: Solve all questions using Excel functions
, Mark %
0
Assignment 2
July 26/2021
f Questions 4
35
using Excel functions and the Excel Data Analysis Pack.
, Q1 5 Marks
The table below indicate the norm for students grades in MGSC 301.
Grade Excellent Very Good Good Accepted Fail
Proportion of Students 0.4 0.3 0.15 0.1 0.05
Q1
The new cohort of 75 students in MGSC 301 indicated the following results:
Grade Excellent Very Good Good Accepted Fail
Number of Students 31 23 12 7 2
Using p = .05, does the actual rating of the new cohort deviate significantly
from the norm in MGSC 301?
