Mathematics AI SL's Sample Internal Assessment

Mathematics AI SL's Sample Internal Assessment

To what extent is there a Correlation between Price of Bitcoin over last twelve months

6/7
6/7
11 mins read
11 mins read
Candidate Name: N/A
Candidate Number: N/A
Session: N/A
Word count: 2,066

Table of content

Rationale

Recently, while surfing internet on my mobile, I have come across advertisements about bidding. I initially ignored them just like other advertisements but a few days back I came across few reviews which quite intrigued me into knowing about it more. It was about an app named Olympus Trade.

 

I was not at all sure whether it was genuine. It showcased interesting deals which grew the interest in me. As a teenager, I wanted to earn my own pocket money. This thought pushed me into gathering information about this app.

 

Once I decided to go along with it, the fear that it could be a fraud, persisted. As a result, I was determined that I would not invest a single penny without finding about it properly.

 

I went on to search all sources available. I came across the term 'Bitcoin'. My eyes popped out knowing the INR value of one bitcoin. Reading more about it, I went through all reviews, terms and conditions and much more.

 

After gathering enough information, I looked for its status in the last twelve months. It was very important for me to know how the bitcoin value changed over time and what the value was for a year. I looked at all possible sources but could not get an answer.

 

Unable to get a proper satisfactory answer, I decided to find it out myself before coming to a conclusion. So in this IA, I have tried to find the relationship between the price of bitcoin and time over a span of last twelve months.

Aim

The main motive of this IA is to find a correlation, if exist, between the price of Bitcoin and time over a span of 12 months. To make to study more accurate and detailed, the span of twelve months will be divided into four groups of 3 months each.

Research question

What is the relationship between the price of Bitcoin and time over a span of last twelve months?

Introduction

Bitcoin is a cryptocurrency which is currently very popular for purchasing and selling shares. It is a form of marketing which is used by several mobile apps. Customers usually buy a share of a bitcoin and sells accordingly. Based upon the price of the bitcoin at that moment, the consumer earns or losses his money. However, Bitcoin is often considered to be illegal in many countries as it is used in transactions executing criminal activities.

Data collection

The price of the Bitcoin over last one year has been collected from a statistical data present in an authentic website. The data is furnished below:

DatePrice of Bitcoin (in USD)
01/11/199131.41063
02/11/199197.63234
03/11/199290.8966
04/11/199202.41545
05/11/199369.62808
06/11/199326.59962
07/11/199335.7524
08/11/199226.48582
09/11/198794.35864
10/11/198798.04205
11/11/199081.18688
12/11/198711.53434
13/11/198760.89272
14/11/198749.52059
15/11/198656.97092
16/11/198500.64356
17/11/198469.2609
18/11/198537.33965
19/11/198205.80637
20/11/198118.48854
21/11/198074.84317
22/11/197612.74057
23/11/197262.11053
24/11/197303.40576
25/11/197041.73294
26/11/197211.86181
27/11/197141.06945
28/11/197523.48067
29/11/197390.20747
30/11/197729.26594
01/12/197542.23561
02/12/197381.96301
03/12/197333.43293
04/12/197315.36776
05/12/197213.73376
06/12/197398.78705
07/12/197511.88058
08/12/197532.12351
09/12/197550.2392
10/12/197333.09604
11/12/197239.76258
12/12/197198.06668
13/12/197190.27237
14/12/197238.87432
15/12/197087.02499
16/12/197112.73148
17/12/196883.49639
18/12/196584.02884
19/12/197424.0154
20/12/197147.56832
21/12/197139.93337
22/12/197286.33508
23/12/197236.9862
24/12/197166.17238
25/12/197235.62665
26/12/197212.8094
27/12/197183.70654
28/12/197227.29371
29/12/197311.56064
30/12/197385.46485
31/12/197251.27679
01/01/207179.95782
02/01/207174.74401
03/01/206955.48758
04/01/207291.21951
05/01/207337.63667
06/01/207347.43326
07/01/207713.86075
08/01/208039.6037
09/01/208067.60637
10/01/207808.70136
11/01/208087.45289
12/01/208078.99353
13/01/208149.31372
14/01/208116.96101
15/01/208735.14244
16/01/208843.67573
17/01/208711.63758
18/01/208925.29903
19/01/208939.8643
20/01/208638.18144
21/01/208652.68376
22/01/208708.78601
23/01/208635.07436
24/01/208384.08878
25/01/208451.2323
26/01/208347.56751
27/01/208562.30747
28/01/208881.96239
29/01/209131.11499
30/01/209320.97841
31/01/209545.07796

