Question: Statistics for People Who (Think They)Hate Statistics Using Microsoft Excel 2016 4th Edition: Given Chapter 5 Data Set 1. Use Excel to solve Chapter 5

Statistics for People Who (Think They)Hate Statistics Using Microsoft Excel 2016 4th Edition: Given Chapter 5 Data Set 1. Use Excel to solve Chapter 5 Question 1. Completely label the output. Prepare a document explaining the statistical process and the results. Correct= Total number of Problems Correct (out of a possible 20) Attitude= Attitude toward test taking (out of a possible 100) Here is the Data: Correct: 17,13,12,15,16,14,16,16,18,19 Attitude: 94,73,59,80,93,85,66,79,77,91 1. Use these data to answer questions 1a and 1b. These data are saved as Chapter 5 Data Set 1. a. Compute the Pearson product-moment correlation coefficient by hand and show all your work. b. Construct a scatterplot for these 10 values by hand. Based on the scatterplot, would you predict the correlation to be direct or indirect? Why?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!