BUS105: Using relevant Excel reports, state the values of three location measures and three dispersion measures of electricity bill: Statistics Assignment, SUSS, Singapore

Mr. Tan is a research student at the Singapore University of Social Sciences, and his research focus is to examine the impact of Covid-19 on household electricity consumption. He hypothesized that the average monthly electricity bill in a household has increased more than $5 during the Covid-19 pandemic. In order to test his hypothesis, he collected the electricity bill data in 50 households in May 2020 when Singapore was during the circuit breaker period.

Mr. Tan also found that the mean and standard deviation of electricity bills in a household in May 2019 are $26 and $7, respectively.

In order to study the impact of Covid-19 on household electricity consumption, Mr. Tan intends to make a comparison of the average electricity bills in May 2019 and May 2020 in his analysis. The data is given in the Excel data file “BUS105_electricity”.

Question

• Using relevant Excel reports, state the values of three location measures and three dispersion measures of electricity bills in a household in May 2020.
• Assume that the electricity bill in a household in May 2019 follows a normal distribution, what is the probability that a randomly selected household had an electricity bill greater than $31 in May 2019? Please use two methods.
• Describe the interquartile range, and explain which one is more appropriate to measure dispersion – standard deviation or interquartile range?
• Using appropriate charts and numerical measures, develop a summary report to address Mr. Tan’s hypothesis. You are expected to provide interpretation to the charts and numerical measures. You are not required to do any further inferential analysis.