Figure 1 - Table On Price Of Bitcoin From 1st November 2019 to 31st January 2020

DatePrice of Bitcoin (in USD)
01/02/209388.88075
02/02/209363.19338
03/02/209385.26039
04/02/209269.70703
05/02/209177.89464
06/02/209625.45664
07/02/209681.37741
08/02/209795.34407
09/02/209927.77826
10/02/2010132.7065
11/02/209838.90002
12/02/2010236.6351
13/02/2010364.9263
14/02/2010218.0997
15/02/2010367.528
16/02/209926.35369
17/02/209876.23496
18/02/209636.62409
19/02/2010189.996
20/02/209701.03719
21/02/209631.48495
22/02/209670.85865
23/02/209689.08674
24/02/209919.55145
25/02/209640.46951
26/02/209392.86963
27/02/208787.97836
28/02/208784.99535
29/02/208778.47051
01/03/208639.59142
02/03/208548.94832
03/03/208923.0444
04/03/208791.11206
05/03/208756.96106
06/03/209078.57878
07/03/209126.63682
08/03/208925.21349
09/03/208166.31389
10/03/207875.75088
11/03/207959.22827
12/03/207955.30628
13/03/205800.2089
14/03/205672.6812
15/03/205304.14995
16/03/205355.18737
17/03/204944.70234
18/03/205465.58259
19/03/205363.82285
20/03/206301.0634
21/03/206185.27984
22/03/206187.05375
23/03/205884.34013
24/03/206455.45469
25/03/206784.31801
26/03/206706.98509
27/03/206721.49539
28/03/206682.78005
29/03/206229.48834
30/03/205922.48984
31/03/206483.73945
01/04/206446.42135
02/04/206537.33646
03/04/206850.55871
04/04/206776.37009
05/04/206855.93326
06/04/206805.36229
07/04/207278.24397
08/04/207175.66748
09/04/207367.2934
10/04/207321.81661
11/04/206866.39819
12/04/206873.8485
13/04/207043.43886
14/04/206889.86377
15/04/206887.55491
16/04/206718.79995
17/04/207166.58282
18/04/207065.08239
19/04/207277.14059
20/04/207185.8703
21/04/206856.14643
22/04/206904.47577
23/04/207118.38875
24/04/207562.03283
25/04/207497.86176
26/04/207542.3034
27/04/207624.85379
28/04/207776.50754
29/04/207761.75878
30/04/208773.10649

Figure 2 - Table On Price Of Bitcoin From 1st February 2020 To 30th April 2020

