Question 1 a) Which are the top 3 countries in terms of projected annual revenue (state them in descending order of amount). b) Which are the lowest 3 countries in terms of projected annual revenue (state them in ascending order of the amount). c) Which quarter is projected to bring in the most revenue? Your answer should also state the amount in millions of pounds. d) Calculate the median revenue for each of the 4 quarters, stating the formula you would use for determining the median for the first quarter’s projected revenue. e) Calculate the Range of revenues for each of the 4 quarters, stating the formula you would use for determining the range for the first quarter’s projected revenue. f) Calculate the mean for each of the 4 quarters, stating the formula you would use for determining the mean for the first quarter’s forecasted revenue. g) Calculate the mean of the projected annual revenues of the 7 countries. Show full working for the mean calculation. h) Discuss the usefulness of a standard deviation in a given dataset. You must cite any sources you use.
Question 1
a) Which are the top 3 countries in terms of projected annual revenue (state them in descending order of amount).
b) Which are the lowest 3 countries in terms of projected annual revenue (state them in ascending order of the amount).
c) Which quarter is projected to bring in the most revenue? Your answer should also state the amount in millions of pounds.
d) Calculate the median revenue for each of the 4 quarters, stating the formula you would use for determining the median for the first quarter’s projected revenue.
e) Calculate the Range of revenues for each of the 4 quarters, stating the formula you would use for determining the range for the first quarter’s projected revenue.
f) Calculate the mean for each of the 4 quarters, stating the formula you would use for determining the mean for the first quarter’s
g) Calculate the mean of the projected annual revenues of the 7 countries. Show full working for the mean calculation.
h) Discuss the usefulness of a standard deviation in a given dataset. You must cite any sources you use.
Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts for you. To get the remaining sub-parts solved, please repost the complete question and mention the sub-parts to be solved.
Step by step
Solved in 3 steps with 2 images