In: Statistics and Probability
Test for Correlation - Download the data set “Course Evaluations” in your preferred technology format (StatCrunch, Statdisk, Excel). Column 2 denotes the mean course rating, and Column 3 denotes the mean professor rating. Using your preferred technology format (StatCrunch, Statdisk, Excel), generate a scatterplot for these two data sets. Based on the graph, do you believe the two sets are correlated?
Now, using the same program, complete a hypothesis test to test the claim that the course rating and the professor rating are correlated. Provide a printout of your technology output using the Insert/Edit Image feature (no attachments!) Explain your conclusion in statistical and non-statistical terms and how you arrived at that conclusion. Be sure to follow the 8-step procedure on page 360, using technology to do your calculations. You should include your null and alternative hypothesis (in English and in symbolic form), your significance level, whether you are conducting a right tailed, left tailed, or two tailed test, r-value, p-value, and conclusions.
Course Evaluations_Excel(1).xlsx