BUS105 Statistics Tutor-Marked Assignment July 2025 Semester Presentation | SUSS

BUS105 Question 1

(a) Using relevant Excel reports, state the values of three (3) location measures and  three (3) dispersion measures of electricity bill in a household in May 2020.  (12 marks)

(b) 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 (i.e., Z-table manual method, and the Excel function) to solve it, and round your answer to four decimal places. (18 marks)

(c) Describe the interquartile range, and explain which one is more appropriate to measure dispersion – standard deviation or interquartile range? (30 marks)

(d)  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. The word limit is 300 words. Please indicate the word count at the end of your answer. (40 marks)