You can use Excel or SPSS to complete this assignment. Use the Excel data file Dataset_BUS_770.xlsx.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). Make sure your report table includes measures of Kurtosis and Skewness.
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 crosstabulation 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 crosstabulation 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?
