Graphical Techniques
Homework1
Wk2QNT351r6GraphicalTechniquesTemplate.xlsxInstructions
| 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 |
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 | 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 |
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 | 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 |
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 |
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 | |
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. |
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
