Urban Rural 986.5 764.12 1005.76 813.86 1024.39 865.67 1178.32 809.25 1018.59 863.47 986.39 728.76 1124.21 869.88 1175.63 741.86 985.54 823.91 922.91 825.21 1043.19 903.42 1157.02 867.77 1042.14 799.01 1053.65 836.88 958.03 786.9 966.28 685.56 1069.42 697.56 974.42 781.38 1094.81 896.84 1080.76 843.29 1098.39 848.83 1002.42 904.52 1109.03 787.43 1149.42 839.78 1011.95 772.28 1028.36 840.45 943.26 816.08 979.16 820.48 1021.8 774.67 841.53 832.94 956.4 763.77 949.11 853.42 994.62 832.56 997.41 797.72 1038.25 907.27 1061.89 1027.65 845.36 789.59 960.84 888.84 986.33 834.81 919.68 645.28 The company's sustainability policies included a commitment to phase in the use of renewable energy sources. Management wished to compare the number of megawatt hours of renewable energy purchased by branches in urban and in rural areas. 40 branches in urban areas and 40 branches in rural areas were randomly selected and the amounts of renewable energy (purchased in the previous month) were recorded for each branch and are stored in Renewables.xlsx. Download and open the file into Excel. Use Excel to undertake a suitable test to address the research question below. Is there a difference between the average amount of renewable energy purchased by branches in urban and rural areas? Urban Rural 0 2 4 6 8 10 1 Frequency i ti o bio 800 900 1000 1100 1200 600 700 800 900 1000 Megawatts hours Differences Megawatts hours Kaunbal zi obca 0 100 400 Rural Urban Megawas difference Answer the following questions by choosing the most correct option or typing the answer 1. (1 mark) The most appropriate test for these data is: 2. (1 mark) The normality assumption seems reasonable because: 3. (1 mark) The assumption of equal variance seems reasonable because: For the remaining questions you may assume that any relevant assumptions have been met 4. (2 marks) The absolute value of the test statistic is equal to (type your answer with 3 dp) 5. (1 mark) The degrees of freedom is equal to (type your answer as an integer) 6. [1 mark) The p-value is larger than 0.05 7. (2 marks) The test shows that average number of megawatt hours of renewable energy purchased was Urban Rural 986.5 764.12 1005.76 813.86 1024.39 865.67 1178.32 809.25 1018.59 863.47 986.39 728.76 1124.21 869.88 1175.63 741.86 985.54 823.91 922.91 825.21 1043.19 903.42 1157.02 867.77 1042.14 799.01 1053.65 836.88 958.03 786.9 966.28 685.56 1069.42 697.56 974.42 781.38 1094.81 896.84 1080.76 843.29 1098.39 848.83 1002.42 904.52 1109.03 787.43 1149.42 839.78 1011.95 772.28 1028.36 840.45 943.26 816.08 979.16 820.48 1021.8 774.67 841.53 832.94 956.4 763.77 949.11 853.42 994.62 832.56 997.41 797.72 1038.25 907.27 1061.89 1027.65 845.36 789.59 960.84 888.84 986.33 834.81 919.68 645.28 The company's sustainability policies included a commitment to phase in the use of renewable energy sources. Management wished to compare the number of megawatt hours of renewable energy purchased by branches in urban and in rural areas. 40 branches in urban areas and 40 branches in rural areas were randomly selected and the amounts of renewable energy (purchased in the previous month) were recorded for each branch and are stored in Renewables.xlsx. Download and open the file into Excel. Use Excel to undertake a suitable test to address the research question below. Is there a difference between the average amount of renewable energy purchased by branches in urban and rural areas? Urban Rural 0 2 4 6 8 10 1 Frequency i ti o bio 800 900 1000 1100 1200 600 700 800 900 1000 Megawatts hours Differences Megawatts hours Kaunbal zi obca 0 100 400 Rural Urban Megawas difference Answer the following questions by choosing the most correct option or typing the answer 1. (1 mark) The most appropriate test for these data is: 2. (1 mark) The normality assumption seems reasonable because: 3. (1 mark) The assumption of equal variance seems reasonable because: For the remaining questions you may assume that any relevant assumptions have been met 4. (2 marks) The absolute value of the test statistic is equal to (type your answer with 3 dp) 5. (1 mark) The degrees of freedom is equal to (type your answer as an integer) 6. [1 mark) The p-value is larger than 0.05 7. (2 marks) The test shows that average number of megawatt hours of renewable energy purchased was