Reference no: EM13909364
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 . Use formula or MS Excel.
Solution:
Instructor Comments:
5. Find the 99% prediction interval for the test score of a person who spent 7hours 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:
|
Prepare a contribution margin income statement
: Refer to Exercise 21-10. In 21 10, Blanchard Company manufactures a single product that sells for $ 180 per unit and whose total variable costs are $ 135 per unit.
|
|
Find the expected wait for customer n without conditioning
: Given that the nth customer arrives at time t, find the expected wait for customer n. Find the expected wait for customer n without conditioning on the arrival time.
|
|
What is the bonds nominal yield to call
: Cable Industries has a bond outstanding with 15 years to maturity, an 8.25% nominal coupon, semi annual payments, and a $1,000 par value. The bond has a 6.50% nominal yield to maturity, but it can be called in 6 years at a price of $1,120. What is th..
|
|
How do i properly capture wip on the books every month
: How do I properly capture WIP on the books every month? Please provide an example step by step assuming we were awarded a $200,000 project.
|
|
Based on correlation coefficient r-is this a good model
: 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.
|
|
Does the bios screen have any security?
: Does the BIOS screen have any security?
|
|
Find the fraction of time that the server is busy
: Apply Little's theorem, not to the system as a whole, but to the number of customers in the server (i.e., 0 or 1). Use this to find the fraction of time that the server is busy.
|
|
Determine type of relationship and correlation coefficient
: What does the scatter plot show? Can you determine a type of relationship? Are there any outliers that you can see? Using the same data conduct a correlation analysis using SPSS or Excel. What is the correlation coefficient?
|