Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Year Quarter Average Quarterly Household Town Gas Consumption (kwh) 2010 Q1 177.6 2010 Q2 172.6 2010 Q3 174.3 2010 Q4 177.2 2011 Q1 176.6
Year Quarter Average Quarterly Household Town Gas Consumption (kwh) 2010 Q1 177.6 2010 Q2 172.6 2010 Q3 174.3 2010 Q4 177.2 2011 Q1 176.6 2011 Q2 172.7 2011 Q3 173.6 2011 Q4 173.9 2012 Q1 174.3 2012 Q2 171 2012 Q3 170.5 2012 Q4 169.4 2013 Q1 168.6 2013 Q2 165.7 2013 Q3 170.3 2013 Q4 166.9 2014 Q1 169.6 2014 Q2 160.6 2014 Q3 163.7 2014 Q4 159.8 2015 Q1 165.4 2015 Q2 160 2015 Q3 164.2 2015 Q4 162.5 2016 Q1 160.4 2016 Q2 157.5 2016 Q3 162.5 2016 Q4 156.8 2017 Q1 159 2017 Q2 156.1 2017 Q3 157.2 2017 Q4 150.3 2018 Q1 151.2 2018 Q2 146.2 2018 Q3 144.1 2018 Q4 139.9 2019 Q1 136.5 2019 Q2 133.9 2019 Q3 134.7 2019 Q4 129.9 2020 Q1 136.2 2020 Q2 157.2 2020 Q3 165.5 2020 Q4 140.2 2021 Q1 140.2 2021 Q2 138.4 There has been coherent effort by various national agencies to educate and encourage reduction in energy consumption among Singapore household over the years. As part of your social science school project, you have chosen to research on whether such campaign has found success among households living in 1-room and 2-room HDB flats. You have downloaded the latest town gas consumption data for further analysis. Please use relevant data in the Excel workbook Q2_input_file.xlsx in Canvas (next to this question paper) to answer the following questions and assume that today is 1st of August 2021. (a) (b) Comment on the underlying pattern in the average quarterly household town gas consumptions over 2010 Q1 - 2021 Q2. Please limit the answer to within one page. (10 marks) Use a suitable method to forecast the average quarterly household town gas consumptions for every quarter up to 2022 Q2 and make a statement to conclude your school project. You are required to show the essential steps in deriving the forecast and comment on any limitations of your technique. Please limit the answer to within two pages.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started