For the questions below, use the most efficient Excel formula or procedure to find your answer. Calculations by hand (or calculator) should only be used to check your answers. Show relevant Excel output and/or formulas and results. For this assignment you will be using the BUS 306 Survey Data.xlsx file from BlackBoard. Immediately save this file to your H: drive or memory stick. For purposes of this assignment consider these to be sample data.
Please complete the following tasks:
⦁ Is there a significant difference between variances of gender and hours per week spent being physical active? [Hint: remove any blanks from each column, remembering to sort the columns together.] Use an F test (on pages A-2 and A-3 of your Class Notes book). (You are advised NOT to use the Two-sample F-test in the Analysis Toolpak. Do the problem using simple formulas and functions.) Use an alpha of 10%. Show your hypotheses, calculation of F* using Excel, and either the critical F value(s) or p-value, calculated by Excel, and decision. Describe the difference if one exists. 
⦁ In this task you will use ANOVA to analyze the relationship between the major that the student is in (or planning to go into) and “How many hours of out-of-class study PER WEEK, FOR A FIVE COURSE WORKLOAD, do you think should be expected of you?” Eliminate any blanks from both variables. Also, we will only keep the top three majors (the ones with the highest counts). Eliminate the other majors. Use ANOVA – single factor in Excel’s Data Analysis ToolPak to test whether there is a relationship between the two variables. Use an alpha of 10% Show your hypotheses, ANOVA output, and decision – referring to numbers in the ANOVA output. If there is a relationship, describe it in non-statistical language, with a visual analysis of the means. Then, use Excel to create formulas for a Multiple Means (Fishers) comparison for the two means that differ the most. Show the Excel formulas that are used to do the comparison, using constants (rather than cell references) from the ANOVA output as well as the Excel T... function. (Do not use the output from the ANOVA Template.xlsx file.) How does the Fishers test support your conclusion? (Note: Consider the categories of the three majors to be your treatments.) 
Get Free Quote!
296 Experts Online