1. Based on Emily's case description at the beginning of Chapter 13, run a bivariate regression analysis to answer Leo's research question - Is the level of cultural competence predicted by the number of diversity trainings attended? Use the variables: 'culturalcompetence' and 'Q25'. Include a scatterplot with the regression line and equation. The RQ is provided. Note your hypotheses and interpret your findings (remember, there are multiple output values to interpret in a regression model).

2. Using Emily's survey data, run a multiple regression analysis to determine if there are other appropriate independent variables to include in the model. Show your output. Note your research question, hypotheses, and interpret your findings. The DV is 'culturalcompetence'. Other variables must be continuous level of measurement. This limits the variables you can include in the analysis. Be selective!

Please show work on excel step by step I upload the documents such as the survey questions. I need great assistance do the math on excel

Appendix B: Emily's Survey Form Date Survey ID 1. I can discuss my own ethnic/cultural heritage. Very Rarely Rarely Sometimes Frequently Very Frequently 2. I am aware of how my cultural background and experience have influenced my attitudes about psychological process. Very Rarely Rarely Sometimes Frequently Very Frequently 3. I am able to discuss how my culture has influenced the way I think. Very Rarely Rarely Sometimes Frequently Very Frequently 4. I can recognize when my attitudes, beliefs, and values are interfering with providing the best services to my clients. Very Rarely Rarely Sometimes Frequently Very Frequently 5. I can discuss my family's perspective regarding acceptable and nonacceptable codes of conduct. Very Rarely Rarely Sometimes Frequently Very Frequently 6. I verbally communicate my acceptance of culturally different persons. Very Rarely Rarely Sometimes Frequently Very Frequently 7. I nonverbally communicate my acceptance of culturally different persons. Very Rarely Rarely Sometimes Frequently Very Frequently 8. I can identify my reactions that are based on stereotypical beliefs about different ethnic groups. Very Rarely Rarely Sometimes Frequently Very Frequently 339340 * RESEARCH METHODS AND STATISTICS FOR PUBLIC AND NONPROFIT ADMINISTRATORS 9. Please rank the following activities in terms of its usefulness in improving your work unit's overall level of understanding on diversity and inclusiveness. (Most useful = 1, Least useful =3) Rank A. Diversity training B. Diversity award event C. Newsletter 10. How often are there differences of opinion in your team? Very Rarely Rarely Sometimes Frequently Very Frequently 1 1. How often do the members of your team disagree about how things should be done? Very Rarely Rarely Sometimes Frequently Very Frequently 12. How often do the members of your team disagree about which procedure should be used to do your work? Very Rarely Rarely Sometimes Frequently Very Frequently 13. How often are the arguments in your team task related? Very Rarely Rarely Sometimes Frequently Very Frequently 14. How much are personality clashes evident on your team? Very Rarely Rarely Sometimes Frequently Very Frequently 15. How much tension is there among the members of your team? Very Rarely Rarely Sometimes Frequently Very Frequently 16. How often do people get angry while working in your team? Very Rarely Rarely Sometimes Frequently Very Frequently 17. How much jealousy or rivalry is there among the members of your team? Very Rarely Rarely Sometimes Frequently Very Frequently 18. How old are you? Years Old 19. How many years have you worked at the City? Year(s)Appendix B