Question 1 Refer to the files 'Excel 1 Bitcoin', 'Excel Ethereum' and 'Excel housing stock'. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Intermediate Accounting
ISBN: 978-0132162302
1st edition
Authors: Elizabeth A. Gordon, Jana S. Raedy, Alexander J. Sannella
Posted Date:
Students also viewed these finance questions
-
A researcher wishes to compare the prices of three types of lawnmowers. At = 0.10, can it be concluded that there is a difference in the prices? Based on your answer, do you feel that the cost...
-
A researcher wishes to compare the prices for prescription drugs in the United States with those in Canada. The same drugs and dosages were compared in each country. At = 0.05, can it be concluded...
-
A researcher wishes to compare two hotels on the following attributes: Convenience of location Friendly personnel Value for money a. Design a Likert scale to accomplish this task. b. Design a...
-
Roles define the manager. Do you agree or disagree with this statement? Discuss what you think managers do.
-
Why are adjusting entries necessary?
-
Determine the standard heal of each of the following reactions at 25(C: (a) N2(g) + 3H2(g) ( 2NH3(g) (b) 4NH3(g) + 5O2(g) ( 4NO(g) + 6H2O(g) (c) 3NO2(g) + H2O(l) ( 2HNO3(l) + NO(g) (d) CaC2(s) +...
-
Choosing a lottery payout option (Learning Objective 3) Congratulations! You've won a state lotto. The state lottery offers you the following (after-tax) payout options: Assuming that you can earn...
-
Ten interrelated elements that are most directly related to measuring the performance and financial status of an enterprise are provided below. Identify the element or elements associated with the 12...
-
Question 3 3 p The ultimate purpose of the balanced scorecard is to give management a balanced view of the company's performa q , True False
-
How would the right squares on the board be painted the color of the tetromino and the tetromino gets hidden? Java Language and located in the gray-out comment section in the image. /** * Starts...
-
exxon mobil & shell company pls reference all the material used Provide guidance to a corporation/organization/business on how to become more sustainable by utilizing the UNSDGs. also give info about...
-
ABC Company has a \(\$ 14\) million convertible bond outstanding that requires payment of \(\$ 1.2\) million in interest annually. Interest expense is \(\$ 1.35\) million. Why is interest expense...
-
Barbaro Ltd. plans to disclose a calculation of per share cash flow from operating activities in addition to EPS. What conditions must the company meet?
-
A company with a 31 December year-end issues shares for cash and retires nonconvertible bonds with the proceeds on 10 January of the next fiscal year. What disclosure is required in the 31 December...
-
Under what circumstances are the EPS of prior years to be restated?
-
You are testing that the mean speed of your cable Internet connection is more than three Megabits per second. State the null and alternative hypotheses.
-
Leaders who are high on initiating structure exhibit which of the following characteristics? Multiple Choice prioritize planning, scheduling, and trying out new ideas create a climate of good rapport
-
The water in tank A is at 270 F with quality of 10% and mass 1 lbm. It is connected to a piston/cylinder holding constant pressure of 40 psia initially with 1 lbm water at 700 F. The valve is opened,...
-
Printmaster Distributors Company sells laser printers and replacement toner cartridges. Printmaster sells two models black and color laser printers. The black printers and black toner cartridges are...
-
Limmox Company has conformity between its taxable income and income before taxes. Limmox Companys net income after taxes is $ 195,000 and its tax rate is 35%. What is its taxes payable?
-
Immox Company has conformity between its taxable income and income before taxes. If Immoxs taxes payable are $ 140,000 and its tax rate is 40%, what is its net income?
-
What are the two types of auditors? Briefly define them.
-
How does Philip Wallages view of the audit process compare the empirical scientific cycle to the financial audit process?
-
What are the five components of internal control? Give a sentence on each.
Study smarter with the SolutionInn App