DatePrice of Bitcoin (in USD)
01/05/208767.67262
02/05/208853.77448
03/05/208963.05756
04/05/208904.71382
05/05/208887.50589
06/05/208978.28359
07/05/209371.68427
08/05/209900.67887
09/05/209917.24841
10/05/209617.51819
11/05/208786.65518
12/05/208608.12525
13/05/208815.23124
14/05/209330.98648
15/05/209757.29659
16/05/209362.63556
17/05/209418.91855
18/05/209684.70196
19/05/209723.68015
20/05/209719.48085
21/05/209540.88657
22/05/209141.15064
23/05/209192.84514
24/05/209220.07589
25/05/209048.71512
26/05/208905.7816
27/05/208835.72722
28/05/209112.97918
29/05/209507.52466
30/05/209425.28187
31/05/209688.32439
01/06/209427.67008
02/06/2010268.582
03/06/209516.13544
04/06/209667.06075
05/06/209811.36709
06/06/209659.6613
07/06/209677.05099
08/06/209737.45856
09/06/209791.9279
10/06/209786.14202
11/06/209874.96705
12/06/209260.83264
13/06/209464.2281
14/06/209458.65975
15/06/209351.95373
16/06/209441.769
17/06/209510.66064
18/06/209457.62707
19/06/209398.64209
20/06/209279.76077
21/06/209353.0782
22/06/209289.10449
23/06/209680.94713
24/06/209609.68025
25/06/209311.13632
26/06/209252.63337
27/06/209171.73209
28/06/209022.15377
29/06/209101.85006
30/06/209188.06138
01/07/209148.44486
02/07/209236.31677
03/07/209097.79737
04/07/209094.32456
05/07/209124.65353
06/07/209055.46448
07/07/209278.80564
08/07/209244.41581
09/07/209471.75997
10/07/209236.14325
11/07/209243.17526
12/07/209229.85975
13/07/209286.73704
14/07/209238.99375
15/07/209260.47098
16/07/209211.02643
17/07/209133.77783
18/07/209160.41059
19/07/209176.68639
20/07/209190.27153
21/07/209172.58833
22/07/209395.06445
23/07/209530.79089
24/07/209617.37786
25/07/209568.97473
26/07/209708.94914
27/07/209938.95122
28/07/2011187.7797
29/07/2010939.6701
30/07/2011284.459
31/07/2011118.9184

Figure 3 - Table On Price Of Bitcoin From 1st May 2020 To 31st July 2020

DatePrice of Bitcoin (in USD)
01/08/2011373.3173
02/08/2011766.7483
03/08/2011139.0984
04/08/2011261.8063
05/08/2011228.0263
06/08/2011653.4076
07/08/2011796.8174
08/08/2011639.9354
09/08/2011744.9121
10/08/2011673.1232
11/08/2011832.2273
12/08/2011340.5823
13/08/2011549.5463
14/08/2011752.1687
15/08/2011783.2834
16/08/2011895.6269
17/08/2011896.9472
18/08/2012399.1119
19/08/2012071.7389
20/08/2011749.8295
21/08/2011833.8973
22/08/2011583.1389
23/08/2011674.6244
24/08/2011666.4101
25/08/2011744.0127
26/08/2011378.726
27/08/2011458.8226
28/08/2011302.121
29/08/2011482.2257
30/08/2011515.0444
31/08/2011657.0039
01/09/2011678.3733
02/09/2011964.2087
03/09/2011427.7026
04/09/2010712.9206
05/09/2010563.8969
06/09/2010042.8549
07/09/2010207.605
08/09/201038.17761
09/09/2010043.1964
10/09/2010268.4609
11/09/2010341.016
12/09/2010380.5396
13/09/2010436.3654
14/09/2010313.0686
15/09/2010680.2976
16/09/2010829.5053
17/09/2011033.3835
18/09/2010937.1113
19/09/2010933.9312
20/09/2011048.8793
21/09/2010852.9101
22/09/2010526.2029
23/09/2010531.1646
24/09/2010260.033
25/09/2010672.9568
26/09/2010729.0696
27/09/2010741.4765
28/09/2010752.3454
29/09/2010863.0657
30/09/2010764.2844
01/10/2010741.5795
02/10/2010626.601
03/10/2010567.3302
04/10/2010555.0287
05/10/2010660.6112
06/10/2010756.4046
07/10/2010589.6264
08/10/2010645.7548
09/10/2010897.5954
10/10/2011052.3951
11/10/2011360.8527
12/10/2011334.0267
13/10/2011666.2117
14/10/2011443.7328
15/10/2011395.5474
16/10/2011504.549
17/10/2011355.1604
18/10/2011358.7064
19/10/2011471.0025
20/10/2011776.593
21/10/2011936.3629
22/10/2013102.9345
23/10/2013140.6693
24/10/2012933.8236
25/10/2013081.6726
26/10/2013008.4533
27/10/2013033.5243
28/10/2013721.2822
29/10/2013282.2603
30/10/2013467.7318
31/10/2013573.7105

