Question

U.S. Manufactured General Aviation Shipments, 2009–2015
Year		Qtr 1				Qtr 2				Qtr 3				Qtr 4				Total
2009			301				404				395				471				1,571
2010			234				361				272				420				1,287
2011			266				287				286				468				1,307
2012			320				353				337				509				1,519
2013			328				414				346				517				1,605
2014			335				371				378				529				1,613
2015			287				353				362				560				1,562

(c) Use MegaStat or Minitab to calculate estimated seasonal indexes and trend. (Round your answers to 3 decimal places.)

Qtr1 Index

Qtr2 Index

Qtr3 Index

Qtr4 Index

Answer 1

By using minitab :

Fitted Trend Equation

Yt = 343.3 + 2.100×t

Seasonal Indices

Period Index
1 -61.172
2   -21.672
3 -41.109
4 123.953

Output:

General Aviation Shipments	TREN1	SEAS1
301	345.3605	-61.1719
404	347.4607	-21.6719
395	349.561	-41.1094
471	351.6613	123.9531
234	353.7616	-61.1719
361	355.8619	-21.6719
272	357.9622	-41.1094
420	360.0624	123.9531
266	362.1627	-61.1719
287	364.263	-21.6719
286	366.3633	-41.1094
468	368.4636	123.9531
320	370.5639	-61.1719
353	372.6641	-21.6719
337	374.7644	-41.1094
509	376.8647	123.9531
328	378.965	-61.1719
414	381.0653	-21.6719
346	383.1656	-41.1094
517	385.2658	123.9531
335	387.3661	-61.1719
371	389.4664	-21.6719
378	391.5667	-41.1094
529	393.667	123.9531
287	395.7673	-61.1719