Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 21P
Consider again the example introduced in Section 4.5 of a credit card company that has a database of information provided by its customers when the customers apply for credit cards. An analyst has created a multiple regression model for which the dependent variable in the model is credit card charges accrued by a customer in the data set over the past year (y), and the independent variables are the customer’s annual household income (x1), number of members of the household (x2), and number of years of post–high school education (x3). Figure 4.23 provides Excel output for a multiple regression model estimated using a data set the company created.
- a. Estimate the corresponding simple linear regression with the customer’s annual household income as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customer’s annual household income and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain?
- b. Estimate the corresponding simple linear regression with the number of members in the customer’s household as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the number of members in the customer’s household and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain?
- c. Estimate the corresponding simple linear regression with the customer’s number of years of post–high school education as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customer’s number of years of post–high school education and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year does this simple linear regression model explain?
- d. Recall the multiple regression in Figure 4.23 with credit card charges accrued by a customer over the past year as the dependent variable and customer’s annual household income (x1), number of members of the household (x2), and number of years of post–high school education (x3) as the independent variables. Do the estimated slopes differ substantially from the corresponding slopes that were estimated using simple linear regression in parts a, b, and c? What does this tell you about multicollinearity in the multiple regression model in Figure 4.23?
- e. Add the coefficients of determination for the simple linear regression in parts a, b, and c, and compare the result to the coefficient of determination for the multiple regression model in Figure 4.23. What does this tell you about multicollinearity in the multiple regression model in Figure 4.23?
- f. Add age, a dummy variable for gender, and a dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as independent variables to the multiple regression model in Figure 4.23. Code the dummy variable for gender as 1 if the customer’s gender is female and 0 if male, and code the dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as 1 if the customer has exceeded his or her credit limit in the past 12 months and 0 otherwise. Do these variables substantially improve the fit of your model?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Suppose you a manager for a local car dealership, and you want to use a linear
regression model to predict the price of a used car. You decide to use four
predictor variables - "Age' (how long the car has been in use since it was
produced), "Dents" (the number of visible dents on the outside of the car),
"Accidents" (the number of accidents the car has been in), and "mpg" (the fuel
efficiency of the car, measured in miles per gallon). Your dataset contains this
information for the past 120 cars sold at your dealership. Using this model, your
analysis finds an R² of 37%. What is the F statistic of your analysis?
Note:
1- Only round your final answer. Round your final answer to two decimal
places.
A researcher collected statistics on the sales amount of a product in 120 different markets and the advertising budgets used in TV, radio and newspaper media channels for each of these markets. The sales amount are expressed in 1000 units, and the budgets are expressed in 1000$. The researcher wants to create a simple linear regression model by choosing one among the TV, radio and newspaper advertising budgets to explain the amount of sales. Accordingly, answer the following question by using the data in the "Regression Data Set" document in the appendix.
1) a) In your opinion, which variable should this researcher choose as an independent variable to the simple regression model? Explain your decision by providing its statistical basis.
A researcher collected statistics on the sales amount of a product in 120 different markets and the advertising budgets used in TV, radio and newspaper media channels for each of these markets. The sales amount are expressed in 1000 units, and the budgets are expressed in 1000$. The researcher wants to create a simple linear regression model by choosing one among the TV, radio and newspaper advertising budgets to explain the amount of sales. Accordingly, answer the following question by using the data in the "Regression Data Set" document in the appendix.1) b) In your opinion, which variable should this researcher choose as an independent variable to the simple regression model? Establish the simple linear regression model using the argument of your choice and write the equation for the model. Interpret b0 and b1.1) c) Test whether there is a statistically significant and linear relationship between the independent variable and the dependent variable by establishing the relevant…
Chapter 4 Solutions
Essentials Of Business Analytics
Ch. 4 - Bicycling World, a magazine devoted to cycling,...Ch. 4 - In a manufacturing process the assembly line speed...Ch. 4 - Jensen Tire Auto is deciding whether to purchase...Ch. 4 - A sociologist was hired by a large city hospital...Ch. 4 - The regional transit authority for a major...Ch. 4 - A marketing professor at Givens College is...Ch. 4 - The Dow Jones Industrial Average (DJIA) and the...Ch. 4 - The Toyota Camry is one of the best-selling cars...Ch. 4 - Dixie Showtime Movie Theaters, Inc., owns and...Ch. 4 - Prob. 10P
Ch. 4 - The American Association of Individual Investors...Ch. 4 - The National Football League (NFL) records a...Ch. 4 - Johnson Filtration. Inc., provides maintenance...Ch. 4 - A study investigated the relationship between...Ch. 4 - The U.S. Department of Energys Fuel Economy Guide...Ch. 4 - A highway department is studying the relationship...Ch. 4 - A sample containing years to maturity and...Ch. 4 - In 2011, home prices and mortgage rates fell so...Ch. 4 - A recent 10-year study conducted by a research...Ch. 4 - The Scholastic Aptitude Test (or SAT) is a...Ch. 4 - Consider again the example introduced in Section...Ch. 4 - Alumni donations are an important source of...
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
- What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardOlympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?arrow_forwardA major brokerage company has an office in Miami, Florida. The manager of the office is evaluated based on the number of new clients generated each quarter. Data were collected that show the number of new customers added during each quarter between 2015 and 2018. A multiple regression model was developed with the number of new customers as the dependent and the following four independent variables: Period (1, …, 16): A variable that measures the trend; Q1 = 1 for first quarter, Q1 = 0 otherwise; Q2 = 1 for second quarter, Q2 = 0 otherwise; Q3 = 1 for third quarter, Q3 = 0 otherwise. Questions: 1. Explain each of the four slopes (Period, Q1, Q2, Q3). 2. How many new customers would you expect in the second quarter of the following year (2019)?arrow_forward
- The November 24, 2001, issue of The Economist published economic data for 15 industrialized nations. Included were the percent changes in gross domestic product (GDP), industrial production (IP), consumer prices (CP), and producer prices (PP) from Fall 2000 to Fall 2001, and the unemployment rate in Fall 2001 (UNEMP). An economist wants to construct a model to predict GDP from the other variables. A fit of the model GDP = , + P,IP + 0,UNEMP + f,CP + P,PP + € yields the following output: The regression equation is GDP = 1.19 + 0.17 IP + 0.18 UNEMP + 0.18 CP – 0.18 PP Predictor Coef SE Coef тР Constant 1.18957 0.42180 2.82 0.018 IP 0.17326 0.041962 4.13 0.002 UNEMP 0.17918 0.045895 3.90 0.003 CP 0.17591 0.11365 1.55 0.153 PP -0.18393 0.068808 -2.67 0.023 Predict the percent change in GDP for a country with IP = 0.5, UNEMP = 5.7, CP = 3.0, and PP = 4.1. a. b. If two countries differ in unemployment rate by 1%, by how much would you predict their percent changes in GDP to differ, other…arrow_forwardWe have data on Lung Capacity of persons and we wish to build a multiple linear regression model that predicts Lung Capacity based on the predictors Age and Smoking Status. Age is a numeric variable whereas Smoke is a categorical variable (0 if non-smoker, 1 if smoker). Here is the partial result from STATISTICA. b* Std.Err. of b* Std.Err. N=725 of b Intercept Age Smoke 0.835543 -0.075120 1.085725 0.555396 0.182989 0.014378 0.021631 0.021631 -0.648588 0.186761 Which of the following statements is absolutely false? A. The expected lung capacity of a smoker is expected to be 0.648588 lower than that of a non-smoker. B. The predictor variables Age and Smoker both contribute significantly to the model. C. For every one year that a person gets older, the lung capacity is expected to increase by 0.555396 units, holding smoker status constant. D. For every one unit increase in smoker status, lung capacity is expected to decrease by 0.648588 units, holding age constant.arrow_forwardBill wants to explore factors affecting work stress. He would like to examine the relationship between age, number of years at the workplace, perceived social support, and work stress. He collects data on the variables from 100 employees (males and females) working in banks. The research question is How accurately can work stress be predicted from linear combination of the predictors (age, social support, number of years at the workplace)? Conduct a multiple regression analysis to answer the following questions: What is the relationship of age, number of years, and social support with work stress? Is the regression significant? If yes, what does it indicate?arrow_forward
- Armer Company is accumulating data to use in preparing its annual profit plan for the coming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff has suggested the use of linear regression to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis follow: Month Maintenance Cost Machine Hours Jan. $ 4,200 480 Feb. 3,000 320 Mar. 3,600 400 Apr. 2,820 300 May 4,350 500 June 2,960 310 July 3,030 320 Aug. 4,470 520 Sept. 4,260 490 Oct. 4,050 470 Nov. 3,300 350 Dec. 3,160 340 Sum $ 43,200 4,800 Average $ 3,600 $ 400 Average cost per hour $ 9.00 a (intercept) $ 684.65 b (coefficient) 7.2884 Standard error of the estimate 34.469 R-squared 0.99724 t-value for b 60.105…arrow_forwardPart I. Run two regressions in Excel using the provided Excel file “Layoffs”.The Excel file Layoffs provides data on 50 manufacturing workers who lost their jobs due to layoffs. The data includes the following list of variables:Weeks – the number of weeks a manufacturing worker has been without a jobAge – the age of the workerEducation – the number of years of education of the workerMarried – a dummy variable, equal to 1 if the worker is married, 0 otherwiseHead – a dummy variable, equal to 1 if the worker is a head of household, 0 otherwiseTenure – the number of years on the previous jobManager – a dummy variable, equal to 1 if the worker had a management occupation, 0 otherwise Sales – a dummy variable, equal to 1 if the worker had an occupation in sales, 0 otherwise 1. Run a simple regression with a dependent variable Weeks and an independent variable Age. Create the regular and standardized residual plots for the simple regression. 2. Run a multiple regression with a dependent…arrow_forwardMark Price, the new productions manager for Speakers and Company, needs to find out which variable most affects the demand for their line of stereo speakers. He is uncertain whether the unit price of the product or the effects of increased marketing are the main drivers in sales and wants to use regression analysis to figure out which factor drives more demand for its particular market. Pertinent information was collected by an extensive marketing project that lasted over the past 12 years and was reduced to the data that follow: YEAR 123456789 10 11 12 UNIT SALES (THOUSANDS) 396 696 896 1,285 1,155 1,186 896 1,118 985 1,334 926 820 PRICE $/UNIT 282 219 206 210 219 209 218 206 220 206 226 236 ADVERTISING ($000) 600 829 1,118 1,413 1,214 1,285 907 1,118 708 907 708 682 a. Perform a regression analysis based on these data using Excel. (Negative values should be indicated by a minus sign. Round your answers to 4 decimal places.)arrow_forward
- A study was conducted to see if a person's income will affect their well-being. We want to create a model with Y = well-being index, and X = income in $1,000. The dependent variable in this study is: Income in $1,000 Well-being index Neitherarrow_forwardIn a useful simple linear regression analysis, the independent variable… is used to predict other independent variables is used to predict the dependent variable has no effect on the dependent variable is the variable that is being predicted using the regression equationarrow_forwardWe have data from 209 publicly traded companies (circa 2010) indicating sales and compensation information at the firm-level. We are interested in predicting a company's sales based on the CEO's salary. The variable sales; represents firm i's annual sales in millions of dollars. The variable salary; represents the salary of a firm i's CEO in thousands of dollars. We use least-squares to estimate the linear regression sales; = a + ßsalary; + ei and get the following regression results: regress sales salary . Source Model Residual Total sales salary _cons SS 337920405 2.3180e+10 2.3518e+10 df 1 207 208 Coef. Std. Err. .9287785 .5346574 5733.917 1002.477 MS 337920405 111980203 113066454 t Number of obs F(1, 207) Prob> F R-squared Adj R-squared Root MSE P>|t| 1.74 0.084 5.72 0.000 209 3.02 -.1252934 3757.543 0.0838 0.0144 0.0096 10582 [95% Conf. Interval] 1.98285 7710.291 This output tells us the regression line equation is sales = 5,733.917 +0.9287785 salary. Suppose a CEO of a company…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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