Figure 4 - Table On Price Of Bitcoin From 1st August 2020 To 31st October 2020

Graphical analysis

Figure 5 - Price Of Bitcoin From November ’19 To January ‘20

Figure 6 - Price Of Price Of Bitcoin From November ’19 To January ‘20 ’20 To April ‘20

Figure 7 - Price Of Bitcoin From May ’20 To July ‘20

Figure 8 - Price Of Bitcoin From August ’20 To October ‘20

Figure 9 - Average Price Of Bitcoin From November ’19 To October ‘20

Calculation of R2

x

y

x2

y2

xy

19131.41063183382660.19131.41063
29197.63234484596440.718395.2647
39290.8966986320759.727872.6898
49202.415451684684450.136809.6618
59369.628082587789930.446848.1404
69326.599623686985460.555959.5977
79335.75244987156272.965350.2668
89226.485826485128040.673811.8866
98794.35864817734074479149.2278
108798.042051007740554487980.4205
119081.1868812182467955.199893.0557
128711.5343414475890830.5104538.412
138760.8927216976753241.2113891.605
148749.5205919676554110.6122493.288
158656.9709222574943145.6129854.564
168500.6435625672260940.9136010.297
178469.260928971728380.2143977.435
188537.3396532472886168.3153672.114
198205.8063736167335258.1155910.321
208118.4885440065909856.1162369.771
218074.8431744165203092.3169571.707
227612.7405748457953819167480.293
237262.1105352952738249.4167028.542
247303.4057657653339735.7175281.738
257041.7329462549586002.7176043.323
267211.8618167652010950.7187508.407
277141.0694572950994872.9192808.875
287523.4806778456602761.4210657.459
297390.2074784154615166.4214316.017
307729.2659490059741552231877.978
317542.2356196156885318233809.304
327381.96301102454493377.8236222.816
337333.43293108953779238.5242003.287
347315.36776115653514605.5248722.504
357213.73376122552037954.8252480.682
367398.78705129654742049.8266356.334
377511.88058136956428349.9277939.582
387532.12351144456732884.6286220.693
397550.2392152157006112294459.329
407333.09604160053774297.6293323.842
417239.76258168152414162.1296830.266
427198.06668176451812163.9302318.8
437190.27237184951700016.7309181.712
447238.87432193652401301.5318510.47
457087.02499202550225923.1318916.124
467112.73148211650590949.1327185.648
476883.49639220947382522.6323524.331
486584.02884230443349435.8316033.384
497424.0154240155116004.7363776.755
507147.56832250051087732.9357378.416
517139.93337260150978648.5364136.602
527286.33508270453090678.9378889.424
537236.9862280952373969.3383560.269
547166.17238291651354026.6386973.308
557235.62665302552354293397959.466
567212.8094313652024619.4403917.326
577183.70654324951605639.6409471.273
587227.29371336452233774.4419183.035
597311.56064348153458919431382.078
607385.46485360054545091443127.891
617251.27679372152581015.1442327.884
627179.95782384451551794.3445157.385
637174.74401396951476951.6452008.873
646955.48758409648378807.5445151.205
657291.21951422553161881.9473929.268
667337.63667435653840911.9484284.02
677347.43326448953984775.6492278.029
687713.86075462459503647.7524542.531
698039.6037476164635227.7554732.655
708067.60637490065086272.5564732.446
717808.70136504160975817554417.797
728087.45289518465406894.2582296.608
738078.99353532965270136.5589766.528
748149.31372547666411314.1603049.215
758116.96101562565885056608772.076
768735.14244577676302713.4663870.825
778843.67573592978210600.5680963.031
788711.63758608475892629.3679507.731
798925.29903624179660962.7705098.623
808939.8643640079921173.7715189.144
818638.18144656174618178.6699692.697
828652.68376672474868936.3709520.069
838708.78601688975842953.8722829.239
848635.07436705674564509.2725346.246
858384.08878722570292944.6712647.546
868451.2323739671423327.3726805.977
878347.56751756969681883.3726238.373
888562.30747774473313109.2753483.057
898881.96239792178889255.9790494.653
909131.11499810083377260.9821800.349
919320.97841828186880638.4848209.035
929545.07796846491108513.2878147.172

