For the module 05 Homework, please download the Microsoft Word document using the link below and follow the directions included in the assignment.Please complete the attached worksheet.Name:______________________________________
Module 5 Homework Assignment
The paired data below consists of test scores and hours of preparation for 5 randomly selected
students. Use this data set to answer the questions below:
x Hours of preparation 5 2 9 6 10
y Test score
64 48 72 73 80
1. Use the given data to find the correlation coefficient r, regression equation and scatter plot in MS
Excel.
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:
Instructor Comments:
4. Find the standard error se . Use formula or MS Excel.
Solution:
Instructor Comments:
5. Find the 99\% prediction interval for the test score of a person who spent 7 hours preparing for the
test.
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 regression
analysis? Is this data point an outlier, influential point or both? Explain.
Solution:
Instructor Comments:
Purchase answer to see full
attachment
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.