Gen Combo Ll Statistical Techniques In Business And Economics; Connect Ac
17th Edition
ISBN: 9781260149623
Author: Lind
Publisher: MCG
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
To help consumers in purchasing a laptop computer, Consumer Reports calculates an overall test score for each computer tested based upon rating factors such as ergonomics, portability, performance, display, and battery life. Higher overall scores indicate better test results. The following data show the average retail price and the overall score for ten 13-inch models (Consumer Reports website, October 25, 2012).
Brand & Model
Price ($)
Overall Score
Samsung Ultrabook NP900X3C-A01US
1250
83
Apple MacBook Air MC965LL/A
1300
83
Apple MacBook Air MD231LL/A
1200
82
HP ENVY 13-2050nr Spectre XT
950
79
Sony VAIO SVS13112FXB
800
77
Acer Aspire S5-391-9880 Ultrabook
1200
74
Apple MacBook Pro MD101LL/A
1200
74
Apple MacBook Pro MD313LL/A
1000
73
Dell Inspiron I13Z-6591SLV
700
67
Samsung NP535U3C-A01US
600
63
a. Select a scatter diagram with price as the independent variable.
b. What does the scatter diagram developed in part (a) indicate about the relationship…
To the Internal Revenue Service, the reasonableness of total itemized deductions depends on the taxpayer’s adjusted gross income. Large deductions, which include charity and medical deductions, are more reasonable for taxpayers with large adjusted gross incomes. If a taxpayer claims larger than average itemized deductions for a given level of income, the chances of an IRS audit are increased. Data (in thousands of dollars) on adjusted gross income and the average or reasonable amount of itemized deductions follow.
Adjusted Gross Income ($1000s)
Reasonable Amount ofItemized Deductions ($1000s)
22
9.6
27
9.6
32
10.1
48
11.1
65
13.5
85
17.7
120
25.5
Compute b1 and b0 (to 4 decimals).b1 b0 Complete the estimated regression equation (to 2 decimals). = + x
Predict a reasonable level of total itemized deductions for a taxpayer with an adjusted gross income of $52.5 thousand (to 2 decimals). thousand dollarsWhat is the value, in dollars, of…
K
The mean height of women in a country (ages 20-29) is 63.7 inches. A random sample of 65 women in this age group
is selected. What is the probability that the mean height for the sample is greater than 64 inches? Assume σ = 2.68.
The probability that the mean height for the sample is greater than 64 inches is
(Round to four decimal places as needed.)
Chapter 18 Solutions
Gen Combo Ll Statistical Techniques In Business And Economics; Connect Ac
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
- In a survey of a group of men, the heights in the 20-29 age group were normally distributed, with a mean of 69.6 inches and a standard deviation of 4.0 inches. A study participant is randomly selected. Complete parts (a) through (d) below. (a) Find the probability that a study participant has a height that is less than 68 inches. The probability that the study participant selected at random is less than 68 inches tall is 0.4. (Round to four decimal places as needed.) 20 2arrow_forwardPEER REPLY 1: Choose a classmate's Main Post and review their decision making process. 1. Choose a risk level for each of the states of nature (assign a probability value to each). 2. Explain why each risk level is chosen. 3. Which alternative do you believe would be the best based on the maximum EMV? 4. Do you feel determining the expected value with perfect information (EVWPI) is worthwhile in this situation? Why or why not?arrow_forwardQuestions An insurance company's cumulative incurred claims for the last 5 accident years are given in the following table: Development Year Accident Year 0 2018 1 2 3 4 245 267 274 289 292 2019 255 276 288 294 2020 265 283 292 2021 263 278 2022 271 It can be assumed that claims are fully run off after 4 years. The premiums received for each year are: Accident Year Premium 2018 306 2019 312 2020 318 2021 326 2022 330 You do not need to make any allowance for inflation. 1. (a) Calculate the reserve at the end of 2022 using the basic chain ladder method. (b) Calculate the reserve at the end of 2022 using the Bornhuetter-Ferguson method. 2. Comment on the differences in the reserves produced by the methods in Part 1.arrow_forward
- You are provided with data that includes all 50 states of the United States. Your task is to draw a sample of: o 20 States using Random Sampling (2 points: 1 for random number generation; 1 for random sample) o 10 States using Systematic Sampling (4 points: 1 for random numbers generation; 1 for random sample different from the previous answer; 1 for correct K value calculation table; 1 for correct sample drawn by using systematic sampling) (For systematic sampling, do not use the original data directly. Instead, first randomize the data, and then use the randomized dataset to draw your sample. Furthermore, do not use the random list previously generated, instead, generate a new random sample for this part. For more details, please see the snapshot provided at the end.) Upload a Microsoft Excel file with two separate sheets. One sheet provides random sampling while the other provides systematic sampling. Excel snapshots that can help you in organizing columns are provided on the next…arrow_forwardThe population mean and standard deviation are given below. Find the required probability and determine whether the given sample mean would be considered unusual. For a sample of n = 65, find the probability of a sample mean being greater than 225 if μ = 224 and σ = 3.5. For a sample of n = 65, the probability of a sample mean being greater than 225 if μ=224 and σ = 3.5 is 0.0102 (Round to four decimal places as needed.)arrow_forward***Please do not just simply copy and paste the other solution for this problem posted on bartleby as that solution does not have all of the parts completed for this problem. Please answer this I will leave a like on the problem. The data needed to answer this question is given in the following link (file is on view only so if you would like to make a copy to make it easier for yourself feel free to do so) https://docs.google.com/spreadsheets/d/1aV5rsxdNjHnkeTkm5VqHzBXZgW-Ptbs3vqwk0SYiQPo/edit?usp=sharingarrow_forward
- The data needed to answer this question is given in the following link (file is on view only so if you would like to make a copy to make it easier for yourself feel free to do so) https://docs.google.com/spreadsheets/d/1aV5rsxdNjHnkeTkm5VqHzBXZgW-Ptbs3vqwk0SYiQPo/edit?usp=sharingarrow_forwardThe following relates to Problems 4 and 5. Christchurch, New Zealand experienced a major earthquake on February 22, 2011. It destroyed 100,000 homes. Data were collected on a sample of 300 damaged homes. These data are saved in the file called CIEG315 Homework 4 data.xlsx, which is available on Canvas under Files. A subset of the data is shown in the accompanying table. Two of the variables are qualitative in nature: Wall construction and roof construction. Two of the variables are quantitative: (1) Peak ground acceleration (PGA), a measure of the intensity of ground shaking that the home experienced in the earthquake (in units of acceleration of gravity, g); (2) Damage, which indicates the amount of damage experienced in the earthquake in New Zealand dollars; and (3) Building value, the pre-earthquake value of the home in New Zealand dollars. PGA (g) Damage (NZ$) Building Value (NZ$) Wall Construction Roof Construction Property ID 1 0.645 2 0.101 141,416 2,826 253,000 B 305,000 B T 3…arrow_forwardRose Par posted Apr 5, 2025 9:01 PM Subscribe To: Store Owner From: Rose Par, Manager Subject: Decision About Selling Custom Flower Bouquets Date: April 5, 2025 Our shop, which prides itself on selling handmade gifts and cultural items, has recently received inquiries from customers about the availability of fresh flower bouquets for special occasions. This has prompted me to consider whether we should introduce custom flower bouquets in our shop. We need to decide whether to start offering this new product. There are three options: provide a complete selection of custom bouquets for events like birthdays and anniversaries, start small with just a few ready-made flower arrangements, or do not add flowers. There are also three possible outcomes. First, we might see high demand, and the bouquets could sell quickly. Second, we might have medium demand, with a few sold each week. Third, there might be low demand, and the flowers may not sell well, possibly going to waste. These outcomes…arrow_forward
- Consider the state space model X₁ = §Xt−1 + Wt, Yt = AX+Vt, where Xt Є R4 and Y E R². Suppose we know the covariance matrices for Wt and Vt. How many unknown parameters are there in the model?arrow_forwardBusiness Discussarrow_forwardYou want to obtain a sample to estimate the proportion of a population that possess a particular genetic marker. Based on previous evidence, you believe approximately p∗=11% of the population have the genetic marker. You would like to be 90% confident that your estimate is within 0.5% of the true population proportion. How large of a sample size is required?n = (Wrong: 10,603) Do not round mid-calculation. However, you may use a critical value accurate to three decimal places.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