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.
