Question: 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

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. B D E F 1 2 3 4 5 6 AllTech Group Forecasted Global Revenue Dashboard for 2021 Country Q1 Q2 Q3 Canada 15000 16000 18000 Singapore 20000 23000 22000 Pakistan 25000 21000 22000 Nigeria 10000 9000 11000 UAE 27000 26000 28000 Spain 19000 22000 21000 Germany 26000 28000 30000 0 000 Q4 17000 21000 21000 8000 7 8 9 10 11 27000 22000 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

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 123 2 AllTech Group 3 Forecasted Global Revenue...

KINGS OWN INSTITUTE* Success in Higher Education ICT106 DATA COMMUNICATIONS AND NETWORKS T223 Page 1 of 18 AUSTRALIAN INSTITUTE OF BUSINESS AND MANAGEMENT PTY LTD ABN: 72 132 629 979 CRICOS 03171A...

I know its a bit harsh but see if you can finish it in before tomorrow? thanks QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 2...

Hello please refer to part 4 from the question paper I have attached the past student work for your reference just have to follow the format if you feel comfortable with I have attached the necessary...

Hi, I need a help from those people who have a great knowledge regarding accounting. Please help me to resolve the questions in attached file. BSB51215 Diploma of Marketing BSBFIM501 Manage budgets...

hi can you help me in my assignment? some details can get in MAA Group Berhad. 2014 financial position, highlights, income statement. Olympia College Assignment Diploma in Business Management DIPLOMA...

Assume you graduate from college with $31,000 in student loans. If your interest rate is xed at 4.50% APR with monthly compounding and you repay the loans over a 10year period. What will be your...

Stacey Ball, vice president of operations for Clinton County Bank, has instructed the banks computer programmer to use a 365-day year to compute interest on depository accounts (liabilities). Stacey...

As the Market Revolution progressed, the northern countryside became Select one A . more concerned about the future. B . less isolated from what was happening elsewhere. C . caught up in trying to...

MSP 4 3 0 FR 6 9 8 9 has instructions to add, subtract, and perform arithmetic bit - shifting, but no instructions to divide or multiply. Using this MCU you want to find the average value of the set...