this question for a statistics class separate the answer individually

6:54 O 2:49:04 3. A researcher believes that an individual's sociability is directly tied to their happiness. More specifically, she believes that the more frequently you spend time with friends the greater your happiness will be. She wants you to analyze this relationship using the variable "SOCFREND". She would like to reduce the number of categories by recoding the variable. Recode this variable into a new variable using the RECODE resources on our canvas (video and recode written guide) into a variable that contains 3 categories: Combine the almost daily and once or twice a week category into a new category (label it frequently), combine several times a month and about once a month into a new category (label it frequently), and finally combine the final three categories (several time a year, about once a year, and never) into a new category (label it infrequently or never). This corresponds to High, Medium, and Low levels of sociability. Set the remaining categories to missing. Call this new variable REsocfrend. Be sure to add your value labels! Next, run a properly formatted crosstab with your new variable and the dependent variable "HAPPY" which measures respondents' level of happiness. a. Do the recode and upload an image of the frequency distribution of your new variable (included the labels!). Spend evening with friends * General happiness Crosstabulation Count General happiness very happy' pretty happy not too happy Total Spend evening with friends almost daily 16 28 51 once or twice a week 180 40 304 several times a month 200 428 about once a month 282 61 436 several times a year 84 468 about once a year 36 123 41 189 never 40 146 80 266 Total 481 1306 384 2151 Chi-Square Tests Asymptotic Significance (2 Value sided) Pearson Chi-Square 45.169" 12 <.001 likelihood ratio .001 linear-by-linear association n of valid cases a. cells have expected count less than the minimum is b. run crosstab and chi square in gss2024 put table into your document. c. describe interpret crosstab. d. researcher suggesting a positive or negative relationship between variables explain e. formally evaluate research hypothesis. f. write null hypothesis evaluate.>