Σx = 4278

Σy = 733375.097

Σx2 = 263810

Σy2 = 5902800547

Σxy = 33977579

Figure 10 - Table On Processed Data For Calculation Of R2 For Group 1

r \(\frac{n\bigg(∑xy\bigg)-(∑x)(∑y)}{\sqrt{[n∑x^2-\bigg(∑x\bigg)^2][n∑y^2-\bigg(∑y\bigg)^2]}}\)

 

\( => r = \frac{92(33977579)-(4278)(733375.097)}{[92(263810)-(4278)^2][92(5902800547)-(733375.097)^2]}\)

 

=> r2 = 0.0042

x

y

x2

y2

xy

19388.88075188151081.89388.88075
29363.19338487669390.318726.3868
39385.26039988083112.528155.7812
49269.707031685927468.537078.8281
59177.89464258423375045889.4732
69625.456643692649415.557752.7398
79681.377414993729068.667769.6419
89795.344076495948765.478362.7525
99927.778268198560781.189350.0043
1010132.7065100102671741101327.065
119838.9000212196803953.5108227.9
1210236.6351144104788699122839.622
1310364.9263169107431697134744.042
1410218.0997196104409562143053.396
1510367.528225107485637155512.92
169926.3536925698532497.6158821.659
179876.2349628997540017167895.994
189636.6240932492864523.9173459.234
1910189.996361103836018193609.924
209701.0371940094110122.6194020.744
219631.4849544192765502.3202261.184
229670.8586548493525507.1212758.89
239689.0867452993878401.9222848.995
249919.5514557698397500.9238069.235
259640.4695162592938652.3241011.738
269392.8696367688225999.9244214.61
278787.9783672977228563.7237275.416
288784.9953578477176143.3245979.87
298778.4705184177061544.5254575.645
308639.5914290074642539.9259187.743
318548.9483296173084517.4265017.398
328923.0444102479620721.3285537.421
338791.11206108977283651.2290106.698
348756.96106115676684367297736.676
359078.57878122582420592.6317750.257
369126.63682129683295499.7328558.926
378925.21349136979659435.8330232.899
388166.31389144466688682.6310319.928
397875.75088152162027451.8307154.284
407959.22827160063349314.7318369.131
417955.30628168163286898.1326167.558
425800.2089176433642423.3243608.774
435672.6812184932179312243925.292
445304.14995193628134006.7233382.598
455355.18737202528678031.8240983.432
464944.70234211624450081.2227456.307
475465.58259220929872593.1256882.382
485363.82285230428770595.6257463.497
496301.0634240139703400308752.107
506185.27984250038257686.7309263.992
516187.05375260138279634.1315539.741
525884.34013270434625458.8305985.687
536455.45469280941672895.2342139.098
546784.31801291646026970.9366353.173
556706.98509302544983649368884.18
566721.49539313645178500.3376403.742
576682.78005324944659549.2380918.463
586229.48834336438806525361310.324
595922.48984348135075885.8349426.9
606483.73945360042038877.2389024.367
616446.42135372141556348.2393231.702
626537.33646384442736768405314.861
636850.55871396946930154.7431585.199
646776.37009409645919191.6433687.686
656855.93326422547003820.9445635.662
666805.36229435646312955.9449153.911
677278.24397448952972835.3487642.346
687175.66748462451490203.7487945.388
697367.2934476154277012508343.244
707321.81661490053608998.5512527.163
716866.39819504147147424.1487514.271
726873.8485518447249793.1494917.092
737043.43886532949610031514171.037
746889.86377547647470222.8509849.919
756887.55491562547438412.6516566.618
766718.79995577645142272.8510628.796
777166.58282592951359909.3551826.877
787065.08239608449915389.2551076.426
797277.14059624152956775.1574894.106
807185.8703640051636732574869.624
816856.14643656147006743.9555347.861
826904.47577672447671785.7566167.013
837118.38875688950671458.4590826.266
847562.03283705657184340.5635210.758
857497.86176722556217931637318.25
867542.3034739656886340.6648638.092
877624.85379756958138395.3663362.279
887776.50754774460474069.6684332.664
897761.75878792160244899.4690796.532
908773.10649810076967397.4789579.584
∑x = 4095∑y = 712404.228

