Excel Lab Assignments

In this problem, I present a sample of residents survey responses to two neighborhood characteristics: job opportunities and community involvement. Are these variables related?
Table 11.7 presents the date for this problem. Conduct a correlation analysis and summarize your responses using SPSS. Be sure to discuss wheter the assumptions were met for this procedure.
Using the data from the table below, conduct a correlation analysis and summarize your findings using Excel and Real Statistics. Be sure to discuss whether the assumptions for the test were met, whether to accept or reject the null hypothesis, and the effect size for the analysis. All answers can be reached by using the textbook. Really.

Job Opportunities Community Involvement
1 1
1 3
1 1
1 1
2 4
2 1
2 1
2 2
2 4
2 3
3 2
3 4
3 5
3 4
4 4
4 3
4 4
4 3
4 4
4 6
5 5
5 5
5 7
6 5
7 7
7 7
7 6
7 7
Required Text:
Abbot, M.L (2016) Using statistics in the social and health sciences with SPSS and excel.Wiley.

Real Statistics for Excel
Introduction to Real Statistics for Excel
Introduction to Real Statistics for Excel
Because the vast majority of MSW practitioners won’t have personal or professional access to statistical analysis software such as SPSS, this course utilizes a program to which everyone can easily and affordably access: Microsoft Excel. Charles Zaiontz has created an add-in for Microsoft Excel that simplifies the process of conducting statistical analysis and produces understandable, academic-grade output.

Not only does his website contain the instructions and download files for Real Statistics, but it also provides a solid collection of information about basic and advanced statistics using Excel. The software add-in and all of the resources on the website is free of charge. Additionally, there is no adware or spyware attached to the software or the website.

The website, Real Statistics Using Excel, can be found at https://www.real-statistics.com. The page to download Real Statistics can be found at https://www.real-statistics.com/free-download/real-statistics-resource-pack/. This page contains files and instructions for both Windows and Mac versions.

Last Completed Projects