I need help with questions 2-7 in part A for BIT and BHP
ECON 1030 – BUSINESS STATISTICS 1 PROJECT Instructions: This is a group assignment with a minimum group size of two and a maximum group size of three. All group members must be enrolled in the same tutorial. There will be two parts to this assignment: Part A: Group Work (A Business Report) Part B: Individual Reflective Piece (A Ministerial Brief) The allocation of marks: Part A 30 Statistical Analysis 22 Professional Report 8 Part B 10 Total 40 Group members will receive a common mark for Part A and an individual mark for Part B. The response to Part A must be provided in the form of a business report with no more than 10 pages (including cover page). The structure of your business report must include 1] A Title, 2] An Executive Summary, 3] An Introduction, and 4] Conclusions. The response to Part B must be provided in the form of a ministerial brief with no more 200 words containing no more than three graphs. Please clearly indicate your student ID and name for your individual work. You must submit an electronic copy (group response to Part A & compilation of individual responses to Part B) of your assignment in Canvas. See an attached Template of your submission for more details. Only one submission is required per group. Hard copies will not be accepted. SHOW YOUR WORK for calculation based questions. This assignment requires the use of Microsoft Excel. If you have Windows, you will need to use the Data Analysis ToolPak. If you have a Mac with Excel 2011, you may need to use StatPlus:MAC LE. Sources used for this assignment include: · Share prices were downloaded from Yahoo finance. Problem Description: The blockchain is a decentralized ledger of all transactions across a peer-to-peer network. Using this technology, participants can confirm transactions without a need for a central clearing authority (or a middle man). According to some, replacing the middle man with a revolutionary technology that is faster, cheaper and as secure will greatly improve market efficiency. One application of blockchain technology in finance is the “cryptocurrencies”, with the best known example being “Bitcoin”. Some believe that such a secure, global, and digital currency represents the future of finance, while some are not optimistic about the future of Bitcoin and cryptocurrencies in general. Useful links on blockchain and cryptocurrencies: https://www.data61.csiro.au/en/our-work/safety-and-security/secure-systems-and-platforms/blockchain https://www.pwc.com/us/en/industries/financial-services/fintech/bitcoin-blockchain-cryptocurrency.html Your task is to evaluate recent prices of Bitcoin and based on this evidence whether individuals should invest in Bitcoin. There are two parts to this assignment, each of which is described in detail: Part A (Group Work: 2 + 2 + 2 + 2 + 4 + 3 + 3 + 4 = 22 marks; professional report = 8 marks) Locate the data file (Assignment Bus Stats.xls) on CANVAS. 1. Using the most appropriate type of graph to present weekly closing price of the Bitcoin and provide a general description. Hint: What are the main features of this graph, is there a trend? [Topic 1] 2. Calculate the weekly return and construct a histogram. Does the data appear normally distributed? Is there evidence of outliers? Hint: the formula for a return is (Current Price – Previous price)/Previous price multiplied by 100 [Topics 1-3] 3. Calculate and interpret the three aspects of Descriptive Analysis, Location, Shape and Spread, for weekly return. [Topic 1] 4. What is the empirical probability of a loss? [Topic 2] 5. Repeat the same steps (steps 1-4 above) for three share prices in the Australia Securities Exchange: BHP Billiton (BHP) from the mining sector, Commonwealth Bank of Australia (CBA) from the bank sector, and Telstra Corporation (TLS) from the telecom sector. 6. Construct a 95% confidence interval of the return to Bitcoin, and interpret the interval. How does your interval change if the level of confidence is 90% and 95% respectively, and explain why. [Topics 6-7] 7. Construct a 95% confidence interval of the return to BHP, CBA, and TLS respectively. [Topics 6-7] 8. An investment advisor claimed that the return to Bitcoin is 4% while the returns to other three shares are no different from zero. Do you agree? Justify your reasoning using a two-tailed hypothesis test approach at the significance level of 5%. [Topic 8] Part B (Individual Reflective Piece, 10 marks) Write a ministerial brief of no more than 200 words containing no more than three graphs on whether you can confidently recommend investing in the Bitcoin, compared with ONE of three shares: BHP, CBA, and TLS. Each student within a group has to comment on a different comparison. Hint: draw on the evidence you have gathered from Part A, as well as other information/evidence not covered here but you believe is useful. Please clearly indicate your student ID and name for your individual work (see Template). Raw Data DateBITCBABHPTLS 6/15/1469080.98120133.5932015.17 6/22/1466581.03099834.0323985.26 6/29/14661.20001281.508435.1069985.34 7/6/14692.14001580.79229735.1162995.33 7/13/14614.11999580.83200135.8731995.43 7/20/14600.84002781.83660136.4431995.45 7/27/14665.92999382.37370335.8918995.44 8/3/14687.7600179.69819635.26585.39 8/10/14584.96997180.76239836.4898995.58 8/17/1454380.17559835.3218995.71 8/24/14510.52999980.88179834.2659995.56 8/31/14537.91998380.861933.3128015.64 9/7/14562.42999379.79769933.4436995.54 9/14/14424.44000277.39070133.1539995.41 9/21/14460.14999474.85440131.92055.31 9/28/14353.35998576.23731.2570995.39 10/5/14481.64001574.39689630.1917995.29 10/12/14485.54998876.12750231.21035.38 10/19/14449.98001178.34549731.5285.5 10/27/14419.89999480.04630331.7336015.63 11/3/14440.98001182.31400332.2289015.77 11/10/14463.95999181.32939931.07025.8 11/17/14448.08999679.65840129.6217995.65 11/24/14471.580.28500428.89295.69 12/1/1447681.20010428.4256995.67 12/8/14419.54998881.299526.59425.7 12/15/14434.97000183.25890427.0800995.89 12/22/14443.45999184.46240227.0708015.91 12/29/14362.79998885.27827.6033995.97 1/5/15350.08999685.57630227.2483016.07 1/12/15290.01998983.11969825.27666.22 1/19/15480.5100185.76529727.4538996.34 1/26/15289.48001188.84860227.3418016.5 2/2/15309.58999692.47899629.48166.59 2/9/15323.89999492.64800330.0610016.59 2/16/15323.589.723930.1825016.61 2/23/15354.85000691.42469831.4446.37 3/2/15351.33999690.59909830.50026.28 3/9/15405.85998590.82790427.8096.2 3/16/15349.82000795.80090328.65936.37 3/23/1538093.83159628.73416.38 3/29/15320.55999893.89129628.23886.32 4/5/15379.94000293.62270428.1641016.28 4/12/1536591.58380128.0051996.14 4/19/1530091.60369929.94896.32 4/26/15324.67999388.44080430.36946.24 5/3/15295.91000482.19470229.2479996.17 5/10/15345.02999984.29329730.3600016.2 5/17/15327.35998582.66210229.256.2 5/24/15369.69000284.631529.596.22 5/31/15328.79998879.857327.96.01 6/7/15320.580.98120127.96.03 6/14/15312.86999584.01480128.416.13 6/21/15325.61999586.18309827.56.2 6/28/15362.17999386.19300126.596.13 7/5/15443.57998785.32769826.656.21 7/12/15412.14999487.50589827.16.42 7/19/15401.95999185.34760325.276.36 7/26/1541587.08820326.4500016.49 8/2/15362.04000980.861925.936.29 8/9/15329.07998781.67749825.326.08 8/16/15357.52999975.58999624.16.07 8/23/15320.39999476.36000125.495.82 8/30/15349.45999172.15000224.6900015.61 9/6/15330.79998875.12999723.7099995.55 9/13/15323.26998975.83000224.4599995.65 9/20/15346.48001171.44000222.935.67 9/27/15350.66000473.38999922.65.62 10/4/15339.58999675.52999925.65.64 10/11/15373.52999976.550003255.44 10/18/15400.0100177.34999824.595.58 10/26/15477.69000276.73000323.025.4 11/2/15551.39001576.58999622.7000015.31 11/9/15471.79000975.76000220.235.14 11/16/15476.89001579.83000220.55.41 11/23/15518.39001580.12000318.775.4 11/30/15540.58001780.22000117.935.41 12/7/15605.46002278.94999717.2000015.2 12/14/15616.2399981.5716.8700015.48 12/21/15581.21002283.3218.345.46 12/28/15582.38000585.52999917.8600015.61 1/4/16642.20001279.41999816.355.3 1/11/16554.28002978.87999715.075.33 1/18/16573.91998376.55999815.265.54 1/25/16532.58001778.66999815.355.63 2/1/16529.39001576.59999816.2000015.65 2/8/16567.04998873.33000215.095.57 2/15/16609.60998573.4316.6100015.28 2/22/16606.67999370.72000115.595.27 2/29/16548.07000775.73999817.675.13 3/7/16543.69000276.37000317.6100015.16 3/14/16584.58001778.16000418.15.22 3/21/16589.96997174.82175.25 3/27/16585.82000772.98999816.9699995.26 4/3/16555.65997370.76000216.185.16 4/10/16574.9299937519.2800015.24 4/17/16616.19000275.04000120.3600015.4 4/24/16588.28002973.88999920.685.36 5/1/16655.86999574.34999818.4599995.6 5/8/16642.66998377.38999918.2000015.68 5/15/16612.7578.12000318.855.66 5/22/16701.2700278.90000219.3700015.67 5/29/16788.69000275.7518.5300015.59 6/5/16903.09002775.48999818.7999995.46 6/12/161053.05004972.02999918.085.31 6/19/16905.65002472.5717.5400015.35 6/26/16897.08001773.83000219.095.58 7/3/16871.53997872.41000419.0499995.59 7/10/16895.0100175.94000220.3700015.75 7/17/16893.5200277.13999919.2999995.8 7/24/16823.17999377.34999819.525.77 7/31/16787.92999376.15000220.0300015.66 8/7/16750.576.01000220.685.45 8/14/1676073.44999721.2900015.48 8/21/1677073.26000220.8799995.3 8/28/16815.59997670.91000419.855.12 9/4/1681470.87000320.7800015.06 9/11/16834.9899972.23999820.095.1 9/18/16786.20001273.40000221.5300015.19 9/25/16819.41998372.40000222.3799995.18 10/2/16815.57000774.37999723.2999995.01 10/9/1685474.58000222.5400015.08 10/16/16861.0200274.90000223.0400015.04 10/23/1692572.7522.984.95 10/31/16925.83001770.98999822.274.9 11/7/16931.90002475.77999924.9400014.72 11/14/161000.5200276.86000124.14.93 11/21/161002.96997178.16999826.55.03 11/28/161024.2700278.59999825.024.95 12/5/161075.19995180.66999825.984.99 12/12/161106.19995181.059998254.91 12/19/161235.93994182.524.6299995.04 12/26/161381.40002482.41000425.0599995.1 1/2/171244.41003484.12999725.55.26 1/9/171095.16003483.86000126.335.22 1/16/171223.19995181.58000226.355.14 1/23/171238.33996682.98000327.525.11 1/30/171347.7399981.6826.2000015.08 2/6/171341.4799882.90000225.8799995.16 2/13/171375.94995185.38999926.6399994.84 2/20/171553.45996183.01999725.0599994.81 2/27/171690.2700283.19999725.344.59 3/6/171649.09997684.523.674.64 3/13/171362.2700284.76999724.844.76 3/20/171277.60998583.37999724.264.59 3/26/171472.88000585.91000424.0400014.66 4/2/171612.82995684.76999724.594.56 4/9/171588.7586.2524.3099994.16 4/16/171683.45996185.63999924.0400014.23 4/23/171781.70996187.40000223.7199994.22 4/30/172196.66992284.40000222.6200014.4 5/7/172595.07006881.66999823.754.36 5/14/172860.85009880.23000324.2800014.43 5/21/173094.79003980.13999924.014.48 5/28/173493.2700280.37999724.074.49 6/4/173889.45996179.19000223.5400014.37 6/11/173588.86010781.86000122.994.38 6/18/173503.31005981.2522.414.35 6/25/173342.7600182.80999823.2800014.3 7/2/173415.5100182.12999724.594.32 7/9/17251083.12000325.1299994.3 7/16/173541.583.97000124.494.1 7/23/173529.7399983.76000225.334.11 7/30/174060.53002980.72000125.7199994.07 8/6/175318.14013780.525.5499994.15 8/13/175298.75976679.08999625.3899993.9 8/20/17562077.72000126.683.92 8/27/176018.39990275.48000327.423.67 9/3/175319.45996173.23999827.2900013.7 9/10/174593.04980576.27999926.263.65 9/17/174625.37988376.62000325.9500013.58 9/24/175565.35986375.2525.7800013.49 10/1/175887.35009876.30000326.6100013.44 10/8/177226.75976676.66000426.3600013.52 10/15/177713.93017678.97000126.683.52 10/22/178018.64990278.23999826.593.55