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 15.5, Problem 19E
In exercise 1, the following estimated regression equation based on 10 observations was presented.
Here SST = 6724.125, SSR = 6216.375,
- a. Compute MSR and MSE.
- b. Compute F and perform the appropriate F test. Use α = .05.
- c. Perform a t test for the significance of β1. Use α = .05.
- d. Perform a t test for the significance of β2. Use α = .05.
- 1. The estimated regression equation for a model involving two independent variables and 10 observations follows.
- a. Interpret b1 and b2 in this estimated regression equation.
- b. Predict y when x1 = 180 and x2 = 310.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Find the correlation coefficient given the estimated regression equation = 25+6x and ² = .8754.
A local retail store compared their monthly sales of umbrellas with the amount of rainfall that occured
during that month. They computed the following statistics:
Rainfall (in) # of umbrellas
mean = 4.64
mean = 34.2
SD = 1.17
SD = 13.2
r = 0.8
1. Find the equation for the regression line that predicts the monthly sales of umbrellas from monthly
rainfall.
The following table gives the data for the grades on the midterm exam and the grades on the final exam. Determine the equation of the regression line, yˆ=b0+b1x�^=�0+�1�. Round the slope and y-intercept to the nearest thousandth.
Grades on Midterm and Final Exams
Grades on Midterm
7171
6262
7878
9494
8383
8181
8080
9494
8585
6262
Grades on Final
8888
7979
8888
9191
8080
7070
7171
9393
6565
7777
Chapter 15 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 15.2 - 1. The estimated regression equation for a model...Ch. 15.2 - Consider the following data for a dependent...Ch. 15.2 - Prob. 3ECh. 15.2 - 4. A shoe store developed the following estimated...Ch. 15.2 - The owner of Showtime Movie Theaters, Inc. would...Ch. 15.2 - NFL Winning Percentage. The National Football...Ch. 15.2 - Prob. 7ECh. 15.2 - Scoring Cruise Ships. The Condé Nast Traveler Gold...Ch. 15.2 - The Professional Golfers Association (PGA)...Ch. 15.2 - Baseball Pitcher Performance. Major League...
Ch. 15.3 - 11. In exercise 1, the following estimated...Ch. 15.3 - 12. In exercise 2, 10 observations were provided...Ch. 15.3 - Prob. 13ECh. 15.3 - Prob. 14ECh. 15.3 - 15. In exercise 5, the owner of Showtime Movie...Ch. 15.3 - Prob. 16ECh. 15.3 - In part (d) of exercise 9, data contained in the...Ch. 15.3 - Prob. 18ECh. 15.5 - In exercise 1, the following estimated regression...Ch. 15.5 - Prob. 20ECh. 15.5 - Prob. 21ECh. 15.5 - Prob. 22ECh. 15.5 - Testing Significance in Theater Revenue. Refer to...Ch. 15.5 - Testing Significance in Predicting NFL Wins. The...Ch. 15.5 - The Condé Nast Traveler Gold List provides ratings...Ch. 15.5 - Prob. 26ECh. 15.6 - Prob. 27ECh. 15.7 - 32. Consider a regression study involving a...Ch. 15.7 - Prob. 33ECh. 15.7 - 34. Management proposed the following regression...Ch. 15.7 - Repair Time. Refer to the Johnson Filtration...Ch. 15.7 - Prob. 36ECh. 15.7 - Prob. 37ECh. 15.8 - Prob. 40ECh. 15.8 - Exercise 5 gave the following data on weekly gross...Ch. 15.8 - The following table reports the price, horsepower,...Ch. 15 - 49. The admissions officer for Clearwater College...Ch. 15 - The personnel director for Electronics Associates...Ch. 15 - Prob. 46SECh. 15 - Recall that in exercise 44, the admissions officer...Ch. 15 - Recall that in exercise 45 the personnel director...Ch. 15 - Fortune magazine publishes an annual list of the...Ch. 15 - The Department of Energy and the U.S....Ch. 15 - The Tire Rack, an online distributor of tires and...Ch. 15 - The National Basketball Association (NBA) records...Ch. 15 - Consumer Research, Inc., is an independent agency...Ch. 15 - Matt Kenseth won the 2012 Daytona 500, the most...Ch. 15 - When trying to decide what car to buy, real value...
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
- Respiratory Rate Researchers have found that the 95 th percentile the value at which 95% of the data are at or below for respiratory rates in breath per minute during the first 3 years of infancy are given by y=101.82411-0.0125995x+0.00013401x2 for awake infants and y=101.72858-0.0139928x+0.00017646x2 for sleeping infants, where x is the age in months. Source: Pediatrics. a. What is the domain for each function? b. For each respiratory rate, is the rate decreasing or increasing over the first 3 years of life? Hint: Is the graph of the quadratic in the exponent opening upward or downward? Where is the vertex? c. Verify your answer to part b using a graphing calculator. d. For a 1- year-old infant in the 95 th percentile, how much higher is the walking respiratory rate then the sleeping respiratory rate? e. f.arrow_forwardFor each gender, estimate an earnings regression where the dependent variable is Annual Earnings and the independent variable is Age. Report the results for each regression, and provide an interpretation of the coefficient associated with age. Female- annual earning: 49347.58 age: 42.81 education: 14.4 Male- Annual earning: 69984.54 age: 42.86 education: 14.11.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.853 b=34.041 r2=0.389376 r=-0.624 Use this to predict the number of situps a person who watches 7 hour(s) of TV can do, and please round your answer to a whole number.arrow_forward
- Listed below are systolic blood pressure measurements (in mm Hg) obtained from the same woman. Find the regression equation, letting the right arm blood pressure be the predictor (x) variable. Find the best predicted systolic blood pressure in the left arm given that the systolic blood pressure in the right arm is 80 mm Hg. Use a significance level of 0.05. -------------- on the second question, 155.2 is the right answer but I don't know how to get the answer. Could you please help me.arrow_forwardCompany 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_forwardThe following estimated regression equation based on 10 observations was presented. ŷ = = 26.1270 +0.5906x₁ +0.4980x2 (a) Develop a point estimate of the mean value of у when X1 = 170 and X₂ = 320. (b) Develop a point estimate for an individual value of y when X₁ = 170 and X₂ = 320.arrow_forward
- Four pairs of data yield r= 0.942 and regression equation y=3x.Also, y= 12.75. What is the best predicted value of y for x= 2.9?arrow_forwardListed below are systolic blood pressure measurements (in mm Hg) obtained from the same woman. Find the regression equation, letting the right arm blood pressure be the predictor (x) variable. Find the best predicted systolic blood pressure in the left arm given that the systolic blood pressure in the right arm is 95 mm Hg. Use a significance level of 0.05. Given that the systolic blood pressure in the right arm is 95 mm Hg, the best predicted systolic blood pressure in the left arm is ____ mm Hg. Right Arm Left Arm103 177102 17196 15076 14677 146arrow_forwardOne set of 20 pairs of scores, X and Y values, produces a correlation of r = 0.70. If SSY = 150, calculate the standard error of the estimate for the regression linearrow_forward
- Listed below are systolic blood pressure measurements (in mm Hg) obtained from the same woman. Find the regression equation, letting the right arm blood pressure be the predictor (x) variable. Find the best predicted systolic blood pressure in the left arm given that the systolic blood pressure in the right arm is 85 mm Hg. Use a significance level of 0.05. Right Arm 101 100 92 79 79 Left Arm 175 168 181 142 144 LOADING... Click the icon to view the critical values of the Pearson correlation coefficient r The regression equation is y=enter your response here+enter your response herex. (Round to one decimal place as needed.) Given that the systolic blood pressure in the right arm is 85 mm Hg, the best predicted systolic blood pressure in the left arm is enter your response here mm Hg. (Round to one decimal place as needed.)arrow_forwardThe estimated regression equation for a model involving two independent variables and 10 observations follows. Y=25.7067 + 0.2795x1 + 0.7337x2 A. Interpret b1 and b2 in this estimated trgression equation. B1 = ? B2 = ? Thank youarrow_forwardThe data show the chest size and weight of several bears. Find the regression equation, letting chest size be the independent (x) variable. Then find the best-predicted weight of a bear with a chest size of 4848 inches. Is the result close to the actual weight of 298298 pounds? Use a significance level of 0.05. Chest_size_(inches) Weight_ (pounds)58 35549 26658 33243 17746 24657 348 Critical Values of the Pearson Correlation Coefficient r n alphaαequals=0.05 alphaαequals=0.01 NOTE: To test H0: rhoρequals=0 against H1: rhoρnot equals≠0, reject H0 if the absolute value of r is greater than the critical value in the table. 4 0.950 0.990 5 0.878 0.959 6 0.811 0.917 7 0.754 0.875 8 0.707 0.834 9 0.666 0.798 10 0.632 0.765 11 0.602 0.735 12 0.576 0.708 13 0.553 0.684 14 0.532 0.661 15 0.514 0.641 16 0.497 0.623 17 0.482 0.606 18 0.468 0.590…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Calculus For The Life SciencesCalculusISBN:9780321964038Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.Publisher:Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Calculus For The Life Sciences
Calculus
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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