Background A group of student researchers were assessing the relationships between several variables to respond to the hypotheses for their research project. The students collected the data from 200 participants using Google Forms and downloaded the file as an MS Excel comma-separated file. You are asked to help the students with the analysis by completing the activities below. 2. Provide your answers to the questions (interpretation included) in full-sentence format. Show how you arrived at this answer by pasting ONLY the relevant output table BELOW your answer for each question. Data Analysis Requirements 1. Upload the MS Excel CSV Data Analysis Assignment file to SPSS/PSPP. The file is located on Moodle in the Data Analysis Workshop files. You are required to paste the SPSS/PSPP Output file report for this requirement. (10 Marks) Use the following Data Description to complete the uploaded file. Data Description Var1Respondent's identification number (ID) Var2Location of residence (LOCATION) 1 Urban 2 Rural Var3Respondent's gender (GENDER) 1 Male 2 Female 9Prefer not to state. Var4How Happy do you feel today (FEELINGS) 1 Very Unhappy 2 Unhappy 3OK 4Happy 5Very Happy 6Prefer not to state. Var5Respondent's age (AGE) Var6Respondent's religious affiliation (RELIGION) 1Seventh Day Adventist 2Catholic 3Baptist 4Methodist 5 Other Var7 Respondent's mother's education - years of schooling (MAEDUC) Var8Respondent's highest level of education completed (EDUC) 1Grade school 2Some high school 3High school graduate 4Some College, but no degree 5Trade or technical school 6Associate degree 7Bachelors degree 8Post Graduate Degree 9None Var9Income of respondents (INCOME) 1Less than $10,000 2$10,000 to less than $20,000 3$20,000 to less than $30,000 4$30,000 to less than $40,000 5$40,000 to less than $50,000 6$50,000 to less than $60,000 7$60,000 to less than $70,000 8$70,000 to less than $80,000 9$80,000 to less than $100,000 10$100,000 or more 99Prefer not to state Var10 Respondent's ethnicity (ETHNIC) 1White 2Black /African-American 3Hispanic / Latino 4American Indian or Alaska Native 5Pacific Islander 6Asian 9Other Var11How knowledgeable are you about health issues (GenHealth) 1 Little or no knowledge 2 Knowledgeable 3 Very knowledgeable 9DK Var12How knowledgeable are you about smartphones (GenSmartPhone) 1 Little or no knowledge 2 Knowledgeable 3 Very knowledgeable 9DK Var13How knowledgeable are you about technology (GenTechnology) 1 Little or no knowledge 2 Knowledgeable 3 Very knowledgeable 9DK Var14How knowledgeable are you about the environment (GenEnvironment) 1 Little or no knowledge 2 Knowledgeable 3 Very knowledgeable 9DK Var15How knowledgeable are you about social media (GenSocialMedia) 1 Little or no knowledge 2 Knowledgeable 3 Very knowledgeable 9DK Var16How knowledgeable are you about Internet Banking (GenInternetBanking) 1 Little or no knowledge 2 Knowledgeable 3 Very knowledgeable 9DK 2. Data cleaning - all variables with the following values must be declared as missing: Other None DK Prefer not to state. After completing the data cleaning exercise, you are required to paste the SPSS/PSPP Variable View screenshot for this requirement. (12 Marks) 3. What are the religions with the highest and lowest frequencies? What per cent of the respondents are affiliated with these religious groups? What is the total percentage of respondents in both groups? Report and interpret your answer.(6 Marks) 4. What are the total and individual frequencies and percentages of respondents' education attained with the highest and lowest frequency? What is the total percentage of both categories? (6 Marks) 5. What is the mode, mean, minimum and maximum for the "AGE" variable? What percentage of the respondents are associated with the mode? (6 Marks) 6. If you ordered the ethnicities from highest to lowest frequencies. What are the two ethnicities with the middle frequencies? In responding to this question, provide the frequency and percentage for each group. (6 Marks) 7. What are the highest and lowest frequencies for the feelings' variable? In responding to this question, you are required to provide the frequencies and percentages and the total for the two groups. (5 Marks) 8. Recode MAEDUC into a new variable - MAEDUC_Levels using the ranges below. You are required to add the label and value labels for the new variable. Report the typical values for the variables "MAEDUC" and "MAEDUC_Levels". What are the percentages for each value? For the recode process copy and paste the Output file information displayed. (8 Marks) Value MAEDUC_Level Value Label 1 - 6 1 Primary 7 - 12 2 Secondary 13 - 19 3 Tertiary 9. Compute and report the Pearson correlation between the variables "GenSmartPhone" and "GenSocialMedia". In reporting your findings include the significance and the strength of the relationship as well as the output table.(8 Marks) 10. Is there a significant difference between income based on location? In responding to this question justify your answer and paste the T-test table as part of the report.(7 Marks) 11. Consider the following variables as items for a proposed "Gen_Knowledge_Index" : GenHealth GenSmartPhone GenTechnology GenEnvironment GenSocialMedia GeninternetBanking a) Compute the Cronbach's Alpha for the proposed 'Gen_Knowledge_Index" index. In answering this question, you must provide the tables associated with Cronbach Alpha. (3 Marks) b) Can the reliability of this index be improved? Justify your answer.(3 Marks) c) Using the results of questions 11a-b, create a "Gen_Knowledge_Index" index using the most appropriate variables. As verification paste the output report from this process.(3 Marks) Tip: Unless you had decided to remove 1 or more items to improve the Croncbach's Alpha, the index should be created with all 6 variables. The name of the newly created index is "Gen_Knowledge_Index." 12. Test the following hypotheses: a) H1: "There is a significant difference in "Gen_Knowledge_Index" based on gender. (Hint: Independent Samples T-test, "Gen_Knowledge_Index" by "Gender") (8 Marks) b) H2: There is a significant difference in "Gen_Knowledge_Index based on MAEDUC_Level (created at question 8 above)? (Hint: One way ANOVA, "IGen_Knowledge_Index" by "MAEDUC_Level")(9 Marks) You are required to provide the relevant tables and analyse your results for both (a) and (b) above.