Question 1 Refer to the files 'Excel 1 Bitcoin', 'Excel Ethereum' and 'Excel housing stock'. The dataset contains the (i) Series 1: Opening prices of Bitcoin (USD) (ii) Series 2: Opening price of Ethereum (USD) (iii) Series 3: Existing housing stock in Malaysia (by housing segments) 4 For each of these Series, use an appropriate method to visualise the dataset (30 marks). A B D EXCEL-ETHEREUM Open 0.734307 1/4/2017 0.920847 1/5/2017 0.878316 1/6/2017 0.933712 1/7/2017 2.31969 6.31931 1/8/2017 1/9/2017 11.4006 1/10/2017 8.77508 1/11/2017 14.1098 1/12/2017 12.4381 1/1/2018 11.8948 1/2/2018 11.6705 1/3/2018 13.2032 1/4/2018 10.9578 1/5/2018 8.60162 1/6/2018 7.98231 1/7/2018 10.7413 1/8/2018 15.8472 1/9/2018 1 2 Date 31/10/2015 4 1/11/2015 5 1/12/2015 6 1/1/2016 7 1/2/2016 8 1/3/2016 9 1/4/2016 10 1/5/2016 11 1/6/2016 12 1/7/2016 13 1/8/2016 14 1/9/2016 15 1/10/2016 16 1/11/2016 17 1/12/2016 18 1/1/2017 19 1/2/2017 20 1/3/2017 21 22 F G 50.033699 1/10/2018 79.321602 1/11/2018 230.886002 1/12/2018 293.352997 1/1/2019 204.688004 1/2/2019 383.46701 1/3/2019 301.546997 1/4/2019 308.644989 1/5/2019 445.209015 1/6/2019 755.757019 1/7/2019 1119.369995 1/8/2019 856.012024 1/9/2019 397.253998 1/10/2019 670.463013 1/11/2019 578.671997 1/12/2019 455.242004 1/1/2020 433.868988 1/2/2020 283.496002 1/3/2020 H 233.220001 1/4/2020 1/5/2020 197.537003 113.397758 1/6/2020 133.418152 1/7/2020 107.147682 1/8/2020 136.836243 1/9/2020 141.465485 1/10/2020 162.186554 1/11/2020 268.43335 1/12/2020 290.268494 1/1/2021 218.554596 1/2/2021 172.458405 1/3/2021 180.209122 1/4/2021 183.803696 1/5/2021 1/6/2021 152.491928 129.630661 1/7/2021 180.11377 1/8/2021 219.752686 1/9/2021 M 133.61232 1/10/2021 207.901733 1/11/2021 230.86026 1/12/2021 226.134583 26/12/2021 345.798615 434.874451 360.309143 386.590332 615.070313 737.708374 1314.855225 1417.151123 1919.157227 2772.838379 2707.560547 2274.397461 2530.462891 3430.762451 + N 3001.129395 4288.217285 4623.679688 4093.280518 C Question 1 Refer to the files 'Excel 1 Bitcoin', 'Excel Ethereum' and 'Excel housing stock'. The dataset contains the (i) Series 1: Opening prices of Bitcoin (USD) (ii) Series 2: Opening price of Ethereum (USD) (iii) Series 3: Existing housing stock in Malaysia (by housing segments) 4 For each of these Series, use an appropriate method to visualise the dataset (30 marks). A B D EXCEL-ETHEREUM Open 0.734307 1/4/2017 0.920847 1/5/2017 0.878316 1/6/2017 0.933712 1/7/2017 2.31969 6.31931 1/8/2017 1/9/2017 11.4006 1/10/2017 8.77508 1/11/2017 14.1098 1/12/2017 12.4381 1/1/2018 11.8948 1/2/2018 11.6705 1/3/2018 13.2032 1/4/2018 10.9578 1/5/2018 8.60162 1/6/2018 7.98231 1/7/2018 10.7413 1/8/2018 15.8472 1/9/2018 1 2 Date 31/10/2015 4 1/11/2015 5 1/12/2015 6 1/1/2016 7 1/2/2016 8 1/3/2016 9 1/4/2016 10 1/5/2016 11 1/6/2016 12 1/7/2016 13 1/8/2016 14 1/9/2016 15 1/10/2016 16 1/11/2016 17 1/12/2016 18 1/1/2017 19 1/2/2017 20 1/3/2017 21 22 F G 50.033699 1/10/2018 79.321602 1/11/2018 230.886002 1/12/2018 293.352997 1/1/2019 204.688004 1/2/2019 383.46701 1/3/2019 301.546997 1/4/2019 308.644989 1/5/2019 445.209015 1/6/2019 755.757019 1/7/2019 1119.369995 1/8/2019 856.012024 1/9/2019 397.253998 1/10/2019 670.463013 1/11/2019 578.671997 1/12/2019 455.242004 1/1/2020 433.868988 1/2/2020 283.496002 1/3/2020 H 233.220001 1/4/2020 1/5/2020 197.537003 113.397758 1/6/2020 133.418152 1/7/2020 107.147682 1/8/2020 136.836243 1/9/2020 141.465485 1/10/2020 162.186554 1/11/2020 268.43335 1/12/2020 290.268494 1/1/2021 218.554596 1/2/2021 172.458405 1/3/2021 180.209122 1/4/2021 183.803696 1/5/2021 1/6/2021 152.491928 129.630661 1/7/2021 180.11377 1/8/2021 219.752686 1/9/2021 M 133.61232 1/10/2021 207.901733 1/11/2021 230.86026 1/12/2021 226.134583 26/12/2021 345.798615 434.874451 360.309143 386.590332 615.070313 737.708374 1314.855225 1417.151123 1919.157227 2772.838379 2707.560547 2274.397461 2530.462891 3430.762451 + N 3001.129395 4288.217285 4623.679688 4093.280518 C
