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
Get step-by-step solutions from verified subject matter experts
