Create a well formatted time plot of the data using excel

Assignment Help Financial Management

Reference no: EM132329985

Assignment

Answer the following questions. Answers should be uploaded in a neat, easy to read Word document. Move all graphs and charts to one document. Do not upload spreadsheets. Be sure to read this week's written lecture for links and other helpful information. Necessary datasets are linked.

2.1 Shipments of household appliances: line graphs. The file ApplianceShipments.xls contains the series of quarterly shipments (in million $) of US household appliances between 19851989 (Data courtesy of Ken Black).

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 3500 - 5000 on the y-axis.

c. Create four separate lines for Q1, Q2, Q3, and Q4, using Excel. In each, plot a line graph. In Excel, order the data by Q1, Q2, Q3, Q4 (alphabetical sorting will work), and plot them as separate series on the line graph. Zoom in to the range of 3500 - 5000 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. Recreate the above plots using an interactive visualization tool such as Spotfire. Make 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, for example using Spotfire vs. Excel, in terms of the effort, as well as the quality of the resulting plots. What are the advantages of each?

2.2 Laptop sales at a London computer chain: bar charts and boxplots. The file LaptopSalesJanuary2008.xls contains data for all sales of laptops at a computer chain in London in January 2008. This is a subset of the full dataset that includes data for the entire year.

a. Create a bar chart, showing the average retail price by store. Which store has the highest average? Which has the lowest?

b. To better compare retail prices across stores, create side by side boxplots of retail price by store. Now compare the prices in the two stores above. Do you see a difference between their price distributions? Explain.

Attachment:- Assignment Details.rar

Reference no: EM132329985

Questions Cloud

How knowledge may be informed by data that is accessed : Among the Resources in this module is the Rutherford (2008) article Standardized Nursing Language: What Does It Mean for Nursing Practice?

What is a probation officer : What is a probation officer? Who appoints them - There are many possible status offenses. Name three you feel are the most serious and explain why

Identify the importance of leadership qualities : Kent Institute Australia - LEMT305, Leadership for Managers Assessment - Self-Reflective Journal. Identify the importance of leadership qualities

Define the validity and reliability reported statistics : In preparation for this assignment, read the "Maladaptive Perfectionism as a Mediator and Moderator Between Adult Attachment and Depressive Mood".

Create a well formatted time plot of the data using excel : Create a bar chart, showing the average retail price by store. Which store has the highest average? Which has the lowest?

What are the weaknesses of qualitative research designs : What are the strengths and weaknesses of qualitative research designs? What are the essential components that should be considered when applying qualitative.

Find the variance of the hours of exercise per week : Find the variance of the hours of exercise per week by the participants. Determine if there is a linear relationship between the hours of exercise per week.

Find the spring constant : Derive the auxiliary equation for the fourth order Cauchy-Euler equation. A spring attached to the ceiling is stretched one foot by a four-pound weight.

Discuss what is a sustainable competitive advantage is : Discuss what is a sustainable competitive advantage is, and why it is so important to a winning business strategy? What is a Blue Ocean strategy

User Account

All Pages