Question

In: Economics

Data Table Two below Data Table Two Year Quarter Number of Visitors(in thousands) 2005 Winter 117...

Data Table Two below

Data Table Two

Year Quarter Number of Visitors(in thousands)
2005 Winter 117
Spring 80.7
Summer 129.6
Fall 76.1
2006 Winter 118.6
Spring 82.5
Summer 121.4
Fall 77
2007 Winter 114
Spring 84.3
Summer 119.9
Fall 75
2008 Winter 120.7
Spring 79.6
Summer 130.7
Fall 69.6
2009 Winter 125.2
Spring 80.2
Summer 127.6
Fall 72

Please post the answer with the work performed in excel and not just the answer, need to show work as I don't understand how to do this and would like the steps so that I can also learn it and it shows all work. You can add screenshots of the steps to find the answer in excel.

The answer to this question is below: how is this answer made, need to show work on how this answer came to be. I have the answer but need to show the work!

1.Develop the typical seasonal pattern for Teton Village
Answer to question 1
Seasonal Indices
Period Index
1 19.0687
2 -19.1750
3 25.1563
4 -25.0500

Accuracy Measures
MAPE 2.7354
MAD 2.7779
MSD 11.4065

Time C3 Trend Seasonal Detrend Deseason Predict Error
1 117.0 100.085 19.0687 16.915 97.931 119.154 -2.15375
2 80.7 100.085 -19.1750 -19.385 99.875 80.910 -0.21000
3 129.6 100.085 25.1563 29.515 104.444 125.241 4.35875
4 76.1 100.085 -25.0500 -23.985 101.150 75.035 1.06500
5 118.6 100.085 19.0687 18.515 99.531 119.154 -0.55375
6 82.5 100.085 -19.1750 -17.585 101.675 80.910 1.59000
7 121.4 100.085 25.1563 21.315 96.244 125.241 -3.84125
8 77.0 100.085 -25.0500 -23.085 102.050 75.035 1.96500
9 114.0 100.085 19.0687 13.915 94.931 119.154 -5.15375
10 84.3 100.085 -19.1750 -15.785 103.475 80.910 3.39000
11 119.9 100.085 25.1563 19.815 94.744 125.241 -5.34125
12 75.0 100.085 -25.0500 -25.085 100.050 75.035 -0.03500
13 120.7 100.085 19.0687 20.615 101.631 119.154 1.54625
14 79.6 100.085 -19.1750 -20.485 98.775 80.910 -1.31000
15 130.7 100.085 25.1563 30.615 105.544 125.241 5.45875
16 69.6 100.085 -25.0500 -30.485 94.650 75.035 -5.43500
17 125.2 100.085 19.0687 25.115 106.131 119.154 6.04625
18 80.2 100.085 -19.1750 -19.885 99.375 80.910 -0.71000
19 127.6 100.085 25.1563 27.515 102.444 125.241 2.35875
20 72.0 100.085 -25.0500 -28.085 97.050 75.035 -3.03500

2. Determine the seasonally adjusted number of visitors for winter 2011.
Seasonally adjusted data
97.931
99.875
104.444
101.150
99.531
101.675
96.244
102.050
94.931
103.475
94.744
100.050
101.631
98.775
105.544
94.650
106.131
99.375
102.444
97.050

Solutions

Expert Solution

Rahul Sunny answered 2 years ago
Next > < Previous

Related Solutions

