+
1. USE THE GIVEN DATA TO FIND THE CORRELATION COEFFICIENT R, REGRESSION

1. USE THE GIVEN DATA TO FIND THE CORRELATION COEFFICIENT R, REGRESSION

Rating:
Rating
(0)
Author: Christine Farr
Description:

http://theperfecthomework.com/1-use-the-given-data-to-find-the-correlation-coefficient-r-regression-equation-and-scatter-plot-in-ms-excel/

Module 5 Homework AssignmentThe paired data below consists of test scores and hours of preparation for 5 randomly selectedstudents. Use this data set to answer the questions below:x Hours of preparation 5 2 9 6 10y Test score64 48 72 73 801. Use the given data to find the correlation coefficient r, regression equation and scatter plot in MSExcel.Solution:Instructor Comments:2. Based on the linear correlation coefficient r, is this a good model? Explain.Solution:Instructor Comments:3. What is the best predicted test score for a student who spent 7 hours preparing for the test?Solution:4. Find the standard errorSolution:Instructor Comments:se. Use formula or MS Excel.Instructor Comments:5. Find the 99% prediction interval for the test score of a person who spent 7 hours preparing for thetest. Solution:Instructor Comments:6. Find the explained variation.Solution:Instructor Comments:7. Find the unexplained variation.Solution:Instructor Comments:8. Find the total variation.Solution:Instructor Comments:9. Find the value of r2 and explain its meaning.Solution:Instructor Comments:10. If the data point ( 3, 100) is added to the data set, how would this effect the results of the regressionanalysis? Is this data point an outlier, influential point or both? Explain.Solution:


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial