
Determine a seasonal index for each of the four quarters.
Find the number of visitors for each quarter of 2017 if 10% increase in the total number of visitors in 2016.
Determine the trend equation.
Project the number of visitors for 2017.
Find the seasonally adjusted forecasts.
Identify the best forecast.

Answer to Problem 31CE
The seasonal indexes for the four quarters are 1.2046, 1.0206, 0.6297 and 01.1451, respectively.
The number of visitors for each quarter of 2017 if 10% increase in the total number of visitors in 2016 is 255.25 visitors per quarter.
The trend equation is
The number of visitors for 2017 are 242.0171, 248.634, 255.2509 and 261.8678.
The seasonally adjusted forecasts are 291.5338, 253.7559, 160.7315 and 299.8648.
The best forecast is the fourth quarter of 2017.
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 | 86 | |||
2 | 62 | ||||
3 | 28 | 70 | 0.4 | ||
4 | 94 | 67.5 | 75 | 1.253333 | |
2011 | 1 | 106 | 72.5 | 80 | 1.325 |
2 | 82 | 77.5 | 85 | 0.964706 | |
3 | 48 | 82.5 | 91.75 | 0.523161 | |
4 | 114 | 87.5 | 100.75 | 1.131514 | |
2012 | 1 | 140 | 96 | 109.75 | 1.275626 |
2 | 120 | 105.5 | 119 | 1.008403 | |
3 | 82 | 114 | 126.75 | 0.646943 | |
4 | 154 | 124 | 132 | 1.166667 | |
2013 | 1 | 162 | 129.5 | 136.75 | 1.184644 |
2 | 140 | 134.5 | 141.5 | 0.989399 | |
3 | 100 | 139 | 147.25 | 0.679117 | |
4 | 174 | 144 | 154.5 | 1.126214 | |
2014 | 1 | 188 | 150.5 | 162 | 1.160494 |
2 | 172 | 158.5 | 168.5 | 1.020772 | |
3 | 128 | 165.5 | 174 | 0.735632 | |
4 | 198 | 171.5 | 180.25 | 1.098474 | |
2015 | 1 | 208 | 176.5 | 187.25 | 1.110814 |
2 | 202 | 184 | 193.25 | 1.045278 | |
3 | 154 | 190.5 | 200.75 | 0.767123 | |
4 | 220 | 196 | 210.25 | 1.046373 | |
2016 | 1 | 246 | 205.5 | 219.5 | 1.120729 |
2 | 240 | 215 | 228 | 1.052632 | |
3 | 190 | 224 | |||
4 | 252 | 232 |
The Quarterly indexes are,
I | II | III | IV | |
2010 | 0.4 | 1.253333 | ||
2011 | 1.325 | 0.964706 | 0.523161 | 1.131514 |
2012 | 1.275626 | 1.008403 | 0.646943 | 1.166667 |
2013 | 1.184644 | 0.989399 | 0.679117 | 1.126214 |
2014 | 1.160494 | 1.020772 | 0.735632 | 1.098474 |
2015 | 1.110814 | 1.045278 | 0.767123 | 1.046373 |
2016 | 1.120729 | 1.052632 | ||
Mean | 1.1962 | 1.0135 | 0.6253 | 1.1371 |
Seasonal index:
Here,
Therefore,
The seasonal indexes are,
I | II | III | IV | |
2010 | 0.4 | 1.253333 | ||
2011 | 1.325 | 0.964706 | 0.523161 | 1.131514 |
2012 | 1.275626 | 1.008403 | 0.646943 | 1.166667 |
2013 | 1.184644 | 0.989399 | 0.679117 | 1.126214 |
2014 | 1.160494 | 1.020772 | 0.735632 | 1.098474 |
2015 | 1.110814 | 1.045278 | 0.767123 | 1.046373 |
2016 | 1.120729 | 1.052632 | ||
Mean | 1.1962 | 1.0135 | 0.6253 | 1.1371 |
Seasonal Index |
The total number of visitors in year 2016 is
The 10% of 928 visitors is
The number of visitors in 2017 is
Therefore, the number of visitors in each quarter of 2017 is
Trend Equation:
Step-by-step procedure to obtain the regression using the Excel:
- Enter the data for Year, Visitors and t in Excel sheet.
- Go to Data Menu.
- Click on Data Analysis.
- Select ‘Regression’ and click on ‘OK’
- Select the column of Visitors 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 output, the regression equation is
Projection of the number of visitors for 2017:
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 third quarter of 2017 is 32.
Seasonally Adjusted Forecast:
Estimated Visitors | Seasonal Index | |
242.0171 | 1.2046 | 291.5338 |
248.634 | 1.0206 | 253.7559 |
255.2509 | 0.6297 | 160.7315 |
261.8678 | 1.1451 | 299.8648 |
The seasonal index for the fourth quarter is high compared with remaining three quarters. Hence, the forecast for the fourth quarter is best.
Want to see more full solutions like this?
Chapter 18 Solutions
EBK STATISTICAL TECHNIQUES IN BUSINESS
- ged the variance for group 1) Different groups of male stalk-eyed flies were raised on different diets: a high nutrient corn diet vs. a low nutrient cotton wool diet. Investigators wanted to see if diet quality influenced eye-stalk length. They obtained the following data: d Diet Sample Mean Eye-stalk Length Variance in Eye-stalk d size, n (mm) Length (mm²) Corn (group 1) 21 2.05 0.0558 Cotton (group 2) 24 1.54 0.0812 =205-1.54-05T a) Construct a 95% confidence interval for the difference in mean eye-stalk length between the two diets (e.g., use group 1 - group 2).arrow_forwardAn article in Business Week discussed the large spread between the federal funds rate and the average credit card rate. The table below is a frequency distribution of the credit card rate charged by the top 100 issuers. Credit Card Rates Credit Card Rate Frequency 18% -23% 19 17% -17.9% 16 16% -16.9% 31 15% -15.9% 26 14% -14.9% Copy Data 8 Step 1 of 2: Calculate the average credit card rate charged by the top 100 issuers based on the frequency distribution. Round your answer to two decimal places.arrow_forwardPlease could you check my answersarrow_forward
- Let Y₁, Y2,, Yy be random variables from an Exponential distribution with unknown mean 0. Let Ô be the maximum likelihood estimates for 0. The probability density function of y; is given by P(Yi; 0) = 0, yi≥ 0. The maximum likelihood estimate is given as follows: Select one: = n Σ19 1 Σ19 n-1 Σ19: n² Σ1arrow_forwardPlease could you help me answer parts d and e. Thanksarrow_forwardWhen fitting the model E[Y] = Bo+B1x1,i + B2x2; to a set of n = 25 observations, the following results were obtained using the general linear model notation: and 25 219 10232 551 XTX = 219 10232 3055 133899 133899 6725688, XTY 7361 337051 (XX)-- 0.1132 -0.0044 -0.00008 -0.0044 0.0027 -0.00004 -0.00008 -0.00004 0.00000129, Construct a multiple linear regression model Yin terms of the explanatory variables 1,i, x2,i- a) What is the value of the least squares estimate of the regression coefficient for 1,+? Give your answer correct to 3 decimal places. B1 b) Given that SSR = 5550, and SST=5784. Calculate the value of the MSg correct to 2 decimal places. c) What is the F statistics for this model correct to 2 decimal places?arrow_forward
- Calculate the sample mean and sample variance for the following frequency distribution of heart rates for a sample of American adults. If necessary, round to one more decimal place than the largest number of decimal places given in the data. Heart Rates in Beats per Minute Class Frequency 51-58 5 59-66 8 67-74 9 75-82 7 83-90 8arrow_forwardcan someone solvearrow_forwardQUAT6221wA1 Accessibility Mode Immersiv Q.1.2 Match the definition in column X with the correct term in column Y. Two marks will be awarded for each correct answer. (20) COLUMN X Q.1.2.1 COLUMN Y Condenses sample data into a few summary A. Statistics measures Q.1.2.2 The collection of all possible observations that exist for the random variable under study. B. Descriptive statistics Q.1.2.3 Describes a characteristic of a sample. C. Ordinal-scaled data Q.1.2.4 The actual values or outcomes are recorded on a random variable. D. Inferential statistics 0.1.2.5 Categorical data, where the categories have an implied ranking. E. Data Q.1.2.6 A set of mathematically based tools & techniques that transform raw data into F. Statistical modelling information to support effective decision- making. 45 Q Search 28 # 00 8 LO 1 f F10 Prise 11+arrow_forward
- Students - Term 1 - Def X W QUAT6221wA1.docx X C Chat - Learn with Chegg | Cheg X | + w:/r/sites/TertiaryStudents/_layouts/15/Doc.aspx?sourcedoc=%7B2759DFAB-EA5E-4526-9991-9087A973B894% QUAT6221wA1 Accessibility Mode பg Immer The following table indicates the unit prices (in Rands) and quantities of three consumer products to be held in a supermarket warehouse in Lenasia over the time period from April to July 2025. APRIL 2025 JULY 2025 PRODUCT Unit Price (po) Quantity (q0)) Unit Price (p₁) Quantity (q1) Mineral Water R23.70 403 R25.70 423 H&S Shampoo R77.00 922 R79.40 899 Toilet Paper R106.50 725 R104.70 730 The Independent Institute of Education (Pty) Ltd 2025 Q Search L W f Page 7 of 9arrow_forwardCOM WIth Chegg Cheg x + w:/r/sites/TertiaryStudents/_layouts/15/Doc.aspx?sourcedoc=%7B2759DFAB-EA5E-4526-9991-9087A973B894%. QUAT6221wA1 Accessibility Mode Immersi The following table indicates the unit prices (in Rands) and quantities of three meals sold every year by a small restaurant over the years 2023 and 2025. 2023 2025 MEAL Unit Price (po) Quantity (q0)) Unit Price (P₁) Quantity (q₁) Lasagne R125 1055 R145 1125 Pizza R110 2115 R130 2195 Pasta R95 1950 R120 2250 Q.2.1 Using 2023 as the base year, compute the individual price relatives in 2025 for (10) lasagne and pasta. Interpret each of your answers. 0.2.2 Using 2023 as the base year, compute the Laspeyres price index for all of the meals (8) for 2025. Interpret your answer. Q.2.3 Using 2023 as the base year, compute the Paasche price index for all of the meals (7) for 2025. Interpret your answer. Q Search L O W Larrow_forwardQUAI6221wA1.docx X + int.com/:w:/r/sites/TertiaryStudents/_layouts/15/Doc.aspx?sourcedoc=%7B2759DFAB-EA5E-4526-9991-9087A973B894%7 26 QUAT6221wA1 Q.1.1.8 One advantage of primary data is that: (1) It is low quality (2) It is irrelevant to the purpose at hand (3) It is time-consuming to collect (4) None of the other options Accessibility Mode Immersive R Q.1.1.9 A sample of fifteen apples is selected from an orchard. We would refer to one of these apples as: (2) ھا (1) A parameter (2) A descriptive statistic (3) A statistical model A sampling unit Q.1.1.10 Categorical data, where the categories do not have implied ranking, is referred to as: (2) Search D (2) 1+ PrtSc Insert Delete F8 F10 F11 F12 Backspace 10 ENG USarrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALTrigonometry (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 HarcourtCollege Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning




