Need help with the SPSS assignment, attached is what the assignment is about if you can help me I will send you the SPSS data. My email is
[email protected]Assignment SPSS Exam for MKT Spring Name: This assignment tests your ability to correctly identify and apply statistical techniques, describe, interpret, and communicate results, and make managerial recommendations. You will be graded on each of these concepts. Always create your own tables to present the results. Simple copying and pasting the SPSS tables will reduce your grade (you may copy/paste histograms from SPSS). First copying/pasting into Excel (or other) and then copying/pasting into your homework is the same thing as copying/pasting directly from SPSS. Be sure to create presentation quality tables from the raw data tables produced by SPSS. Presentation tables should NOT look like the SPSS data tables. Keep in mind that a table may not be necessary for every question. DO NOT USE SCREEN SHOTS!!!!! This also means you cannot use Paste Special Picture. Assume any data errors you discover are from double-entries which should be corrected to single-entries (e.g., 44 should be 4). Not finding and correcting these errors means your other answers will probably be wrong. Be sure to properly list results (e.g., sort means in descending order, etc.) rather than a random (i.e., lack of meaning) order. Download the SPSS file “Avery Fitness Center MR Fall 2021.sav” from Blackboard>Assignments. See the handout on Identifying and Correcting Errors on how to save your data file. Refer to the survey and codebook posted on Blackboard. The handouts, class notes, and textbooks are all that are required to complete this assignment. Unless specified otherwise, use an alpha of .05. Be sure to report all relevant values (e.g., chi-square, et cetera). Also use a 95% confidence level where appropriate unless told otherwise. The Guide to Using SPSS, the textbook, and the class handouts will help you use SPSS. When done, submit a single Word document with your “lastname SPSS” in the filename on Blackboard>Assignments>SPSS Homework Submission. Included MUST be the relevant SPSS raw data tables from the SPSS Output. See the directions at the end of this assignment on how to include the SPSS Output. NOTE: The results you get will be DIFFERENT from the exhibits in the handouts! Remember to use relevant data to thoroughly explain and analyze your answers. In addition to the correct answers, you will be graded on the clarity of communication including the appearance of exhibits (e.g. tables). Presenting SPSS data tables will lower your grade. The tables you submit should be created/modified in either Word or Excel (or similar). This is an INDIVIDUAL assignment. Sharing of answers, data, tables, analysis, et cetera is strictly prohibited. You cannot work together on the analysis of the data, creation of the tables, or any other component of this project. This includes using and/or reviewing work of others from previous semesters or other courses. If you do, then you are violating the Academic Integrity policy and subject to receiving a failing grade for the course. Your papers will be submitted through turnitin.com (via Blackboard) and checked for originality. Furthermore each file will be inspected for evidence of collaboration. Use of a “homework” site (e.g., homeworkmarket.com) is strictly prohibited. Working side-by-side or sharing of files is a violation of the academic integrity policy and all parties involved will be reported to the Associate Provost. DO NOT allow someone else to have access to your files. You will be held responsible if someone else uses your file/work even if they do not have your permission. Violating the Academic Integrity policy may result in failing the course. Remember to (points will be deducted if you do not remember): · Answer in complete sentences. · Report all relevant statistics including t, F, df and significance levels, et cetera. · Where appropriate, show and explain if the results are significant. Simply including/reporting a significance number is not adequate. · Provide complete and thorough interpretations of the individual variable and, where appropriate, in comparison to other variables (e.g., Importance variables). · Use tables and/or graphs, with accompanying commentary, where appropriate. Tables should have a consistent look-and-feel for all answers and be sorted in a meaningful order. · Means, Medians, Standard Deviations, F/t/significance values etc. should be rounded to two decimal places (the mean for Age can be rounded to no decimal places). · Not use screen shots/picture (including Paste Special Picture or drag/drop). The tables in Word must be editable. · Be consistent with decimal places, table headings, look-and-feel, et cetera · Insert your complete SPSS Output file in your Word document. · Rename the file “OUTPUT your lastname.doc” · Rename the SPSS data file “Corrected your lastname.sav” Part 1: Identify, correct, and present any mistakes in the data file. Once any errors are corrected, provide an overall profile of the data and of the respondents (e.g., sample size, gender, work status, etc.). This is more of an overall summary than the detailed analysis you will do below. You can reuse tables/charts from this section below if appropriate. Part 2: Management needs a better understanding of their members, with accompanying tables (or graphs if appropriate), and any relevant statistics and calculations. 1. Present and describe the Income levels of the AFC members including: a. What percentage of the respondents who answered the question make more than $120,000 per year? b. What percentage of the respondents who answered the question reported making over $60,000 per year? c. What percentage of the respondents who answered the question reported making $30,000 or less per year? d. What percentage of the survey respondents reported making between $45,001 and $60,000 per year? 2. The average Age and distribution of the ages of the respondents compared to a normal distribution of the data. a. Are there any respondents outside of this distribution? If so, how many and how did you determine this? b. Should these members be ignored or included for further analyses? 3. Profile the Gender of the members. a. How confident are you that the gender responses reflect the overall population of their members? How did you determine this? Be sure to show the needed statistics for both genders. 4. Which was the most successful way to promote to potential members? 5. Looking at the four importance variables (General Health/Fitness, Social Aspects, Physical Enjoyment, and Specific Medical Concerns) for the overall sample, provide the percentages and counts for each category variables, the top two boxes for each of these variables, the mean, median, and standard deviation for each variable and the variable’s sampling error in a single table. a. Describe the distribution of data for each variable. b. Test to see if these four Importance variables are significantly different from each other. c. Sort and rank these variables in the table from the most important to the least important. 6. How many respondents have visited within the last 30 days? How does their average attendance level mathematically compare to the average attendance level of the overall sample? 7. Managers want to know if the average number of monthly visits (i.e., the variable Visits) is significantly different from the national average of eight. Interpret and explain your relevant results. 8. Is there a significant relationship between when people use the Therapy Pool and if they were Recommended by the Doctor. Specifically, a. What percentage of the total sample utilized the therapy pool? b. What percentage of those who used the therapy pool were recommended by a doctor? c. What percentage of those recommended by a doctor utilized the therapy pool? d. How strongly, if at all, are these variables associated with each other? 9. Is there a difference between the number of Visits and whether people had Utilized the Exercise Circuit. Explain, and show, if the means are significantly different from each other. 10. Is there a difference in the importance variables between those who work and those that are retired? Explain, and show, if the means are significantly different from each other. 11. Create a single table and show and explain the correlations between the four Importance variables (General Fitness; Social Aspects; Physical Enjoyment; Specific Medical Concerns) and Age. Be sure to show their respective means and standard deviations in the same table. 12. Management wants to know if the variables that measure Importance (from above), Likely to Recommend, and the Number of Visits predict Revenue. Be sure to address if the model is significant or not by reporting and interpreting relevant values. If the model is significant then: a. How much variation in the dependent variable can be explained by the independent variables? b. Are there any specific variables that stand out? How do they influence Revenue? c. Are these results and your interpretation the same if the alpha is changed to .10? 13. Based on your analysis of ALL the data in this assignment and the dataset, present your clear managerial recommendations. 14. Data File Insert the Output file containing your raw data tables into the end of your file. The instructions below show you how to do this. Simply copying/pasting is not sufficient – you must follow the instructions provided. See the file posted on Blackboard on how to Upload a SPSS data file (.sav) to SPSS Exporting SPSS Output (raw data tables) from SPSS: 1. Right-click on the word Output in Output screen and choose Export. 2. Select All Objects to Export 3. Be sure that the Document Type of file is Word/RTF.doc 4. Change the name of the file to “OUTPUT your lastname.doc” 5. Press Ok (be sure to remember where the file is being saved). 6. In your Word document move your cursor to the end of the document. These instructions may be different depending on the version of Word you use. a. Choose Menu Insert File and select the OUTPUT your lastname.doc file with your data; or b. Choose Menu Insert Object File and select the OUTPUT your lastname.doc file with your data. Right 1