EBK STATISTICAL TECHNIQUES IN BUSINESS
17th Edition
ISBN: 9781259924163
Author: Lind
Publisher: MCGRAW HILL BOOK COMPANY
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 18, Problem 28CE
a.
To determine
Determine the typical seasonal patterns for sales using the ratio-to-moving-average method.
a.
Expert Solution
Answer to Problem 28CE
The typical seasonal patterns for sales are 1.191168, 1.121778, 0.435094 and 1.251959, respectively.
Explanation of Solution
Calculation:
Four-Year moving average:
Centered Moving Average:
Specific seasonal index:
| Year | Quarter | Visitors |
Four-quarter moving average |
Centered Moving average | Specific seasonal |
| 2010 | 1 | 210 | |||
| 2 | 180 | ||||
| 3 | 60 | 174.5 | 0.34384 | ||
| 4 | 246 | 174 | 179.5 | 1.370474 | |
| 2011 | 1 | 214 | 175 | 186.75 | 1.145917 |
| 2 | 216 | 184 | 187.5 | 1.152 | |
| 3 | 82 | 189.5 | 189.5 | 0.432718 | |
| 4 | 230 | 185.5 | 195 | 1.179487 | |
| 2012 | 1 | 246 | 193.5 | 197.625 | 1.244782 |
| 2 | 228 | 196.5 | 205 | 1.112195 | |
| 3 | 91 | 198.75 | 212.75 | 0.427732 | |
| 4 | 280 | 211.25 | 217 | 1.290323 | |
| 2013 | 1 | 258 | 214.25 | 222.5 | 1.159551 |
| 2 | 250 | 219.75 | 227.5 | 1.098901 | |
| 3 | 113 | 225.25 | 232.375 | 0.486283 | |
| 4 | 298 | 229.75 | 237.125 | 1.256721 | |
| 2014 | 1 | 279 | 235 | 239.625 | 1.164319 |
| 2 | 267 | 239.25 | 240.75 | 1.109034 | |
| 3 | 116 | 240 | 244.375 | 0.47468 | |
| 4 | 304 | 241.5 | 250.125 | 1.215392 | |
| 2015 | 1 | 302 | 247.25 | 252.75 | 1.194857 |
| 2 | 290 | 253 | 253.25 | 1.145114 | |
| 3 | 114 | 252.5 | 256.375 | 0.444661 | |
| 4 | 310 | 254 | 258.875 | 1.197489 | |
| 2016 | 1 | 321 | 258.75 | 259.75 | 1.235804 |
| 2 | 291 | 259 | 261.75 | 1.111748 | |
| 3 | 120 | 260.5 | |||
| 4 | 320 | 263 |
The Quarterly indexes are,
| I | II | III | IV | |
| 2010 | 0.34384 | 1.370474 | ||
| 2011 | 1.145917 | 1.152 | 0.432718 | 1.179487 |
| 2012 | 1.244782 | 1.112195 | 0.427732 | 1.290323 |
| 2013 | 1.159551 | 1.098901 | 0.486283 | 1.256721 |
| 2014 | 1.164319 | 1.109034 | 0.47468 | 1.215392 |
| 2015 | 1.194857 | 1.145114 | 0.444661 | 1.197489 |
| 2016 | 1.235804 | 1.111748 | ||
| Mean | 1.190871 | 1.121499 | 0.434986 | 1.251648 |
Typical Seasonal index:
Here,
Therefore,
The seasonal indexes are,
| I | II | III | IV | |
| 2010 | 0.34384 | 1.370474 | ||
| 2011 | 1.145917 | 1.152 | 0.432718 | 1.179487 |
| 2012 | 1.244782 | 1.112195 | 0.427732 | 1.290323 |
| 2013 | 1.159551 | 1.098901 | 0.486283 | 1.256721 |
| 2014 | 1.164319 | 1.109034 | 0.47468 | 1.215392 |
| 2015 | 1.194857 | 1.145114 | 0.444661 | 1.197489 |
| 2016 | 1.235804 | 1.111748 | ||
| Mean | 1.190871 | 1.121499 | 0.434986 | 1.251648 |
| Typical Seasonal Index | 1.191168 | 1.121778 | 0.435094 | 1.251959 |
b.
To determine
Determine the trend equation.
b.
Expert Solution
Answer to Problem 28CE
The trend equation is
Explanation of Solution
Calculation:
Deseasonalization:
| Sales | Typical seasonal index | Deseasonalized Sales |
| 210 | 1.191168 | 176.29755 |
| 180 | 1.121778 | 160.4595562 |
| 60 | 0.435094 | 137.9012351 |
| 246 | 1.251959 | 196.4920576 |
| 214 | 1.191168 | 179.6555985 |
| 216 | 1.121778 | 192.5514674 |
| 82 | 0.435094 | 188.4650214 |
| 230 | 1.251959 | 183.7120864 |
| 246 | 1.191168 | 206.5199871 |
| 228 | 1.121778 | 203.2487711 |
| 91 | 0.435094 | 209.1502066 |
| 280 | 1.251959 | 223.6494965 |
| 258 | 1.191168 | 216.5941328 |
| 250 | 1.121778 | 222.8604947 |
| 113 | 0.435094 | 259.7139928 |
| 298 | 1.251959 | 238.0269641 |
| 279 | 1.191168 | 234.2238878 |
| 267 | 1.121778 | 238.0150083 |
| 116 | 0.435094 | 266.6090546 |
| 304 | 1.251959 | 242.8194534 |
| 302 | 1.191168 | 253.5326671 |
| 290 | 1.121778 | 258.5181738 |
| 114 | 0.435094 | 262.0123468 |
| 310 | 1.251959 | 247.6119426 |
| 321 | 1.191168 | 269.4833978 |
| 291 | 1.121778 | 259.4096158 |
| 120 | 0.435094 | 275.8024703 |
| 320 | 1.251959 | 255.5994246 |
Assign t value as 1 for first quarter of 2010, 2 for the second quarter of 2011 and so on.
Step-by-step procedure to obtain the regression using the Excel:
- Enter the data for Sales and t in Excel sheet.
- Go to Data Menu.
- Click on Data Analysis.
- Select ‘Regression’ and click on ‘OK’
- Select the column of Deseasonalized Sales under ‘Input Y
Range ’. - Select the column of t under ‘Input X Range’.
- Click on ‘OK’.
Output for the Regression obtained using the Excel is as follows:
From the Excel output, the regression equation is
c.
To determine
Project the sales for the four quarters of next year using the trend equation.
Find the seasonally adjusted values.
c.
Expert Solution
Answer to Problem 28CE
The sales for the four quarters for next year are 283.487, 287.6217, 291.7564 and 295.8911.
The seasonally adjusted values are 337.6806, 322.6477, 126.9415 and 370.4435.
Explanation of Solution
Calculation:
From the output, the regression equation is
The t value for first quarter of 2017 is 29.
The t value for second quarter of 2017 is 30.
The t value for third quarter of 2017 is 31.
The t value for fourth quarter of 2017 is 32.
Seasonally Adjusted Forecast:
| Estimated Visitors | Seasonal Index | |
| 283.487 | 1.191168 | 337.6806 |
| 287.6217 | 1.121778 | 322.6477 |
| 291.7564 | 0.435094 | 126.9415 |
| 295.8911 | 1.251959 | 370.4435 |
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Une Entreprise œuvrant dans le domaine du multividéo donne l'opportunité à ses
programmeurs-analystes d'évaluer la performance des cadres supérieurs.
Voici les résultats obtenues (sur une échelle de 10 à 50) où 50 représentent une
excellente performance. 10 programmeurs furent sélectionnés au hazard pour
évaluer deux cadres. Un rapport Excel est également fourni.
Programmeurs
Cadre A Cadre B
1
34
36
2
32
34
3
18
19
33
38
19
21
21
23
7
35
34
8
20
20
9
34
34
10
36
34
Test d'égalité des espérances: observations pairées
A television news channel samples 25 gas stations from its local area and uses the results to estimate the average gas price for the state. What’s wrong with its margin of error?
You’re fed up with keeping Fido locked inside, so you conduct a mail survey to find out people’s opinions on the new dog barking ordinance in a certain city. Of the 10,000 people who receive surveys, 1,000 respond, and only 80 are in favor of it. You calculate the margin of error to be 1.2 percent. Explain why this reported margin of error is misleading.
Chapter 18 Solutions
EBK STATISTICAL TECHNIQUES IN BUSINESS
Ch. 18 - Prob. 1SRCh. 18 - Prob. 1ECh. 18 - Prob. 2ECh. 18 - Prob. 2SRCh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Prob. 3SRCh. 18 - Prob. 7E
Ch. 18 - Prob. 8ECh. 18 - Prob. 4SRCh. 18 - Prob. 9ECh. 18 - Prob. 10ECh. 18 - Prob. 5SRCh. 18 - Prob. 11ECh. 18 - Prob. 12ECh. 18 - Prob. 13ECh. 18 - Prob. 14ECh. 18 - Prob. 15ECh. 18 - Prob. 16ECh. 18 - Prob. 17CECh. 18 - Prob. 18CECh. 18 - Prob. 19CECh. 18 - Prob. 20CECh. 18 - Prob. 21CECh. 18 - Prob. 22CECh. 18 - Prob. 23CECh. 18 - Prob. 24CECh. 18 - Prob. 25CECh. 18 - Prob. 26CECh. 18 - Prob. 27CECh. 18 - Prob. 28CECh. 18 - Prob. 29CECh. 18 - Prob. 30CECh. 18 - Prob. 31CECh. 18 - Prob. 32CECh. 18 - Prob. 33CECh. 18 - Prob. 34DACh. 18 - Prob. 35DACh. 18 - Prob. 36DACh. 18 - Prob. 37DACh. 18 - Prob. 1PCh. 18 - Prob. 2PCh. 18 - Prob. 3PCh. 18 - Prob. 1.1PTCh. 18 - Prob. 1.2PTCh. 18 - Prob. 1.3PTCh. 18 - Prob. 1.4PTCh. 18 - Prob. 1.5PTCh. 18 - Prob. 1.6PTCh. 18 - Prob. 1.7PTCh. 18 - Prob. 1.8PTCh. 18 - Prob. 1.9PTCh. 18 - Prob. 1.10PTCh. 18 - Prob. 2.1PTCh. 18 - Prob. 2.2PTCh. 18 - Prob. 2.3PT
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
- You find out that the dietary scale you use each day is off by a factor of 2 ounces (over — at least that’s what you say!). The margin of error for your scale was plus or minus 0.5 ounces before you found this out. What’s the margin of error now?arrow_forwardSuppose that Sue and Bill each make a confidence interval out of the same data set, but Sue wants a confidence level of 80 percent compared to Bill’s 90 percent. How do their margins of error compare?arrow_forwardSuppose that you conduct a study twice, and the second time you use four times as many people as you did the first time. How does the change affect your margin of error? (Assume the other components remain constant.)arrow_forward
- Out of a sample of 200 babysitters, 70 percent are girls, and 30 percent are guys. What’s the margin of error for the percentage of female babysitters? Assume 95 percent confidence.What’s the margin of error for the percentage of male babysitters? Assume 95 percent confidence.arrow_forwardYou sample 100 fish in Pond A at the fish hatchery and find that they average 5.5 inches with a standard deviation of 1 inch. Your sample of 100 fish from Pond B has the same mean, but the standard deviation is 2 inches. How do the margins of error compare? (Assume the confidence levels are the same.)arrow_forwardA survey of 1,000 dental patients produces 450 people who floss their teeth adequately. What’s the margin of error for this result? Assume 90 percent confidence.arrow_forward
- The annual aggregate claim amount of an insurer follows a compound Poisson distribution with parameter 1,000. Individual claim amounts follow a Gamma distribution with shape parameter a = 750 and rate parameter λ = 0.25. 1. Generate 20,000 simulated aggregate claim values for the insurer, using a random number generator seed of 955.Display the first five simulated claim values in your answer script using the R function head(). 2. Plot the empirical density function of the simulated aggregate claim values from Question 1, setting the x-axis range from 2,600,000 to 3,300,000 and the y-axis range from 0 to 0.0000045. 3. Suggest a suitable distribution, including its parameters, that approximates the simulated aggregate claim values from Question 1. 4. Generate 20,000 values from your suggested distribution in Question 3 using a random number generator seed of 955. Use the R function head() to display the first five generated values in your answer script. 5. Plot the empirical density…arrow_forwardFind binomial probability if: x = 8, n = 10, p = 0.7 x= 3, n=5, p = 0.3 x = 4, n=7, p = 0.6 Quality Control: A factory produces light bulbs with a 2% defect rate. If a random sample of 20 bulbs is tested, what is the probability that exactly 2 bulbs are defective? (hint: p=2% or 0.02; x =2, n=20; use the same logic for the following problems) Marketing Campaign: A marketing company sends out 1,000 promotional emails. The probability of any email being opened is 0.15. What is the probability that exactly 150 emails will be opened? (hint: total emails or n=1000, x =150) Customer Satisfaction: A survey shows that 70% of customers are satisfied with a new product. Out of 10 randomly selected customers, what is the probability that at least 8 are satisfied? (hint: One of the keyword in this question is “at least 8”, it is not “exactly 8”, the correct formula for this should be = 1- (binom.dist(7, 10, 0.7, TRUE)). The part in the princess will give you the probability of seven and less than…arrow_forwardplease answer these questionsarrow_forward
- Selon une économiste d’une société financière, les dépenses moyennes pour « meubles et appareils de maison » ont été moins importantes pour les ménages de la région de Montréal, que celles de la région de Québec. Un échantillon aléatoire de 14 ménages pour la région de Montréal et de 16 ménages pour la région Québec est tiré et donne les données suivantes, en ce qui a trait aux dépenses pour ce secteur d’activité économique. On suppose que les données de chaque population sont distribuées selon une loi normale. Nous sommes intéressé à connaitre si les variances des populations sont égales.a) Faites le test d’hypothèse sur deux variances approprié au seuil de signification de 1 %. Inclure les informations suivantes : i. Hypothèse / Identification des populationsii. Valeur(s) critique(s) de Fiii. Règle de décisioniv. Valeur du rapport Fv. Décision et conclusion b) A partir des résultats obtenus en a), est-ce que l’hypothèse d’égalité des variances pour cette…arrow_forwardAccording to an economist from a financial company, the average expenditures on "furniture and household appliances" have been lower for households in the Montreal area than those in the Quebec region. A random sample of 14 households from the Montreal region and 16 households from the Quebec region was taken, providing the following data regarding expenditures in this economic sector. It is assumed that the data from each population are distributed normally. We are interested in knowing if the variances of the populations are equal. a) Perform the appropriate hypothesis test on two variances at a significance level of 1%. Include the following information: i. Hypothesis / Identification of populations ii. Critical F-value(s) iii. Decision rule iv. F-ratio value v. Decision and conclusion b) Based on the results obtained in a), is the hypothesis of equal variances for this socio-economic characteristic measured in these two populations upheld? c) Based on the results obtained in a),…arrow_forwardA major company in the Montreal area, offering a range of engineering services from project preparation to construction execution, and industrial project management, wants to ensure that the individuals who are responsible for project cost estimation and bid preparation demonstrate a certain uniformity in their estimates. The head of civil engineering and municipal services decided to structure an experimental plan to detect if there could be significant differences in project evaluation. Seven projects were selected, each of which had to be evaluated by each of the two estimators, with the order of the projects submitted being random. The obtained estimates are presented in the table below. a) Complete the table above by calculating: i. The differences (A-B) ii. The sum of the differences iii. The mean of the differences iv. The standard deviation of the differences b) What is the value of the t-statistic? c) What is the critical t-value for this test at a significance level of 1%?…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
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
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher: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
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
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
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