Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 55SE
Refer to the Hudson Marine data in exercise 53.
- a. Deseasonalize the data and use the deseasonalized time series to identify the trend.
- b. Use the results of part (a) to develop a quarterly forecast for next year based on trend.
- c. Use the seasonal indexes developed in exercise 54 to adjust the forecasts developed in part (b) to account for the effect of season.
53. Refer to the Hudson Marine problem in exercise 52. Suppose the quarterly sales values for the seven years of historical data are as follows.
- a. Use the following dummy variables to develop an estimated regression equation to account for any season and linear trend effects in the data: Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; and Qtr3 = 1 if Quarter 3, 0 otherwise.
- b. Compute the quarterly forecasts for next year.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
I need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)
I need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)
This exercise is based on the following data on four bodybuilding supplements. (Figures shown correspond to a single serving.)
Creatine(grams)
L-Glutamine(grams)
BCAAs(grams)
Cost($)
Xtend(SciVation)
0
2.5
7
1.00
Gainz(MP Hardcore)
2
3
6
1.10
Strongevity(Bill Phillips)
2.5
1
0
1.20
Muscle Physique(EAS)
2
2
0
1.00
Your personal trainer suggests that you supplement with at least 10 grams of creatine, 39 grams of L-glutamine, and 90 grams of BCAAs each week. You are thinking of combining Xtend and Gainz to provide you with the required nutrients. How many servings of each should you combine to obtain a week's supply that meets your trainer's specifications at the least cost? (If an answer does not exist, enter DNE.)
servings of xtend servings of gainz
Chapter 17 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 17.2 - 1. Consider the following time series...Ch. 17.2 - 2. Refer to the time series data in exercise 1....Ch. 17.2 - Prob. 3ECh. 17.2 - 4. Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Prob. 8ECh. 17.3 - 9. With the gasoline time series data from Table...Ch. 17.3 - 10. With a smoothing constant of α = .2, equation...
Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in $...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - Prob. 16ECh. 17.4 - Consider the following time series...Ch. 17.4 - Prob. 18ECh. 17.4 - Prob. 19ECh. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - Prob. 22ECh. 17.4 - The president of a small manufacturing firm is...Ch. 17.4 - The following data shows the average interest rate...Ch. 17.4 - Quarterly revenue ($ millions) for Twitter for the...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - The number of users of Facebook from 2004 through...Ch. 17.5 - Consider the following time series.
Construct a...Ch. 17.5 - Consider the following time series...Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Prob. 33ECh. 17.5 - Prob. 34ECh. 17.6 - Consider the following time series...Ch. 17.6 - Refer to exercise 35.
Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies, Inc., supplies milk to several...Ch. 17 - Annual retail store revenue for Apple from 2007 to...Ch. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Prob. 47SECh. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Prob. 50SECh. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Prob. 52SECh. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise...Ch. 17 - Refer to the Hudson Marine data in exercise...Ch. 17 - Forecasting Food and Beverage Sales
The Vintage...Ch. 17 - The Carlson Department Store suffered heavy damage...
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
- I need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forwardDATA TABLE VALUES Meal Price ($) 22.78 31.90 33.89 22.77 18.04 23.29 35.28 42.38 36.88 38.55 41.68 25.73 34.19 31.75 25.24 26.32 19.57 36.57 32.97 36.83 30.17 37.29 25.37 24.71 28.79 32.83 43.00 35.23 34.76 33.06 27.73 31.89 38.47 39.42 40.72 43.92 36.51 45.25 33.51 29.17 30.54 26.74 37.93arrow_forward
- I need help with this problem and an explanation of the solution for the image described below. (Statistics: Engineering Probabilities)arrow_forwardSales personnel for Skillings Distributors submit weekly reports listing the customer contacts made during the week. A sample of 65 weekly reports showed a sample mean of 19.5 customer contacts per week. The sample standard deviation was 5.2. Provide 90% and 95% confidence intervals for the population mean number of weekly customer contacts for the sales personnel. 90% Confidence interval, to 2 decimals: ( , ) 95% Confidence interval, to 2 decimals:arrow_forwardA simple random sample of 40 items resulted in a sample mean of 25. The population standard deviation is 5. a. What is the standard error of the mean (to 2 decimals)? b. At 95% confidence, what is the margin of error (to 2 decimals)?arrow_forward
- mean trough level of the population to be 3.7 micrograms/mL. The researcher conducts a study among 93 newly diagnosed arthritis patients and finds the mean trough to be 4.1 micrograms/mL with a standard deviation of 2.4 micrograms/mL. The researcher wants to test at the 5% level of significance if the trough is different than previously reported or not. Z statistics will be used. Complete Step 5 of hypothesis testing: Conclusion. State whether or not you would reject the null hypothesis and why. Also interpret what this means (i.e. is the mean trough different from 3.7 or noarrow_forward30% of all college students major in STEM (Science, Technology, Engineering, and Math). If 48 college students are randomly selected, find the probability thata. Exactly 12 of them major in STEM. b. At most 17 of them major in STEM. c. At least 12 of them major in STEM. d. Between 9 and 13 (including 9 and 13) of them major in STEM.arrow_forward7% of all Americans live in poverty. If 40 Americans are randomly selected, find the probability thata. Exactly 4 of them live in poverty. b. At most 1 of them live in poverty. c. At least 1 of them live in poverty. d. Between 2 and 9 (including 2 and 9) of them live in poverty.arrow_forward
- 48% of all violent felons in the prison system are repeat offenders. If 40 violent felons are randomly selected, find the probability that a. Exactly 18 of them are repeat offenders. b. At most 18 of them are repeat offenders. c. At least 18 of them are repeat offenders. d. Between 17 and 21 (including 17 and 21) of them are repeat offenders.arrow_forwardConsider an MA(6) model with θ1 = 0.5, θ2 = −25, θ3 = 0.125, θ4 = −0.0625, θ5 = 0.03125, and θ6 = −0.015625. Find a much simpler model that has nearly the same ψ-weights.arrow_forwardLet {Yt} be an AR(2) process of the special form Yt = φ2Yt − 2 + et. Use first principles to find the range of values of φ2 for which the process is stationary.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 Hill
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Big 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
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY