1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the alternative hypothesis that Volume has a linear relationship to Price Change. Specifically, what are the test statistic and the p-value for that test statistic? For α = .05, what do you conclude about the relationship between the variables? (reminder: the T.DIST.2T function requires input of a positive test statistic)

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Cryptocurrencies have rapidly become an important alternative to traditional currencies for many types of transactions. Etherium, one of the most prominent cryptocurrencies, has rapidly appreciated in value. Daily Etherium trading information for the first 332 days of 2021. 

It includes the following variables:

Date

Day – Day of the year, used to assess trend over time

Volume (US $) – Daily trading volume

Opening Price (US $) – Opening price for daily trading

Price Change (US $) – Daily change in price from opening to close

1. Determine the sample correlation coefficient, r, between Volume and Price Change. Test the alternative hypothesis that Volume has a linear relationship to Price Change. Specifically, what are the test statistic and the p-value for that test statistic? For α = .05, what do you conclude about the relationship between the variables? (reminder: the T.DIST.2T function requires input of a positive test statistic)

Date
Day
Volume
Opening Price
Price Change
1/1/21
1
13652004358
737.7084
-7.3408
1/2/21
2
19740771179
730.4026
44.1323
1/3/21
3
45200463368
774.5118
200.9958
1/4/21
4
56945985763
977.0588
63.1742
1/5/21
41535932781
1041.4988
58.5073
1/6/21
44699914188
1101.0050
106.1072
1/7/21
7
40468027280
1208.0784
17.5997
1/8/21
8
44334826666
1225.9679
-1.7708
1/9/21
9
33233105361
1223.7405
57.3368
1/10/21
10
40616938053
1280.8711
-18.6244
1/11/21
11
60733630300
1261.6229
-171.4775
1/12/21
12
37494601692
1088.5267
-45.0922
1/13/21
13
30109792795
1043.7410
86.9984
1/14/21
14
33410915929
1130.2312
88.2218
1/15/21
15
35972039310
1221.8772
-50.0426
1/16/21
16
32319240157
1171.4431
62.0945
1/17/21
17
29258032819
1233.4534
-3.2811
1/18/21
18
25817455560
1230.3132
26.9663
1/19/21
19
47195935190
1257.4346
119.8613
1/20/21
20
46784030909
1375.2484
7.0256
1/21/21
21
45932464754
1382.6844
-261.1135
1/22/21
22
43918338506
1118.8890
117.6232
1/23/21
23
27253895441
1235.2679
-4.2773
1/24/21
24
36418163554
1231.2106
160.3988
1/25/21
25
43565777745
1390.6399
-66.2251
1/26/21
26
41572917750
1323.7417
33.3164
1/27/21
27
39394416990
1358.3334
-105.1462
1/28/21
28
39790481941
1251.2798
46.8220
1/29/21
29
53611955259
1369.0868
13.4360
1/30/21
30
30616574234
1382.2319
-6.1165
1/31/21
31
25198853581
1376.8236
-61.8374
2/1/21
32
29210670920
1314.8552
54.1853
2/2/21
33
45437142801
1369.5051
145.6886
2/3/21
34
41874566399
1514.7697
146.1399
2/4/21
35
44396871836
1661.1702
-66.4075
2/5/21
36
40108628454
1594.7933
123.8575
2/6/21
37
39873420648
1717.7975
-39.9507
2/7/21
38
39889440151
1677.6057
-63.3779
2/8/21
39
48012285956
1613.6422
132.9746
2/9/21
40
44180727529
1746.9261
21.1089
2/10/21
41
41916084617
1768.0398
-23.7964
2/11/21
42
36021495262
1743.7142
40.0837
2/12/21
43
37905036865
1783.4891
60.0435
2/13/21
44
35359490535
1843.9868
-29.8770
2/14/21
45
31439114900
1814.3723
-9.2882
2/15/21
46
38955610883
1804.6768
-24.8857
Transcribed Image Text:Date Day Volume Opening Price Price Change 1/1/21 1 13652004358 737.7084 -7.3408 1/2/21 2 19740771179 730.4026 44.1323 1/3/21 3 45200463368 774.5118 200.9958 1/4/21 4 56945985763 977.0588 63.1742 1/5/21 41535932781 1041.4988 58.5073 1/6/21 44699914188 1101.0050 106.1072 1/7/21 7 40468027280 1208.0784 17.5997 1/8/21 8 44334826666 1225.9679 -1.7708 1/9/21 9 33233105361 1223.7405 57.3368 1/10/21 10 40616938053 1280.8711 -18.6244 1/11/21 11 60733630300 1261.6229 -171.4775 1/12/21 12 37494601692 1088.5267 -45.0922 1/13/21 13 30109792795 1043.7410 86.9984 1/14/21 14 33410915929 1130.2312 88.2218 1/15/21 15 35972039310 1221.8772 -50.0426 1/16/21 16 32319240157 1171.4431 62.0945 1/17/21 17 29258032819 1233.4534 -3.2811 1/18/21 18 25817455560 1230.3132 26.9663 1/19/21 19 47195935190 1257.4346 119.8613 1/20/21 20 46784030909 1375.2484 7.0256 1/21/21 21 45932464754 1382.6844 -261.1135 1/22/21 22 43918338506 1118.8890 117.6232 1/23/21 23 27253895441 1235.2679 -4.2773 1/24/21 24 36418163554 1231.2106 160.3988 1/25/21 25 43565777745 1390.6399 -66.2251 1/26/21 26 41572917750 1323.7417 33.3164 1/27/21 27 39394416990 1358.3334 -105.1462 1/28/21 28 39790481941 1251.2798 46.8220 1/29/21 29 53611955259 1369.0868 13.4360 1/30/21 30 30616574234 1382.2319 -6.1165 1/31/21 31 25198853581 1376.8236 -61.8374 2/1/21 32 29210670920 1314.8552 54.1853 2/2/21 33 45437142801 1369.5051 145.6886 2/3/21 34 41874566399 1514.7697 146.1399 2/4/21 35 44396871836 1661.1702 -66.4075 2/5/21 36 40108628454 1594.7933 123.8575 2/6/21 37 39873420648 1717.7975 -39.9507 2/7/21 38 39889440151 1677.6057 -63.3779 2/8/21 39 48012285956 1613.6422 132.9746 2/9/21 40 44180727529 1746.9261 21.1089 2/10/21 41 41916084617 1768.0398 -23.7964 2/11/21 42 36021495262 1743.7142 40.0837 2/12/21 43 37905036865 1783.4891 60.0435 2/13/21 44 35359490535 1843.9868 -29.8770 2/14/21 45 31439114900 1814.3723 -9.2882 2/15/21 46 38955610883 1804.6768 -24.8857
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman