Solution Found!
Solved: find the (a) explained variation, (b) unexplained
Chapter 10, Problem 19BSC(choose chapter or problem)
Variation and Prediction Intervals. In Exercises 17–20, find the (a) explained variation, (b) unexplained variation, and (c) indicated prediction interval. In each case, there is sufficient evidence to support a claim of a linear correlation, so it is reasonable to use the regression equation when making predictions.
Galaxy Distances The table below lists measured amounts of redshift and the distances (billions of lightyears) to randomly selected clusters of galaxies (based on data from The Cosmic Perspective by Bennett et al., Benjamin Cummings). For the prediction interval, use a 90% confidence level with a redshift of the cluster Hydra of 0.0126.
Questions & Answers
QUESTION:
Variation and Prediction Intervals. In Exercises 17–20, find the (a) explained variation, (b) unexplained variation, and (c) indicated prediction interval. In each case, there is sufficient evidence to support a claim of a linear correlation, so it is reasonable to use the regression equation when making predictions.
Galaxy Distances The table below lists measured amounts of redshift and the distances (billions of lightyears) to randomly selected clusters of galaxies (based on data from The Cosmic Perspective by Bennett et al., Benjamin Cummings). For the prediction interval, use a 90% confidence level with a redshift of the cluster Hydra of 0.0126.
ANSWER:
Answer :
Step 1 of 1 :
The data can be analyzed through excel.
We have to follow the step by step.
1) We have to enter the data in excel.
2) Click to the data analysis.
3) Click regression then ok.
4) In y range select distance and select redshift in x range.
5) Select output range then ok.
We get the output.
The output is given below.
Regression Statistics | |
Multiple R |
0.999992108 |
R Square |
0.999984216 |
Adjusted R Square |
0.99998027 |
Standard Error |
0.001356464 |
Observations |
6 |
ANOVA |
|||||
|
df |
SS |
MS |
F |
Significance F |