Gym membership gender analysis

Instructions REMEMBER: You will be submitting 2 files – an Excel file with your work AND a Word file with your report. You will receive a zero (0) for the assignment if you don’t submit both parts! Your report should contain the Excel tables, graphics, and statistics you are asked to create by using copy/paste functionality from Excel to Word. You can also use “snipping tool” as an alternative for copying from Excel to Word. Use the Excel file M06 Business Application – AJ FitnessDownload M06 Business Application – AJ Fitness Part 1 The owner of AJ Fitness center is interested in whether men or women visit the gym more regularly and by how much. Sample data are in the Excel file linked above. Use the steps below to find the answer. Use a pivot table to find the distribution of typical visits per week grouping by 1 visit. Use the pivot table to create a histogram. Does the data appear to be normally distributed? Report the average value of typical visits per week by gender. Answer the question: Which gender visits the gym more per week? By how much? Report the standard deviation and sample size of typical visits per week by gender. Calculate a 95% confidence interval for the difference in typical visits per week for men and women. Assume equal variances. Interpret you confidence interval. Using your confidence interval results, how would you answer the question, “Is there a significant difference in the number of typical visits per week for male and female members with the club?” Show work either using Excel commands or using the Excel CALCULATOR Part 2 The owner also wishes to see if there is a significant difference in the average age of men and women who attend the gym. Here are the steps to test whether there is a significant difference. Report the average value of age by Answer the question: Which gender is older on average? By how much? Report the standard deviation and sample size of age by Test whether there is a significant difference in the average age of men and women who attend the gym. Assume data is normally distributed with equal variances. Use alpha = 0.10 level of significance and assume equal variances. State the hypotheses Give the test statistic and p-value State your conclusion Show work either using Excel commands or using the Excel CALCULATOR Part 3 The owner of AJ Fitness also want to answer the question: Do men or women tend to stay with the club for more years? Follow these steps to answer that question. Use a pivot table to count the number of members with 0-5 and 5-10 years with the club by gender. You will need to group the years with the club in your pivot table. Using your counts, find the proportion of men who have been with the club 5 or more years and find the proportion of women who have been with the club 5 or more years. Test whether there is any difference between the proportion of men with 5 or more years and the proportion of women with 5 or more years using alpha is 0.05 level of significance. State the hypotheses Give the test statistic and p-value State your conclusion Show work either using Excel commands or using the Excel CALCULATOR Submit a Word document of your written report. Use complete sentences and thoughts. Consider writing a paragraph for each part of this assignment. Report in your Word document all your findings using the calculations, tables, and graphics from Excel. You can copy and paste from Excel into Word. Create a report worthy of submission to management. Submit your Excel file demonstrating your work using the appropriate Excel commands or Excel Calculators for full credit.