I would like to book a session this evening for an hour to help me navigate a really difficult data analysis assignment in my social work course that involves the use of Excel.

I would like to book a session this evening for an hour to help me navigate a really difficult data analysis assignment in my social work course that involves the use of Excel.


Data Analysis Assignment Using the Data Analysis Homework dataset, complete the following activities. Use this form to respond to each item. When you upload your assignment, include this document and your completed Excel workbook. ************************************************** Frequencies & Central Tendency 1. Which scale are you using? Depression 2. Using scale, divide the total scores into groupings a. What are your groupings and why do they make sense for this scale? b. Calculate a grouped frequency distribution. Create an APA style table and insert it to illustrate your grouped frequency distribution. (see module for example) 3. Using the ungrouped total scores, run measures of central tendency: a. Mean = b. Median = c. Mode = d. Standard Deviation = e. Minimum = f. Maximum = 4. Write an interpretive paragraph for the frequency distribution and central tendency results. What do these results tell us? **************************************************** Crosstabs 1. Choose two variables appropriate for a crosstabs (refer to the notes to see what type of variables are appropriate for this test) a. Which two variables did you select? i. Variable 1: ii. Variable 2: b. Why are these two variables appropriate for this test? 2. Create and insert an APA style table to illustrate your crosstabs results. (see module for example) 3. Conduct a subgroup and comparison analysis of the results. What do these results tell us? **************************************************** Chi-Square 1. Pick two variables that are appropriate for a chi-square analysis (refer to the notes to see what types of variables are appropriate for this test, along with the rules that apply to the test) a. Which variables did you select? i. Variable 1: ii. Variable 2: b. Why are these two variables appropriate for this test? 2. State your research and null hypotheses: a. Research hypothesis: b. Null hypothesis: 4. Create and insert an APA style table to illustrate your crosstabs results. (see module for example) 3. Write an APA style interpretation of your results. What do these results tell us? **************************************************** Independent t-Test 1. Pick two variables appropriate for an independent t-test (refer to the notes to see what types of variables are appropriate for this test) a. Which variables did you select? i. Variable 1: ii. Variable 2: b. Why are these two variables appropriate for this test? 2. State your research and null hypotheses: a. Research hypothesis: b. Null hypothesis: 5. Create and insert an APA style table to illustrate your independent t-test results. (see module for example) 4. Write an APA style interpretation of your results. What do these results tell us? *************************************************** Paired t-Test 1. Pick two variables appropriate for a paired t-test (refer to the notes to see what types of variables are appropriate for this test) a. Which variables did you select? i. Variable 1: ii. Variable 2: b. Why are these two variables appropriate for this test? 2. State your research and null hypotheses: a. Research hypothesis: b. Null hypothesis: 3. Create and insert an APA style table to illustrate your paired t-test results. (see module for example) 4. Write an APA style interpretation of your results. What do these results tell us? **************************************************** ANOVA 1. Pick two variables appropriate for an ANOVA (refer to the notes to see what types of variables are appropriate for this test) a. Which variables did you select? i. Variable 1: ii. Variable 2: b. Why are these two variables appropriate for this test? 2. State your research and null hypotheses: a. Research hypothesis: b. Null hypothesis: 3. Create and insert an APA style table to illustrate your ANOVA results. (see module for example) 4. Write an APA style interpretation of your results. What do these results tell us? **************************************************** Correlation 1. Pick two variables appropriate for a correlation analysis(refer to the notes to see what types of variables are appropriate for this test) a. Which variables did you select? i. Variable 1: ii. Variable 2: b. Why are these two variables appropriate for this test? 2. State your research and null hypotheses: a. Research hypothesis: b. Null hypothesis: 3. Create and insert an APA style table to illustrate your correlation results. (see module for example) 4. Write an APA style interpretation of your results. What do these results tell us? Original Data - Copy Over Project ID numberGender AgeMarital StatusCurrently Working?Highest level of educationNumber of people in houseHow the person describes his/her weightHow would you describe your health?Depressive Symptoms Scale - Wave 1Depressive Symptoms Scale - Wave 2Anxiety Scale - Wave 1Anxiety Scale - Wave 2Activity Scale - Wave 1Activity Scale - Wave 2Quality of Life - Wave 1Quality of Life - Wave 2Self-Esteem Scale - Wave 1Self-Esteem Scale - Wave 2Stress Scale - Wave 1Stress Scale - Wave 2 1144014133.003.003.004.003.000.001.0022.0024.000.000.000.000.00 2144014144.000.001.001.002.000.001.0025.0025.001.000.000.000.00 3035111244.001.001.002.004.000.001.0027.0035.001.000.000.000.00 4043111233.001.000.002.003.001.001.0021.0019.000.000.001.000.00 5149115133.001.001.003.000.001.000.0025.0016.001.000.001.001.00 6037013133.000.000.000.000.001.000.0013.0019.000.000.003.000.00 7129111233.000.002.000.001.000.001.0014.0032.000.002.003.002.00 8136112144.002.002.003.002.000.001.0018.0015.004.003.000.001.00 9152115244.002.002.003.002.001.000.0021.0023.002.001.003.001.00 10131101233.002.000.003.002.001.000.0015.009.000.000.001.000.00 11033112244.002.004.006.004.001.002.0014.0022.000.001.000.001.00 12134112144.000.001.004.003.000.000.0014.0011.001.002.000.000.00 13130102222.000.003.002.003.001.001.0024.0021.000.004.002.001.00 14034113222.003.002.004.004.002.001.0020.0032.001.001.000.001.00 15140114233.000.000.000.000.000.000.0015.0012.000.000.000.000.00 16150113133.001.000.004.004.001.001.0013.0011.002.000.003.000.00 17134112244.003.004.004.002.001.000.0040.0045.003.001.006.006.00 18133211244.005.004.004.001.001.001.0029.0027.001.003.003.000.00 19144115144.004.005.008.004.005.003.0044.0034.002.002.000.001.00 20144010233.001.004.003.003.001.001.0015.0028.002.003.000.000.00 21150115233.000.000.002.001.000.000.007.001.000.000.001.002.00 22134101333.006.004.004.003.003.004.0032.0018.000.000.000.001.00 23131112244.002.002.003.004.001.001.0014.0020.000.000.003.000.00 24135101133.003.006.001.001.000.000.0023.0023.000.001.001.001.00 25040112333.002.004.001.000.002.004.0010.0015.000.001.002.003.00 26135102233.003.001.003.003.003.002.0023.0020.000.000.001.000.00 27142112244.003.000.005.003.001.000.0023.0016.003.000.003.004.00 28142112222.001.002.003.002.000.000.0017.0016.002.000.002.000.00 29039112133.000.000.004.002.001.001.0013.007.001.000.001.000.00 30040112133.002.001.004.005.001.000.0021.0015.000.000.003.001.00 31140112133.000.004.004.001.000.001.0017.0027.001.000.002.002.00 32138112244.002.001.004.002.002.001.0027.0020.002.002.000.000.00 33138112155.000.002.007.006.002.001.0020.0018.000.000.002.000.00 34146115144.003.003.003.003.002.005.0029.0029.000.000.000.000.00 35144111233.001.000.000.000.001.000.0020.0019.000.000.000.000.00 36144111244.008.007.006.004.003.002.0046.0036.000.002.002.000.00 37145111333.002.005.004.006.002.002.0041.0054.000.000.000.001.00 38147105133.002.000.006.000.000.000.0018.002.000.000.003.000.00 39144115133.005.002.004.004.000.000.0028.0019.000.000.000.000.00 40142112244.000.002.000.007.000.003.009.0014.005.005.004.004.00 41142112233.000.002.003.007.000.003.0032.0052.002.006.003.003.00 42137115155.000.000.002.002.000.000.0011.006.000.001.000.001.00 43137115144.006.001.005.003.002.000.0039.0025.000.000.000.000.00 44146012133.004.003.004.003.001.000.0027.0026.001.000.000.000.00 45140115233.000.001.002.001.000.000.006.009.000.001.000.000.00 46138215144.003.003.002.003.003.002.0028.0021.006.003.001.001.00 47131111244.002.003.001.004.000.001.0012.0019.000.000.002.001.00 48037113122.001.001.002.001.001.000.0017.0020.000.000.000.000.00 49137113133.000.000.003.002.001.002.0012.0016.001.001.000.002.00 50139011133.002.000.005.003.002.000.0019.0016.000.000.001.000.00 51127212233.000.002.001.000.000.000.004.005.001.000.000.000.00 52145112133.000.001.003.005.000.001.0024.0035.000.002.001.001.00 53140113133.000.000.002.002.000.000.0012.0016.000.000.000.000.00 5413210231-1.004.006.004.004.002.002.0036.0051.006.002.002.001.00 55149211233.001.002.004.006.000.001.0021.0018.007.002.002.000.00 56149211244.000.000.003.005.000.000.0013.0020.002.000.000.000.00 57145101222.000.001.002.000.000.000.008.004.000.000.000.000.00 58145101233.000.000.002.000.001.001.009.007.001.000.000.001.00 59145101233.000.000.004.002.001.001.0014.0013.000.001.001.000.00 60138012133.000.002.004.004.001.001.0032.0028.000.000.004.002.00 61138012133.000.001.000.001.000.000.003.004.001.000.003.002.00 62128111233.002.001.003.003.001.000.0015.0016.003.002.004.002.00 63128111233.003.001.004.003.002.000.0032.0021.004.002.001.001.00 64140202244.000.000.004.006.001.000.0016.0012.000.000.000.000.00 65149011144.000.001.000.000.001.000.0025.0027.009.006.004.001.00 66149011144.003.001.005.004.003.002.0038.0028.003.001.005.002.00 67038112244.006.005.005.005.004.002.0051.0051.005.001.001.002.00 68136111233.000.000.002.001.000.000.005.005.004.000.000.000.00 69136111244.000.000.001.003.000.000.0018.0015.001.001.000.001.00 70139101233.002.000.001.000.000.000.0020.0012.001.002.001.000.00 71040112233.000.001.001.002.000.000.005.0012.000.000.000.000.00 72137201222.000.001.002.002.000.000.0018.0024.000.002.000.000.00 73133112144.003.003.004.003.001.002.0017.0021.002.001.003.003.00 74039111333.002.000.002.001.000.000.0020.0012.009.007.007.007.00 75149113144.001.001.003.001.002.001.0019.007.000.000.000.000.00 76133111133.000.003.004.005.000.003.0019.0032.000.000.002.002.00 77134010133.000.002.002.002.002.001.0022.0032.001.000.000.000.00 78136111222.001.001.003.002.000.000.0014.0013.001.000.001.000.00 79039112144.001.000.001.003.002.000.0018.0019.003.002.002.001.00 80139111133.000.000.002.001.000.000.007.006.000.001.002