Business Statistics - Bitcoin: Weekly Price and Return Analysis

This business statistics assignment provides an analysis of Bitcoin's weekly closing prices and calculates weekly returns from 2013 to 2019. The analysis begins with a graphical presentation of the closing price trends, revealing fluctuations and growth patterns over the specified period. The assignment then focuses on calculating the weekly returns using the formula: (Current year - Previous year) / Previous year * 100. The fluctuations and trends are presented with supporting references and an appendix containing the weekly dataset and return calculations. The report discusses the trends, fluctuations, and potential reasons behind the price movements, such as market interest and external allegations. The analysis concludes with an assessment of the weekly returns, highlighting periods of aggressive price movements and negative returns, offering insights into the investment performance of Bitcoin.

Business Statistics – Bitcoin

TABLE OF CONTENTS
1. Presenting weekly closing price of Bitcoin and commenting on the trend ...........................3
2. Calculating weekly return for BIT and constructing histogram from the dataset given.........3
REFERENCES ...............................................................................................................................4
APPENDIX......................................................................................................................................5
1. Weekly dataset related to Bitcoin............................................................................................5
2. Assessment of weekly return ................................................................................................13

l壱1. Presenting weekly closing price of Bitcoin and commenting on the trend
Graphical presentation
Charts are the graphical presentation for representing information about security prices
over time. Charts helps Bitcoin in plotting historical data which is based on combination of
volume, prices and time intervals. Charts are the prevalent method used by technical anlyst and
are known as chartist. Previously drawing of charts were done manually but nowadays majority
charts are prepared by computer.
For presenting the weekly analysis of closing price trend analysis has been used. It will
reveal the trends that were faced by company during the tenure from year 2013 to 2019.
company has seen very low fluctuations during the year 2013 only at the ending months.
Company during 2014 started to rise from the starting months as it was a new concept and
people showed interest towards it. Movement of the trend was slow which raise in its starting
period and slowed down reaching at end of year. From the year 2015 company did not showed
much fluctuations in its prices and pricing of company was found consistent to half of year 2016.

Growth was not aggressive of company in years 2013 to 2016 as company was its initial stage
and people were not trusting on its reliability (Feder and et.al, 2018). From the year 2017 shares
of company were bullish and took hike to 25000 points in the same year and seen significant
decline to 10000 points. Company shares were fluctuating during 2017 to 2018 but it is seen that
fluctuations were seen because of the allegations that were imposed on company.
From the year 2018 company prices were very fluctuating as it dropped to almost 5000
points and and from there it raised to over 16000 points with slight fluctuations in the trend over
the two years. Seeing the trend it can be analysed that company has putted its effort for raising
the performance because of which prices are showing rise (Historical data related to Bitcoin
USD. 2019).
l壱2. Calculating weekly return for BIT and constructing histogram from the dataset given

Investors are interested about only two things in their investment which are return and risk. It is
used by them for calculating the investments and comparing the investment opportunities of
company. It will help analysts to measure the increase or decrease in share prices of company.
Formula for calculating weekly returns of company = Current year - Previous year /
previous year * 100
The weekly returns of the BIT are calculated by company for measuring its performance.
The fluctuations are mostly seen in year between 2017 and 2019. The returns for the weeks
show that the prices were aggressive for continuously many weeks. Returns of company ranged
from 1 % to 28 % during its tenure. There were also negative returns that may be because of
trends of the market (Moore, Christin and Szurdi, 2018) The returns of company tend to fall for
continuously two to three weeks where when it rises growth was seen for continuous three to
four weeks. It shows that fluctuations were there but not constant.

·REFERENCES
Journals
Feder, A. and et.al, 2018. The impact of DDoS and other security shocks on Bitcoin currency
exchanges: Evidence from Mt. Gox. Journal of Cybersecurity. 3(2). pp.137-144.
Moore, T., Christin, N. and Szurdi, J., 2018. Revisiting the risks of bitcoin currency exchange
closure. ACM Transactions on Internet Technology (TOIT). 18(4). p.50.
Online
Historical data related to Bitcoin USD. 2019. [Online]. Available through: <
https://finance.yahoo.com/quote/BTC-USD/history/ >.

