statistics. The paired data below consists of test scores and hours of preparation for 5 randomly selected students. xÿÿÿ Hours of preparationÿÿÿÿÿ 5ÿÿÿÿ 2ÿÿÿÿ 9ÿÿÿÿÿ 6ÿÿ 10y ÿÿÿTest score ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ64ÿÿ 48ÿÿ 72ÿÿÿ 73ÿÿ 801. Use the given data and MS Excel and find the correlation coefficient r, regression equation and scatter plot.2. Based on the linear correlation coefficient r, andÿ a = 0.05, is this a good model?ÿ Explain.3.ÿ What is the best predicted test score for a student who spent 7 hours preparing for the test?4.ÿ Find the standard error . Use the formula or Microsoft Excel Regression5.ÿ Find the 99% prediction interval for the test score of a person who spent 7 hours preparing for the test given that E = 34.677. Interpret the result.6.ÿ Find the explained variation.7.ÿ Find the unexplained variation.8.ÿ Find the total variation. 9.ÿ Find the value of r2 and explain its meaning.10.ÿ If the data point (3, 100) is added to the data set, how would this affect the results of the regression analysis?ÿ Is this data point an outlier, influential point or both?ÿ Explain.



15% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.