Reference no: EM132378999
ECON 1030 - BUSINESS STATISTICS 1
PROJECT
Instructions:
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.
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
Locate the data file (Assignment_BusStats.xls) on CANVAS.
1. Use the most appropriate type of graph to present the weekly closing price of Bitcoin (BIT) and provide a general description, commenting on the trend. [Topic 1]
2. Calculate the weekly return for BIT and construct a histogram. Does the data on return rates appear normally distributed? On the basis of z-scores do you find evidence of outliers? Hint: the formula for a return is (Current Price - Previous price)/Previous price multiplied by 100. [Topics 1-4]
3. Calculate and interpret the three aspects of Descriptive Analysis for weekly return: Location, Shape and Spread. Hint: make sure you interpret these measures in the context of the data and pay attention to the unit of measurement.
4. Construct a 95% confidence interval for BIT return and interpret the interval.
5. An investment advisor claimed that BIT return is 2%. Do you agree? Justify your reasoning using a two-tailed hypothesis test approach at the significance level of 5%.
6. Repeat steps 1-5 above for another financial stock traded at the Australia Securities Exchange: the Macquarie Group Limited (MAC).
7. Explore the association between BIT and MAC returns. Specifically, construct a contingency table for the positive and non-positive returns of the two stocks and calculate the following: a) Prob (BIT return is positive), b) Prob (MAC return is positive), and c) Prob (positive BIT return conditional on positive MAC return). Are returns to BIT and MAC statistically independent? Hint: use the IF function in excel to construct the four joint events: +ve and +ve returns, +ve and -ve returns, -ve and +ve returns, -ve and -ve returns.
Part B
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, as compared with MAC. Hint: draw on the relevant evidence you have gathered from Part A, as well as other information/evidence not covered here but you believe is useful.
Note: Need Only Question 2,3 and 7 and thee ministerial brief
Attachment:- Business stats Assignment Instructions.rar