Create frequency table for the variable Distance From SchoolUse the Recode into Same Variables command to assign ascending numerical values to distances. (Note: highest numerical value should be assigned to Other OutofState)Create value labels corresponding to numerical values, change the Type of the variable to Numeric and change the Measure to Ordinal. Rerun the frequencies commandCreate standardized values for the HSGPA variable. Report key descriptive statistics for this variable. Make sure your report table includes measures of Kurtosis and Skewness. Create a histogram for HSGPA. Based on your visual inspection and measures of Kurtosis and Skewness, what is your conclusion regarding the shape of the distribution? Create a cross tabulation of Retained vs Received Financial Aid. Of the students who had received financial aid, what percentage were retained?Test the following hypothesis at 95% confidence level:H0: Overall GPA of students in the sample is equal to 3.0755 HA: Overall GPA of students in the sample is different than 3.0755Test the following hypothesis at 95% confidence level:H0: Overall GPA of students in the sample is greater than 3.0755 HA: Overall GPA of students in the sample is less than or equal to 3.0755Conduct a test on the number of Infirmary Visits using the following hypothesis:H0: The likelihood of infirmary visits is equal for students who visit the infirmary between one and six times. HA: The likelihood of infirmary visits is not equal for students who visit the infirmary between one and six times.

For multihospital systems, scenario analysis has both advantages and disadvantages.Assess whether the advantages or disadvantages are greater.Assess whether financial analysis should or shouldn’t play a dominant role in capital budgeting decisions.Provide reasons for and evidence in support of your responses.Comment on the postings of two of your classmates. Is your assessment the same or different? Why or why not?