INVESTIGATION 1: Mr Wilkinson is a CEO of a local company and as a part of his company's expansion policy he is interested in taking over two department stores in the west of the country. His business consultant is working on the expansion programme and he has collected some data from these two companies. Below, you are given the two companies' customers' spending profile on a random day: Department Store A Department Store B Purchase Amount (E) Number of Customers Number of Customers EO-10 29 22 -E20 50 29 -30 59 14 -40 66 28 63 31 -60 77 60 -70 50 79 -80 32 72 -590 15 54 -E100 9 61 As a business strategist, you are expected to write a report about these two companies -50 profiles by using descriptive statistics methods. In your report you will also compare these two department stores and you are expected to write the necessary business strategies to aim for financial success Task 1 (Maximum 10 Marks) Learning Outcome(s) LO2 Calculate necessary statistics for both companies: Mean, Modal Class, Standard Deviation and Variance. Plot box plot diagrams for both companies. LO5 Compare and contrast both companies based on your findings and your box LO6 plot diagram. Include your tables/ formulae and boxplot diagrams in your report. . Task 2 (Maximum 5 Marks) Learning Outcome(s) LO3 Create histogram charts for purchase amount (E) for both department stores LO4 and calculate the number of customers whose budget is between 45 and 75. L05 Include your histogram charts and working in your report above. Lo Stuc Groi INVESTIGATION 1: Mr Wilkinson is a CEO of a local company and as a part of his company's expansion policy he is interested in taking over two department stores in the west of the country. His business consultant is working on the expansion programme and he has collected some data from these two companies. Below, you are given the two companies' customers' spending profile on a random day: Department Store A Department Store B Purchase Amount (E) Number of Customers Number of Customers EO-10 29 22 -E20 50 29 -30 59 14 -40 66 28 63 31 -60 77 60 -70 50 79 -80 32 72 -590 15 54 -E100 9 61 As a business strategist, you are expected to write a report about these two companies -50 profiles by using descriptive statistics methods. In your report you will also compare these two department stores and you are expected to write the necessary business strategies to aim for financial success Task 1 (Maximum 10 Marks) Learning Outcome(s) LO2 Calculate necessary statistics for both companies: Mean, Modal Class, Standard Deviation and Variance. Plot box plot diagrams for both companies. LO5 Compare and contrast both companies based on your findings and your box LO6 plot diagram. Include your tables/ formulae and boxplot diagrams in your report. . Task 2 (Maximum 5 Marks) Learning Outcome(s) LO3 Create histogram charts for purchase amount (E) for both department stores LO4 and calculate the number of customers whose budget is between 45 and 75. L05 Include your histogram charts and working in your report above. Lo Stuc Groi