Assignment-   Upload the Excel data file Dataset BUS 770a Business Research Methods xlsx in

 
Upload the Excel data file Dataset BUS 770a Business Research Methods xlsx in a quantitative research tool. The data file is located in GAP under Week Seven. Complete the following tasks and copy your results in a word document and submit your report. 
Create frequency table for the variable Distance From School
Use 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 command
Create 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.0755
Test 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.0755
Conduct 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.