Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

From Product Statistics, Sale Statistics, Sale Trend, write a short analysis from the information extracted. [15 marks] What important information is missing from this dashboard?

image text in transcribedimage text in transcribedimage text in transcribed
  1. From Product Statistics, Sale Statistics, Sale Trend, write a short analysis from the information extracted. [15 marks]
  2. What important information is missing from this dashboard? Explain why it is important. [10 marks
image text in transcribedimage text in transcribedimage text in transcribed
Dashboard Author: ID: Product Statistics CHART 01: Product price Mean Price 4.62 Median Price 4.6 Price Chart Min Price 3.5 5.3 5.3 5.8 5.8 5.5 5.3 5.5 5.3 5.8 5.1 5.1 5.6 5.5 4.6 4.6 4.4 4.4 4.8 Max Price 4.6 4.8 5.2 5.2 5.1 4.6 3.7 5.8 3. 3.9 4.1 4.1 4.5 4.5 4.9 4.8 3.9 3.9 4.4 3.7 3.7 4.2 3.5 3.8 3.8 3.6 4.1 OHNWAGON 3.5 Cappuccino Chai Latte Choc Duo Latte Tea Choc Mocha Espresso Flat White Vienna Dark Chocolate Hot Chocolate Long Black Long Macchiato Marble Mocha Piccolo Latte Short Macchiato White Chocolate Small Standard . LargeSale Statistics CHART 02: Sale Quantity and Sale Values Mean Sale Number 29 Median Sale Numb 30 Quantity and Sales Value Chart 189.2 Min Sale 83.4 149.4 140 157.7 129.8 152.8 Max Sale 189.2 122.1 143.5 200 150 100 Total 50 rate Small Choc Duo Latte Cappuccino Chai Latte Choc Mocha Espresso Tea Flat White Long Black Vienna Dark Chocolate Hot Chocolate Long Macchiato Piccolo Latte Marble Mocha Short Macchiato White Chocolate Small rate Standard rate . Large rate . TotalSale Trend Sale Amount CHART 03: Sales per days Day Monday 68 Tuesday 67 Daily Sales Wednesday 77 Thursday 74 90 Friday 76 88 86 Saturday 74 84 64 82 Sunday 80 77 76 78 74 74 76 74 72 70 68 67 68 64 66 64 62 60 SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY Please write down your analysis by summarising the information fro Horizontal (Category) Axis ised information above. Also let us know what we are still missing in this dashboard

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Engineering Mathematics

Authors: Dennis G Zill, Warren S Wright

5th Edition

1449679781, 9781449679781

More Books

Students also viewed these Mathematics questions