∑x2 = 247065

∑y= 5837903479

∑xy = 30001786.8

Figure 11 - Table On Processed Data For Calculation Of R2 For Group 2

r \(\frac{n\bigg(∑xy\bigg)-(∑x)(∑y)}{\sqrt{[n∑x^2-\bigg(∑x\bigg)^2][n∑y^2-\bigg(∑y\bigg)^2]}}\)

 

\( => r = \frac{90(30001786.8)-(4095)(712404.228)}{\sqrt{[90(247065)-(4095)^2][90(5837903479)-(712404.228)^2]}}\)

 

=> r2 = 0.482

x

y

x2

y2

xy

18767.67262176872083.28767.67262
28853.77448478389322.617707.549
38963.05756980336400.826889.1727
48904.713821679293928.235618.8553
58887.50589257898776144437.5295
68978.283593680609576.253869.7015
79371.684274987828466.165601.7899
89900.67887649802344279205.4309
99917.248418198351816.189255.2357
109617.5181910092496656.296175.1819
118786.6551812177205309.396653.207
128608.1252514474099820.2103297.503
138815.2312416977708301.9114598.006
149330.9864819687067308.8130633.811
159757.2965922595204836.7146359.449
169362.6355625687658944.6149802.169
179418.9185528988716026.7160121.615
189684.7019632493793452174324.635
199723.6801536194549955.7184749.923
209719.4808540094468308.1194389.617
219540.8865744191028516.5200358.618
229141.1506448483560635201105.314
239192.8451452984508401.7211435.438
249220.0758957685009799.4221281.821
259048.7151262581879245.3226217.878
268905.781667679312946231550.322
278835.7272272978070075.6238564.635
289112.9791878483046389.5255163.417
299507.5246684190393025.2275718.215
309425.2818790088835938.3282758.456
319688.3243996193863629.5300338.056
329427.67008102488880963.2301685.443
3310268.5821089105443776338863.205
349516.13544115690556833.8323548.605
359667.06075122593452063.6338347.126
369811.36709129696262924.3353209.215
379659.6613136993309056.4357407.468
389677.05099144493645316367727.938
399737.45856152194818099.2379760.884
409791.9279160095881852391677.116
419786.14202168195768575.6401231.823
429874.96705176497514974.2414748.616
439260.83264184985763021.2398215.804
449464.2281193689571613.5416426.036
459458.65975202589466244.3425639.689
469351.95373211687459038.5430189.871
479441.769220989147001.8443763.143
489510.66064230490452665.8456511.711
499457.62707240189446709.9463423.727
509398.64209250088334473.2469932.105
519279.76077260186113959.9473267.799
529353.0782270487480071.7486360.066
539289.10449280986287462.3492322.538
549680.94713291693720737.3522771.145
559609.68025302592345954.4528532.414
569311.13632313686697259.5521423.634
579252.63337324985611224.3527400.102
589171.73209336484120669.5531960.461
599022.15377348181399258.6532307.072
609101.85006360082843674.5546111.003
619188.06138372184420471.8560471.744
629148.44486384483694043.3567203.581
639236.31677396985309547.5581887.957
649097.79737409682769916.9582259.031
659094.32456422582706739.2591131.096
669124.65353435683259302.1602227.133
679055.46448448982001437606716.12
689278.80564462486096234630958.783
699244.41581476185459223.8637864.691
709471.75997490089714237663023.198
719236.14325504185306342.2655766.171
729243.17526518485436288.9665508.619
739229.85975532985190311.1673779.762
749286.73704547686243484.9687218.541
759238.99375562585359005.6692924.532
769260.47098577685756322.8703795.794
779211.02643592984843007.9709249.035
789133.77783608483425897.5712434.671
799160.41059624183913122.2723672.437
809176.68639640084211573.1734134.911
819190.27153656184461090.9744411.994
829172.58833672484136376.7752152.243
839395.06445688988267235.9779790.349
849530.79089705690835974.9800586.434
859617.37786722592493956.9817477.118
869568.97473739691565277.3822931.826
879708.94914756994263693.4844678.575
889938.95122774498782751.4874627.708
8911187.77977921125166415995712.396
9010939.67018100119676383984570.313
9111284.45982811273390151026885.77
9211118.918484641236303471022940.49
∑x = 4278∑y = 867394.736

