Reference no: EM133521436
Question 1: What type of graph is suitable to show the correlation between the revenue generated by Tesco's UK & ROI division and the revenue generated by Tesco's Central Europe division over the last recorded five years?
Question 2: Create an appropriate graph to show the correlation between the total revenue generated by Tesco and the number of its stores over the last recorded five years?
c) What type of correlation is present between the total revenue generated by Tesco and the number of its stores over the last recorded five years?
Question 3 a) Calculate the median generated revenue for each division of Tesco, stating the formula you would use for determining the median revenue for its Bank division.
b) Calculate the average generated revenue for each division of Tesco, stating the formula you would use for determining the average for its UK & ROI division.
c) Calculate the standard deviation of the total revenue dataset (Column F) using Excel. Use the standard deviation range function, STDEV.P, to check your answer.
d) Provide a definition for the standard deviation of any dataset. You must cite any sources used.