·APPENDIX
·1. Weekly dataset related to Bitcoin
BIT3/11/201352.063/18/201353.843/25/201399.994/1/2013139.234/8/2013113.074/15/201312
3.934/22/2013141.364/29/2013126.55/6/2013120.395/13/2013125.55/20/2013142.525/27/20131
37.886/3/2013115.666/10/2013120.986/17/2013125.286/24/2013111.977/1/201397.547/8/20131
14.957/15/201396.57/22/2013927/29/201399.958/5/2013125.498/12/2013104.18/19/2013109.53
8/26/2013158.759/2/2013136.129/9/2013147.879/16/2013143.099/23/2013142.089/30/2013140.
2410/7/2013151.7710/14/2013193.5210/21/2013213.8910/28/2013233.511/4/2013331.0511/11/
2013547.0811/18/2013974.5511/25/20131191.9912/2/20131016.2712/9/20131027.8212/16/201
3781.7812/23/2013889.1112/30/20139991/6/20141037.921/13/2014977.11/20/201410001/27/20
14928.992/3/20148502/10/20147402/17/2014728.372/24/20146503/3/2014674.733/10/2014669.
533/17/2014646.833/24/20145603/31/2014518.314/7/20144754/14/2014567.544/21/20144694/2
8/2014502.165/5/20144565/12/2014510.95/19/2014648.665/26/2014752.716/2/20147506/9/201
4671.716/16/20146906/23/20146656/30/2014661.27/7/2014692.147/14/2014614.127/21/201460
0.847/28/2014665.938/4/2014687.768/11/2014584.978/18/20145438/25/2014510.539/1/201453
7.929/8/2014562.439/15/2014424.449/22/2014460.159/29/2014353.3610/6/2014481.6410/13/20
14485.5510/20/2014449.9810/27/2014419.911/3/2014440.9811/10/2014463.9611/17/2014448.0
911/24/2014471.512/1/201447612/8/2014419.5512/15/2014434.9712/22/2014443.4612/29/2014
362.81/5/2015350.091/12/2015290.021/19/2015480.511/26/2015289.482/2/2015309.592/9/2015
323.92/16/2015323.52/23/2015354.853/2/2015351.343/9/2015405.863/16/2015349.823/23/2015
3803/30/2015320.564/6/2015379.944/13/20153654/20/20153004/27/2015324.685/4/2015295.91
5/11/2015345.035/18/2015327.365/25/2015369.696/1/2015328.86/8/2015320.56/15/2015312.87
6/22/2015325.626/29/2015362.187/6/2015443.587/13/2015412.157/20/2015401.967/27/201541
58/3/2015362.048/10/2015329.088/17/2015357.538/24/2015320.48/31/2015349.469/7/2015330.
89/14/2015323.279/21/2015346.489/28/2015350.6610/5/2015339.5910/12/2015373.5310/19/20
15400.0110/26/2015477.6911/2/2015551.3911/9/2015471.7911/16/2015476.8911/23/2015518.3
911/30/2015540.5812/7/2015605.4612/14/2015616.2412/21/2015581.2112/28/2015582.381/4/2
016642.21/11/2016554.281/18/2016573.921/25/2016532.582/1/2016529.392/8/2016567.052/15/
2016609.612/22/2016606.682/29/2016548.073/7/2016543.693/14/2016584.583/21/2016589.973
/28/2016585.824/4/2016555.664/11/2016574.934/18/2016616.194/25/2016588.285/2/2016655.8
75/9/2016642.675/16/2016612.755/23/2016701.275/30/2016788.696/6/2016903.096/13/201610
53.056/20/2016905.656/27/2016897.087/4/2016871.547/11/2016895.017/18/2016893.527/25/20
16823.188/1/2016787.938/8/2016750.58/15/20167608/22/20167708/29/2016815.69/5/20168149
/12/2016834.999/19/2016786.29/26/2016819.4210/3/2016815.5710/10/201685410/17/2016861.
0210/24/201692510/31/2016925.8311/7/2016931.911/14/20161000.5211/21/20161002.9711/28/
20161024.2712/5/20161075.212/12/20161106.212/19/20161235.9412/26/20161381.41/2/20171
244.411/9/20171095.161/16/20171223.21/23/20171238.341/30/20171347.742/6/20171341.482/
13/20171375.952/20/20171553.462/27/20171690.273/6/20171649.13/13/20171362.273/20/2017
1277.613/27/20171472.884/3/20171612.834/10/20171588.754/17/20171683.464/24/20171781.7
15/1/20172196.675/8/20172595.075/15/20172860.855/22/20173094.795/29/20173493.276/5/20
173889.466/12/20173588.866/19/20173503.316/26/20173342.767/3/20173415.517/10/2017251
07/17/20173541.57/24/20173529.747/31/20174060.538/7/20175318.148/14/20175298.768/21/2
01756208/28/20176018.49/4/20175319.469/11/20174593.059/18/20174625.389/25/20175565.3
610/2/20175887.3510/9/20177226.7610/16/20177713.9310/23/20178018.6510/30/20179692.39

