Assignment: Purpose of Assignment: The purpose of this assignment is to provide students hands-on experience with summarizing raw data using graphs and charts and interpreting results. Students will also use Excel® Pivot Tables and Pivot Charts to summarize raw data. In the era of big data, tools like Pivot Tables and PowerPivot are critical tools to summarize the data.
Assignment Steps:
Resources: Microsoft Excel
Complete the five exercises on the Microsoft Excel file, "Graphical Techniques Template."
Question 1: Plot a 100% stacked column chart for television sales by year. U.S. Television Sales, 2002 - 2005 ($ thousands)
|
|
Projection TV
|
LCD TV
|
Plasma TV
|
|
2002
|
3,574
|
246
|
515
|
|
2003
|
4,351
|
664
|
1,590
|
|
2004
|
6,271
|
1,579
|
2,347
|
|
2005
|
5,320
|
3,295
|
4,012
|
Detailed Instructions are given on the Instructions document attached separately with this assignment. The instructions will work both for Macs and Windows.
Question 2: In a 2013 survey of employees conducted by Financial Finesse Inc., employees were asked about their overall financial stress levels. The following table shows the results of this survey. Plot a pie chart.
|
Stress Level
|
Percentage of Responses
|
|
No financial stress
|
14
|
|
Some financial stress
|
63
|
|
High financial stress
|
18
|
|
Overwhelming financial stress
|
5
|
Detailed Instructions are given on the Instructions document attached separately with this assignment. The instructions will work both for Macs and Windows.
Question 3: Given below are the ratings of the overall dining experience (Outstanding, Very Good, Good, Average, or Poor) of 30 randomly selected patrons at a restaurant on a Saturday evening.
a) Using the Pivot table in Excel, construct a frequency distribution. Frequency Distribution is a table with two columns - Ratings and Frequency.
b) Plot a bar chart using Pivot Chart.
c) Plot a pie chart using Pivot Chart.
|
Restaurant Ratings
|
|
Outstanding
|
|
Outstanding
|
|
Very Good
|
|
Outstanding
|
|
Good
|
|
Good
|
|
Outstanding
|
|
Outstanding
|
|
Good
|
|
Very Good
|
|
Very Good
|
|
Outstanding
|
|
Outstanding
|
|
Very Good
|
|
Outstanding
|
|
Very Good
|
|
Very Good
|
|
Outstanding
|
|
Outstanding
|
|
Very Good
|
|
Outstanding
|
|
Very Good
|
|
Outstanding
|
|
Very Good
|
|
Good
|
|
Good
|
|
Average
|
|
Very Good
|
|
Outstanding
|
|
Outstanding
|
Detailed Instructions are given on the Instructions document attached separately with this assignment. The instructions will work both for Macs and Windows.
Question 4: Given below is the revenue data for an organization. Plot Revenue on a line chart.
|
Month
|
Revenue
|
|
Jan
|
$4,510
|
|
Feb
|
$10,430
|
|
Mar
|
$8,950
|
|
Apr
|
$12,300
|
|
May
|
$5,300
|
|
Jun
|
$12,430
|
|
Jul
|
$11,900
|
|
Aug
|
$12,230
|
|
Sep
|
$10,480
|
|
Oct
|
$10,500
|
|
Nov
|
$12,870
|
|
Dec
|
$11,400
|
Detailed Instructions are given on the Instructions document attached separately with this assignment. The instructions will work both for Macs and Windows.
Information related to above question is enclosed below:
Attachment:- Graphical_Techniques_Instructionsalex.rar