∑x= 263810

∑y2 = 8198700818

∑xy = 40700709

Figure 12 - Table On Processed Data For Calculation Of R2 For Group 3

\(r = \frac{n\bigg(∑xy\bigg)-(∑x)(∑y)}{\sqrt{[n∑x^2-\bigg(∑x\bigg)^2][n∑y^2-\bigg(∑y\bigg)^2]}}\)

 

\( => r = \frac{92(40700709)-(4278)(867394.736)}{\sqrt{[92(263810)-(4278)^2][92(8198700818)-(867394.736)^2]}}\)

 

=> r2 = 0.1001

x

y

x2

y2

xy

111373.3173112935234611373.3173
211766.7483413845636623533.4966
311139.0984912407951333417.2952
411261.80631612682828145047.2252
511228.02632512606857556140.1315
611653.40763613580190969920.4456
711796.81744913916490182577.7218
811639.93546413548809693119.4832
911744.912181137942960105704.209
1011673.1232100136261805116731.232
1111832.2273121140001603130154.5
1211340.5823144128608807136086.988
1311549.5463169133392020150144.102
1411752.1687196138113469164530.362
1511783.2834225138845768176749.251
1611895.6269256141505939190330.03
1711896.9472289141537353202248.102
1812399.1119324153737976223184.014
1912071.7389361145726880229363.039
2011749.8295400138058493234996.59
2111833.8973441140041125248511.843
2211583.1389484134169107254829.056
2311674.6244529136296855268516.361
2411666.4101576136105125279993.842
2511744.0127625137921834293600.318
2611378.726676129475405295846.876
2711458.8226729131304615309388.21
2811302.121784127737939316459.388
2911482.2257841131841507332984.545
3011515.0444900132596248345451.332
3111657.0039961135885740361367.121
3211678.37331024136384403373707.946
3311964.20871089143142290394818.887
3411427.70261156130592387388541.888
3510712.92061225114766668374952.221
3610563.89691296111595918380300.288
3710042.85491369100858935371585.631
3810207.6051444104195200387888.99
3910381.77611521107781275404889.268
4010043.19641600100865794401727.856
4110268.46091681105441289421006.897
4210341.0161764106936612434322.672
4310380.53961849107755602446363.203
4410436.36541936108917723459200.078
4510313.06862025106359384464088.087
4610680.29762116114068757491293.69
4710829.50532209117278185508986.749
4811033.38352304121735551529602.408
4910937.11132401119620404535918.454
5010933.93122500119550851546696.56
5111048.87932601122077734563492.844
5210852.91012704117785658564351.325
5310526.20292809110800947557888.754
5410531.16462916110905428568682.888
5510260.0333025105268277564301.815
5610672.95683136113912007597685.581
5710729.06963249115112934611556.967
5810741.47653364115379317623005.637
5910752.34543481115612932634388.379
6010863.06573600118006196651783.942
6110764.28443721115869819656621.348
6210741.57953844115381530665977.929
6310626.6013969112924649669475.863
6410567.33024096111668468676309.133
6510555.02874225111408631686076.866
6610660.61124356113648631703600.339
6710756.40464489115700240720679.108
6810589.62644624112140187720094.595
6910645.75484761113332095734557.081
7010897.59544900118757586762831.678
7111052.39515041122155437784720.052
7211360.85275184129068974817981.394
7311334.02675329128460161827383.949
7411666.21175476136100495863299.666
7511443.73285625130959020858279.96
7611395.54745776129858501866061.602
7711504.5495929132354648885850.273
7811355.16046084128939668885702.511
7911358.70646241129020211897337.806
8011471.00256400131583898917680.2
8111776.5936561138688143953904.033
8211936.36296724142476759978781.758
8313102.934568891716868931087543.56
8413140.669370561726771901103816.22
8512933.823672251672837931099375.01
8613081.672673961711301581125023.84
8713008.453375691692198571131735.44
8813033.524377441698727561146950.14
8913721.282279211882735851221194.12
9013282.260381001764184391195403.43
9113467.731882811813798001225563.59
9213573.710584641842456171248781.37
∑x = 4278∑y = 1047804.62