11/6/20177924.8911/13/201710693.511/20/20171229811/27/201715024.212/4/201721184.912/
11/201725986.612/18/201718939.812/25/201719050.71/1/201822862.21/8/201819041.51/15/20
1815148.41/22/201814445.11/29/201810225.82/5/201810382.72/12/201813338.52/19/2018123
00.72/26/201814763.93/5/201812143.73/12/201810646.93/19/201811039.23/26/20188835.984/
2/20189130.394/9/201810654.34/16/201811357.24/23/201812432.84/30/201812682.65/7/20181
15605/14/201811318.55/21/20189752.025/28/201810233.16/4/20188956.316/11/20188717.196/
18/20188252.916/25/20188489.057/2/20188953.637/9/20188555.527/16/20189947.287/23/2018
11114.17/30/20189559.818/6/20188719.778/13/20188920.448/20/20189172.498/27/201810081.
29/3/20188802.439/10/20189058.839/17/20189118.229/24/20189139.6810/1/20189264.6910/8/
20188735.7410/15/20189005.4810/22/20189019.6110/29/20188908.9711/5/20188841.3911/12/
20187579.2411/19/20185435.5711/26/20185586.6512/3/20184914.8912/10/20184440.4412/17/
20185596.1812/24/20185456.2612/31/20185686.61/7/20194908.141/14/20194962.341/21/2019
4942.091/28/20194734.242/4/20195132.332/11/20195083.22/18/20195213.992/25/20195340.09
3/4/20195555.143/11/20195626.453/18/20195617.533/25/20195738.094/1/20197253.714/8/201
97214.664/15/20197437.264/22/20197405.254/29/20198120.415/6/20199962.315/13/20191188
4.95/20/201912617.35/27/201912606.96/3/201910983.86/10/201912961.36/17/201915572.96/2
4/201915180.27/1/2019163687/8/201914657.17/15/201915057.77/22/201913891.67/29/201916
132.98/5/201917037.68/12/201915348.8
l壱2. Assessment of weekly return
DateReturn of BIT (in %)3/18/20133.42%3/25/201385.72%4/1/201339.24%4/8/2013-
18.79%4/15/20139.60%4/22/201314.06%4/29/2013-10.51%5/6/2013-
4.83%5/13/20134.24%5/20/201313.56%5/27/2013-3.26%6/3/2013-
16.12%6/10/20134.60%6/17/20133.55%6/24/2013-10.62%7/1/2013-
12.89%7/8/201317.85%7/15/2013-16.05%7/22/2013-
4.66%7/29/20138.64%8/5/201325.55%8/12/2013-
17.05%8/19/20135.22%8/26/201344.94%9/2/2013-14.26%9/9/20138.63%9/16/2013-
3.23%9/23/2013-0.71%9/30/2013-
1.30%10/7/20138.22%10/14/201327.51%10/21/201310.53%10/28/20139.17%11/4/201341.78%
11/11/201365.26%11/18/201378.14%11/25/201322.31%12/2/2013-
14.74%12/9/20131.14%12/16/2013-
23.94%12/23/201313.73%12/30/201312.36%1/6/20143.90%1/13/2014-
5.86%1/20/20142.34%1/27/2014-7.10%2/3/2014-8.50%2/10/2014-12.94%2/17/2014-
1.57%2/24/2014-10.76%3/3/20143.80%3/10/2014-0.77%3/17/2014-3.39%3/24/2014-
13.42%3/31/2014-7.44%4/7/2014-8.36%4/14/201419.48%4/21/2014-
17.36%4/28/20147.07%5/5/2014-
9.19%5/12/201412.04%5/19/201426.96%5/26/201416.04%6/2/2014-0.36%6/9/2014-
10.44%6/16/20142.72%6/23/2014-3.62%6/30/2014-0.57%7/7/20144.68%7/14/2014-
11.27%7/21/2014-2.16%7/28/201410.83%8/4/20143.28%8/11/2014-14.95%8/18/2014-
7.17%8/25/2014-5.98%9/1/20145.37%9/8/20144.56%9/15/2014-
24.53%9/22/20148.41%9/29/2014-23.21%10/6/201436.30%10/13/20140.81%10/20/2014-
7.33%10/27/2014-6.68%11/3/20145.02%11/10/20145.21%11/17/2014-
3.42%11/24/20145.22%12/1/20140.95%12/8/2014-
11.86%12/15/20143.68%12/22/20141.95%12/29/2014-18.19%1/5/2015-3.50%1/12/2015-
17.16%1/19/201565.68%1/26/2015-39.76%2/2/20156.95%2/9/20154.62%2/16/2015-
0.12%2/23/20159.69%3/2/2015-0.99%3/9/201515.52%3/16/2015-

