De Anza College Excel Spreadsheet for Simon Student Calculating Correlations Exercise

Correlation Assignment Spreadsheet <-Here is your spreadsheet for calculating correlations.

In this assignment, you will run a few quick correlations among responses to typical organizational survey questions. Then you take a screen shot or upload your spreadsheet into the assignment.

How to complete the assignment:

1. Open the provided spreadsheet in GoogleSheets, MS Excel, or Apple Numbers.

1. “Save As” your spreadsheet with your name in the title of the document, e.g.,

“SimonStudent_CorrelationAssignmentFall2020”

1. Review the question headings and the overall dataset. The survey questions are the same as those we’ve seen in several examples in class. Responses are on a 1 – 5 scale, with 1 meaning “Strongly Disagree” and 5 “Strongly Agree.”

1. Customize your spreadsheet by deleting the entire row of the RespondentID corresponding to your birthday. For example, if your birthday is December 4^th, you would delete the row of responses for RespondentID #4. Then your spreadsheet would have respondent #3 followed by respondent #5 and all the rest.

1. Run at least four (4) Pearson Correlations by choosing an empty cell (can be in column H or I, next to all the data) and using the CORREL function. For example, to correlate responses between the questions “I am satisfied with my compensation/pay.” (column C) And “The level of daily job stress that I feel is acceptable” (column D) you would enter:

=CORREL(C2:C38, D2:D38)

1. Be sure to bold or highlight the area of the spreadsheet with your correlations.

1. Run at least four correlations.

1. Refer to YouTube videos for help: How to Calculate a Correlation in Microsoft Excel – Pearson’s r or Calculate a Correlation in Google Sheets; Pearson’s r; How to calculate r

Next, click in a row next to the data and correlations (for example, in column G, near the top of the spreadsheet) and write 3-4 sentences describing what your correlations revealed. For example, you might note the questions with the highest correlation between them, and the questions with the lowest. Perhaps there is even a negative correlation between certain questions?

To complete the assignment, submit the saved spreadsheet, or a screen shot of it, into this assignment by the due date.

Have