Graphical Techniques

Wk2QNT351r6GraphicalTechniquesTemplate1.xlsx

Instructions

QNT-351 - Quantitative Analysis for Business
	Detailed Instructions are given on the Instructions document attached separately with this assignment.
	The instructions were created by Excel 365.

Plot a stacked column chart for television sales ($) by year.
	U.S. Television Sales, 2014 - 2019 ($ thousands)
	Year	Projection TV	LCD TV	Plasma TV	Stacked Column chart
	2014	3574	246	515	Include the x- and y-axis labels
	2015	4351	664	1590
	2016	6271	1579	2347
	2017	5320	3295	4012
	2018	6669	3962	4928
	2019	6484	5328	6343

In a survey of employees conducted by Financial Finesse Inc., 100 employees
	were asked about their overall financial stress levels. The following table shows
	the results of this survey.
	A. Plot a pie chart
	B. Plot a bar chart
	C. Which chart do you believe is better for readability. In particular, to 10% and 11% responses?
	Stress Level	Percentage of Responses	The bar chart may be vertical or horizontal
	No financial stress	11
	Some financial stress	21
	High financial stress	10
	Overwhelming financial stress	58
	Pie chart
	Include the category and percents
	Bar chart
	Include the x- and y-axis labels

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.
	Restaurant Ratings
	Outstanding	a) Using the Pivot table in Excel, construct a frequency distribution.
	Outstanding	Frequency Distribution is a table with two columns - Ratings and Frequency.
	Outstanding
	Outstanding	b) Plot a bar chart using Pivot Table.
	Very Good
	Very Good
	Outstanding	Bar chart
	Very Good	Include the x- and y-axis labels
	Very Good
	Good
	Average
	Average
	Good
	Good
	Good
	Very Good
	Outstanding
	Outstanding
	Outstanding
	Outstanding
	Good
	Good
	Good
	Outstanding
	Very Good
	Very Good
	Outstanding
	Outstanding
	Average
	Very Good

Given below is the revenue data for an organization.
	Plot Revenue on a line chart.
	Month	Revenue
	Jan	$8,950
	Feb	$10,300
	Mar	$7,300
	Apr	$12,430
	May	$11,900	Line chart
	Jun	$12,230	Include the x- and y-axis labels
	Jul	$10,480
	Aug	$10,500
	Sep	$12,870
	Oct	$11,400
	Nov	$12,997
	Dec	$12,772

Given below is the revenue data for an organization.				Axis	Variable
	Plot Cost of Goods Sold and Gross Profit on a scatter plot.			x	Cost of Goods Sold
				y	Gross Profit
	Cost of Goods	Profit
	$179,000	$8,950
	$44,783	$10,300
	$1,043,000	$10,430
	$49,905	$10,480
	$50,000	$10,500
	$95,000	$11,400
	$170,000	$11,900	Scatterplot
	$611,500	$12,230	Include the x- and y-axis labels
	$77,688	$12,430
	$45,964	$12,870
	$81,230	$12,997
	$153,823	$13,869

Refer to the chart below and answer the questions
										Suppose 1,000 vehicles were sold. Estimate the number
										of Sedans that were sold.

Hybrid 20%

Sedan 15%

SUV 30%

Compact 20%

Truck 15%

Vehicle Type Sales

Hybrid

20%

Sedan

15%

SUV

30%

Compact

20%

Truck

15%

Vehicle Type Sales