1 Shipments of Household Appliances: Line Graphs. The file ApplianceShipments.xls contains the series of quarterly shipments (in million $) of U.S. household appliances between 1985 and 1989 (data courtesy of Ken Black).

Create a well-formatted time plot of the data using Excel.

Does there appear to be a quarterly pattern? For a closer view of the patterns, zoom in to the range of 35005000 on the y axis.

Create four separate lines for Q 1, Q2, Q3, and Q4, using Excel. In each, plot a line graph. In Excel, order the data by Q 1, Q2, Q3, Q4 (alphabetical sorting will work), and plot them as separate series on the line graph. Zoom in to the range of 35005000 on the y axis. Does there appear to be a difference between quarters?

Using Excel, create a line graph of the series at a yearly aggregated level (i.e., the total shipments in each year).

Re-create the above plots using an interactive visualization tool. Make sure to enter the quarter information in a format that is recognized by the software as a date.