A data analysis consultancy is tasked to rate four energy providers based on their response time to complaints. They have conducted a study and collected the amount of time taken by a sample of regular customers at each of these four energy providers to receive a response to their complaints.

Collected data is available in BE279-2023-QAdata.xlsx file, available on Moodle under: BE279>Assessment>Data Files.

You are tasked to:

1. Calculate Numerical Measures (Central Location, Variability, and Relative Standing) of Descriptive Statistics for these datasets. Explain the application of the techniques you use in detail. (25 marks)

2. Compare the four sets of data, interpret the results obtained, and prepare a managerial report. Include graphical representation of the data sets in this report. (25 marks)