Basic Business Statistics, Student Value Edition
14th Edition
ISBN: 9780134685113
Author: Mark L. Berenson, David M. Levine, David F. Stephan, Kathryn Szabat
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 14, Problem 81PS
To determine
Find the appropriate multiple regression model and test whether all three independent variables should be included in the model.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
In a study of housing demand, the county assessor is interested in developing a regression model to estimate the market value (i.e., selling price) of residential property within his jurisdiction. The assessor feels that the most important variable affecting selling price (measured in thousands of dollars) is the size of house (measured in hundreds of square feet). He randomly selected 15 houses and measured both the selling price and size, as shown in the following table.
OBSERVATIONi
SELLING PRICE (× $1,000)Y
SIZE (× 100 ft2 )X
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
265.2
279.6
311.2
328.0
352.0
281.2
288.4
292.8
356.0
263.2
272.4
291.2
299.6
307.6
320.4
12.0
20.2
27.0
30.0
30.0
21.4
21.6
25.2
37.2
14.4
15.0
22.4
23.9
26.6
30.7
a. Plot the data.b. Determine the estimated regression line. Give an economic interpretation of the estimated slope (b) coefficient.c. Determine if size is a statistically significant variable in estimating selling price.d. Calculate the coefficient…
A mail-order business selling personal computer supplies, software and hardware maintains a centralized warehouse. Management is currently examining the process of distribution from the warehouse and wants to study the factors that affect the warehouse distribution costs.
Data collected over 24 random months contain the warehouse’s distribution cost (in thousands of Rands), the sales (in thousands of Rands) and the number of orders received. A multiple linear regression model was fitted to the data by using Stat1.2. Use the output to answer the questions that follow by typing only the letter of the correct option in the answer boxes.
Variablesy: Warehouse Distribution Costx1: Salesx2: Number of Orders
Model Fitting StatisticsR2 = 0.8504Adj R2: ?
Regression Coefficients Beta Parameter Standard b Parameter Standard Estimates…
Identify a characteristic of the data that is ignored by the regression line.
Chapter 14 Solutions
Basic Business Statistics, Student Value Edition
Ch. 14 - For this problem, use the following multiple...Ch. 14 - For this problem, use the following multiple...Ch. 14 - A nonprofit analyst seeks to determine which...Ch. 14 - Profitability remains a challenge for banks and...Ch. 14 - The production of wine is a multibillion-dollar...Ch. 14 - Human resource managers face the business problem...Ch. 14 - Prob. 7PSCh. 14 - Prob. 8PSCh. 14 - The following ANOVA summary table is for a...Ch. 14 - The following ANOVA summary table is for a...
Ch. 14 - A financial analyst engaged in business valuation...Ch. 14 - In Problem 14.3 on page 541, you predicted...Ch. 14 - In Problem 14.5 on page 542, you used the...Ch. 14 - In Problem 14.4 on page 541, you used efficiency...Ch. 14 - In Problem 14.7 on page 542, you used the weekly...Ch. 14 - Prob. 16PSCh. 14 - Prob. 17PSCh. 14 - Prob. 18PSCh. 14 - In Problem 14.5 on page 542, you used the...Ch. 14 - Prob. 20PSCh. 14 - Prob. 21PSCh. 14 - Prob. 22PSCh. 14 - Prob. 23PSCh. 14 - Prob. 24PSCh. 14 - In Problem 14.3 on page 541, you predicted...Ch. 14 - In Problem on page 541, you used efficiency ratio...Ch. 14 - Prob. 27PSCh. 14 - In Problem 14.6 on page 542, you used full-time...Ch. 14 - Prob. 29PSCh. 14 - Prob. 30PSCh. 14 - The following is the ANOVA summary table for a...Ch. 14 - The following is the ANOVA summary table for a...Ch. 14 - In Problem 14.5 on page 542, you used alcohol...Ch. 14 - In Problem 14.4 on page 541, you used efficiency...Ch. 14 - Prob. 35PSCh. 14 - In Problem 14.6 on page 542, you used full-time...Ch. 14 - Prob. 37PSCh. 14 - Suppose X1 is a numerical variable and X2 is a...Ch. 14 - The chair of the accounting department plans to...Ch. 14 - A real estate association in a suburban community...Ch. 14 - In Problem 14.5 on page 542, you developed a...Ch. 14 - In mining engineering, holes are often drilled...Ch. 14 - The owner of a moving company typically has his...Ch. 14 - Prob. 44PSCh. 14 - Zagat’s publishes restaurant rating for various...Ch. 14 - In Problem 14.6 on page 542, you used full-time...Ch. 14 - In Problem 14.5 on page 542, the percentage of...Ch. 14 - Prob. 48PSCh. 14 - The director of a training program for a large...Ch. 14 - Prob. 50PSCh. 14 - Prob. 51PSCh. 14 - Prob. 52PSCh. 14 - Prob. 53PSCh. 14 - Prob. 54PSCh. 14 - Prob. 55PSCh. 14 - Prob. 56PSCh. 14 - Prob. 57PSCh. 14 - An automotive insurance company wants to predict...Ch. 14 - A marketing manager wants to predict customer with...Ch. 14 - A local supermarket manager wants to use two...Ch. 14 - Prob. 61PSCh. 14 - Prob. 62PSCh. 14 - Prob. 63PSCh. 14 - Prob. 64PSCh. 14 - Prob. 65PSCh. 14 - Prob. 66PSCh. 14 - Prob. 67PSCh. 14 - Prob. 68PSCh. 14 - Prob. 69PSCh. 14 - Prob. 70PSCh. 14 - Prob. 71PSCh. 14 - The owner of a moving company typically has his...Ch. 14 - Professional basketball has truly become a sport...Ch. 14 - A sample of 61 house recently listed for sale in...Ch. 14 - Measuring the height of a California redwood tree...Ch. 14 - A sample of 61 houses recently listed for sale in...Ch. 14 - Prob. 77PSCh. 14 - Referring to Problem 14.77, Suppose that an...Ch. 14 - Prob. 79PSCh. 14 - Prob. 80PSCh. 14 - Prob. 81PSCh. 14 - Prob. 82PSCh. 14 - Prob. 83PS
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
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardA study was conducted on 64 female college athletes. The researcher collected data on a number of variables including percent body fat, total body weight, height, and age of athlete. The researcher wondered if % body fat (%BF), height (HGT), and/or age are significant predictors of total body weight. All conditions have been checked and are met and no transformations were needed. The technology output from the multiple regression analysis is given below. What percent of the variation in total body weight is being explained by the regression model with these three explanatory variables?arrow_forwardConsumer Reports tested 19 different brands and models of road, fitness, and comfort bikes. Road bikes are designed for long road trips; fitness bikes are designed for regular workouts or daily commuters; and comfort bikes are designed for leisure rides on typically flat roads. The data file Bikes show the type, weight (lb.), and price ($) for the 20 bicycles tested. Develop an estimated regression equation that can be used to predict Price by using Type and Weight. Brand and Model Type Weight Price Klein Rêve v Road 20 1800 Giant OCR Composite 3 Road 22 1800 Giant OCR 1 Road 22 1000 Specialized Roubaix Road 21 1300 Trek Pilot 2.1 Road 21 1320 Cannondale Synapse 4 Road 21 1050 LeMond Poprad Road 22 1350 Raleigh Cadent 1.0 Road 24 650 Giant FCR3 Fitness 23 630 Schwinn Super Sport GS Fitness 23 700 Fuji Absolute 2.0 Fitness 24 700 Jamis Coda Comp Fitness 26 830 Cannondale Road Warrior 400 Fitness 25 700 Schwinn Sierra GS Comfort 31 340 Mongoose…arrow_forward
- Explain why the interpretation of the regression coefficients is difficult when the predictor variables are highly intercorrelated.arrow_forwardWhat is the relationship between diamond price and carat size? 307 diamonds were sampled and a straight-line relationship was hypothesized between y = diamond price (in dollars) and x = size of the diamond (in carats). The simple linear regression for the analysis is shown below: Least Squares Linear Regression of PRICE Interpret the standard deviation of the regression model. a) We expect most of the sampled diamond prices to fall within $1117.56 of their least squares predicted values. b) We can explain 89.25% of the variation in the sampled diamond prices around their mean using the size of the diamond in a linear model. c) For every 1-carat increase in the size of a diamond, we estimate that the price of the diamond will increase by $1117.56. d) We expect most of the sampled diamond prices to fall within $2235.12 of their least squares predicted values.arrow_forwardIn a study of housing demand, the county assessor develops the following regression model to estimate the market value (i.e., selling price) of residential property within his jurisdiction. The assessor suspects that important variables affecting selling price (YY, measured in thousands of dollars) are the size of a house (X1X1, measured in hundreds of square feet), the total number of rooms (X2X2), age (X3X3), and whether or not the house has an attached garage (X4X4, No=0, Yes=1No=0, Yes=1). Y=α+β1X1+β2X2+β3X3+β4X4+εY=α+β1X1+β2X2+β3X3+β4X4+ε Now suppose that the estimate of the model produces following results: a=166.048a=166.048, b1=3.459b1=3.459, b2=8.015b2=8.015, b3=−0.319b3=−0.319, b4=1.186b4=1.186, sb1=1.079sb1=1.079, sb2=5.288sb2=5.288, sb3=0.789sb3=0.789, sb4=12.252sb4=12.252, R2=0.838R2=0.838, F-statistic=12.919F-statistic=12.919, and se=13.702se=13.702. Note that the sample consists of 15 randomly selected observations. According to the estimated model, holding all…arrow_forward
- Zagat’s publishes restaurant ratings for various locations in the United States. The following table contains the Zagat rating for food, décor, service, and the cost per person for a sample of 100 restaurants located in New York City and in a suburb of New York City. Develop a regression model to predict the cost per person, based on a variable that represents the sum of the ratings for food, décor, and service. Predict the mean cost per person for a restaurant with a sum-mated rating of 50. What should you tell the owner of a group of restaurants in this geographical area about the relationship between the summated rating and the cost of a meal? Location Food Décor Service Summated Rating Coded Location Cost Bins Midpoints City 22 14 19 55 0 33 19.99 25 City 20 15 20 55 0 26 29.99 35 City 23 19 21 63 0 43 39.99 45 City 19 18 18 55 0 32 49.99 55 City 24 16 18 58 0 44 59.99 65 City 22 22 21 65 0 44 69.99 75 City 22 20 20 62 0 50 79.99 85 City 20 19…arrow_forwardA researcher is interested in examining the relationship between spousal abuse and child abuse. Specifically, they are interested in determining whether there is a predictive relationship between spousal abuse and child abuse in 5 county social services offices. Calculate the linear regression line for the following data. Note you have already calculated the first step to this analysisarrow_forwardAn important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume. Consider the following sample of production volumes and total cost data for a manufacturing operation.arrow_forward
- It is considered that the number of employees in the enterprise affects the number of production. Data are given below. What is the Regression Separation Sum of Squares (RAKT) in the validity of the regression model?arrow_forwardThe county assessor feels that the use of more independent variables in the regression equation might improve the overall explanatory power of the model. In addition to size, the assessor feels that the total number of rooms, age, and whether or not the house has an attached garage might be important variables affecting selling price. The data for the 15 randomly selected dwellings are shown in the following table. What proportion of the total variation in selling price is explained by the regression model?arrow_forwardA real estate builder wishes to determine how house size (House) is influenced by family income (Income) and family size (Size). House size is measured in meter square and income is measured in IDR millions. The builder randomly selected 50 families and ran the multiple regression. Partial Microsoft Excel output is provided below: Which of the independent variables in the model are significant at the 5% level? Formulate the hypothesis and explain the answer. How far can you rely upon this model? Or, what is the percentage variation in House explained by the model? What is the predicted house size (in hundreds of square feet) for an individual earning an annual income of IDR 400 million and having a family size of 4?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
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
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
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
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