U. S. Manufactured General Aviation Shipments, 2009–2015 Year Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total
2009 310 408 390 477 1,585
2010 243 377 281 433 1,334
2011 268 289 286 480 1,323
2012 305 358 339 514 1,516
2013 329 413 353 520 1,615
2014 345 380 379 527 1,631
2015 296 374 378 544 1,592

Click here for the Excel Data File

(a) Plot the data on airplane shipments.

Plot A Plot B Plot C Plot D

multiple choice 1
Plot A
Plot B
Plot C
Plot D

(b) Can you see seasonal patterns?

multiple choice 2
Yes
No

(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

(d) In which quarters are shipments highest? Lowest? (You may select more than one answer. Click the box with a check mark for the correct answer and double click to empty the box for the wrong answer.)

Highest

check all that apply 1
Q1
Q2
Q3
Q4

Lowest

check all that apply 2
Q1
Q2
Q3
Q4

(e) Is there a trend in the deseasonalized data?

There is a slight
(Click to select)
trend in the deseasonalized data.