Pearson eText for Basic Business Statistics -- Instant Access (Pearson+)
14th Edition
ISBN: 9780137400119
Author: MARK BERENSON, David Levine
Publisher: PEARSON+
expand_more
expand_more
format_list_bulleted
Concept explainers
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 solutionStudents 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…
A 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?
Chapter 14 Solutions
Pearson eText for Basic Business Statistics -- Instant Access (Pearson+)
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_forwardExplain why the interpretation of the regression coefficients is difficult when the predictor variables are highly intercorrelated.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_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_forwardExplain why the predictor variable is useless as a predictor of the response variable if the slope of the population regression line is 0.arrow_forward
- A 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_forwardAs part of a study designed to compare hybrid and similarly equipped conventional vehicles, Consumer Reports tested a variety of classes of hybrid and all-gas model cars and sport utility vehicles (SUV’s). You are given the required information in the Excel data-file named HybridTest. Test for any significant effect due to Class, Type using multiple regressions. Create dummy variables for Class and Type. Use alpha=0.05 Make/Model Class Type MPG Honda Civic Small Car Hybrid 37 Honda Civic Small Car Conventional 28 Toyota Prius Small Car Hybrid 44 Toyota Corolla Small Car Conventional 32 Chevrolet Malibu Midsize Car Hybrid 27 Chevrolet Malibu Midsize Car Conventional 23 Nissan Altima Midsize Car Hybrid 32 Nissan Altima Midsize Car Conventional 25 Ford Escape Small SUV Hybrid 27 Ford Escape Small SUV Conventional 21 Saturn Vue Small SUV Hybrid 28 Saturn Vue Small SUV Conventional 22 Lexus RX Midsize SUV Hybrid 23 Lexus RX Midsize SUV Conventional 19…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: State the hypothesis for this study.arrow_forward
- To predict the market share of one of their products, a manufacturer of consumer electronics products hired a market research company to conduct a study that relates market share in a particular geographic region (in %) to the average annual household income and the number of retail outlets per 100,000 residents. The results of a multiple regression model to predict market share from Household income (in thousands of dollars) and number of outlets per 100,000 residents are given below. a) How much of the variation in market share can this model predict? Is this statistically significant? b) Someone claims that each additional outlet will increase the market share by more than 1.5%, regardless of what the household income is. Perform the appropriate hypothesis test to check this claim with a 5% significance level. c) What increase in market share would your model predict for every two additional retail outlets in a region where the annual household income is $75,000? Find a 95%…arrow_forwardA magazine publishes restaurant ratings for various locations around the world. The magazine rates the restaurants for food, decor, service, and the cost per person. Develop a regression model to predict the cost per person, based on a variable that represents the sum of the three ratings. The magazine has compiled the accompanying table of this summated ratings variable and the cost per person for 25 restaurants in a major city. Predict the mean cost per person for a restaurant with a summated rating of 70.arrow_forwardJensen, Solberg, and Zorn investigated the relationship of insider ownership, debt, and dividend policies in companies. One of their findings was that firms with high insider ownership choose lower levels of both debt and dividends. Shown here is a sample of data of these three variables for 11 different industries. Use the data to develop the equation of the regression model to predict insider ownership by debt ratio and dividend payout. Comment on the regression coefficients.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
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