13.81%3/23/20158.63%3/30/2015-15.64%4/6/201518.52%4/13/2015-3.93%4/20/2015-
17.81%4/27/20158.23%5/4/2015-8.86%5/11/201516.60%5/18/2015-
5.12%5/25/201512.93%6/1/2015-11.06%6/8/2015-2.52%6/15/2015-
2.38%6/22/20154.08%6/29/201511.23%7/6/201522.48%7/13/2015-7.09%7/20/2015-
2.47%7/27/20153.24%8/3/2015-12.76%8/10/2015-9.10%8/17/20158.65%8/24/2015-
10.39%8/31/20159.07%9/7/2015-5.34%9/14/2015-
2.28%9/21/20157.18%9/28/20151.21%10/5/2015-
3.16%10/12/20159.99%10/19/20157.09%10/26/201519.42%11/2/201515.43%11/9/2015-
14.44%11/16/20151.08%11/23/20158.70%11/30/20154.28%12/7/201512.00%12/14/20151.78%
12/21/2015-5.68%12/28/20150.20%1/4/201610.27%1/11/2016-
13.69%1/18/20163.54%1/25/2016-7.20%2/1/2016-
0.60%2/8/20167.11%2/15/20167.51%2/22/2016-0.48%2/29/2016-9.66%3/7/2016-
0.80%3/14/20167.52%3/21/20160.92%3/28/2016-0.70%4/4/2016-
5.15%4/11/20163.47%4/18/20167.18%4/25/2016-4.53%5/2/201611.49%5/9/2016-
2.01%5/16/2016-
4.66%5/23/201614.45%5/30/201612.47%6/6/201614.51%6/13/201616.61%6/20/2016-
14.00%6/27/2016-0.95%7/4/2016-2.85%7/11/20162.69%7/18/2016-0.17%7/25/2016-
7.87%8/1/2016-4.28%8/8/2016-
4.75%8/15/20161.27%8/22/20161.32%8/29/20165.92%9/5/2016-
0.20%9/12/20162.58%9/19/2016-5.84%9/26/20164.23%10/3/2016-
0.47%10/10/20164.71%10/17/20160.82%10/24/20167.43%10/31/20160.09%11/7/20160.66%11
/14/20167.36%11/21/20160.24%11/28/20162.12%12/5/20164.97%12/12/20162.88%12/19/2016
11.73%12/26/201611.77%1/2/2017-9.92%1/9/2017-
11.99%1/16/201711.69%1/23/20171.24%1/30/20178.83%2/6/2017-
0.46%2/13/20172.57%2/20/201712.90%2/27/20178.81%3/6/2017-2.44%3/13/2017-
17.39%3/20/2017-6.21%3/27/201715.28%4/3/20179.50%4/10/2017-
1.49%4/17/20175.96%4/24/20175.84%5/1/201723.29%5/8/201718.14%5/15/201710.24%5/22/2
0178.18%5/29/201712.88%6/5/201711.34%6/12/2017-7.73%6/19/2017-2.38%6/26/2017-
4.58%7/3/20172.18%7/10/2017-26.51%7/17/201741.10%7/24/2017-
0.33%7/31/201715.04%8/7/201730.97%8/14/2017-
0.36%8/21/20176.06%8/28/20177.09%9/4/2017-11.61%9/11/2017-
13.66%9/18/20170.70%9/25/201720.32%10/2/20175.79%10/9/201722.75%10/16/20176.74%10
/23/20173.95%10/30/201720.87%11/6/2017-
18.24%11/13/201734.94%11/20/201715.00%11/27/201722.17%12/4/201741.01%12/11/201722
.67%12/18/2017-27.12%12/25/20170.59%1/1/201820.01%1/8/2018-16.71%1/15/2018-
20.45%1/22/2018-4.64%1/29/2018-29.21%2/5/20181.53%2/12/201828.47%2/19/2018-
7.78%2/26/201820.03%3/5/2018-17.75%3/12/2018-12.33%3/19/20183.68%3/26/2018-
19.96%4/2/20183.33%4/9/201816.69%4/16/20186.60%4/23/20189.47%4/30/20182.01%5/7/201
8-8.85%5/14/2018-2.09%5/21/2018-13.84%5/28/20184.93%6/4/2018-12.48%6/11/2018-
2.67%6/18/2018-5.33%6/25/20182.86%7/2/20185.47%7/9/2018-
4.45%7/16/201816.27%7/23/201811.73%7/30/2018-13.98%8/6/2018-
8.79%8/13/20182.30%8/20/20182.83%8/27/20189.91%9/3/2018-
12.68%9/10/20182.91%9/17/20180.66%9/24/20180.24%10/1/20181.37%10/8/2018-
5.71%10/15/20183.09%10/22/20180.16%10/29/2018-1.23%11/5/2018-0.76%11/12/2018-
14.28%11/19/2018-28.28%11/26/20182.78%12/3/2018-12.02%12/10/2018-
9.65%12/17/201826.03%12/24/2018-2.50%12/31/20184.22%1/7/2019-

13.69%1/14/20191.10%1/21/2019-0.41%1/28/2019-4.21%2/4/20198.41%2/11/2019-
0.96%2/18/20192.57%2/25/20192.42%3/4/20194.03%3/11/20191.28%3/18/2019-
0.16%3/25/20192.15%4/1/201926.41%4/8/2019-0.54%4/15/20193.09%4/22/2019-
0.43%4/29/20199.66%5/6/201922.68%5/13/201919.30%5/20/20196.16%5/27/2019-
0.08%6/3/2019-12.87%6/10/201918.00%6/17/201920.15%6/24/2019-
2.52%7/1/20197.83%7/8/2019-10.45%7/15/20192.73%7/22/2019-
7.74%7/29/201916.13%8/5/20195.61%8/12/2019-9.91%