Excel — must use Data Analysis tool pak (do not take question if you do not)
Must follow instructions. use only what is given … ill send link to textbook… use only one excel sheet
Once information is received from respondents, the marketing researcher has to interpret it. This data analysis assignment asks you to interpret information from our textbook as practice before interpreting it for your group’s final report. There are 5 attachments included. To access them, click on the ‘Data Analysis Assignment 1’ title.
Your assignment this week is to use the Avery Fitness Center Data Excel file to recreate the Appendix D Tables. So, before you begin, you have all the answers. You do not need to format fancy tables, I just want you to show counts, percentages, means, standard deviations, sample size etc. Whatever statistic is reported in the table, your Excel file should have that included. Please keep your Excel file as clean as you can. I would prefer you organize each sheet by question when possible.
To help you do this analysis, I have included Appendix A Member Survey, Appendix B Membership Application, and Appendix C Codebook. These will help you understand the information in the data file. The data has been coded and in order to know what each number corresponds to, you will need to use the codebook.
In addition, if you do not have Excel or the Data Analysis tool pak, now would be a good time to download them. Links to both are in Week 1 content. To access the Data Analysis add-in in Excel click on the Data tab and at the far right is the add-in.
Please submit one Excel file to the dropbox. This assignment is worth up to 100 points.