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)
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
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc3b7fb4a-c313-4eeb-80f4-13d565cf5353%2F9eec6694-4405-4c95-8e68-56605cc63e9b%2F6g0ctiv_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)