Statistics for Business and Economics (13th Edition)
13th Edition
ISBN: 9780134506593
Author: James T. McClave, P. George Benson, Terry Sincich
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 11, Problem 11.117ACI
Forecasting managerial needs. Managers are an important part of any organization's resource base. Accordingly, the organization should be just as concerned about forecasting its future managerial needs as it is with forecasting its needs for. say. the natural resources used in its production process (Northcraft and Neale, Organizational Behavior: A Management Challenge, 2001). A common forecasting procedure is to model the relationship between sales and the number of managers needed. To develop this relationship, the data shown in the following table are collected from a firm’s records.
- a. Test the usefulness of the model. Use α = .05. State your conclusion in the context of the problem.
- b. The company projects that it will sell 39 units next month. Use the least squares model to construct a 90% prediction interval for the number of managers needed next month.
- c. Interpret the interval in part b. Use the interval to determine the reliability of the firm's projection.
Units Sold, x | Managers, y |
5 | 10 |
4 | 11 |
8 | 10 |
7 | 10 |
9 | 9 |
15 | 10 |
20 | 11 |
21 | 17 |
25 | 19 |
24 | 21 |
30 | 22 |
31 | 25 |
36 | 30 |
38 | 30 |
40 | 31 |
41 | 31 |
51 | 32 |
40 | 30 |
48 | 32 |
47 | 32 |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Briefly explain how the organization forecast sales for its products.a. Using historical sales data, choose a quantitative technique to forecast sales for thatorganisation for the next sales period. Comment on the appropriateness of thetechnique used.b. Describe three strategies that the organization uses to compete and comment on theappropriateness of these strategies
Using the actual sales (in units) over the past 15 months, a demand planner at a leading e-commerce firm has
forecasted the demand for a popular consumer product as shown below. Forecast 1 and Forecast 2 represent the
outputs of two comparative forecasting methods currently used by the sales and marketing, and operations
departments of the firm.
Month
October 22
November 22
December 22
January 23
February 23
March 23
April 23
May 23
June 23
July 23
August 23
September 23
October 23
November 23
December 23
Actual sales (units)
120 000
138 000
172 000
120 000
114 000
98 000
118 000
112 000
132 000
138 000
108 000
126 000
144 000
162 000
189 000
QUESTION 24
Determine the mean absolute deviation of Forecast 1.
A 234 290 units
a 18 721 units
c 19 524 units
22 670 units
QUESTION 25
Determine the mean absolute deviation of Forecast 2.
A 21 638 units
a 35 280 units
c. 19 330 units
23 600 units
Forecast 1 (units)
133 280
130 620
127
300
121 440
120 750
119 000
121 600
124 900
121 500
122400
126…
Compare the primary types of forecasting methods used to determine demand.
Chapter 11 Solutions
Statistics for Business and Economics (13th Edition)
Ch. 11.1 - In each case, graph the line that passes through...Ch. 11.1 - Give the slope and y-intercept for each of the...Ch. 11.1 - The equation for a straight line (deterministic...Ch. 11.1 - Refer to Exercise 11.3. Find the equations of the...Ch. 11.1 - Plot the following lines: a. y 4 + x b. y = 5 2x...Ch. 11.1 - Give the slope and y-intercept for each of the...Ch. 11.1 - Prob. 11.7LMCh. 11.1 - Prob. 11.8LMCh. 11.1 - If a straight-line probabilistic relationship...Ch. 11.1 - Congress voting on women's issues. The American...
Ch. 11.1 - Best-paid CEOs. Refer to Glassdoor Economic...Ch. 11.1 - Estimating repair and replacement costs of water...Ch. 11.1 - Forecasting movie revenues with Twitter. A study...Ch. 11.2 - The following table is similar to Table 11.2.It is...Ch. 11.2 - Refer to Exercise 11.14. After the least squares...Ch. 11.2 - Construct a scatterplot for the data in the...Ch. 11.2 - Consider the following pairs of measurements: a....Ch. 11.2 - Use the applet Regression by Eye to explore the...Ch. 11.2 - In business, do nice guys finish first or last?...Ch. 11.2 - State Math SAT scores. Refer to the data on...Ch. 11.2 - Lobster fishing study. Refer to the Bulletin of...Ch. 11.2 - Repair and replacement costs of water pipes. Refer...Ch. 11.2 - Joint Strike Fighter program. The Joint Strike...Ch. 11.2 - Software millionaires and birthdays. In Outliers:...Ch. 11.2 - Prob. 11.24ACICh. 11.2 - Ranking driving performance of professional...Ch. 11.2 - Sweetness of orange juice. The quality of the...Ch. 11.2 - Forecasting movie revenues with Twitter. Marketers...Ch. 11.2 - Charisma of top-level leaders. According to a...Ch. 11.2 - Ran kings of research universities. Refer to the...Ch. 11.2 - Prob. 11.30ACACh. 11.3 - Visually compare the scatterplots shown below. If...Ch. 11.3 - Calculate SSE and s2 for each of the following...Ch. 11.3 - Suppose you fit a least squares line to 26 data...Ch. 11.3 - Refer to Exercise 11.14 (p. 629). Calculate SSE,...Ch. 11.3 - Do nice guys really finish last in business? Refer...Ch. 11.3 - State Math SAT scores. Refer to the simple linear...Ch. 11.3 - Prob. 11.37ACBCh. 11.3 - Prob. 11.38ACBCh. 11.3 - Prob. 11.39ACBCh. 11.3 - Prob. 11.40ACICh. 11.3 - Prob. 11.41ACICh. 11.3 - Sweetness of orange juice. Refer to the study of...Ch. 11.3 - Rankings of research universities. Refer to the...Ch. 11.3 - Life tests of cutting tools. To Improve the...Ch. 11.4 - Construct both a 95% and a 90% confidence interval...Ch. 11.4 - Consider the following pairs of observations: a....Ch. 11.4 - Refer to Exercise 11.46. Construct an 80% and a...Ch. 11.4 - Do the accompanying data provide sufficient...Ch. 11.4 - State Math SAT Scores. Refer to the SPSS simple...Ch. 11.4 - Lobster fishing study. Refer to the Bulletin of...Ch. 11.4 - Prob. 11.51ACBCh. 11.4 - Prob. 11.52ACBCh. 11.4 - Estimating repair and replacement costs of water...Ch. 11.4 - Prob. 11.54ACBCh. 11.4 - Prob. 11.55ACICh. 11.4 - Beauty and electoral success. Are good looks an...Ch. 11.4 - Prob. 11.57ACICh. 11.4 - Prob. 11.58ACICh. 11.4 - Prob. 11.59ACICh. 11.4 - Prob. 11.60ACICh. 11.4 - Rankings of research universities. Refer to the...Ch. 11.4 - Prob. 11.62ACACh. 11.4 - Does elevation impact hitting performance in...Ch. 11.5 - Explain what each of the following sample...Ch. 11.5 - Describe the slope of the least squares line if a....Ch. 11.5 - Construct a scatterplot for each data set. Then...Ch. 11.5 - Calculate r2 for the least squares line in each of...Ch. 11.5 - Use the applet Correlation by Eye to explore the...Ch. 11.5 - In business, do nice guys finish first or last?...Ch. 11.5 - Going for it on fourth-down in the NFL Each week...Ch. 11.5 - Lobster fishing study. Refer to the Bulletin of...Ch. 11.5 - RateMyProfessors.com. A popular Web site among...Ch. 11.5 - Last name and acquisition timing. Refer to the...Ch. 11.5 - Women in top management. An empirical analysis of...Ch. 11.5 - Prob. 11.74ACICh. 11.5 - Prob. 11.75ACICh. 11.5 - Prob. 11.76ACICh. 11.5 - Prob. 11.77ACICh. 11.5 - Prob. 11.78ACICh. 11.5 - Evaluation of an imputation method for missing...Ch. 11.5 - Prob. 11.80ACICh. 11.5 - Prob. 11.81ACACh. 11.6 - Consider the followings of measurements: a...Ch. 11.6 - Consider the pairs of measurements shown in the...Ch. 11.6 - In fitting a least squares line to n = 10 data...Ch. 11.6 - Prob. 11.86ACBCh. 11.6 - Prob. 11.87ACBCh. 11.6 - Prob. 11.88ACBCh. 11.6 - Prob. 11.89ACBCh. 11.6 - Prob. 11.90ACBCh. 11.6 - Prob. 11.91ACICh. 11.6 - Ranking driving performance of professional...Ch. 11.6 - Spreading rate of spilled liquid Refer to the...Ch. 11.6 - Removing nitrogen from toxic wastewater. Highly...Ch. 11.6 - Predicting quit rates In manufacturing The reasons...Ch. 11.6 - Life tests of cutting tools Refer to the data...Ch. 11.7 - Prices of recycled materials. Prices of recycled...Ch. 11.7 - Thickness of dust on solar cells. The performance...Ch. 11.7 - Management research In Africa. The editors of the...Ch. 11.7 - An MBAs work-life balance. The importance of...Ch. 11 - In fitting a least squares line ton= 15 data...Ch. 11 - Consider the following sample data. a. Construct a...Ch. 11 - Consider the following 10 data points. a. Plot the...Ch. 11 - Drug controlled-release rate study. The effect of...Ch. 11 - Metaskills and career management. Effective...Ch. 11 - Burnout of human services professionals. Emotional...Ch. 11 - Retaliation against company whistle-blowers....Ch. 11 - Extending the life of an aluminum smelter pot. An...Ch. 11 - Diamonds sold at retail. Refer to the Journal of...Ch. 11 - Sports news on local TV broadcasts. The Sports...Ch. 11 - Evaluating managerial success. An observational...Ch. 11 - Doctors and ethics. Refer to the Journal of...Ch. 11 - FCAT scores and poverty. In the state of Florida,...Ch. 11 - Monetary values of NFL teams. Refer to the Forbes...Ch. 11 - Evaluating a truck weigh-in-motion program. The...Ch. 11 - Energy efficiency of buildings. Firms conscious of...Ch. 11 - Forecasting managerial needs. Managers are an...Ch. 11 - Prob. 11.118ACACh. 11 - Prob. 11.119CTCCh. 11 - Prob. 11.120CTC
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
- The busiest time of the day at the Taco Town fast-food restaurant is between 11:00 A.M. and 2:00 P.M. Taco Town’s service is very labor dependent, and a critical factor for providing quick service is the number of employees on hand during this 3-hour period. To determine the number of employees it needs during each hour of the 3-hour lunch period, Taco Town requires an accurate forecasting model. Following are the number of customers served at Taco Town during each hour of the lunch period for the past 20 weekdays: Develop a forecast model that you believe will best forecast Taco Town’s customer demand for the next day and explain why you selected this model.arrow_forwardTo what extent do data and information have an impact on one another?arrow_forwardThe business problem facing the director of broadcasting operations for a television station was the issue of standby hours (i.e. hours in which unionized graphic artists at the station are paid but are not actually involved in any activity) and what factors were related to standby hours. A study of standby hours was conducted for 26 weeks. The variables in the study are described below and the data from the study are shown in the accompanying table. Complete parts a throughg below. Standby hours (Y)-Total number of standby hours in a week Total staff present (X,)-Weekly total of people-days Remote hours (X,)-Number of hours worked by employees off-site E Click the icon to view the data table. Standby hours a. State the multiple regression equation. Standby Hours (Y) Present (X,) Hours (X2) 247 Total Staff Remote Ý, =- 328.6 + (1.8) x, + (- 328.6)X (Round to one decimal place as needed.) 338 333 358 372 337 414 177 600 656 269 211 631 196 135 195 118 116 147 528 289 419 334 382 293 399…arrow_forward
- Relate how the independent and dependent variables affect each other.arrow_forwardAssume you have a project to develop a model to forecast natural gas consumption for the residential sector in the Washington, DC, metropolitan area. The level of natural gas consumption is influenced by a variety of factors. You decided that the most important factors include local weather, the state of the national and the local economies, the purchasing power of the dollar (because at least some of the natural gas is imported), and the prices for other commodities. The following variables have been identified and recorded on a quarterly basis (the data cover the period 1997Q1 through 2008Q3, with all data measured quarterly): GASCONS: consumption of natural gas in DC metro area (million cubic feet) AVETEMP: average temperature for the period in the DC metro area GDP: annualized percentage change in GDP UNEMP: percentage unemployment in the DC metro area GAS_PRICE: price of natural gas ($/100 cubic feet) DOLLAR: value index for the U.S. dollar relative to a basket of international…arrow_forward(Don't hand writing solution)arrow_forward
- olem 2 Motion Picture Industry The motion picture industry is a competitive business. More than 50 studios produce a a to- tal of 300 to 400 new motion pictures each year, and the financial success of each motion picture varies considerably. The opening weekend gross sales, the total gross sales, the number of theaters the movie was shown in, and the number of weeks the motion picture was in the top 60 for gross sales are common variables used to measure the success of a motion picture. Data collected for a sample of 100 motion pictures produced in 2005 are contained in the file named Movies. Table 3.13 shows the data for the first 10 motion pictures in the file. TABLE 3.13 PERFORMANCE DATA FOR 10 MOTION PICTURES Motion Picture Coach Carter Ladies in Lavender Batman Begins Unleashed Pretty Persuasion Fever Pitch Harry Potter and the Goblet of Fire Monster-in-Law White Noise Mr. and Mrs. Smith Opening Gross Sales (Smillions) 29.17 0.15 48.75 10.90 0.06 12.40 102.69 23.11 24.11 50.34 D…arrow_forwardSeveral studies have found that the frequency with which shoppers browse Internet retailers is related to the frequency with which they actually purchase products and/or services online. The data in the accompanying table show the age of respondents and their answer to the question "how many minutes do you browse online retailers per week?" Complete parts a through d. Click the icon to view the data table. b) Do you think a linear model is appropriate? Explain. A. The scatterplot appears to have slight curvature at one end of the age distribution, so a linear regression may not be completely appropriate. O B. The scatterplot shows a curved line, so a linear regression is not appropriate unless the variables are transformed to make the scatterplot more linear. OC. The scatterplot shows points in a tightly clustered single stream that form a straight line, so a linear regression is definitely appropriate. OD. The scatterplot does not show any discernable trend or pattern, so a linear…arrow_forwardThe First Peoples of BC have always had a close relationship with the land. "Traditional Ecological Knowledge is, above all, local knowledge based in people’s relationship to place. It is also holistic, not subject to the segmentation of contemporary science. Knowledge about a specific plant may include understanding its life cycle, its spiritual connections, its relationship to the seasons and with other plants and animals in its ecosystem, as well as its uses and its stories." - Science First Peoples Teacher Resource Guide by First Nations Education Steering Committee To support seasonal food gathering and assess the health of plants and animals, First Peoples closely monitor seasonal changes and climate. Reliable information of weather patterns, ocean currents, and tides is crticial to safely conduct seasonal food gathering along the coast. Currently, there have been increased observations of environmental change, which is of concern to First Peoples and their relationship…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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