show steps how to do it in excel

show steps how to do it in excel

3.1 Shipments of Household Appliances: Line Graphs. The file ApplianceShip- ments.xls contains the series of quarterly shipments (in millions of dollars) of US household appliances between 1985 and 1989. a. Create a well-formatted time plot of the data using Excel. b. 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. c. Using Excel, create one chart with four separate lines, one line for each of Q1, Q2, Q3, and Q4. In Excel this can be achieved by sorting the data by Q1, Q2, Q3, Q4 (alphabetical sorting will work), and then plotting 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? d. Using Excel, create a line graph of the series at a yearly aggregated level (i.e., the total shipments in each year). e. Re-create the plots above using an interactive visualization tool. Be sure to enter the quarter information in a format that is recognized by the software as a date. f. Compare the two processes of generating the line graphs in terms of effort as well as the quality of the resulting plots. What are the advantages of each