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
Videos
Textbook Question
Chapter 15.2, Problem 5E
The owner of Showtime Movie Theaters, Inc. would like to predict weekly gross revenue as a 
- Develop an estimated regression equation with the amount of television advertising as the independent variable.
- Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables.
- Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b)? Interpret the coefficient in each case.
- Predict weekly gross revenue for a week when $3500 is spent on television advertising and $1800 is spent on newspaper advertising?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A financial website reported the beta value for a certain company was 0.86. Betas for individual stocks are determined by simple linear regression. The dependent variable is the total return for the stock, and the independent variable is the total return for the stock market, such as the return of a market index. The slope of this regression equation is referred to as the stock's beta. Many financial analysts prefer to measure the risk of a stock by computing the stock's beta value.
Suppose the following data show the monthly percentage returns for the market index and the company for a recent year.
Month
Market Index% Return
Company% Return
August
-3
4
September
8
7
October
0
1
November
-2
1
December
-5
0
January
0
0
February
7
7
March
0
-2
April
2
0
May
-5
-1
a. Develop the least squares estimated regression equation. (Let x = Market Index % Return (as a %), and let y = Company % Return (as a %). Round your numerical values to four decimal places.)
A researcher is analyzing the relationship between various variables in housing data for 32 cities: median list prices of single family homes, condominium or co-ops, all homes, median household income, unemployment rate, and population.
What is the regression equation for the model that predicts the list price of all homes using population as an explanatory variable?What is the interpretation of the slope?
What is the interpretation of the intercept?
A random sample of beef hotdogs was taken and the amount of sodium (in mg) and calories were measured.
The data are in the table. Create a scatter plot and find a regression equation between amount of calories
and amount of sodium. Then use the regression equation to find the amount of sodium a beef hotdog has if
it is 138 calories and if it is 100 calories. Which sodium level that you calculated do you think is closer to
the true sodium level? Why?
Calories and Sodium Levels in Beef Hotdogs
Calories
Sodium
181
477
114
296
184
440
164
495
149
374
180
526
137
251
170
482
133
350
Select the correct scatterplot.
500
400
440
420
400
340
300
200
124010 15 120 125 18015 140 145 150 155 100 45 170 175 Jao Jas I80 4p.
500
400
440
420
400
300
340
300
200
I4oio is 120 125 180 135 140 J45 J50 153 100 165 170o
500
400
440
420
400
300
340
320
300
220
200
1240lio is 120 125 180 1 140 145 150 155 100 165 170 175 Jao Jas J0 4s.
The regression equation is y=
decimal places if necessary.)
(Round to two…
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
- Does Table 2 represent a linear function? If so, finda linear equation that models the data.arrow_forwardWhat is regression analysis? Describe the process of performing regression analysis on a graphing utility.arrow_forwardFind the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forward
- Life Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300arrow_forwardAriel was running analyses over and over in census data and came across a correlation between weight and debt (r=.78). Independent variable is weight and dependent variable is debt. b) Curious Ariel noted some statistics on these weight (M=160lb, SD=15lb) and debt (M=196k, SD=20k). If Ariel wanted to calculate a regression equation, what would her slope and intercept be?arrow_forwardProfessional basketball has truly become a sport that generates interest among fans around the world. More and more players come from outside the United States to play in the National Basketball Association (NBA). You want to develop a regression model to predict the number of wins achieved by each NBA team, based on field goal (shots made) percentage and three-point field goal percentage. The data are stored in NBA.xlsx . TEAM Wins Field Goal % Three-Point Field Goal % Points Per Game Rebound Freedraw Turnover Houston Rockets 65 46 36.2 112.4 43.5 19.6 13.8 Toronto Raptors 59 47.2 35.8 111.7 44 17.3 13.4 Golden State Warriors 58 50.3 39.1 113.5 43.5 16.6 15.4 Boston Celtics 55 45 37.7 104 44.5 16 14 Philadelphia 76ers 52 47.2 36.9 109.8 47.4 17.1 16.5 Cleveland Cavaliers 50 47.6 37.2 110.9 42.1 18.1 13.7 Portland Trail Blazers 49 45.2 36.6 105.6 45.5 16.7 13.5 Indiana Pacers 48 47.2 36.9 105.6 42.3 14.9 13.3 New Orleans Pelicans 48 48.3 36.2 111.7 44.3 16.1 14.9…arrow_forward
- Professional basketball has truly become a sport that generates interest among fans around the world. More and more players come from outside the United States to play in the National Basketball Association (NBA). You want to develop a regression model to predict the number of wins achieved by each NBA team, based on field goal (shots made) percentage and three-point field goal percentage. The data are stored in NBA.xlsx . TEAM Wins Field Goal % Three-Point Field Goal % Points Per Game Rebound Freedraw Turnover Houston Rockets 65 46 36.2 112.4 43.5 19.6 13.8 Toronto Raptors 59 47.2 35.8 111.7 44 17.3 13.4 Golden State Warriors 58 50.3 39.1 113.5 43.5 16.6 15.4 Boston Celtics 55 45 37.7 104 44.5 16 14 Philadelphia 76ers 52 47.2 36.9 109.8 47.4 17.1 16.5 Cleveland Cavaliers 50 47.6 37.2 110.9 42.1 18.1 13.7 Portland Trail Blazers 49 45.2 36.6 105.6 45.5 16.7 13.5 Indiana Pacers 48 47.2 36.9 105.6 42.3 14.9 13.3 New Orleans Pelicans 48 48.3 36.2 111.7 44.3 16.1 14.9…arrow_forwardA real estate company wants to study the relationship between house sales prices and some important predictors of sales prices. Based on data from recently sold homes in the space, the following variables are used in a multiple regression model. y = sales price (in thousands of dollars) x₁ = total floor area (in square feet) x₂ = number of bedrooms x3 distance to nearest high school (in miles) = The estimated model is as follows. =76+0.098x₁ +16x₂ - 8x3 Answer the questions below for the interpretation of the coefficient of X₂ in this model. (a) Holding the other variables fixed, what is the average change in sales price for each additional bedroom in a house? dollars (b) Is this change an increase or a decrease? O increase O decrease Xarrow_forwardWhat is meant by the slope of the regression line?arrow_forward
- A consumer organization wants to develop a regression model to predict gasoline mileage (as measured by miles per gallon) based on the horsepower of the car’s engine and the weight of the car, in pounds. A sample of 50 recent car models was selected, with the results recorded in the file auto.xls. State the multiple regression equation. Interpret the meaning of the slopes, b1 and b2, in this problem. Explain why the regression coefficient, b0, has no practical meaning in the context of this problem. Predict the mean miles per gallon for cars that have 60 horsepower and weigh 2,000 pounds.arrow_forwardWrite the simple linear regression equation for miles per gallon as the response variable and weight as the predictor variable. How might the car rental company use this model?arrow_forwardThe regression line always gives an exact model for data. true or falsearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
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