Task 2 The data set for assignment is in the excel folder assignment. Required: Activity 01: Enter all data from the spreadsheet “Data for Assignment “into Excel. You will need to set up the variable...

Task 2

The data set for assignment is in the excel folder assignment.

Required:

Activity 01:

Enter all data from the spreadsheet “Data for Assignment “into Excel. You will need to set up the variable view with the following 11 variables and then enter the data in excel:



a)    Student_ID,
b)    Year_Enrolled,

c)    HI001_Final_Exam,

d)    HI001_Assignment_01,

e)    HI001_Assignment_02,

f)    HI002_Final_Exam,

g)    HI002_Assignment_01,

h)    HI002_Assignment_02,

i)    HI003_Final_Exam,

j)    HI003_Assignment_01,

k)    HI003_Assignment_02.



Activity 02:

a)    Draw a histogram for each one of the 11 variables?


b)    Do descriptive statistics (mean, standard deviation, minimum, maximum) for each one of the 11 variables.