. What is the relationship between Gold prices and Dollar Index? Column C, D, E and F represented the market data during Open, High, Low and Close respectively

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Hi can explain? tq

1. What is the relationship between Gold prices and Dollar Index?

Column C, D, E and F represented the market data during Open, High, Low and Close respectively

Dollar Index Daily Data
A
B
C
D
E F G
2020.09.11
0:00
93.345
93.39
93.065
93.215
36761
2020.11.05
0:00
93.395 93.525
92.46
92.53
32746
2020.09.14
0:00
93.255
93.33
93.03
93.075
8628
2020.11.06
0:00
92.735 92.815
92.16
92.295
29952
2020.09.15
0:00
93.045
93.17
92.785
93.095
19669
2020.11.09
0:00
92.195
92.96
92.105
92.805
40115
2020.09.16
0:00
93.125
93.29
92.785
93.115
30916
2020.11.10
0:00
92.795
92.96
92.575
92.695
32550
2020.09.17
0:00
93.18
93.62
92.87
92.91
30964
2020.11.11
0:00
92.7
93.185
92.58
92.965
21438
2020.09.18
0:00
92.89
93.035
92.765
92.995
21802
2020.11.12
0:00
92.965
93.115
92.745
92.94
21346
2020.09.21
0:00
92.97
93.785
92.74
93.545
22727
2020.11.13
0:00
92.94
92.995
92.665
92.665
15296
2020.09.22
0:00
93.58
94.105
93.495
93.995
29047
2020.11.16
0:00
92.68
92.84
92.435
92.515
20982
2020.09.23
0:00
94.015
94.485
93.96
94.43
28615
2020.11.17
0:00
92.455
92.6
92.245
92.36
16382
2020.09.24
0:00
94.44
94.645
94.22
94.36
29812
17117
14901
2020.11.18
0:00
92.435
92.495
92.185 92.375
2020.09.25
0:00
94.34
94.79
94.215
94.595
25758
2020.11.19
0:00
92.5
92.715
92.22
92.295
2020.09.28
0:00
94.575
94.66
94.165
94.3
23198
2020.11.20
0:00
92.295
92.42
92.175
92.36
16538
2020.09.29
0:00
94.175
94.34
93.845
93.9
22309
2020.11.23
0:00
92.345
92.765
91.995
92.53
17708
2020.09.30
0:00
93.895
94.24
93.685
93.87
30804
2020.11.24
0:00
92.5
92.545
92.095
18343
92.105
2020.10.01
0:00
93.86
93.975
93.56
93.795
28380
2020.11.25
0:00
92.11
92.245
91.9
92.005
19501
2020.10.02
0:00
93.77
94.08
93.72
93.875
32782
2020.11.26
0:00
91.92
92.16
91.82
92.005
10142
2020.10.05
0:00
93.865
93.9
93.405
93.465
17859
2020.11.27
0:00
91.985
92.025
91.735
91.815
13624
2020.10.06
0:00
93.435
93.905
93.365
93.84
25654
2020.11.30
0:00
91.735
92.03
91.485
92.005
21135
2020.10.07
0:00
93.86
93.96
93.59
93.655
18717
2020.12.01
0:00
91.885
91.9
91.275
91.345
15727
2020.10.08
0:00
93.655
93.815
93.51
93.59
16709
2020.12.02
0:00
91.185
91.49
90.975 90.975
23499
2020.10.09
0:00
93.57
93.61
92.995 93.035
17478
2020.12.03
0:00
91.065
91.08
90.495
90.65
20921
2020.10.12
0:00
93.11
93.265
93.015
93.04
12815
2020.12.04
0:00
90.65
90.86
90.46
90.73
23847
2020.10.13
0:00
93.05
93.6
93.04
93.495
17847
2020.12.07
0:00
90.755
91.23
90.6
90.82
23993
2020.10.14
0:00
93.535
93.67
93.23
93.38
17177
2020.12.08
0:00
90.885 91.015 90.735 90.955
22053
2020.10.15
0:00
93.405
93.875
93.355
93.815
17063
2020.12.09
0:00
90.885 91.195
90.68
91.005
20264
2020.10.16
0:00
93.805
93.875
93.515
93.69
17650
2020.12.10
0:00
91.045
91.15
90.65
90.77
20908
2020.10.19
0:00
93.695
93.76
93.185
93.385
15876
2020.12.11
0:00
90.725 91.045
90.6
90.94
14575
2020.10.20
0:00
93.41
93.5
92.975
93.06
15741
2020.10.21
0:00
93.045
93.045
92.45
92.61
19896
2020.10.22
0:00
92.705
92.98
92.6
92.92
16912
2020.10.23
0:00
92.965
93.115
92.635
92.705
17014
2020.10.26
0:00
92.8
93.1
92.77
93.04
15413
2020.10.27
0:00
93.055
93.12
92.77
93.02
13764
2020.10.28
0:00
93.1
93.655
93.025
93.475
21486
2020.10.29
0:00
93.465
94.13
93.34
93.905
22973
2020.10.30
0:00
93.91
94.095
93.655
94.04
21524
2020.11.02
0:00
94.13
94.305
93.985
94.045
13405
2020.11.03
0:00
94.03
94.05
93.29
93.385
17133
2020.11.04
0:00
93.655
94.31
93.235
93.41
55082
Transcribed Image Text:Dollar Index Daily Data A B C D E F G 2020.09.11 0:00 93.345 93.39 93.065 93.215 36761 2020.11.05 0:00 93.395 93.525 92.46 92.53 32746 2020.09.14 0:00 93.255 93.33 93.03 93.075 8628 2020.11.06 0:00 92.735 92.815 92.16 92.295 29952 2020.09.15 0:00 93.045 93.17 92.785 93.095 19669 2020.11.09 0:00 92.195 92.96 92.105 92.805 40115 2020.09.16 0:00 93.125 93.29 92.785 93.115 30916 2020.11.10 0:00 92.795 92.96 92.575 92.695 32550 2020.09.17 0:00 93.18 93.62 92.87 92.91 30964 2020.11.11 0:00 92.7 93.185 92.58 92.965 21438 2020.09.18 0:00 92.89 93.035 92.765 92.995 21802 2020.11.12 0:00 92.965 93.115 92.745 92.94 21346 2020.09.21 0:00 92.97 93.785 92.74 93.545 22727 2020.11.13 0:00 92.94 92.995 92.665 92.665 15296 2020.09.22 0:00 93.58 94.105 93.495 93.995 29047 2020.11.16 0:00 92.68 92.84 92.435 92.515 20982 2020.09.23 0:00 94.015 94.485 93.96 94.43 28615 2020.11.17 0:00 92.455 92.6 92.245 92.36 16382 2020.09.24 0:00 94.44 94.645 94.22 94.36 29812 17117 14901 2020.11.18 0:00 92.435 92.495 92.185 92.375 2020.09.25 0:00 94.34 94.79 94.215 94.595 25758 2020.11.19 0:00 92.5 92.715 92.22 92.295 2020.09.28 0:00 94.575 94.66 94.165 94.3 23198 2020.11.20 0:00 92.295 92.42 92.175 92.36 16538 2020.09.29 0:00 94.175 94.34 93.845 93.9 22309 2020.11.23 0:00 92.345 92.765 91.995 92.53 17708 2020.09.30 0:00 93.895 94.24 93.685 93.87 30804 2020.11.24 0:00 92.5 92.545 92.095 18343 92.105 2020.10.01 0:00 93.86 93.975 93.56 93.795 28380 2020.11.25 0:00 92.11 92.245 91.9 92.005 19501 2020.10.02 0:00 93.77 94.08 93.72 93.875 32782 2020.11.26 0:00 91.92 92.16 91.82 92.005 10142 2020.10.05 0:00 93.865 93.9 93.405 93.465 17859 2020.11.27 0:00 91.985 92.025 91.735 91.815 13624 2020.10.06 0:00 93.435 93.905 93.365 93.84 25654 2020.11.30 0:00 91.735 92.03 91.485 92.005 21135 2020.10.07 0:00 93.86 93.96 93.59 93.655 18717 2020.12.01 0:00 91.885 91.9 91.275 91.345 15727 2020.10.08 0:00 93.655 93.815 93.51 93.59 16709 2020.12.02 0:00 91.185 91.49 90.975 90.975 23499 2020.10.09 0:00 93.57 93.61 92.995 93.035 17478 2020.12.03 0:00 91.065 91.08 90.495 90.65 20921 2020.10.12 0:00 93.11 93.265 93.015 93.04 12815 2020.12.04 0:00 90.65 90.86 90.46 90.73 23847 2020.10.13 0:00 93.05 93.6 93.04 93.495 17847 2020.12.07 0:00 90.755 91.23 90.6 90.82 23993 2020.10.14 0:00 93.535 93.67 93.23 93.38 17177 2020.12.08 0:00 90.885 91.015 90.735 90.955 22053 2020.10.15 0:00 93.405 93.875 93.355 93.815 17063 2020.12.09 0:00 90.885 91.195 90.68 91.005 20264 2020.10.16 0:00 93.805 93.875 93.515 93.69 17650 2020.12.10 0:00 91.045 91.15 90.65 90.77 20908 2020.10.19 0:00 93.695 93.76 93.185 93.385 15876 2020.12.11 0:00 90.725 91.045 90.6 90.94 14575 2020.10.20 0:00 93.41 93.5 92.975 93.06 15741 2020.10.21 0:00 93.045 93.045 92.45 92.61 19896 2020.10.22 0:00 92.705 92.98 92.6 92.92 16912 2020.10.23 0:00 92.965 93.115 92.635 92.705 17014 2020.10.26 0:00 92.8 93.1 92.77 93.04 15413 2020.10.27 0:00 93.055 93.12 92.77 93.02 13764 2020.10.28 0:00 93.1 93.655 93.025 93.475 21486 2020.10.29 0:00 93.465 94.13 93.34 93.905 22973 2020.10.30 0:00 93.91 94.095 93.655 94.04 21524 2020.11.02 0:00 94.13 94.305 93.985 94.045 13405 2020.11.03 0:00 94.03 94.05 93.29 93.385 17133 2020.11.04 0:00 93.655 94.31 93.235 93.41 55082
Gold Daily Data
A
В
C
D E F
G
2020.09.11
0:00
1944.69
1954.66 1937.11
1940.19
345554
2020.11.05
1902.91
1952.65
1901.95
1948,83
346178
0:00
2020.09.14
0:00
1940.65
1962.4 1936.29
1955.98
270305
2020.11.06
0:00
1947.57
1960.22 1935.45
1951.11
315759
2020.09.15
0:00
1956.91
1972.03
1948.34
1953.26
292475
2020.11.09
0:00
1953.97
1965.46
1850.28
1861.12
493276
2020.09.16
0:00
1951.06 1973.55
1949.74
1957.88
373631
2020.11.10
0:00
1862.57
1890.24
1859.9
1876.55
358137
2020.09.17
0:00
1958.55
1960,83
1932.67
1943.3
401986
2020.11.11
0:00
1876.27
1884.34
1856.17
1864.47
264239
2020.09.18
0:00
1941.75
1960.02
1941.75
1950.41
320143
1949 55
1911.46
509091
2020.11.12
0:00
1864.47
1883.64
1862.56
1876.01
257560
2020.09.21
0:00
1955.54
1882.07
2020.09.22
0:00
1911.97
1919.98
1894.69
1899.3
504466
2020.11.13
0:00
1875.47
1896.69
1873.79
1889.31
229056
2020.09.23
0:00
1899.67 1905.34
1855.65
1862.58
610332
2020.11.16
0:00 1887.45
1898.9
1864.12
1887.82
271626
2020.09.24
0:00
1863.06 1877.02 1848.74
1866.82
648229
2020.11.17
0:00
1888.07
1893.37
1876.74
1879.98
221762
2020.09.25
0:00
1867.43 1875.06
1852.17
1863.65
504696
2020.11.18
0:00
1879.77
1884.73
1863,47
1872
237867
2020.09.28
0:00
1858.73
1882.88
1848.51
1880,62
443938
2020.11.19
0:00
1871.67 1873.86 1852.43
1864.49
233885
2020.09.29
0:00
1879.7 1899.06 1875.41
1896.82
428855
2020.11.20
2020.11.23
0:00
1865.56
1879.65
1860.71
1873.16
244842
2020.09.30
0:00
1897.38
1902.18
1881.4
1884.98
430921
0:00
1870.33
1875.94
1830,84
1836,77
277114
2020.10.01
0:00
1883.94 1912.11
1883.94
1904.73
423652
2020.11.24
0:00 1836.34
1838.88
1800.25
1806.71
358308
2020.10.02
0:00
1904.48
1916.96 1889.73
1897.18
377753
2020.11.25
0:00
1806.46
1817.59
1801.64
1806.77
254536
2020.10.05
0:00
1903.92
1918.68
1886.95
1912.62
300355
2020,11.26
0:00
1806.83
1818.16
1805.64
1808.87
121200
2020.10.06
0:00
1910.61
1921.09
1874.53
1876.44
357596
2020.11.27
0:00
1809.59
1813.67
1774.17 1787.43
207477
2020.10.07
0:00 1876.06
1897.9 1872.85
1886.46
341126
1886.66
1900.61
1881.84
1892.96
292892
2020.11.30
0:00
1786.23
1789.84
1764.21
1776.28
281034
2020.10.08
0:00
2020.10.09
1893.22
1930.4
1893.2
1930.11
333176
2020.12.01
0:00
1776.32 1817.19 1775.63
1814.63
285269
0:00
2020.10.12
0:00
1928,65
1933.15
1918.12
1921.95
327070
2020,12.02
0:00
1815.03
1832.28 1807.33 1830.25
272770
2020.10.13
0:00
1920.06 1925.34 1886.36 1890.23
396176
2020.12.03
0:00
1830.09
1843.85
1823.61
1840.21
275234
2020.10.14
0:00
1890.37
1912.85
1882.26 1900.82
347924
2020.12.04
0:00
1840,85
1848.14 1829.04 1837.09
255434
2020.10.15
0:00
1901.47
1908.8 1889.38 1907.91
367478
2020.12.07
0:00
1837.03 1868.46
1821.8 1861.92
279530
2020.10.16
0:00
1904.86
1913.88 1897.66 1900.56
303080
2020.12.08
0:00
1861.61
1875.12
1860.08
1869.46
245243
2020,10.19
0:00
1899.59
1918.48
1896.89 1903.56
314381
2020.12.09
0:00
1870.03
1870.8
1825.29
1838.83
338224
2020.10.20
0:00
1901.65
1914.02 1894.38
1904.92
303672
2020.12.10
1838.96
1849.92 1828.55
1835.88
327094
0:00
2020.10.21
0:00
1906.59
1931.39
1906.59
1923.91
314030
2020.12.11
0:00
1835.21
1847.64
1823.87
1839.32
272922
2020.10.22
0:00
1923.65
1925.96 1894.24 1903.4I
287230
2020.10.23
0:00
1902.82
1914.12 1894.18 1900.77
250652
2020.10.26
0:00
1902.6 1908.56 1891.24
1901.66
281183
2020.10.27
0:00
1901.46 19111.34
1897.79 1907.37
217377
2020,10.28
0:00
1906.48
1910.77 1869.27
1876.36
348293
2020,10.29
0:00
1873.78
1884.89
1859.82
1867.01
346441
2020.10.30
0:00 1865.86 1889.71
1864.21
1878.76
357883
2020.11.02
0:00 1876.55
1895.96
1873.31
1894.12
271142
2020.11.03
0:00
1891.42
1910.45 1886.86 1907.75
246224
2020.11.04
0:00 1907.59
1916.25
1881.15
1902.91
477652
Transcribed Image Text:Gold Daily Data A В C D E F G 2020.09.11 0:00 1944.69 1954.66 1937.11 1940.19 345554 2020.11.05 1902.91 1952.65 1901.95 1948,83 346178 0:00 2020.09.14 0:00 1940.65 1962.4 1936.29 1955.98 270305 2020.11.06 0:00 1947.57 1960.22 1935.45 1951.11 315759 2020.09.15 0:00 1956.91 1972.03 1948.34 1953.26 292475 2020.11.09 0:00 1953.97 1965.46 1850.28 1861.12 493276 2020.09.16 0:00 1951.06 1973.55 1949.74 1957.88 373631 2020.11.10 0:00 1862.57 1890.24 1859.9 1876.55 358137 2020.09.17 0:00 1958.55 1960,83 1932.67 1943.3 401986 2020.11.11 0:00 1876.27 1884.34 1856.17 1864.47 264239 2020.09.18 0:00 1941.75 1960.02 1941.75 1950.41 320143 1949 55 1911.46 509091 2020.11.12 0:00 1864.47 1883.64 1862.56 1876.01 257560 2020.09.21 0:00 1955.54 1882.07 2020.09.22 0:00 1911.97 1919.98 1894.69 1899.3 504466 2020.11.13 0:00 1875.47 1896.69 1873.79 1889.31 229056 2020.09.23 0:00 1899.67 1905.34 1855.65 1862.58 610332 2020.11.16 0:00 1887.45 1898.9 1864.12 1887.82 271626 2020.09.24 0:00 1863.06 1877.02 1848.74 1866.82 648229 2020.11.17 0:00 1888.07 1893.37 1876.74 1879.98 221762 2020.09.25 0:00 1867.43 1875.06 1852.17 1863.65 504696 2020.11.18 0:00 1879.77 1884.73 1863,47 1872 237867 2020.09.28 0:00 1858.73 1882.88 1848.51 1880,62 443938 2020.11.19 0:00 1871.67 1873.86 1852.43 1864.49 233885 2020.09.29 0:00 1879.7 1899.06 1875.41 1896.82 428855 2020.11.20 2020.11.23 0:00 1865.56 1879.65 1860.71 1873.16 244842 2020.09.30 0:00 1897.38 1902.18 1881.4 1884.98 430921 0:00 1870.33 1875.94 1830,84 1836,77 277114 2020.10.01 0:00 1883.94 1912.11 1883.94 1904.73 423652 2020.11.24 0:00 1836.34 1838.88 1800.25 1806.71 358308 2020.10.02 0:00 1904.48 1916.96 1889.73 1897.18 377753 2020.11.25 0:00 1806.46 1817.59 1801.64 1806.77 254536 2020.10.05 0:00 1903.92 1918.68 1886.95 1912.62 300355 2020,11.26 0:00 1806.83 1818.16 1805.64 1808.87 121200 2020.10.06 0:00 1910.61 1921.09 1874.53 1876.44 357596 2020.11.27 0:00 1809.59 1813.67 1774.17 1787.43 207477 2020.10.07 0:00 1876.06 1897.9 1872.85 1886.46 341126 1886.66 1900.61 1881.84 1892.96 292892 2020.11.30 0:00 1786.23 1789.84 1764.21 1776.28 281034 2020.10.08 0:00 2020.10.09 1893.22 1930.4 1893.2 1930.11 333176 2020.12.01 0:00 1776.32 1817.19 1775.63 1814.63 285269 0:00 2020.10.12 0:00 1928,65 1933.15 1918.12 1921.95 327070 2020,12.02 0:00 1815.03 1832.28 1807.33 1830.25 272770 2020.10.13 0:00 1920.06 1925.34 1886.36 1890.23 396176 2020.12.03 0:00 1830.09 1843.85 1823.61 1840.21 275234 2020.10.14 0:00 1890.37 1912.85 1882.26 1900.82 347924 2020.12.04 0:00 1840,85 1848.14 1829.04 1837.09 255434 2020.10.15 0:00 1901.47 1908.8 1889.38 1907.91 367478 2020.12.07 0:00 1837.03 1868.46 1821.8 1861.92 279530 2020.10.16 0:00 1904.86 1913.88 1897.66 1900.56 303080 2020.12.08 0:00 1861.61 1875.12 1860.08 1869.46 245243 2020,10.19 0:00 1899.59 1918.48 1896.89 1903.56 314381 2020.12.09 0:00 1870.03 1870.8 1825.29 1838.83 338224 2020.10.20 0:00 1901.65 1914.02 1894.38 1904.92 303672 2020.12.10 1838.96 1849.92 1828.55 1835.88 327094 0:00 2020.10.21 0:00 1906.59 1931.39 1906.59 1923.91 314030 2020.12.11 0:00 1835.21 1847.64 1823.87 1839.32 272922 2020.10.22 0:00 1923.65 1925.96 1894.24 1903.4I 287230 2020.10.23 0:00 1902.82 1914.12 1894.18 1900.77 250652 2020.10.26 0:00 1902.6 1908.56 1891.24 1901.66 281183 2020.10.27 0:00 1901.46 19111.34 1897.79 1907.37 217377 2020,10.28 0:00 1906.48 1910.77 1869.27 1876.36 348293 2020,10.29 0:00 1873.78 1884.89 1859.82 1867.01 346441 2020.10.30 0:00 1865.86 1889.71 1864.21 1878.76 357883 2020.11.02 0:00 1876.55 1895.96 1873.31 1894.12 271142 2020.11.03 0:00 1891.42 1910.45 1886.86 1907.75 246224 2020.11.04 0:00 1907.59 1916.25 1881.15 1902.91 477652
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Stock Market Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education