Answered step by step
Verified Expert Solution
Question
1 Approved Answer
TASK TWO - SUMMATIVE This final task must be submitted for final marking. Prepare the spreadsheet below in Excel and use it to answer Questions
TASK TWO - SUMMATIVE This final task must be submitted for final marking. Prepare the spreadsheet below in Excel and use it to answer Questions 1 to 3. A B C D E F 1 2 AllTech Group 3 Forecasted Global Revenue Dashboard for 2021 4 Country Q1 Q2 Q3 Q4 5 Canada 15000 16000 18000 17000 6 Singapore 20000 23000 22000 21000 7 Pakistan 25000 21000 22000 21000 8 Nigeria 10000 9000 11000 8000 9 UAE 27000 26000 28000 27000 10 Spain 19000 22000 21000 22000 11 Germany 26000 28000 30000 29000 Question 1: Answer the following questions: a) Which are the top 3 countries in terms of projected annual revenue (state them in descending order of amount. b) Which quarter is projected to bring in the most revenue? Question 2 a) Produce an appropriate fully labelled chart to reflect the quarterly totals for each region. b) Use a suitable and fully labelled chart to reflect the contribution of each region to the overall project annual revenue. Question 3 Imagine a scenario where you are the CEO of the AllTech group. What information could you gather from calculating the mean, median, mode, and range of each region? Discuss the importance of each measure of central tendency separately (max. 300 words)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started