\fHow much is the average energy consumption by Australian households? The Excel file DailyElectricity.xIsx contains 30 Australian households' daily electricity consumption. Use Excel to complete the following sample summary statistics, assuming the daily electricity consumption is normally distributed. Type in each of the answers. 1. (1 mark) Mean = (KWh) (3 dp) 2. (1 mark) Median = (KWh) (3 dp) 3. (1 mark) Standard deviation = (KWh) (3 dp) 4. (1 mark) Range = (KWh) (3 dp) 5. (1 mark) Q1 = (KWh) (3 dp) 6. (1 mark) Q3 = (KWh) (3 dp) Copyright @ Macquarie University. Copying or distribution of part or all of the contents in any form is prohibited