Find the correlation coefficient regression equation

Assignment Help Basic Statistics
Reference no: EM13901193

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.

2. Based on the linear correlation coefficient r, 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 formula or MS Excel.

5. Find the 99% prediction interval for the test score of a person who spent 7hours preparing for the test.

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 effect the results of the regression analysis? Is this data point an outlier, influential point or both? Explain.

Reference no: EM13901193

Questions Cloud

Compute payback period and net present value : Compute the following: Payback period, Present value of estimated annual savings, Present value of estimated residual value, Net present value and Total present value of estimated cash in flows.
Standards for ambient quality : Compare technology-based approaches for addressing water pollution in a watershed with standards for ambient quality of the watershed. What are the benefits for each strategy? Which strategy is more effective? Explain.
Linear correlation between altitude and temperature : Listed below are altitudes (thousands of feet) and outside air temperatures(degrees Fahrenheit) recorded by the author during Delta Flight. is there sufficient evidence to conclude that is a linear correlation between altitude and outside air temp..
Address the health behavior : Provide an explanation as to why it is important to address the health behavior you have chosen. What benefits or consequences do the behaviors have on individuals' health?
Find the correlation coefficient regression equation : Use the given data to find the correlation coefficient r, regression equation and scatter plot in MS Excel. Based on the linear correlation coefficient r, is this a good model? Explain
The second interest payment on december : Paulson Company issues 6%, four-year bonds, on December 31, 2013, with a par value of $ 200,000 and semiannual interest payments. Use the following bond amortization table and prepare journal entries to record
Describe steps that marian should take to resolve situation : Assuming Marian Nevins believes the controller has acted unethically and not apprised the CEO and CFO of the findings, describe the steps that she should take to resolve the situation.
The maturity of the bond on december : Dobbs Company issues 5%, two year bonds, on December 31, 2013, with a par value of $ 200,000 and semiannual interest payments. Use the following bond amortization table and prepare journal entries to record
Discuss citing specific standards from the cma code : Is Gus Swanson's discussion with the team about the prospective sale of Emery unethical? Discuss, citing specific standards from the CMA Code of Professional Ethics for management accountants to support your position.

Reviews

Write a Review

Basic Statistics Questions & Answers

  What is the probability that exactly one vehicle requires

industry standards suggest that 7 percent of new vehicles require warranty service within the first year. jones niussan

  The average score of all golfers for a particular course

the average score of all golfers for a particular course has a mean of 66 and a standard deviation of 5. suppose 100

  Is the job change rate at pioneer significantly different

a research study showed that 50 of workers change jobs within 2 years of employment. landy r. took a random sample of

  Investment portfolio diagram for three stocks

Expand the above table to show the change in Ms A's investment portfolio over the year, and construct a suitable diagram to illustrate that information.

  Using contingency table find out tha probability of girl

If a randomly selected student is a female student, what is the probability she is a C student?

  Perform a sensitivity analysis on optimal decision

Perform a sensitivity analysis on the optimal decision and summarize your findings. In response to which model inputs is the expected profit value most sensitive?

  Compute the mean and standard deviation for the sample

A sample consists of the following n =7 scores: 5, 0, 4, 5, 1, 2, and 4- Compute the mean and standard deviation for the sample.

  Discuss a relationship that can be modeled

Develop and discuss a relationship that can be modeled with a simple regression - State the model in mathematical terms.

  In a gallop poll of 1005 randomly selected americans in

in a gallop poll of 1005 randomly selected americans in april 2006 482 responded yes to the question do you consider

  Use the normal distribution

Use the normal distribution of women's total cholesterol levels in Exercise 9 for which the mean is 186 milligrams per deciliter and the standard deviation is 37.2 milligrams per deciliter.

  Why is it so important to periodically take a physical

why is it so important to periodically take a physical inventory when using a perpetual inventory system? does the

  A standard deviation of 067 inches show all work what

the diameters of grapefruits in a certain orchard are normally distributed with a mean of 5.96 inches and a standard

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd