You can use Excel or SPSS to complete this assignment.The data file is located in GAP under Week Ten.
Complete the following tasks and copy your results in a word document and submit your report.
1) Create standardized values for the Overall GPA variable. Report key descriptive statistics for this variable (i.e., standardized Overall GPA).
2) Create a histogram of Standardized Overall GPA. Based on your visual inspection and measures of Kurtosis and Skewness, what is your conclusion regarding the shape of the distribution? Does it resemble a normal distribution? Explain.
3) Create a cross tabulation of Retained vs College_A. How many students in College of Education were retained? What percentage of all retained students were from College of Education?
4) Create a cross tabulation of Retained vs Received Financial Aid. Of the students who had received financial aid, what percentage were retained? Conduct the Goodness of Fit test and calculate the chi-square value. Write the null and alternative hypotheses. What is your conclusion?