Question: Management of a soft-drink bottling company
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 and stored in Delivery .
a. Use the least-squares method to compute the regression coefficients b0 and b1.
b. Interpret the meaning of b0 and b1 in this problem.
c. Predict the mean delivery time for 150 cases of soft drink.
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, r2, and explain its meaning in this problem.
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 95% confidence interval estimate of the mean delivery time for 150 cases of soft drink and a 95% prediction interval of the delivery time for a single delivery of 150 cases of soft drink.
i. What conclusions can you reach from (a) through (h) about the relationship between the number of cases and delivery time?
Transcribed Image Text:
Delivery Delivery Number Time Number Time Customer of Cases (minutes) Customer of Cases (minutes) 1 52 32.1 11 161 43.0 2 64 34.8 12 184 49.4 3 73 36.2 13 202 57.2 4 85 37.8 14 218 56.8 5 95 37.8 15 243 60.6 103 39.7 16 254 61.2 7 116 38.5 17 267 58.2 8 121 41.9 18 275 63.1 143 44.2 19 287 65.6 10 157 47.1 20 298 67.3
> Undergraduate students at Miami University in Oxford, Ohio, were surveyed in order to evaluate the effect of price on the purchase of a pizza from Pizza Hut. Students were first asked to imagine a situation in which they were planning to call and order f
> Referring to Problem 14.41 on page 567, you have decided to analyze whether there are differences in fixed acidity, chlorides, and pH between white wines and red wines (0 = white 1 = red). Using the data stored in RedandWhite , a. Develop a logistic regr
> A study was conducted to determine the factors involved in the rate of participation of discharged cardiac patients in a rehabilitation program. Data were collected from 516 treated patients. Source: Data extracted from F. Van Der Meulen, T. Vermaat, and
> Refer to Figure 14.14 on page 571. a. Predict the probability that a cardholder who charged $36,000 last year and does not have any additional credit cards for other authorized users will purchase the platinum card during the marketing campaign. b. Compa
> Consider the following logistic regression equation: ln (Estimated odds ratio) = 0.1 + 0.5X1i + 0.2X2i a. Interpret the meaning of the logistic regression coefficients. b. If X1 = 2 and X2 = 1.5, compute the estimated odds ratio and interpret its meaning
> Given an estimated odds ratio of 0.75, compute the estimated probability of an event of interest.
> Given an estimated odds ratio of 2.5, compute the estimated probability of an event of interest.
> An experiment was conducted to study the extrusion process of biodegradable packaging foam. Two of the factors considered for their effect on the unit density (mg>ml) were the die temperature (145 °C vs. 155 °C) and the die diameter (3 mm vs. 4 mm). The
> Interpret the meaning of a slope coefficient equal to 2.2 in logistic regression.
> The production of wine is a multibillion-dollar worldwide industry. In an attempt to develop a model of wine quality as judged by wine experts, data was collected from red wine variants of Portuguese “Vinho Verde” wine. A sample of 50 wines is stored in
> The director of a training program for a large insurance company has the business objective of determining which training method is best for training underwriters. The three methods to be evaluated are classroom, online, and courseware app. The 30 traine
> In Problem 14.7 on page 542, you used weekly staff count and remote hours to predict standby hours (stored in Nickels26Weeks ). Develop a regression model to predict standby hours that includes total staff present, remote hours, and the interaction of to
> In Problem 14.5 on page 542, the percentage of alcohol and chlorides were used to predict the quality of red wines (stored in VinhoVerde ). Develop a regression model that includes the percentage of alcohol, the chlorides, and the interaction of the perc
> In Problem 14.6 on page 542, you used full-time voluntary turnover (%), and total worldwide revenue ($billions) to predict number of full-time job openings (stored in BestCompanies ). Develop a regression model to predict the number of full-time job open
> Zagat’s publishes restaurant ratings for various locations in the United States. The file Restaurants contains the Zagat rating for food, décor, service, and cost per person for a sample of 50 center city restaurants and 50 metro area restaurants. Source
> In Problem 14.4 on page 541, you used efficiency ratio and total risk-based capital to predict ROAA at a community bank (stored in CommunityBanks ). Develop a regression model to predict ROAA that includes efficiency ratio, total risk-based capital, and
> The owner of a moving company typically has his most experienced manager predict the total number of labor hours that will be required to complete an upcoming move. This approach has proved useful in the past, but the owner has the business objective of
> In mining engineering, holes are often drilled through rock, using drill bits. As a drill hole gets deeper, additional rods are added to the drill bit to enable additional drilling to take place. It is expected that drilling time increases with depth. Th
> Given the results from Problem 11.20, a. at the 0.05 level of significance, is there an effect due to factor A? b. at the 0.05 level of significance, is there an effect due to factor B? c. at the 0.05 level of significance, is there an interaction effect
> In Problem 14.5 on page 542, you developed a multiple regression model to predict wine quality for red wines. Now, you wish to determine whether there is an effect on wine quality due to whether the wine is white (0) or red (1). These data are organized
> A real estate association in a suburban community would like to study the relationship between the size of a single-family house (as measured by the number of rooms) and the selling price of the house (in $thousands). Two different neighborhoods are incl
> Profitability remains a challenge for banks and thrifts with less than $2 billion of assets. The business problem facing a bank analyst relates to the factors that affect return on average assets (ROAA), an indicator of how profitable a company is relati
> The chair of the accounting department plans to develop a regression model to predict the grade point average in accounting for those students who are graduating and have completed the accounting major, based on a student’s SAT score and whether the stud
> Suppose X1 is a numerical variable and X2 is a dummy variable with two categories and the regression equation for a sample of n = 20 is a. Interpret the regression coefficient associated with variable X1. b. Interpret the regression coefficient associa
> In Problem 14.8 on page 542, you used land area of a property and age of a house to predict the fair market value (stored in GlenCove ). Using the results from that problem, a. at the 0.05 level of significance, determine whether each independent variabl
> In Problem 14.6 on page 542, you used full-time voluntary turnover (%), and total worldwide revenue ($billions) to predict the number of full-time job openings (stored in BestCompanies). Using the results from that problem, a. at the 0.05 level of signi
> In Problem 14.7 on page 542, you used the weekly staff count and remote engineering hours to predict standby hours (stored in Nickels26Weeks ). Using the results from that problem, a. at the 0.05 level of significance, determine whether each independent
> In Problem 14.4 on page 541, you used efficiency ratio and total risk-based capital to predict ROAA at a community bank (stored in CommunityBanks ). Using the results from that problem, a. at the 0.05 level of significance, determine whether each indepen
> In Problem 14.5 on page 542, you used alcohol percentage and chlorides to predict wine quality (stored in VinhoVerde ). Using the results from that problem, a. at the 0.05 level of significance, determine whether each independent variable makes a signifi
> Given a two-factor factorial experiment and the ANOVA summary table that follows, fill in all the missing results: Degrees of Freedom Sum of Mean Square Squares Source (Variance) F FsTaT = ? MSB = ? FSTAT = 11.0 A r - 1 = 2 SSA = ? MSA = 80 B c - 1
> The following is the ANOVA summary table for a multiple regression model with two independent variables: If SSR(X1) = 20 and SSR(X2) = 15, a. determine whether there is a significant relationship between Y and each independent variable at the 0.05 leve
> The following is the ANOVA summary table for a multiple regression model with two independent variables: If SSR(X1) = 45 and SSR(X2) = 25, a. determine whether there is a significant relationship between Y and each independent variable at the 0.05 leve
> In Problem 14.8 on page 542, you used land area of a property and age of a house to predict the fair market value (stored in GlenCove ). Using the results from that problem, a. construct a 95% confidence interval estimate of the population slope between
> A nonprofit analyst seeks to determine which variables should be used to predict nonprofit charitable commitment, a nonprofit organization commitment to its charitable purpose. Two independent variables under consideration are Revenue, a measurement of t
> In Problem 14.7 on page 542, you used the weekly staff present and remote engineering hours to predict standby hours (stored in Nickels26Weeks). Using the results from that problem, a. construct a 95% confidence interval estimate of the population slope
> In Problem 14.6 on page 542, you used full-time voluntary turnover (%) and total worldwide revenue ($billions) to predict the number of full-time job openings (stored in BestCompanies ). Using the results from that problem, a. construct a 95% confidence
> In Problem 14.5 on page 542, you used the percentage of alcohol and chlorides to predict wine quality (stored in VinhoVerde ). Using the results from that problem, a. construct a 95% confidence interval estimate of the population slope between wine quali
> In Problem 14.4 on page 541, you used efficiency ratio and total risk-based capital to predict ROAA at a community bank (stored in CommunityBanks ). Using the results from that problem, a. construct a 95% confidence interval estimate of the population sl
> In Problem 13.82 you used annual revenue to develop a model to predict the franchise value of National Basketball Association (NBA) teams. Can you also use the annual revenues generated by European soccer teams to predict franchise values? (European socc
> Can you use the annual revenues generated by National Basketball Association (NBA) franchises to predict franchise values? Figure 2.17 on page 68 shows a scatter plot of revenue with franchise value, and Figure 3.10 on page 148, shows the correlation coe
> Given a two-way ANOVA with two levels for factor A, five levels for factor B, and four replicates in each of the 10 cells, with SSA = 18, SSB = 64, SSE = 60, and SST = 150, a. form the ANOVA summary table and fill in all values in the body of the table.
> A baseball analyst would like to study various team statistics for a recent season to determine which variables might be useful in predicting the number of wins achieved by teams during the season. He begins by using a team’s earned run average (ERA), a
> On January 28, 1986, the space shuttle Challenger exploded, and seven astronauts were killed. Prior to the launch, the predicted atmospheric temperature was for freezing weather at the launch site. Engineers for Morton Thiokol (the manufacturer of the ro
> An accountant for a large department store has the business objective of developing a model to predict the amount of time it takes to process invoices. Data are collected from the past 32 working days, and the number of invoices processed and completion
> An analyst has the objective of predicting the return on average tangible common equity (ROATCE) of banks. The analyst begins by using efficiency ratio, a measure of a bank’s ability to turn resources into revenue. A sample of 100 American banks is selec
> In Problem 14.3 on page 541, you predicted nonprofit charitable commitment, based on nonprofit revenue (Revenue) and fundraising efficiency (Efficiency) for a sample of 98 nonprofit organizations. Use the following results: a. Construct 95% confidence
> You want to develop a model to predict the taxes of houses, based on asking price. A sample of 61 single-family houses listed for sale in Silver Spring, Maryland, a suburb of Washington, DC, is selected. The taxes (in $) and the asking price of the house
> You want to develop a model to predict the asking price of homes based on their size. A sample of 61 single-family houses listed for sale in Silver Spring, Maryland, a suburb of Washington, DC, is selected to study the relationship between asking price (
> Measuring the height of a California redwood tree is very difficult because these trees grow to heights of over 300 feet. People familiar with these trees understand that the height of a California redwood tree is related to other characteristics of the
> Can you use movie critics’ opinions to forecast box office receipts on the opening weekend? The following data, stored in Tomatometer , indicate the Tomatometer rating, the percentage of professional critic reviews that are positive, an
> Given the results from Problems 11.15 through 11.17, a. at the 0.05 level of significance, is there an effect due to factor A? b. at the 0.05 level of significance, is there an effect due to factor B? c. at the 0.05 level of significance, is there an int
> A manufacturer of pens has hired an advertising agency to develop an advertising campaign for the upcoming holiday season. To prepare for this project, the research director decides to initiate a study of the effect of advertising on product perception.
> The more costly and time-consuming it is to export and import, the more difficult it is for local companies to be competitive and to reach international markets. As part of an initial investigation exploring foreign market entry, 10 countries were select
> One of the steps involved in the processing of corn flakes for cereals involves toasting the flakes. The file CornFlakes contains the following data for corn flakes thickness (mm) for four different toasting times (seconds). Source: Data extracted from
> You are working with the same experiment as in Problem 11.5. a. At the 0.05 level of significance, state the decision rule for testing the null hypothesis that all four groups have equal population means. b. What is your statistical decision? c. At th
> Consider an experiment with four groups, with eight values in each. For the ANOVA summary table below, fill in all the missing results: Mean Degrees of Sum of Square (Variance) Source Freedom Squares F Among c - 1 = ? SSA = ? MSA = 80 FSTAT ? group
> Consider an experiment with three groups, with seven values in each. a. How many degrees of freedom are there in determining the among-group variation? b. How many degrees of freedom are there in determining the within-group variation? c. How many deg
> In Problem 14.7 on page 542, you used the weekly staff count and remote engineering hours to predict standby hours (stored in Nickels26Weeks ). Using the results from that problem, a. determine whether there is a significant relationship between standby
> You are working with the same experiment as in Problems 11.1 and 11.2. a. Construct the ANOVA summary table and fill in all values in the table. b. At the 0.05 level of significance, what is the upper-tail critical value from the F distribution? c. St
> You are working with the same experiment as in Problem 11.1. a. If SSA = 60 and SST = 210, what is SSW? b. What is MSA? c. What is MSW? d. What is the value of FSTAT? Problem 11.1: An experiment has a single factor with five groups and seven values
> An experiment has a single factor with five groups and seven values in each group. a. How many degrees of freedom are there in determining the among-group variation? b. How many degrees of freedom are there in determining the within-group variation? c
> Do Americans trust advertisements? A survey by YouGov asked Americans who view advertisements at least once a month how honest the advertisements that they see, read, and hear are. The results were: a. At the 0.05 level of significance, is there evide
> Business leaders around the world are becoming aware of the huge potential of digital transformation. Fujitsu conducted as global survey to find out more about how business leaders are responding to the digital transformation revolution. To assess the ex
> What social media tools do marketers commonly use? The Social Media Examiner surveyed marketers who commonly use an indicated social media tool. Surveyed were both B2B marketers, marketers that focus primarily on attracting businesses, and B2C marketers,
> Undergraduate students at Miami University in Oxford, Ohio, were surveyed in order to evaluate the effect of gender and price on purchasing a pizza from Pizza Hut. Students were told to suppose that they were planning to have a large two-topping pizza de
> Under what conditions should you use the Kruskal-Wallis rank test instead of the one-way ANOVA?
> Under what conditions should you use the Wilcoxon rank sum test instead of the t test for the difference between the means?
> Under what conditions should you use the χ2 test of independence?
> In Problem 14.4 on page 541, you used efficiency ratio and total risk-based capital to predict ROAA at a community bank (stored in CommunityBanks ). Using the results from that problem, a. determine whether there is a significant relationship between RO
> Under what conditions should you use the χ2 test to determine whether there is a difference among the proportions of more than two independent populations?
> Under what conditions should you use the χ2 test to determine whether there is a difference between the proportions of two independent populations?
> The more costly and time consuming it is to export and import, the more difficult it is for local companies to be competitive and to reach international markets. As part of an initial investigation exploring foreign market entry, 10 countries were select
> A transportation strategist wanted to compare the traffic congestion levels across four continents: Asia, Europe, North America, and South America. The file CongestionLevel contains congestion level, defined as the increase (%) in overall travel time whe
> An advertising agency has been hired by a manufacturer of pens to develop an advertising campaign for the upcoming holiday season. To prepare for this project, the research director decides to initiate a study of the effect of advertising on product perc
> QSR magazine reports on the largest quick-serve and fast-casual brands in the United States. The file FastFoodChain contains the food segment (burger, chicken, sandwich, or pizza/pasta) and U.S. mean sales per unit ($thousands) for each of 37 quick-servi
> A hospital conducted a study of the waiting time in its emergency room. The hospital has a main campus, along with three affiliated locations. Management had a business objective of reducing waiting time for emergency room cases that did not require imme
> A pet food company has the business objective of expanding its product line beyond its current kidney and shrimp-based cat foods. The company developed two new products—one based on chicken livers and the other based on salmon. The company conducted an e
> For this problem, use the results of Problem 12.43. a. State the decision rule for testing the null hypothesis that all six groups have equal population medians. b. What is your statistical decision if the computed value of the test statistic H is 13.77?
> What is the upper-tail critical value from the chi-square distribution if you use the Kruskal-Wallis rank test for comparing the medians in six populations at the 0.01 level of significance?
> Problem 14.5 on page 542, you used the percentage of alcohol and chlorides to predict wine quality (stored in VinhoVerde ). Use the results from that problem to do the following: a. Determine whether there is a significant relationship between wine qual
> The annual NFL Super Bowl is the most widely watched sporting event in the United States each year. In recent years, there has been a great deal of interest in the ads that appear during the game. These ads vary in length with most lasting 30 seconds or
> A bank with a branch located in a commercial district of a city has developed an improved process for serving customers during the noon-to-1 p.m. lunch period. The bank has the business objective of reducing the waiting time (defined as the number of min
> Brand valuations are critical to CEOs, financial and marketing executives, security analysts, institutional investors, and others who depend on well-researched, reliable information for assessments and comparisons in decision making. WPP and Millward Bro
> The lengths of life (in hours) of a sample of 40 6-watt light emitting diode (LED) light bulbs produced by Manufacturer A and a sample of 40 6-watt LED light bulbs produced by Manufacturer B are stored in Bulbs . a. Using a 0.05 level of significance, is
> The management of a hotel has the business objective of increasing the return rate for hotel guests. One aspect of first impressions by guests relates to the time it takes to deliver a guest’s luggage to the room after check-in to the hotel. A random sam
> Is there a difference in the satisfaction rating of traditional cellphone providers who bill for service at the end of a month often under a contract and prepaid cellphone service providers who bill in advance without a contract? The file CellphoneProvid
> Wine experts Gaiter and Brecher use a six-category scale when rating wines: Yech, OK, Good, Very Good, Delicious, and Delicious! Suppose Gaiter and Brecher tested wines from a random sample of eight inexpensive California Cabernets and a random sample of
> A vice president for marketing recruits 20 college graduates for management training. Each of the 20 individuals is randomly assigned to one of two groups (10 in each group). A “traditional” method of training (T) is used in one group, and an “experiment
> In Problems 12.32 and 12.33, what is your statistical decision? Problem 12.33: From Problem 12.32, at the 0.05 level of significance, determine the lower-tail critical value for the Wilcoxon rank sum test statistic, T1, if you want to test the null hypo
> From Problem 12.32, at the 0.05 level of significance, determine the lower-tail critical value for the Wilcoxon rank sum test statistic, T1, if you want to test the null hypothesis, H0: M1 ≥ M2, against the one-tail alternative, H1: M1 < M2. Problem 12.
> In Problem 14.3 on page 541, you predicted nonprofit charitable commitment, based on nonprofit revenue and fundraising efficiency. The regression analysis resulted in this ANOVA table: Determine whether there is a significant relationship between comm
> The following information is available for two samples selected from independent and similarly shaped right-skewed populations: Sample 1: n1 = 5 1.1 2.3 2.9 3.6 14.7 Sample 2: n2 = 6 2.8 4.4 4.4 5.2 6.0 18.5 a. Replace the observed values with the corr
> In Problems 12.29 and 12.30, what is your statistical decision? In Problem 12.29, what are the lower- and upper-tail critical values for the test statistic T1 from Table E.6 if you use a 0.05 level of significance and the alternative hypothesis is H1: M
> In Problem 12.29, what are the lower- and upper-tail critical values for the test statistic T1 from Table E.6 if you use a 0.05 level of significance and the alternative hypothesis is H1: M1 ≠M2? Problem 12.29: The following informati
> The following information is available for two samples selected from independent populations: Sample 1: n1 = 7 Assigned ranks: 4 1 8 2 5 10 11 Sample 2: n2 = 9 Assigned ranks: 7 16 12 9 3 14 13 6 15 What is the value of T1 if you are testing the null h
> Using Table E.6, determine the lower-tail critical value for the Wilcoxon rank sum test statistic, T1, in each of the following one-tail tests: a. α = 0.05, n1 = 6, n2 = 8 b. α = 0.025, n1 = 6, n2 = 8 c. α = 0.01
> Using Table E.6, determine the lower- and upper-tail critical values for the Wilcoxon rank sum test statistic, T1, in each of the following two-tail tests: a. α = 0.10, n1 = 6, n2 = 8 b. α = 0.05, n1 = 6, n2 = 8 c. Î&plu
> PwC takes a closer look at what CEOs are looking for and are finding as new sources of value in their businesses and industries. Based on a 2017 Global CEO survey, CEOs are categorized by the main activity they identified that would strengthen their comp
> What makes sales leaders tick? Mercuri International conducted a study to explore sales strategies, processes, and support systems within businesses. Organizations were categorized by sales performance level (top performers vs. middle performers vs. bott
> How often do Facebook users post? A study by the Pew Research Center revealed the following results: At the 0.01 level of significance, is there evidence of a significant relationship between frequency of posting on Facebook and age?
