Question: please do it ASAP.... I'll give you up thumb definitely BUS105_Electricity A B Electricity Bill in May 2020 1 2 3 No Bill ($) 1



please do it ASAP.... I'll give you up thumb definitely
BUS105_Electricity A B Electricity Bill in May 2020 1 2 3 No Bill ($) 1 4 2 5 3 N 5 v 2 O S T 39.7 27.5 37.7 41.7 25.1 4 6 7 5 20.1 vo 6 7 8 9 10 11 oo 8 12 9 10 11 12 13 14 15 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 34.9 28.7 49.8 29.8 27.7 39.2 22.5 36.4 33.1 25.4 26.1 27.9 24.6 49.6 24.8 34.6 28.1 23.7 27.4. 38.3 33 28.9 28.2 27.8 23.7 54.2 32.6 26.6 22.7 32.2 44 38.2 32 15.8 33.2 33.2 18.6 43.2 25.1 26.3 16.3 34 36.7 20.9 33 35 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 36 37 38 39 40 41 42 43 44 45 46 47 48 51 49 50 52 53 During the Covid-19 pandemic, working from home has become the norm. Because of this, many households face an increasing monthly electricity bill. 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 hypothesised 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 bill 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". (c) Apply an appropriate hypothesis test to determine if the average monthly electricity bill in a household during the Covid-19 pandemic is $5 greater than that before the Covid- 19 pandemic. (15 marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
