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
Textbook Question
Chapter 13, Problem 74PS
Management of a soft-drink botting company has the business objective of developing a method for allocating delivery costs to customers. Although one cost clearly relates to travel time within a particular route, another variable cost reflects the time required to unload the cases of soft drink at the delivery point. To begin, management decided to develop a regression model to predict delivery time based on the number of cases delivered. A sample of 20 deliveries within a territory was selected. The delivery times and the number of cases delivered were organized in the following table and stored in Delivery.
a. Use the least-squares method to compute the regression coefficients
b. Interpret the meaning of
c. Predict the
d. Should you use the model to predict the delivery time for a customer who is receiving 500 cases of soft drink? Why or why not?
e. Determine the coefficient of determination,
f. Perform a residual analysis. Is there any evidence of a pattern in the residuals? Explain.
g. At the 0.05 level of significance, is there evidence of a linear relationship between delivery time and the number of cases delivered?
h. Construct a
i. What conclusions can you reach from (a) through (h) about the relationship between the number of cases and delivery time?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Management of a soft-drink bottling company has the business objective of developing a method for allocating delivery costs to customers. Although one cost clearly relates to travel time within a particular route, another variable cost reflects the time required to unload the cases of soft drink at the delivery point. To begin, management decided to develop a regression model to predict delivery time based on the number of cases delivered. A sample of 20 deliveries within a territory was selected. The delivery times and the number of cases delivered were organized in the following table:
CUSTOMER
NUMBER OF CASES
DELIVERY TIME (MINUTS)
1
52
32.1
2
64
34.8
3
73
36.2
4
85
37.8
5
95
37.8
6
103
39.7
7
116
38.5
8
121
41.9
9
143
44.2
10
157
47.1
11
161
43.0
12
184
49.4
13
202
57.2
14
218
56.8
15
243
60.6
16
254
61.2
17
267
58.2
18
275
63.1…
Management of a soft drink bottling company has the business objective of developing a
method for allocating delivery costs to customers. Although one cost clearly relates to travel
time within a particular route, another variable cost reflects the time required to unload the
cases of soft drink at the delivery point. To begin, management decided to develop a regression
model to predict delivery time based on the number of cases delivered. A sample of 7 deliveries
within a territory was selected. The delivery times and the number of cases delivered were
organized in the following table:
Customer No. of Cases Delivery
Time
1
14
24
16
31
3
17
28
4
19
30
5
11
20
6
16
22
7
24
40
a) Use the least-squares method to compute the regression coefficients.
b) Write down the estimated equation and interpret the meaning of the coefficients in this
problem
c) Predict the mean delivery time for 26 cases of soft drink.
d) Determine the value of the extent of relationship between delivery time and…
4. Housing Prices in New YorkWe have looked at predicting the price (in s) of New York homes based on the size (in thousands of square feet), using the data in HomesForSaleNY. Two other variables in the dataset are the number of bedrooms and the number of bathrooms. Use technology to create a multiple regression model to predict price based on all three variables: size, number of bedrooms, and number of bathrooms.
Price
Size
Beds
Baths
145
1.3
3
1.5
875
2.9
7
3.75
300
1.5
3
2.5
370
1.1
2
1
268
1.5
2
2
1399
4.8
6
5
1125
3.1
3
2.5
299
1.4
3
2
110
1.2
3
1
2999
6
7
8
170
1
2
1
269
1.5
3
1.5
150
1
2
1.5
288
1.8
3
2.1
350
1.3
3
2
120
0.9
1
1
309
2.4
4
2.5
1500
1.5
2
1.5
635
2.5
4
2.5
350
0.9
2
1
459
1.8
4
2.5
275
2.9
4
1.5
275
1.8
3
2
2500
3.7
3
3
187
1.4
3
1.5
238
1.7
3
1.5
155
0.7
1
1
175
1.6
3
1.5
569
3.2
4
2
105
1.2
2
2.5
a) Which of the variables which are significant at the 5% level?
b) Which variable is the most…
Chapter 13 Solutions
Basic Business Statistics, Student Value Edition
Ch. 13 - Prob. 1PSCh. 13 - If the values of X in Problem 13.1 from 2 to 25,...Ch. 13 - Fitting a straight line to a set data yields the...Ch. 13 - The production of wine is a multibillion-dollar...Ch. 13 - Zagat’s publisher restaurant rating for various...Ch. 13 - Is an MBA a golden ticket? Pursuing an MBA is a...Ch. 13 - Starbucks Coffee Co. uses a data-based approach to...Ch. 13 - The value of a sports franchise is directly...Ch. 13 - An agent for a residential real estate company in...Ch. 13 - A box office analyst seeks to predict opening...
Ch. 13 - How do you interpret a coefficient by of...Ch. 13 - If SSR= 36 and SSE=4, determine SST and then...Ch. 13 - If SSR=66 and SST=88, Compute the coefficient of...Ch. 13 - If SSE= 10 and SSR=30, compute the coefficient of...Ch. 13 - If SSR=120, Why is it impossible for SST to equal...Ch. 13 - In problem 13.4 on page 493, the percentage of...Ch. 13 - In problem 13.5 on page 493, you used the summated...Ch. 13 - In Problem 13.6 on page 494, a prospective MBA...Ch. 13 - In Problem 13.7 on page 494, you used the plate...Ch. 13 - In problem 13.8 on page 494, you used annual...Ch. 13 - In problem 13.9 on page 494, an agent for a real...Ch. 13 - In problem 13.10 on page 494, you used You tube...Ch. 13 - The following results provide the X Values,...Ch. 13 - The following results show the X Values,...Ch. 13 - In problem 13.5 on page 493, you used the summated...Ch. 13 - In problem 13.4 on page 493, you used the...Ch. 13 - In problem 13.7 on page 494, you used the plate...Ch. 13 - In problem 13.6 on page 494, a prospective MBA...Ch. 13 - In problem 13.9 on page 494, an agent for a real...Ch. 13 - Prob. 30PSCh. 13 - Prob. 31PSCh. 13 - The residuals for 10 consecutive time periods are...Ch. 13 - The residuals for 15 consecutive time periods are...Ch. 13 - In Problem 13.7 on page 494 concerning the...Ch. 13 - What is the relationship between the price of...Ch. 13 - Prob. 36PSCh. 13 - A freshly brewed shot of espresso has three...Ch. 13 - The owners of a chain of ice cream stores have the...Ch. 13 - You are testing the null hypothesis that there is...Ch. 13 - Prob. 40PSCh. 13 - Prob. 41PSCh. 13 - In problem 13.4 on page 493, you used the...Ch. 13 - Prob. 43PSCh. 13 - In problem 13.6 on page 494, a prospective MBA...Ch. 13 - In Problem 13.7 on page 494, you used the plate...Ch. 13 - Prob. 46PSCh. 13 - In Problem 13.9 on page 494, an agent for a real...Ch. 13 - In Problem 13.10 on page 494, you used you used...Ch. 13 - The volatility of a stock is often measured by its...Ch. 13 - Prob. 50PSCh. 13 - Prob. 51PSCh. 13 - Movie companies need to predict the gross receipts...Ch. 13 - Prob. 53PSCh. 13 - Prob. 54PSCh. 13 - Prob. 55PSCh. 13 - Based on a sample of n=20, the latest-squares...Ch. 13 - Prob. 57PSCh. 13 - In Problem 13.4 on page 493, you used the...Ch. 13 - In Problem 13.7 on page 494, you used the plate...Ch. 13 - In Problem 13.6 on page 494, a prospective MBA...Ch. 13 - Prob. 61PSCh. 13 - Prob. 62PSCh. 13 - In problem 13.10 on page 494, you used YouTube...Ch. 13 - Prob. 64PSCh. 13 - Prob. 65PSCh. 13 - When is the unexplained variation (i.e., error sum...Ch. 13 - Prob. 67PSCh. 13 - Prob. 68PSCh. 13 - Prob. 69PSCh. 13 - How do you evaluate the assumptions of regression...Ch. 13 - When and how do you use the Durbin-Watson...Ch. 13 - Prob. 72PSCh. 13 - Can you use movie critics’ opinions to forecast...Ch. 13 - Management of a soft-drink botting company has the...Ch. 13 - Measuring the height of a California redwood tree...Ch. 13 - You want to develop a model to predict the asking...Ch. 13 - You want to develop a model to predict the taxes...Ch. 13 - An analyst has the objective of predicting the...Ch. 13 - An accountant for a large department store has the...Ch. 13 - On January 28, 1986, the space shuttle Challenger...Ch. 13 - A baseball analyst would like to study various...Ch. 13 - Can you use the annual revenues generated by...Ch. 13 - In Problem 13.82 you used annual revenue to...Ch. 13 - During the fall harvest season in the United...Ch. 13 - Refer to the discussion of beta values and market...Ch. 13 - The file CEO 2016 includes the total compensation...Ch. 13 - In Problem 13.8, 13.20, 13.30, 13.46, 13.62,...
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
- A 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_forwardThe general manager of an engineering firm wants to know whether a technical artist's experience influences the quality of his or her work. A random sample of 24 artists is selected and their years of work experience and quality rating (as assessed by their supervisors) recorded. Work experience (EXPER) is measured in years and quality rating (RATING) takes a value of 1 through 7, with 7 = excellent and 1 = poor. The simple regression model RATING = ẞ1 + ẞ₂EXPER+ € is proposed. The least squares estimates of the model, and the standard errors of the estimates, are RATING= 3.204 +0.076EXPER (se) (0.709) (0.044) (a) Interpret the coefficient of EXPER. (b) Construct a 95% confidence interval for B2, the slope of the relationship between quality rating and experience. In what are you 95% confident? (c) Test the null hypothesis that ẞ2 is zero against the alternative that it is not using a two-tail test and the α = 0.05 level of significance. What do you conclude? (d) Test the null…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
- Bill 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_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 regression equation for all the predictors? Write a results section based on your analysis that answers the research question.arrow_forwardIn 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…arrow_forward
- An 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_forwardThe St. Lucian Government is interested in predicting the number of weekly riders on the public buses using the following variables: • • • • Price of bus trips per weekThe population in the cityThe monthly income of ridersAverage rate to park your personal vehicle Determine the multiple regression equation for the data. What is the predicted value of the number of weekly riders if: price of bus trips per week = $24; population = $2,000,000; the monthly income of riders = $13,500; and average rate to park your personal vehicle = $150. Interpret the coefficient of determination.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
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
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
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