Modern Business Statistics with Microsoft Excel (MindTap Course List)
5th Edition
ISBN: 9781285433301
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 45SE
The Garden Avenue Seven sells CDs of its musical performances. The following table reports sales (in units) for the past 18 months. The group’s manager wants an accurate method for forecasting future sales.
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Use exponential smoothing with α = .3, .4, and .5. Which value of α provides the most accurate forecasts?
- c. Use trend projection to provide a forecast. What is the value of MSE?
- d. Which method of forecasting would you recommend to the manager? Why?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A 24-1 design has been used to investigate the effect of four factors on the resistivity of a silicon wafer. The data
from this experiment are shown in Table 4.
Table 4: Resistivity Experiment for Exercise 5
Run
A
B
с
D
Resistivity
1
23
2
3
4
5
6
7
8
9
10
11
12
I+I+I+I+Oooo
0
0
||++TI++o000
33.2
4.6
31.2
9.6
40.6
162.4
39.4
158.6
63.4
62.6
58.7
0
0
60.9
3
(a) Estimate the factor effects. Plot the effect estimates on a normal probability scale.
(b) Identify a tentative model for this process. Fit the model and test for curvature.
(c) Plot the residuals from the model in part (b) versus the predicted resistivity. Is there any indication on
this plot of model inadequacy?
(d) Construct a normal probability plot of the residuals. Is there any reason to doubt the validity of the
normality assumption?
Stem1: 1,4
Stem 2: 2,4,8
Stem3: 2,4
Stem4: 0,1,6,8
Stem5: 0,1,2,3,9
Stem 6: 2,2
What’s the Min,Q1, Med,Q3,Max?
Are the t-statistics here greater than 1.96? What do you conclude?
colgPA= 1.39+0.412 hsGPA
(.33) (0.094)
Find the P value
Chapter 17 Solutions
Modern Business Statistics with Microsoft Excel (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 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Prob. 25ECh. 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 - Prob. 44SECh. 17 - The Garden Avenue Seven sells CDs of its musical...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
- A poll before the elections showed that in a given sample 79% of people vote for candidate C. How many people should be interviewed so that the pollsters can be 99% sure that from 75% to 83% of the population will vote for candidate C? Round your answer to the whole number.arrow_forwardSuppose a random sample of 459 married couples found that 307 had two or more personality preferences in common. In another random sample of 471 married couples, it was found that only 31 had no preferences in common. Let p1 be the population proportion of all married couples who have two or more personality preferences in common. Let p2 be the population proportion of all married couples who have no personality preferences in common. Find a95% confidence interval for . Round your answer to three decimal places.arrow_forwardA history teacher interviewed a random sample of 80 students about their preferences in learning activities outside of school and whether they are considering watching a historical movie at the cinema. 69 answered that they would like to go to the cinema. Let p represent the proportion of students who want to watch a historical movie. Determine the maximal margin of error. Use α = 0.05. Round your answer to three decimal places. arrow_forward
- A random sample of medical files is used to estimate the proportion p of all people who have blood type B. If you have no preliminary estimate for p, how many medical files should you include in a random sample in order to be 99% sure that the point estimate will be within a distance of 0.07 from p? Round your answer to the next higher whole number.arrow_forwardA clinical study is designed to assess the average length of hospital stay of patients who underwent surgery. A preliminary study of a random sample of 70 surgery patients’ records showed that the standard deviation of the lengths of stay of all surgery patients is 7.5 days. How large should a sample to estimate the desired mean to within 1 day at 95% confidence? Round your answer to the whole number.arrow_forwardA clinical study is designed to assess the average length of hospital stay of patients who underwent surgery. A preliminary study of a random sample of 70 surgery patients’ records showed that the standard deviation of the lengths of stay of all surgery patients is 7.5 days. How large should a sample to estimate the desired mean to within 1 day at 95% confidence? Round your answer to the whole number.arrow_forward
- In the experiment a sample of subjects is drawn of people who have an elbow surgery. Each of the people included in the sample was interviewed about their health status and measurements were taken before and after surgery. Are the measurements before and after the operation independent or dependent samples?arrow_forwardiid 1. The CLT provides an approximate sampling distribution for the arithmetic average Ỹ of a random sample Y₁, . . ., Yn f(y). The parameters of the approximate sampling distribution depend on the mean and variance of the underlying random variables (i.e., the population mean and variance). The approximation can be written to emphasize this, using the expec- tation and variance of one of the random variables in the sample instead of the parameters μ, 02: YNEY, · (1 (EY,, varyi n For the following population distributions f, write the approximate distribution of the sample mean. (a) Exponential with rate ẞ: f(y) = ß exp{−ßy} 1 (b) Chi-square with degrees of freedom: f(y) = ( 4 ) 2 y = exp { — ½/ } г( (c) Poisson with rate λ: P(Y = y) = exp(-\} > y! y²arrow_forward2. Let Y₁,……., Y be a random sample with common mean μ and common variance σ². Use the CLT to write an expression approximating the CDF P(Ỹ ≤ x) in terms of µ, σ² and n, and the standard normal CDF Fz(·).arrow_forward
- matharrow_forwardCompute the median of the following data. 32, 41, 36, 42, 29, 30, 40, 22, 25, 37arrow_forwardTask Description: Read the following case study and answer the questions that follow. Ella is a 9-year-old third-grade student in an inclusive classroom. She has been diagnosed with Emotional and Behavioural Disorder (EBD). She has been struggling academically and socially due to challenges related to self-regulation, impulsivity, and emotional outbursts. Ella's behaviour includes frequent tantrums, defiance toward authority figures, and difficulty forming positive relationships with peers. Despite her challenges, Ella shows an interest in art and creative activities and demonstrates strong verbal skills when calm. Describe 2 strategies that could be implemented that could help Ella regulate her emotions in class (4 marks) Explain 2 strategies that could improve Ella’s social skills (4 marks) Identify 2 accommodations that could be implemented to support Ella academic progress and provide a rationale for your recommendation.(6 marks) Provide a detailed explanation of 2 ways…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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
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
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
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