Expert answer:Graphical Techniques

Solved by verified expert: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.” Note: Detailed instructions for the first four questions are provided in the document, “Graphical Techniques Instructions.”
qnt351_r6_wk2_graphical_techniques_template.xlsx

Unformatted Attachment Preview

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)
2002
2003
2004
2005
Projection TV LCD TV
Plasma TV
3.574
246
515
4.351
664
1.590
6.271
1.579
2.347
5.320
3.295
4.012
Detailed Instructions are given on the Instructio
The instructions will work both for Macs and W
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
No financial stress
14
Some financial stress
63
High financial stress
18
Overwhelming financial stress
5
Detailed Instructions are given on t
The instructions will work both for
Instructions are given on the Instructions document attached separately with this assignment.
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
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
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.
Detailed Instructions are given on the Instructions document attached separate
Given below is the revenue data for an organization.
Plot Revenue on a line chart.
Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Revenue
$4.510
$10.430
$8.950
$12.300
$5.300
$12.430
$11.900
$12.230
$10.480
$10.500
$12.870
$11.400
Detailed Instructions are given on the Instructions document attach
The instructions will work both for Macs and Windows.
Refer to the chart below and answer the questions
a. What is the name given to this type of c
b. Suppose that 1,000 graduates will start
whose first contact for employment occur
e that 1,000 graduates will start a new job shortly after graduation. Estimate the number of graduates
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades