Business Decision Making Process

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.

Question 1

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

U.S. Television Sales

LCD TV 2014 2015 2016 2017 2018 2019 246 664 1579 3295 3962 5328.3333333333303 Projection TV 2014 2015 2016 2017 2018 2019 3574 4351 6271 5320 6668.5 6484 Plasma TV 2014 2015 2016 2017 2018 2019 515 1590 2347 4012 4928 6343.3333333333303

Year

Sales in $ thousands

Question 2

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					Pie Chart
	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
						Bar Graph
					C. Pie chart is better than bar graph for readability, especially with respect to 10% response and 11% response

Percentage of Responses

Percentage of Responses No financial stress Some financial stress High financial stress Overwhelming financial stress 0.11 0.21 0.1 0.57999999999999996

Percentage of Responses

Percentage of Responses No financial stress Some financial stress High financial stress Overwhelming financial stress 0.11 0.21 0.1 0.57999999999999996

Stress Levels

Response in percentage

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.
	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		Row Labels	Sum of Frequency
	Very Good		Average	3
	Very Good		Good	7
	Outstanding		Outstanding	12
	Very Good		Very Good	8
	Very Good		Grand Total	30
	Good
	Average
	Average		b) Plot a bar chart using Pivot Table.
	Good
	Good
	Good		Bar chart
	Very Good		Include the x- and y-axis labels
	Outstanding
	Outstanding
	Outstanding
	Outstanding
	Good
	Good
	Good
	Outstanding
	Very Good
	Very Good
	Outstanding
	Outstanding
	Average
	Very Good
	Restaurant Ratings	Frequency
	Outstanding	12
	Very Good	8
	Good	7
	Average	3
	Sum	30

Restaurant Rating

Frequency Outstanding Very Good Good Average 12 8 7 3

Rating

Frequency

Question 4

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

Monthly Revenue

Revenue Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 8950 10300 7300 12430 11900 12230 10480 10500 12870 11400 12996.8181818182 12772.121212121199

Month

Revenue

Question 5

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

Gross Profit

Profit 179000 44783 1043000 49905 50000 95000 170000 611500 77688 45964 81230 153822.74242424301 8950 10300 10430 10480 10500 11400 11900 12230 12430 12870 12996.8181818182 13868.939393939399

Cost of goods sold

Gross Profit

Question 6

Refer to the chart below and answer the questions

Suppose 1,000 vehicles were sold. Estimate the number

of Sedans that were sold.

150

Hybrid 20%

Sedan 15%

SUV 30%

Compact 20%

Truck 15%

Vehicle Type Sales