∑x2 = 263810

∑y2 = 11998253546

∑xy = 49153924.2

Figure 13 - Table On Processed Data For Calculation Of R2 For Group 4

\(r = \frac{n\bigg(∑xy\bigg)-(∑x)(∑y)}{\sqrt{[n∑x^2-\bigg(∑x\bigg)^2][n∑y^2-\bigg(∑y\bigg)^2]}}\)

 

\( => r = \frac{92(49153924.2)-(4278)(1047804.62)}{\sqrt{[92(263810)-(4278)^2][92(11998253546)-(1047804.62)^2]}}\)

 

=> r2 = 0.0447

Conclusion

In this IA, a correlation has been developed between the price of Bitcoin in last twelve months from November 2019 to October 2020. To make the study more accurate, the span of twelve months has been divided into four groups of three months each. For the first group, i.e., between the November 2019 to January 2020, the price of the Bitcoin is almost constant over the extremities. However, a considerable variation is changed throughout the 92 days. As a result, value of the correlation coefficient R2 is very less and equal to 0.0042. Such a less value of correlation coefficient significantly denies the existence of the correlation and thus it can be concluded that there exist no definite correlation between the price of the Bitcoin with time over the above-mentioned duration. Nevertheless, the equation of the trendline is shown below:

 

y = -1.9167x + 91954

 

For the second group, i.e., between the February 2020 to April 2020, the price of the Bitcoin is decreased over the duration. However, a considerable variation is changed throughout the 90 days. As a result, value of the correlation coefficient R2 is very less and equal to 0.482. The value of the coefficient is at a mid-way between 0 and 1 which though denies the existence of the correlation but with such a less value, it can be easily concluded that the correlation is not uniform throughout the duration which is significant from the graph as well. Nevertheless, the equation of the trendline is shown below:

 

y = -39.719x + 2X106

 

For the third group, i.e., between the May 2020 to July 2020, the price of the Bitcoin is increased over the duration. However, a considerable variation is changed throughout the 92 days. As a result, value of the correlation coefficient R2 is very less and equal to 0.1001. Such a less value of correlation coefficient significantly denies the existence of the correlation and thus it can be concluded that there exist no definite correlation between the price of the Bitcoin with time over the above-mentioned duration. Nevertheless, the equation of the trendline is shown below:

 

y = 5.6541x – 239337

 

For the fourth group, i.e., between the August 2020 to October 2020, the price of the Bitcoin is increased over the duration. However, a considerable variation is changed throughout the 92 days. As a result, value of the correlation coefficient R2 is very less and equal to 0.0447. Such a less value of correlation coefficient significantly denies the existence of the correlation and thus it can be concluded that there exist no definite correlation between the price of the Bitcoin with time over the above-mentioned duration. Nevertheless, the equation of the trendline is shown below

 

y = 6.6429x - 281492

Bibliography

  • Antonopoulos, Andreas M. Mastering Bitcoin: unlocking digital cryptocurrencies. " O'Reilly Media, Inc.", 2014.
  • “Bitcoin Price Index — CoinDesk 20.” CoinDesk, https://www.coindesk.com/price/bitcoin. Accessed 2 Nov. 2020.