Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card
6th Edition
ISBN: 9781260260632
Author: David Doane, Lori Seward Senior Instructor of Operations Management
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 12.6, Problem 30SE
Instructions for exercises 12.29–12.31: (a) Use Excel’s Data Analysis > Regression (or MegaStat or Minitab) to obtain regression estimates. (b) Interpret the 95 percent confidence interval for the slope. Does it contain zero? (c) Interpret the t test for the slope and its p-value. (d) Interpret the F statistic. (e) Verify that the p-value for F is the same as for the slope’s t statistic, and show that t2 = F. (f) Describe the fit of the regression.
12.30 Annual Percent Return on Mutual Funds (n = 17)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
City Fuel Consumption: Finding the Best Multiple Regression Equation. In Exercises 9–12, refer to the accompanying table, which was obtained using the data from 21 cars listed in Data Set 20 “Car Measurements” in Appendix B. The response (y) variable is CITY (fuel consumption in mi/gal). The predictor (x) variables are WT (weight in pounds), DISP (engine displacement in liters), and HWY (highway fuel consumption in mi /gal).
A Honda Civic weighs 2740 lb, it has an engine displacement of 1.8 L, and its highway fuel consumption is 36 mi/gal. What is the best predicted value of the city fuel consumption? Is that predicted value likely to be a good estimate? Is that predicted value likely to be very accurate?
City Fuel Consumption: Finding the Best Multiple Regression Equation. In Exercises 9–12, refer to the accompanying table, which was obtained using the data from 21 cars listed in Data Set 20 “Car Measurements” in Appendix B. The response (y) variable is CITY (fuel consumption in mi/gal). The predictor (x) variables are WT (weight in pounds), DISP (engine displacement in liters), and HWY (highway fuel consumption in mi /gal).
Which regression equation is best for predicting city fuel consumption? Why?
City Fuel Consumption: Finding the Best Multiple Regression Equation. In Exercises 9–12, refer to the accompanying table, which was obtained using the data from 21 cars listed in Data Set 20 “Car Measurements” in Appendix B. The response (y) variable is CITY (fuel consumption in mi/gal). The predictor (x) variables are WT (weight in pounds), DISP (engine displacement in liters), and HWY (highway fuel consumption in mi /gal).
If exactly two predictor (x) variables are to be used to predict the city fuel consumption, which two variables should be chosen? Why?
Chapter 12 Solutions
Gen Combo Ll Applied Statistics In Business & Economics; Connect Access Card
Ch. 12.1 - For each sample, do a test for zero correlation....Ch. 12.1 - Instructions for Exercises 12.2 and 12.3: (a) Make...Ch. 12.1 - Prob. 3SECh. 12.1 - Prob. 4SECh. 12.1 - Instructions for exercises 12.412.6: (a) Make a...Ch. 12.1 - Prob. 6SECh. 12.2 - (a) Interpret the slope of the fitted regression...Ch. 12.2 - (a) Interpret the slope of the fitted regression...Ch. 12.2 - Prob. 9SECh. 12.2 - (a) Interpret the slope of the fitted regression...
Ch. 12.2 - (a) Interpret the slope of the fitted regression...Ch. 12.3 - Prob. 12SECh. 12.3 - Prob. 13SECh. 12.3 - The regression equation Credits = 15.4 .07 Work...Ch. 12.3 - Below are fitted regressions for Y = asking price...Ch. 12.3 - Refer back to the regression equation in exercise...Ch. 12.3 - Refer back to the regression equation in exercise...Ch. 12.4 - Instructions for exercises 12.18 and 12.19: (a)...Ch. 12.4 - Instructions for exercises 12.18 and 12.19: (a)...Ch. 12.4 - Instructions for exercises 12.2012.22: (a) Use...Ch. 12.4 - Instructions for exercises 12.2012.22: (a) Use...Ch. 12.4 - Instructions for exercises 12.2012.22: (a) Use...Ch. 12.5 - Instructions for exercises 12.23 and 12.24: (a)...Ch. 12.5 - Instructions for exercises 12.23 and 12.24: (a)...Ch. 12.5 - A regression was performed using data on 32 NFL...Ch. 12.5 - A regression was performed using data on 16...Ch. 12.6 - Below is a regression using X = home price (000),...Ch. 12.6 - Below is a regression using X = average price, Y =...Ch. 12.6 - Instructions for exercises 12.2912.31: (a) Use...Ch. 12.6 - Instructions for exercises 12.2912.31: (a) Use...Ch. 12.6 - Instructions for exercises 12.2912.31: (a) Use...Ch. 12.7 - Refer to the Weekly Earnings data set below. (a)...Ch. 12.7 - Prob. 33SECh. 12.8 - Prob. 34SECh. 12.8 - Prob. 35SECh. 12.9 - Calculate the standardized residual ei and...Ch. 12.9 - Prob. 37SECh. 12.9 - An estimated regression for a random sample of...Ch. 12.9 - An estimated regression for a random sample of...Ch. 12.9 - Prob. 40SECh. 12.9 - Prob. 41SECh. 12.9 - Prob. 42SECh. 12.9 - Prob. 43SECh. 12.11 - Prob. 44SECh. 12.11 - Prob. 45SECh. 12 - (a) How does correlation analysis differ from...Ch. 12 - (a) What is a simple regression model? (b) State...Ch. 12 - (a) Explain how you fit a regression to an Excel...Ch. 12 - (a) Explain the logic of the ordinary least...Ch. 12 - (a) Why cant we use the sum of the residuals to...Ch. 12 - Prob. 6CRCh. 12 - Prob. 7CRCh. 12 - Prob. 8CRCh. 12 - Prob. 9CRCh. 12 - Prob. 10CRCh. 12 - Prob. 11CRCh. 12 - Prob. 12CRCh. 12 - (a) What is heteroscedasticity? Identify its two...Ch. 12 - (a) What is autocorrelation? Identify two main...Ch. 12 - Prob. 15CRCh. 12 - Prob. 16CRCh. 12 - (a) What is a log transform? (b) What are its...Ch. 12 - (a) When is logistic regression needed? (b) Why...Ch. 12 - Prob. 46CECh. 12 - Prob. 47CECh. 12 - Prob. 48CECh. 12 - Instructions: Choose one or more of the data sets...Ch. 12 - Prob. 50CECh. 12 - Prob. 51CECh. 12 - Prob. 52CECh. 12 - Prob. 53CECh. 12 - Instructions: Choose one or more of the data sets...Ch. 12 - Instructions: Choose one or more of the data sets...Ch. 12 - Instructions: Choose one or more of the data sets...Ch. 12 - Prob. 57CECh. 12 - Prob. 58CECh. 12 - Prob. 59CECh. 12 - Prob. 60CECh. 12 - Prob. 61CECh. 12 - Prob. 62CECh. 12 - Prob. 63CECh. 12 - Prob. 64CECh. 12 - Prob. 65CECh. 12 - In the following regression, X = weekly pay, Y =...Ch. 12 - Prob. 67CECh. 12 - In the following regression, X = total assets (...Ch. 12 - Prob. 69CECh. 12 - Below are percentages for annual sales growth and...Ch. 12 - Prob. 71CECh. 12 - Prob. 72CECh. 12 - Prob. 73CECh. 12 - Simple regression was employed to establish the...Ch. 12 - Prob. 75CECh. 12 - Prob. 76CECh. 12 - Prob. 77CECh. 12 - Below are revenue and profit (both in billions)...Ch. 12 - Below are fitted regressions based on used vehicle...Ch. 12 - Below are results of a regression of Y = average...Ch. 12 - Prob. 81CE
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
- Regression and Predictions. Exercises 13–28 use the same data sets as Exercises 13–28 in Section 10-1. In each case, find the regression equation, letting the first variable be the predictor (x) variable. Find the indicated predicted value by following the prediction procedure summarized in Figure 10-5 on page 493. Internet and Nobel Laureates Find the best predicted Nobel Laureate rate for Japan, which has 79.1 Internet users per 100 people. How does it compare to Japan’s Nobel Laureate rate of 1.5 per 10 million people?arrow_forwardRegression and Predictions. Exercises 13–28 use the same data sets as Exercises 13–28 in Section 10-1. In each case, find the regression equation, letting the first variable be the predictor (x) variable. Find the indicated predicted value by following the prediction procedure summarized in Figure 10-5 on page 493. CPI and the Subway Use the CPI/subway fare data from the preceding exercise and find the best predicted subway fare for a time when the CPI reaches 500. What is wrong with this prediction?arrow_forwardA. B Math Grade English Grade 86 80 90 88 78 85 88 87 89 90 90 94 91 93 77 80 85 80 78 80arrow_forward
- Regression and Predictions. Exercises 13–28 use the same data sets as Exercises 13–28 in Section 10-1. In each case, find the regression equation, letting the first variable be the predictor (x) variable. Find the indicated predicted value by following the prediction procedure summarized in Figure 10-5 on page 493. Tips Using the bill/tip data, find the best predicted tip amount for a dinner bill of $100. What tipping rule does the regression equation suggest?arrow_forward10) 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+b a=-0.767 b=31.009 r2=0.609961 r=-0.781 Use this to predict the number of situps a person who watches 7.5 hours of TV can do (to one decimal place)arrow_forwardState the Interpretation of Regression Coefficients?arrow_forward
- Q: The dataset posted below lists a sample of months and the advertising budget (in hundreds of dollars) for TV, radio and newspaper advertisements. Also included is whether a coupon was published for that month and the resulting sales (in thousands of dollars). a) Develop a multiple regression model predicting the sales based off the four predictor variables: TV, radio, and newspaper advertising budget and whether a coupon is used. Recode Coupon as 0 = No and 1 = Yes. Report the estimated regression equation (Solve in Excel) TV ($100) radio ($100) newspaper ($100) Coupon sales ($1000) 0.7 39.6 8.7 No 1.6 230.1 37.8 69.2 No 22.1 4.1 11.6 5.7 Yes 3.2 44.5 39.3 45.1 No 10.4 250.9 36.5 72.3 No 22.2 8.6 2.1 1 No 4.8 17.2 45.9 69.3 Yes 9.3 104.6 5.7 34.4 No 10.4 216.8 43.9 27.2 Yes 22.3 5.4 29.9 9.4 No 5.3 69 9.3 0.9 No 9.3 70.6 16 40.8 No 10.5 151.5 41.3 58.5 No 18.5 195.4 47.7 52.9 Yes 22.4 13.1 0.4 25.6 Yes 5.3 76.4 0.8…arrow_forwardh) Perform the test using a regression test (using a regression model with dummy variable).arrow_forwardConsider a regression model. The coefficient of determination (R2) gives the proportion of the variability in the dependent variable that is explained by the regression equation. True Falsearrow_forward
- 3. Regression analysis breaks scores on the DV into... (explain and give equations)arrow_forwardA regression analysis was performed to determine if there is a relationship between hours of TV watched per day (xx) and number of sit ups a person can do (yy). The results of the regression were: y=ax+b a=-0.786 b=37.449 r2=0.579121 r=-0.761 Use this to predict the number of sit ups a person who watches 1.5 hours of TV can do, and please round your answer to a whole number.arrow_forward2arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License