Vehicle Sales: Consider the data below ( in thousands of units):   year Quarter 1 Quarter 2...
Vehicle Sales: Consider the data below ( in thousands of units):   year Quarter 1 Quarter 2 Quarter 3 Quarter 4 2016: 4072 4521 4452 4418 2017: 4010 4392 4399 4334 2018: 4092 4484 4277     4360 Obtain the seasonal factors and enter them into the appropriate yellow cells below: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Seasonal Factor Using the columns Year and Total (Annual Sales) below, obtain the regression equation from the Excel's Scatter Diagram Year Quarter 1...
The table below shows the number of hybrid cars sold (in thousands) in the US in...
The table below shows the number of hybrid cars sold (in thousands) in the US in the following years.                                                          * Source: Wikipedia Year Hybrid cars sold in US (in thousands) 2000 9.35 2002 36.04 2004 84.20 2007 352.27 2010 274.21 2014 452.15 Find an exponential regression equation for the data. Let x = 0 represent the year 2000. Round a to two decimal places, and round b to four decimal places. Describe what a and b tell you from your...
Question 5 The data in the incomplete table below represent annual Savings (in thousands of dollars)...
Question 5 The data in the incomplete table below represent annual Savings (in thousands of dollars) and annual Income (in thousands of dollars) for a sample of 7 families in Brisbane: Annual Income X ('000 dollars) Annual Saving Y ('000 dollars) X2 Y2 XY 60 10 80 40 100 30 120 49 140 57 180 50 200 70 Total= Total= Total= .    Total= Total=    a. Complete the necessary additional columns on the above table to calculate the required...
7. Quarterly billing for water usage is shown below. Year Quarter 1 2 3 4 Winter...
7. Quarterly billing for water usage is shown below. Year Quarter 1 2 3 4 Winter 64 66 68 73 Spring 103 103 104 120 Summer 152 160 162 176 Fall 73 72 78 88 The forecast equation is: Ft = 64.875 – 6.1375 Qtr1t + 32.325 Qtr2t + 86.0375 Qtr3t + 1.2875 (t). Forecast the summer of year 5 and spring of year 6.
The data below is the mileage (thousands of miles) and age of your cars . Year...
The data below is the mileage (thousands of miles) and age of your cars . Year Miles Age 2017    8.5    1 2009 100.3    9 2014   32.7    4 2004 125.0   14 2003 115.0   15 2011   85.5    7 2012   23.1    6 2012   45.0    6 2004 123.0   14 2013   51.2    5 2013 116.0    5 2009 110.0    9 2003 143.0   15 2017   12.0    1 2005 180.0   13 2008 270.0   10 Please include appropriate Minitab Results when important a. Identify terms in the simple linear...
The data below is the mileage (thousands of miles) and age of your cars . Year...
The data below is the mileage (thousands of miles) and age of your cars . Year Miles Age 2017    8.5    1 2009 100.3    9 2014   32.7    4 2004 125.0   14 2003 115.0   15 2011   85.5    7 2012   23.1    6 2012   45.0    6 2004 123.0   14 2013   51.2    5 2013 116.0    5 2009 110.0    9 2003 143.0   15 2017   12.0    1 2005 180.0   13 2008 270.0   10 Please include appropriate Minitab Results when important a. Identify terms in the simple linear...
Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A...
Consider the data in the following table: Year 2004 2005 2006 2007 2008 2009 Stock A -10% 20% 5% -5% 2% 9% Stock B 21% 7% 30% -3% -8% 25% Use the above information to answer the following questions. Round your answers to four decimal places (i.e. 0.0105). 1. Estimate the average return for stock A. 2. Estimate the average return for stock B. 3. Estimate the volatility of stock A. 4.Estimate the volatility of stock B. 5 .Estimate the...
Numbers (in thousands) of forest fires over the year and the number (in hundred thousands) of...
Numbers (in thousands) of forest fires over the year and the number (in hundred thousands) of aces burned for 7 recent years are shown. Number of fires (x): 72 69 58 47 84 62 57 Number of acres burned (y): 73 70 59 48 85 63 58 The correlation coefficient for the data is r = 1 and standard deviation = 0.05. Should the regression analysis be done? Find the equation of the regression line. Round to three decimal places....
The table below contains real data for the first two decades of AIDS reporting. Year #...
The table below contains real data for the first two decades of AIDS reporting. Year # AIDS cases diagnosed # AIDS deaths Pre–1981 91 29 1981 319 121 1982 1,170 453 1983 3,076 1,482 1984 6,240 3,466 1985 11,776 6,878 1986 19,032 11,987 1987 28,564 16,162 1988 35,447 20,868 1989 42,674 27,591 1990 48,634 31,335 1991 59,660 36,560 1992 78,530 41,055 1993 78,834 44,730 1994 71,874 49,095 1995 68,505 49,456 1996 59,347 38,510 1997 47,149 20,736 1998 38,393 19,005 1999...
The table below contains real data for the first two decades of AIDS reporting. Year #...
The table below contains real data for the first two decades of AIDS reporting. Year # AIDS cases diagnosed # AIDS deaths Pre–1981 91 29 1981 319 121 1982 1,170 453 1983 3,076 1,482 1984 6,240 3,466 1985 11,776 6,878 1986 19,032 11,987 1987 28,564 16,162 1988 35,447 20,868 1989 42,674 27,591 1990 48,634 31,335 1991 59,660 36,560 1992 78,530 41,055 1993 78,834 44,730 1994 71,874 49,095 1995 68,505 49,456 1996 59,347 38,510 1997 47,149 20,736 1998 38,393 19,005 1999...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT