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 . 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?
