Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
7th Edition
ISBN: 9781337298353
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 15.3, Problem 13E
a)
To determine
To find: The value of
b)
To determine
To find: The value of
c)
To determine
To comment: On the goodness of the fit of the data.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The following estimated regression equation based on 30 observations was presented.
ŷ = 17.6 + 3.8x1 − 2.3x2 + 7.6x3 + 2.7x4
The values of SST and SSR are 1,808 and 1,780, respectively.
(a)
Compute R2.
(b)
Compute
Ra2.
(c)
Comment on the goodness of fit.
The following estimated regression equation is based on 30 observations.
ŷ = 18.3 + 3.9x1 − 2.2x2 + 7.5x3 + 2.5x4
The values of SST and SSR are 1,805 and 1,762, respectively.
a. Compute R2 = (to 3 decimals).
b. Compute Ra2 = (to 3 decimals).
The following estimated regression equation based on 10 observations was presented.
ŷ = 29.1260 + 0.5306x1 + 0.4680x2
The values of SST and SSR are 6,728.125 and 6,215.375, respectively.
(a)
Find SSE.
SSE =
(b)
Compute R2. (Round your answer to three decimal places.)
R2 =
(c)
Compute
Ra2.
(Round your answer to three decimal places.)
Ra2 =
(d)
Comment on the goodness of fit. (For purposes of this exercise, consider a proportion large if it is at least 0.55.)
The estimated regression equation provided a good fit as a small proportion of the variability in y has been explained by the estimated regression equation.The estimated regression equation did not provide a good fit as a small proportion of the variability in y has been explained by the estimated regression equation. The estimated regression equation provided a good fit as a large proportion of the variability in y has been explained by the estimated regression equation.
Chapter 15 Solutions
Essentials of Modern Business Statistics with Microsoft Office Excel (Book Only)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- The following fictitious table shows kryptonite price, in dollar per gram, t years after 2006. t= Years since 2006 0 1 2 3 4 5 6 7 8 9 10 K= Price 56 51 50 55 58 52 45 43 44 48 51 Make a quartic model of these data. Round the regression parameters to two decimal places.arrow_forwardThe exercise involving data in this and subsequent sections were designed to be solved using Excel. The following estimated regression equation is based on 30 observations. Y^ = 17.7 + 3.8x1 – 2x2 + 7.4x3 + 2.7x4 The values of SST and SSR are 1,809 and 1,762, respectively. Compute R2 (to 3 decimals). Compute R2a ? (to 3 decimals).arrow_forwardThe exercise involving data in this and subsequent sections were designed to be solved using Excel. The following estimated regression equation is based on 30 observations. ^y = 17.2 + 3.6x1 – 2.2x2 + 7.8x3 – 2.9x4 The values of SST and SSR are 1,805 and 1,762 , respectively. Compute R2 (to 3 decimals).arrow_forward
- The following estimated regression equation based on 30 observations was presented. ŷ = 17.6 + 3.8x1 − 2.3x2 + 7.6x3 + 2.7x4 The values of SST and SSR are 1,807 and 1,757, respectively. (a) Compute R2. (Round your answer to three decimal places.) R2 = (b) Compute Ra2. (Round your answer to three decimal places.) Ra2 = (c) Comment on the goodness of fit. (For purposes of this exercise, consider a proportion large if it is at least 0.55.) The estimated regression equation did not provide a good fit as a large proportion of the variability in y has been explained by the estimated regression equation. The estimated regression equation provided a good fit as a large proportion of the variability in y has been explained by the estimated regression equation. The estimated regression equation provided a good fit as a small proportion of the variability in y has been explained by the estimated regression equation. The estimated regression equation did not provide a good…arrow_forwardThe following estimated regression equation based on 30 observations was presented. ŷ = 17.6 + 3.8x1 − 2.3x2 + 7.6x3 + 2.7x4 The values of SST and SSR are 1,801 and 1,758, respectively. (a)Compute R2. (Round your answer to three decimal places.) R2 = (b)Compute Ra2.(Round your answer to three decimal places.) Ra2 = (c) Comment on the goodness of fit. (For purposes of this exercise, consider a proportion large if it is at least 0.55.) The estimated regression equation provided a good fit as a small proportion of the variability in y has been explained by the estimated regression equation.The estimated regression equation did not provide a good fit as a large proportion of the variability in y has been explained by the estimated regression equation. The estimated regression equation did not provide a good fit as a small proportion of the variability in y has been explained by the estimated regression equation.The estimated regression equation provided a good fit as a…arrow_forwardThe following sample of observations was randomly selected. x 5 3 6 3 4 4 6 8 y 13 15 7 12 13 11 9 5 a. Determine the regression equation.b. Determine the value of ŷ when x is 7arrow_forward
- The grades of a sample of 9 students on a prelim exam (x) and on the midterm exam (y) are shown below. Find the regression equation. y = 34.661 + 0.433x y = 0.777 + 12.0623x y = 12.0623 + 0.777x y = 34.661 - 0.433xarrow_forwardIn the following case find the best predicted value of y given the following: x = 3.00, r = 0.052 (p-value = 0.85), y (bar)= 5.00, n = 20 and the equation of the regression line is: y (hat) = 6.00 + 4.00xarrow_forwardThe following scores represent a nurse’s assessment (X) and a physician’s assessment (Y) of the condition of 10 patients at time of admission to a trauma centre: X: 18 13 18 15 10 12 8 4 7 3 Y: 23 20 18 16 14 11 10 7 6 4 a) Obtain the regression equation. b) What is the predicted physician’s assessment for a nurse’s assessment of; 16 scores? 21 scores? c) Distinguish between extrapolation and interpolationarrow_forward
- A researcher conducted a number of descriptive statistics for two variables X and Y. They were as follows: SP = -20; SSx = 4; My = 7; Mx = 3 What is b equal to? What is a equal to? Using b and a construct a regression equation, and then using the regression equation, calculate the value of predicted Y when X = 2?arrow_forwardIn a regression model involving 30 observations, the following estimated regression equation was obtained.ŷ = 170 + 34x1 – 3x2 + 8x3 + 58x4 + 3x5For this model, SSR = 1,740 and SST = 2,000.The degrees of freedom associated with SSE are _____. a. 6 b. 5 c. 24 d. 19arrow_forwardThe following estimated regression equation based on 30 observations was presented. ŷ = 17.6 + 3.8x1 − 2.3x2 + 7.6x3 + 2.7x4 The values of SST and SSR are 1,801 and 1,758, respectively. (a) Compute R2. (Round your answer to three decimal places.) R2 = ?? (b) Compute Ra2. (Round your answer to three decimal places.) Ra2 = ?? (c)Comment on the goodness of fit. (For purposes of this exercise, consider a proportion large if it is at least 0.55.) -The estimated regression equation provided a good fit as a small proportion of the variability in y has been explained by the estimated regression equation. -The estimated regression equation did not provide a good fit as a large proportion of the variability in y has been explained by the estimated regression equation. -The estimated regression equation did not provide a good fit as a small proportion of the variability in y has been explained by the estimated regression equation. -The estimated regression equation…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY