Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 16.2, Problem 10E
In a
For this estimated regression equation SST = 1550 and SSE = 520.
a. At α = .05, test whether x1 is significant.
Suppose that variables x2 and x3 are added to the model and the following regression equation is obtained.
For this estimated regression equation SST = 1550 and SSE = 100.
b. Use an F test and a .05 level of significance to determine whether x2 and x3 together contribute significantly to the model.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A regression was run to determine if there is a relationship between hours of TV watched per day (xx) and number of situps a person can do (yy).
The results of the regression were: y=ax+ba=-1.392b=32.952r2=0.527076r=-0.726Use this to predict the number of situps a person who watches 2 hour(s) of TV can do, and please round your answer to a whole number.
The estimated regression equation for a model involving two independent variables and 10 observations follows.
y = 33.0798 + 0.6071x1 + 0.7058x2
a. Interpret b₁ and b2 in this estimated regression equation (to 4 decimals).
b₁
=
- Select your answer -
b₂
=
- Select your answer -
b. Estimate y when *₁ = 180 and ₂ = 310 (to 3 decimals).
The estimated regression equation for a model involving two independent variables and 10 observations follows. ŷ = 32.4394 + 0.5695x1 + 0.7347x2
a. Interpret b1 and b2 in this estimated regression equation (to 4 decimals).
b. Estimate y when x1 = 180 and x2 = 310 (to 3 decimals).
Chapter 16 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 16.1 - Consider the following data for two variables, x...Ch. 16.1 - Consider the following data for two variables, x...Ch. 16.1 - Prob. 3ECh. 16.1 - A highway department is studying the relationship...Ch. 16.1 - In working further with the problem of exercise 4,...Ch. 16.1 - A study of emergency service facilities...Ch. 16.1 - Home Depot, a nationwide home improvement...Ch. 16.1 - Corvette, Ferrari, and Jaguar produced a variety...Ch. 16.1 - The film Suicide Squad has an average rating of...Ch. 16.2 - In a regression analysis involving 27...
Ch. 16.2 - Prob. 11ECh. 16.2 - The Professional Golfers’ Association of America...Ch. 16.2 - Refer to exercise 12.
Develop an estimated...Ch. 16.2 - A 10-year study conducted by the American Heart...Ch. 16.2 - The average monthly residential gas bill for Black...Ch. 16.5 - Prob. 16ECh. 16.5 - Prob. 17ECh. 16.5 - Prob. 18ECh. 16.5 - Prob. 19ECh. 16.5 - Prob. 20ECh. 16.5 - Prob. 21ECh. 16.5 - Prob. 22ECh. 16.5 - Prob. 23ECh. 16.6 - The following data show the daily closing prices...Ch. 16.6 - Refer to the Cravens data set in Table 16.5. In...Ch. 16 - A sample containing years to maturity and yield...Ch. 16 - Consumer Reports tested 19 different brands and...Ch. 16 - A study investigated the relationship between...Ch. 16 - Refer to the data in exercise 28. Consider a model...Ch. 16 - Refer to the data in exercise 28.
Develop an...Ch. 16 - Prob. 31SECh. 16 - The Ladies Professional Golf Association (LPGA)...Ch. 16 - Wine Spectator magazine contains articles and...
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 table provides values of the function f(x,y). However, because of potential; errors in measurement, the functional values may be slightly inaccurately. Using the statistical package included with a graphical calculator or spreadsheet and critical thinking skills, find the function f(x,y)=a+bx+cy that best estimate the table where a, b and c are integers. Hint: Do a linear regression on each column with the value of y fixed and then use these four regression equations to determine the coefficient c. x y 0 1 2 3 0 4.02 7.04 9.98 13.00 1 6.01 9.06 11.98 14.96 2 7.99 10.95 14.02 17.09 3 9.99 13.01 16.01 19.02arrow_forwardThe equation used to predict college GPA (range 0-4.0) is y= 0.17 +0.52x, +0.002x,, where x, is high school GPA (range 0-4.0) and X2 is college board score (range 200-800). Use the multiple regression equation to predict college GPA for a high school GPA of 3.1 and a college board score of 600.arrow_forwardA regression was run to determine if there is a relationship between hours of TV watched per day (x) and number of situps a person can do (y). The results of the regression were: Y=ax+b a= -0.921 b= 39.616 r^= 0.483025 r= -0.695 Use this to predict the number of situps a person who watches 11.5 hours of TV can do (to one decimal place)arrow_forward
- The equation used to predict college GPA (range 0-4.0) is y = 0.17 +0.51x, +0.002x,, where x, is high school GPA (range 0-4.0) and x, is college board score (range 200-800). Use the multiple regression equation to predict college GPA for a high school GPA of 3.8 and a college board score of 500. The predicted college GPA for a high school GPA of 3.8 and a college board score of 500 is (Round to the nearest tenth as needed.)arrow_forwardRun a simple linear regressionin SPSS to know if previous experience (‘prevexp’: Previous Experience-months) significantly predicts current salary(‘salary’: Current Salary) in the work force . Use α =.05 Write the regression equation (use a and b provided in the Coefficients Table) Use this equation for: If a person has 112 months of previous experience, what is the person’s predicted current salary?arrow_forwardAn independent researcher wants to investigate if the factors which determine the house rent (Y, measured in dollars), such as the distance of the house from the airport (X,), the time since the house was built (X,), are significant or not. He collects data from 280 prospective locations and estimates the following regression equation: Y = 2.5 -0.88X, +1.98X2. (0.98) (2.14) The 95% confidence interval for the slope coefficient B,, keeping the other variables constant will be (Round your answer to two decimal places. Enter a minus sign if your answer is negative.) owe ppe Based on the calculated confidence intervals, we can say that at the 5% significance level, we will V the hypothesis B, = 0. The 99% confidence interval for the slope coefficient B,, keeping the other variables constant will be (. 1.04 (Round your answer to two decimal places. Enter a minus sign if your answer is negative.) Based on the calculated confidence intervals, we can say that at the 1% significance level, we…arrow_forward
- Company Legal Name ASX Code ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORG ORG ORG ORIGIN ENERGY LTD ORIGIN ENERGY LTD ORIGIN ENERGY LTD ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORIGIN ENERGY LTD ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORIGIN ENERGY LTD ORG ORG QEarnings 1 Date 2 2019/4/1 3 2019/4/2 4 2019/4/3 5 2019/4/4 6 2019/4/5 7 2019/4/8 8 2019/4/9 9 2019/4/10 10 2019/4/11 11 2019/4/12 12 2019/4/15 13 2019/4/16 14 2019/4/17 15 2019/4/18 16 2019/4/23 17 2019/4/24 18 2019/4/26 19 2019/4/29 20 2019/4/30 21 2019/5/1 22 2019/5/2 2019/5/3 23 24 2019/5/6 25 2019/5/7 26 2019/5/8 27 2019/5/9 28 2019/5/10 29 2019/5/13 30 2019/5/14 31 2019/5/15 32 2019/5/16 33 2019/5/17 34 2019/5/20 2019/5/21 35 36 2019/5/22 37 2019/5/23 38 2019/5/24 39 40 2019/5/27 2019/5/28 41 2019/5/29 42 2019/5/30 1 Date…arrow_forwardRun a simple linear regression in SPSS to know if previous experience (‘prevexp’: Previous Experience-months) significantly predicts current salary(‘salary’: Current Salary) in the work force . Use α =.05 Interpret each of the terms of the regression equation That is, interpret: X, Ŷ, a and barrow_forwardAssume a person got score of 32.5 on Test A and a score of 95.25 on Test B. Using the regression equation (B' = 2.3A + 9.5), what is the error of prediction for this person?arrow_forward
- A regression was run to determine if there is a relationship between hours of TV watched per day (x) and number of situps a person can do (y). The results of the regression were: y=ax+ba=-0.759b=20.094r2=0.573049r=-0.757 Use this to predict the number of situps a person who watches 7 hours of TV can do (to one decimal place)arrow_forwardThe estimated regression equation for a model involving two independent variables and 10 observations follows. ŷ = 26.0336 + 0.5179z1 + 0.7599x2 a. Interpret by and by in this estimated regression equation. %3D b1 y changes by 0.5179 when x1 increases by 1 unit and x2 stays the same y changes by 0.7599 when x2 increases by 1 unit and x1 stays the same b. Estimate y when a1 = 180 and æz = 310 (to 3 decimals).arrow_forwardA regression was run to determine if there is a relationship between hours of TV watched per day (xx) and number of situps a person can do (yy).The results of the regression were:y=ax+b a=-0.883 b=30.476 r2=0.660969 r=-0.813 Use this to predict the number of situps a person who watches 8 hour(s) of TV can do, and please round your answer to a whole number.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Calculus For The Life SciencesCalculusISBN:9780321964038Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.Publisher:Pearson Addison Wesley,
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
Calculus For The Life Sciences
Calculus
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:Pearson Addison Wesley,
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