5 questions

answerthesequestions.xlsx

Instructions

QNT-351 - Quantitative Analysis for Business

Individual Assignment Due Week 2

Total Number of Questions 5

Maximum Score 10

Detailed Instructions are given on the Instructions document attached separately with this assignment.

The instructions are primarily for Excel 2013 for Windows. Mac students will find them helpful too.

Plot a 100% stacked column chart for television sales by year.
U.S. Television Sales, 2002 - 2005 ($ thousands)
	Projection TV	LCD TV	Plasma TV	Detailed Instructions are given on the Instructions document attached separately with this assignment.
2002	3,574	246	515	The instructions will work both for Macs and Windows.
2003	4,351	664	1,590
2004	6,271	1,579	2,347
2005	5,320	3,295	4,012

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 (www.financialfinesse.com).
Plot a pie chart.
	Stress Level	Percentage of Responses	Detailed Instructions are given on the Instructions document attached separately with this assignment.
	No financial stress	14	The instructions will work both for Macs and Windows.
	Some financial stress	63
	High financial stress	18
	Overwhelming financial stress	5

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.
Very Good
Outstanding		b) Plot a bar chart using Pivot Chart.
Good
Good		c) Plot a pie chart using Pivot Chart.
Outstanding
Outstanding		Detailed Instructions are given on the Instructions document attached separately with this assignment.
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

Given below is the revenue data for an organization.
Plot Revenue on a line chart.
Month	Revenue	Detailed Instructions are given on the Instructions document attached separately with this assignment.
Jan	$4,510	The instructions will work both for Macs and Windows.
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

Refer to the chart below and answer the questions
							a. What is the name given to this type of chart?
							b. Suppose that 1,000 graduates will start a new job shortly after graduation. Estimate the number of graduates
							whose first contact for employment occurred through networking and other connections.