Question

Teton Village, Wyoming, near Grand Teton Park and Yellowstone Park, contains shops, restaurants, and motels. The village has two peak seasons---winter, for skiing on the 10,000-foot slopes, and summer, for tourists visiting the parks. The number of visitors(in thousands) by quarter for five years can be found in Data Table Two below

1.Develop the typical seasonal pattern for Teton Village

2. Determine the seasonally adjusted number of visitors for winter 2011.

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. You can send screenshots of the excel steps.

Answer 1

I had tried making the excel sheet. Its a very easy ways. Steps involved are:-

1. Collect the data and divide them according to your requirement. For example we did season division in accordance to year and number of visitors.

Higlight the season with bold and under them by using command.

Easy to draw conclusions.

b. From the above data we can say that the two maximum season for visitors are summer and winters.

So as per the data the number of visitors in the 2011 would be estimated between 120-135. If we see at the past data.