Question 1 Refer to the files 'Excel 1 Bitcoin', 'Excel Ethereum' and 'Excel housing stock'. The...

    

Transcribed Image Text:

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) For each of these Series, use an appropriate method to visualise the dataset (30 marks). (iv) If a researcher wishes to compare Series 1 and Series 2 to identify relationships between the series, use an appropriate graphing method to display this relationship (10 marks). Dae 1/10/2015 23503938 1/11/2015 315.005005 1/12/2015 377.414001 1/1/2016 430.721008 1/2/2016 369.330006 1/3/2016 437.916992 416.75001 448.484009 531.106995 672.515015 624.60199 575.546021 609.929016 1/4/2016 1/5/2016 1/6/2016 1/7/2016 1/8/2016 1/9/2016 Open 1/10/2016 1/11/2016 701 336975 1/12/2016 745.046021 1/1/2017 963.65802 1/2/2017 970.940979 1/3/2017 1180.040039 1/4/2017 10717E951 1/5/2017 1348.3000 1/6/2017 2288 330078 1/7/2017 2492.600098 1/8/2017 2871.300049 1/9/2017 470173765 1/10/2017 4341.049805 1/11/2017 7446.830078 1/12/2017 10198.99961 1/1/2018 141122002 10237.29981 1/2/2018 1/3/2018 1/4/2018 1/5/2018 9251.469727 1/6/2018 7500.700195 6411.680176 7769.00039 1/9/2018 70448019 1/10/2018 6619.830098 1/11/2018 6318.140137 1/12/2018 1/7/2018 1/8/2018 10885 7003 0:0059 4024.464355 3746.713379 3460.547119 1/1/2019 1/2/2019 1/3/2019 3853.75708 1/4/2019 4105.362305 1/5/2019 $350.914551 1/5/2019 8573.839844 1/7/2019 10796.93066 1/8/2019 10077.44238 1/9/2019 9530532773 1/10/2019 8299.70T03 1/11/2019 9193992 1/12/2019 7571616 1/1/2020 7194.892 1/2/2020 9346357 1/3/2020 8599759 1/4/2020 6437.319 1/5/200 8672782 1/6/2020 9463.605 1/7/2020 9145.985 1/8/2020 11322 57 1/9/2020 11679.32 1/10/2020 10795.25 1/11/2020 13781 1/12/2020 1963.77 1/1/2021 28994.01 1/2/2021 33114.58 1/3/2021 45139.5 1/4/2021 38926.56 1/5/2021 57714.66 1/6/2021 37293.79 1/7/2021 3505.98 1/8/2021 41460.84 1/9/2021 47099.77 1/10/2021 43815.74 1/11/2021 61320.45 1/12/2021 56907.96 50430.3 25/12/2021 Date 1/10/2015 1/11/2015 1/12/2015 1/1/2016 1/2/2016 1/3/2016 1/4/2016 1/5/2016 1/6/2016 1/7/2016 1/8/2016 1/9/2016 1/10/2016 1/11/2016 1/12/2016 1/1/2017 1/2/2017 1/3/2017 1/4/2017 1/5/2017 1/6/2017 1/7/2017 1/8/2017 1/9/2017 1/10/2017 1/11/2017 1/12/2017 1/1/2018 1/2/2018 1/3/2018 1/4/2018 1/8/2018 1/9/2018 1/10/2018 Open 1/11/2018 1/12/2018 1/1/2019 1/2/2019 1/3/2019 1/4/2019 1/5/2019 1/6/2019 1/7/2019 1/8/2019 1/9/2019 1/10/2019 0.734307 0.920847 0.878316 0.931712 2.31969 6.31931 114005 8.77508 14.1098 124181 118948 116705 13.2032 109578 8.60162 7.98231 107413 158472 50.033699 79.321602 1/5/2018 670.463013 1/6/2018 578.671997 1/7/2018 455.242004 433.88988 283.496002 233.220001 197.537003 2:30.886002 293.352997 204.688004 383.46701 301 546997 308.644989 445.209015 755.757019 1119.349995 856.012024 397.253998 113.397758 133.418152 107.147682 136.836243 141.465485 162.186554 268.43335 290 298494 218.554596 172.438405 180 209122 1/11/2019 1/12/2019 1/1/2020 1/2/2020 1/3/2020 1/4/2020 1/5/2020 1/6/2020 1/7/2020 1/8/2020 1/9/2020 1/10/2020 1/11/2020 1/12/2020 1/1/2021 1/2/2021 1/3/2021 1417.151123 1/4/2021 1919.157227 2772838379 2707.540547 2274397461 2530462891 3430762451 1/5/2021 1/6/2021 1/7/2021 183803696 152491928 129630661 180.11377 219752686 133.61232 207.901733 230.85026 226134583 345798615 434874451 360309143 386.590332 615070313 737.708374 1314855225 1/8/2021 1/9/2021 1/10/2021 3001129395 1/11/2021 4288217285 1/12/2021 25/12/2021 4623.679688 4093.280518 Housing type Condominium/apartment Flat Low cost lat Low cost house Single storey terrace house 2-3 floor terrace house Single storey semi detached house 2-3 floor semi-detached house Detached house TOTAL Existing stock 514 396 1,438 9,117 7,123 1,557 4,380 1,077 748 26,350 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) For each of these Series, use an appropriate method to visualise the dataset (30 marks). (iv) If a researcher wishes to compare Series 1 and Series 2 to identify relationships between the series, use an appropriate graphing method to display this relationship (10 marks). Dae 1/10/2015 23503938 1/11/2015 315.005005 1/12/2015 377.414001 1/1/2016 430.721008 1/2/2016 369.330006 1/3/2016 437.916992 416.75001 448.484009 531.106995 672.515015 624.60199 575.546021 609.929016 1/4/2016 1/5/2016 1/6/2016 1/7/2016 1/8/2016 1/9/2016 Open 1/10/2016 1/11/2016 701 336975 1/12/2016 745.046021 1/1/2017 963.65802 1/2/2017 970.940979 1/3/2017 1180.040039 1/4/2017 10717E951 1/5/2017 1348.3000 1/6/2017 2288 330078 1/7/2017 2492.600098 1/8/2017 2871.300049 1/9/2017 470173765 1/10/2017 4341.049805 1/11/2017 7446.830078 1/12/2017 10198.99961 1/1/2018 141122002 10237.29981 1/2/2018 1/3/2018 1/4/2018 1/5/2018 9251.469727 1/6/2018 7500.700195 6411.680176 7769.00039 1/9/2018 70448019 1/10/2018 6619.830098 1/11/2018 6318.140137 1/12/2018 1/7/2018 1/8/2018 10885 7003 0:0059 4024.464355 3746.713379 3460.547119 1/1/2019 1/2/2019 1/3/2019 3853.75708 1/4/2019 4105.362305 1/5/2019 $350.914551 1/5/2019 8573.839844 1/7/2019 10796.93066 1/8/2019 10077.44238 1/9/2019 9530532773 1/10/2019 8299.70T03 1/11/2019 9193992 1/12/2019 7571616 1/1/2020 7194.892 1/2/2020 9346357 1/3/2020 8599759 1/4/2020 6437.319 1/5/200 8672782 1/6/2020 9463.605 1/7/2020 9145.985 1/8/2020 11322 57 1/9/2020 11679.32 1/10/2020 10795.25 1/11/2020 13781 1/12/2020 1963.77 1/1/2021 28994.01 1/2/2021 33114.58 1/3/2021 45139.5 1/4/2021 38926.56 1/5/2021 57714.66 1/6/2021 37293.79 1/7/2021 3505.98 1/8/2021 41460.84 1/9/2021 47099.77 1/10/2021 43815.74 1/11/2021 61320.45 1/12/2021 56907.96 50430.3 25/12/2021 Date 1/10/2015 1/11/2015 1/12/2015 1/1/2016 1/2/2016 1/3/2016 1/4/2016 1/5/2016 1/6/2016 1/7/2016 1/8/2016 1/9/2016 1/10/2016 1/11/2016 1/12/2016 1/1/2017 1/2/2017 1/3/2017 1/4/2017 1/5/2017 1/6/2017 1/7/2017 1/8/2017 1/9/2017 1/10/2017 1/11/2017 1/12/2017 1/1/2018 1/2/2018 1/3/2018 1/4/2018 1/8/2018 1/9/2018 1/10/2018 Open 1/11/2018 1/12/2018 1/1/2019 1/2/2019 1/3/2019 1/4/2019 1/5/2019 1/6/2019 1/7/2019 1/8/2019 1/9/2019 1/10/2019 0.734307 0.920847 0.878316 0.931712 2.31969 6.31931 114005 8.77508 14.1098 124181 118948 116705 13.2032 109578 8.60162 7.98231 107413 158472 50.033699 79.321602 1/5/2018 670.463013 1/6/2018 578.671997 1/7/2018 455.242004 433.88988 283.496002 233.220001 197.537003 2:30.886002 293.352997 204.688004 383.46701 301 546997 308.644989 445.209015 755.757019 1119.349995 856.012024 397.253998 113.397758 133.418152 107.147682 136.836243 141.465485 162.186554 268.43335 290 298494 218.554596 172.438405 180 209122 1/11/2019 1/12/2019 1/1/2020 1/2/2020 1/3/2020 1/4/2020 1/5/2020 1/6/2020 1/7/2020 1/8/2020 1/9/2020 1/10/2020 1/11/2020 1/12/2020 1/1/2021 1/2/2021 1/3/2021 1417.151123 1/4/2021 1919.157227 2772838379 2707.540547 2274397461 2530462891 3430762451 1/5/2021 1/6/2021 1/7/2021 183803696 152491928 129630661 180.11377 219752686 133.61232 207.901733 230.85026 226134583 345798615 434874451 360309143 386.590332 615070313 737.708374 1314855225 1/8/2021 1/9/2021 1/10/2021 3001129395 1/11/2021 4288217285 1/12/2021 25/12/2021 4623.679688 4093.280518 Housing type Condominium/apartment Flat Low cost lat Low cost house Single storey terrace house 2-3 floor terrace house Single storey semi detached house 2-3 floor semi-detached house Detached house TOTAL Existing stock 514 396 1,438 9,117 7,123 1,557 4,380 1,077 748 26,350

Answer rating: 100% (QA)

Question pyrthon code given below This part of code is common for all plots matplotlib inline import ... View the full answer