Swamped with your writing assignments? Take the weight off your shoulder!
Submit your assignment instructions
Prompt: For all Excel Practice assignments, submit only ONE Excel document but answer each question on separate worksheets within the document.
In Excel, use the data in Chapter 6: Data Set 1 to compute the Pearson product-moment correlation coefficient and create a scatterplot. (Worksheet 1)
You are developing an instrument that measures vocational preferences (what people want to do for a living), and you need to administer the test several times during the year to students who are attending a vocational program. You need to assess the test–retest reliability of the test and the data from two administrations (available as Chapter 7: Data Set 1) — one in the fall and one in the spring. In Excel, calculate Pearson’s correlation coefficient. Would you call this a reliable test? Why, or why not? (Worksheet 2)
The following videos provide instructions:
How to Calculate a Correlation in Microsoft Excel – Pearson’s 2.
How make a scatter pot in excel