1. this picture is gold daily data.

2. this picture is dollar index daily data.

Question : i.) specify the estimated regression function of Gold prices and dollar index. ii.) what is the relationship between Golf price and Dollar Index? iii.) Explain the correlation coefficient of the estimated regression function. iv.) based on your answer in (iii.) does the Dollar Index highly related with the Gold price?.

Show calculation. Need it ASAP. THANK YOU.

Picture 1 (QUESTION)

PICTURE 2 (GOLD DAILY DATA)

PICTURE 3 (DOLLAR INDEX DAILY DATA)

Refer to the provided Microsoft Excel daily data of Gold prices and Dollar Index. Column CD, Eand Frepresented the market data during Open, High, Low and Close respectively. Financial market analysts believed that the behaviour of market Open Gold prices is determine by the fluctuations of the Dollar indexes during Open market. By using the Gold prices and US Dollar indexes data from 11 September 2020 to 11 December 2020, answer the following questions: fi. Specify the estimated regression function of Gold prices and Dollar Index. What is the relationship between Gold prices and Dollar Index? Explain the correlation coefficient of the estimated regression function Based on your answer in iii), does the Dollar Index highly related with the Gold price? Suggest any other factors that can explain the behaviour of Gold prices. iv. No saved yet E 2012 0907 1742.01 1739.85 1737.89 0.00 0.00 0:00 0:00 0:00 0:00 0:00 2012.08.11 2012 09.12 2012 09.13 2012.09.14 1735.3 1725.78 1731.78 1730.43 1786.38 1746.75 0:00 58897 45973 48848 49415 59818 81103 48798 80688 51840 58832 51790 81235 2052 09 18 2012.09 19 2012.09 20 2012.00 21 2012.09.24 2012.09.25 2012.09.26 2012 09 27 2012 09 28 2012.10.01 2012.10.02 2012.10.03 2012 10.04 2012.10.05 2012.10.08 1701 1735.16 1725 34 1731.41 1730.97 1767 23 1770.84 1761.83 1771.18 1769 41 1767,8 1771.92 1763.88 1760.34 1753.31 1776.6 1770.93 1775.07 1774 23 1777 73 1789.56 1779.53 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 1688.91 1724 69 1725.34 1725.09 1719.85 1765.4 1754.12 1751.97 1762.09 1755.8 1766.57 1755.5 1758.65 1736.28 1750 88 1767.16 1763.27 1770.45 1770.77 1777.55 1772.89 1766.6 1772.62 1777 69 1776.22 1773.32 1779.17 1772.16 1787.37 1772.13 1774.82 1765.39 1780.18 1783.07 1791.54 1784.16 1781.7 1795.09 1795.75 1779.77 1770 1761.17 1771.7 1770 15 1768. 18 1772.55 1764 13 1760.45 1752.45 1776.95 1771.95 1774.96 1774.2 1777.8 1790.15 1780.23 1774.44 58527 31507 65054 65620 58912 0:00 0:00 0:00 0.00 0.00 0.00 88340 52811 c D E 861 91 79.63 79.63 79.61 79.36 79.82 80.6 79.56 79.58 79.56 79.34 79.78 711 891 731 80.45 91 761 511 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 2012 12 28 2012 12 30 201212 31 2013.01 02 5 2013 01.03 2013/01 04 2013.01 06 2013.01.07 2013.01 DB 10 2013.01.09 2013.01.10 2013 01.11 2013.01.13 2013 01.14 15 2013.01.15 2013.01.16 17 2013.01.17 2013.01.18 2013.01 20 2013.01 21 21 2013.01.22 2013 01 23 401 1211 80.49 80.12 80.3 80.59 79.77 79.47 79.52 79.48 79.7 79.82 79.66 80.06 80.04 80.02 79.84 79.91 79.64 79.84 79.92 80.62 80.86 80.52 80.66 80.43 80.62 80.66 79.85 79.53 79.63 79.88 79.89 79.88 80.14 80.09 80.09 80.07 80.11 80.39 80.45 80.09 80.09 80.27 79.65 79.39 79.46 79.32 79.36 79.59 79.55 79.63 80.02 79.89 79.67 79.67 79 87 79,6 79.8 79.81 80.61 80.44 80.5 80.11 80.29 80.6 79.78 79.56 79.51 79.49 79.69 79.83 79.67 80 80.03 80.03 79.85 79.94 101 591 831 511 681 111 0:00 391 0:00 0:00 0.00 781 Refer to the provided Microsoft Excel daily data of Gold prices and Dollar Index. Column CD, E and Frepresented the market data during Open, High, Low and close respectively. Financial market analysts believed that the behaviour of market Open Gold prices is determine by the fluctuations of the Dollar indexes during Open market. By using the Gold prices and US Dollar indexes data from 11 September 2020 to 11 December 2020, answer the following questions: Z ii. . Specify the estimated regression function of Gold prices and Dollar Index. What is the relationship between Gold prices and Dollar Index? Explain the correlation coefficient of the estimated regression function Based on your answer in it), does the Dollar Index highly related with the Gold price? Suggest any other factors that can explain the behaviour of Gold prices. v. GOLD_Daily_Data_SM CSV Not saved yet B c D G H 0:00 1742.01 1688 91 1739.85 1724.69 0:00 0:00 0:00 1701 1735.16 1725.34 1731.41 58697 45973 46646 1725.34 1725.09 49415 0:00 1719.85 59816 1730.97 1767.23 17353 1725.76 1731.76 1730.43 1766.38 1770 1761.17 1771.7 1770.15 1768.18 1765.4 0:00 0:00 61103 48798 1 2012 09.07 2 2012 09.10 3 2012 09 11 4 2012.09.12 5 2012 09 13 5 2012.09 14 2012.09.17 2012 09.1B 2012.09.19 10 2012.09.20 2012 09:21 12 2012 09 24 13 2012 09 25 14 2012 09 26 15 2012 09 27 2012.09 28 17 2012 10.01 18 2012 10.02 0:00 1754.12 1751.97 1762.09 1755.8 60686 51840 58832 0:00 0:00 0:00 0:00 0:00 0:00 1772.55 1737.89 1746.75 1772.62 1777.69 1776.22 1773.32 1779.17 1772.16 1787.37 1772.13 1774.82 1765.39 1780.18 1783.07 1791.54 1784.16 1770.84 1761.83 1771.18 1769.41 1767.8 1771.92 1763.88 1760.34 1753.31 1776.6 1770.93 1775.07 61790 61235 61748 58527 1766.57 1755.5 1758.65 1736.28 1750.88 1767.16 1763.27 1770.45 1764.13 1760.45 1752.45 1776.95 1771.95 1774.96 0:00 0:00 61507 65054 65620 0:00 0:00 1774.2 58912 - .CSV Dollar Index_Daily_Data_SM, Not saved yet B D E F G H 861 0.00 0:00 0.00 0:00 79.63 79.63 79.61 79.36 79.82 79.91 79.64 79.84 91 371 711 891 80.6 781 80.45 7 2012 12:28 2 2012 1230 2012 12 31 2013 01.02 5 2013 01 03 2013 01.04 7 2013 01.06 E 2013 01.07 2013.01 DB 10 2013 01.09 1 2013 01 10 12 2013 01.11 13 2013 01.13 14 2013.01.14 15 2013.01 15 10 2013 01.16 12 2013.01 17 18 2013.01 18 0.00 0:00 0:00 0:00 0.00 0:00 0:00 0:00 0:00 91 761 79.56 79.58 79.56 79.34 79.78 80.39 80.45 80.09 80.09 80.27 79.65 79.39 79.46 80.49 80.12 79.92 80.62 80.86 80.52 80.66 80.43 80.62 80.66 79.85 79.53 79.63 79.88 79.67 79.6 79.8 79.81 80.61 80.44 80.5 80.11 80.29 80.6 79.78 79.56 79.51 79.49 79.69 79.83 79.67 80 511 401 1211 711 101 0:00 80.3 80.59 79.77 79.47 79.52 79.48 79.7 79.82 79.66 79.32 591 831 0.00 0:00 0 00 0.00 79.89 79.88 80.14 79.36 79.59 79.55 79.63 471 511 681 Sheet1 OB:43 F GOLD_Daily_Dala_SMART3 - Read-only Read Only - To make changes, save a copy of this file into a fx 2012.09.07 G 1 2012.09. 2 2012.09. 3 2012.09.1 4 2012.09.1 5 2012.09.10 6 2012.09.1 2012.09.1 8 2012.09.11 9 2012.09.13 10 2012.09.21 -11 2012.09.2 12 2012.09.2 13 2012.09.2: 14 2012.09.21 15 2012.09.2 16 2012.09.21 17 2012.10.0 18 2012.10.0 19 2012.10.0 20 2012.10.0 21 2012. 10.0 22 2012.10.0: 23 2012.10.0 24 2012.10.11 25 2012.10.1 26 2012.10.1 B F c E 00:00 1701 1742.01 1688.91 1735.3 00:00 1735.16 1739.85 1724.69 1725.76 00:00 1725.34 1737.89 1725.34 1731.76 00:00 1731.41 1746.75 1725.09 1730.43 00:00 1730.97 1772.62 1719.85 1766.38 00:00 1767.23 1777.69 1765.4 1770 00:00 1770.84 1776.22 1754.12 1761.17 00:00 1761.83 1773.32 1751.97 1771.7 00:00 1771.18 1779.17 1762.09 1770.15 00:00 1769.41 1772.16 1755.8 1768.18 00:00 1767.8 1787.37 1766.57 1772.55 00:00 1771.92 1772.13 1755.5 1764.13 00:00 1763.88 1774.82 1758.65 1760.45 00:00 1760.34 1765.39 1736.28 1752.45 00:00 1753.31 1780.18 1750.88 1776.95 00:00 1776.6 1783.07 1767.16 1771.95 00:00 1770.93 1791.54 1763.27 1774.96 00:00 1775.07 1784.16 1770.45 1774.2 00:00 1774.23 1781.7 1770.77 1777.8 00:00 1777.73 1795.09 1777.55 1790.15 00:00 1789.56 1795.75 1772.89 1780.23 00:00 1779.53 1779.77 1766.6 1774.44 00:00 1775.34 1779.64 1760.31 1763.94 00:00 1764.32 1768.04 1756.77 1761.78 00:00 1761.84 1774.72 1758.39 1766.71 00:00 1767 58697 45973 46646 49415 59816 61103 48798 60686 51840 58832 61790 61235 61748 58527 61507 65054 65620 58912 61464 68340 59882 52811 59755 57948 57595 1772 Refer to the provided Microsoft Excel daily data of Gold prices and Dollar Index. Column CD, Eand Frepresented the market data during Open, High, Low and Close respectively. Financial market analysts believed that the behaviour of market Open Gold prices is determine by the fluctuations of the Dollar indexes during Open market. By using the Gold prices and US Dollar indexes data from 11 September 2020 to 11 December 2020, answer the following questions: fi. Specify the estimated regression function of Gold prices and Dollar Index. What is the relationship between Gold prices and Dollar Index? Explain the correlation coefficient of the estimated regression function Based on your answer in iii), does the Dollar Index highly related with the Gold price? Suggest any other factors that can explain the behaviour of Gold prices. iv. No saved yet E 2012 0907 1742.01 1739.85 1737.89 0.00 0.00 0:00 0:00 0:00 0:00 0:00 2012.08.11 2012 09.12 2012 09.13 2012.09.14 1735.3 1725.78 1731.78 1730.43 1786.38 1746.75 0:00 58897 45973 48848 49415 59818 81103 48798 80688 51840 58832 51790 81235 2052 09 18 2012.09 19 2012.09 20 2012.00 21 2012.09.24 2012.09.25 2012.09.26 2012 09 27 2012 09 28 2012.10.01 2012.10.02 2012.10.03 2012 10.04 2012.10.05 2012.10.08 1701 1735.16 1725 34 1731.41 1730.97 1767 23 1770.84 1761.83 1771.18 1769 41 1767,8 1771.92 1763.88 1760.34 1753.31 1776.6 1770.93 1775.07 1774 23 1777 73 1789.56 1779.53 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 1688.91 1724 69 1725.34 1725.09 1719.85 1765.4 1754.12 1751.97 1762.09 1755.8 1766.57 1755.5 1758.65 1736.28 1750 88 1767.16 1763.27 1770.45 1770.77 1777.55 1772.89 1766.6 1772.62 1777 69 1776.22 1773.32 1779.17 1772.16 1787.37 1772.13 1774.82 1765.39 1780.18 1783.07 1791.54 1784.16 1781.7 1795.09 1795.75 1779.77 1770 1761.17 1771.7 1770 15 1768. 18 1772.55 1764 13 1760.45 1752.45 1776.95 1771.95 1774.96 1774.2 1777.8 1790.15 1780.23 1774.44 58527 31507 65054 65620 58912 0:00 0:00 0:00 0.00 0.00 0.00 88340 52811 c D E 861 91 79.63 79.63 79.61 79.36 79.82 80.6 79.56 79.58 79.56 79.34 79.78 711 891 731 80.45 91 761 511 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00 2012 12 28 2012 12 30 201212 31 2013.01 02 5 2013 01.03 2013/01 04 2013.01 06 2013.01.07 2013.01 DB 10 2013.01.09 2013.01.10 2013 01.11 2013.01.13 2013 01.14 15 2013.01.15 2013.01.16 17 2013.01.17 2013.01.18 2013.01 20 2013.01 21 21 2013.01.22 2013 01 23 401 1211 80.49 80.12 80.3 80.59 79.77 79.47 79.52 79.48 79.7 79.82 79.66 80.06 80.04 80.02 79.84 79.91 79.64 79.84 79.92 80.62 80.86 80.52 80.66 80.43 80.62 80.66 79.85 79.53 79.63 79.88 79.89 79.88 80.14 80.09 80.09 80.07 80.11 80.39 80.45 80.09 80.09 80.27 79.65 79.39 79.46 79.32 79.36 79.59 79.55 79.63 80.02 79.89 79.67 79.67 79 87 79,6 79.8 79.81 80.61 80.44 80.5 80.11 80.29 80.6 79.78 79.56 79.51 79.49 79.69 79.83 79.67 80 80.03 80.03 79.85 79.94 101 591 831 511 681 111 0:00 391 0:00 0:00 0.00 781 Refer to the provided Microsoft Excel daily data of Gold prices and Dollar Index. Column CD, E and Frepresented the market data during Open, High, Low and close respectively. Financial market analysts believed that the behaviour of market Open Gold prices is determine by the fluctuations of the Dollar indexes during Open market. By using the Gold prices and US Dollar indexes data from 11 September 2020 to 11 December 2020, answer the following questions: Z ii. . Specify the estimated regression function of Gold prices and Dollar Index. What is the relationship between Gold prices and Dollar Index? Explain the correlation coefficient of the estimated regression function Based on your answer in it), does the Dollar Index highly related with the Gold price? Suggest any other factors that can explain the behaviour of Gold prices. v. GOLD_Daily_Data_SM CSV Not saved yet B c D G H 0:00 1742.01 1688 91 1739.85 1724.69 0:00 0:00 0:00 1701 1735.16 1725.34 1731.41 58697 45973 46646 1725.34 1725.09 49415 0:00 1719.85 59816 1730.97 1767.23 17353 1725.76 1731.76 1730.43 1766.38 1770 1761.17 1771.7 1770.15 1768.18 1765.4 0:00 0:00 61103 48798 1 2012 09.07 2 2012 09.10 3 2012 09 11 4 2012.09.12 5 2012 09 13 5 2012.09 14 2012.09.17 2012 09.1B 2012.09.19 10 2012.09.20 2012 09:21 12 2012 09 24 13 2012 09 25 14 2012 09 26 15 2012 09 27 2012.09 28 17 2012 10.01 18 2012 10.02 0:00 1754.12 1751.97 1762.09 1755.8 60686 51840 58832 0:00 0:00 0:00 0:00 0:00 0:00 1772.55 1737.89 1746.75 1772.62 1777.69 1776.22 1773.32 1779.17 1772.16 1787.37 1772.13 1774.82 1765.39 1780.18 1783.07 1791.54 1784.16 1770.84 1761.83 1771.18 1769.41 1767.8 1771.92 1763.88 1760.34 1753.31 1776.6 1770.93 1775.07 61790 61235 61748 58527 1766.57 1755.5 1758.65 1736.28 1750.88 1767.16 1763.27 1770.45 1764.13 1760.45 1752.45 1776.95 1771.95 1774.96 0:00 0:00 61507 65054 65620 0:00 0:00 1774.2 58912 - .CSV Dollar Index_Daily_Data_SM, Not saved yet B D E F G H 861 0.00 0:00 0.00 0:00 79.63 79.63 79.61 79.36 79.82 79.91 79.64 79.84 91 371 711 891 80.6 781 80.45 7 2012 12:28 2 2012 1230 2012 12 31 2013 01.02 5 2013 01 03 2013 01.04 7 2013 01.06 E 2013 01.07 2013.01 DB 10 2013 01.09 1 2013 01 10 12 2013 01.11 13 2013 01.13 14 2013.01.14 15 2013.01 15 10 2013 01.16 12 2013.01 17 18 2013.01 18 0.00 0:00 0:00 0:00 0.00 0:00 0:00 0:00 0:00 91 761 79.56 79.58 79.56 79.34 79.78 80.39 80.45 80.09 80.09 80.27 79.65 79.39 79.46 80.49 80.12 79.92 80.62 80.86 80.52 80.66 80.43 80.62 80.66 79.85 79.53 79.63 79.88 79.67 79.6 79.8 79.81 80.61 80.44 80.5 80.11 80.29 80.6 79.78 79.56 79.51 79.49 79.69 79.83 79.67 80 511 401 1211 711 101 0:00 80.3 80.59 79.77 79.47 79.52 79.48 79.7 79.82 79.66 79.32 591 831 0.00 0:00 0 00 0.00 79.89 79.88 80.14 79.36 79.59 79.55 79.63 471 511 681 Sheet1 OB:43 F GOLD_Daily_Dala_SMART3 - Read-only Read Only - To make changes, save a copy of this file into a fx 2012.09.07 G 1 2012.09. 2 2012.09. 3 2012.09.1 4 2012.09.1 5 2012.09.10 6 2012.09.1 2012.09.1 8 2012.09.11 9 2012.09.13 10 2012.09.21 -11 2012.09.2 12 2012.09.2 13 2012.09.2: 14 2012.09.21 15 2012.09.2 16 2012.09.21 17 2012.10.0 18 2012.10.0 19 2012.10.0 20 2012.10.0 21 2012. 10.0 22 2012.10.0: 23 2012.10.0 24 2012.10.11 25 2012.10.1 26 2012.10.1 B F c E 00:00 1701 1742.01 1688.91 1735.3 00:00 1735.16 1739.85 1724.69 1725.76 00:00 1725.34 1737.89 1725.34 1731.76 00:00 1731.41 1746.75 1725.09 1730.43 00:00 1730.97 1772.62 1719.85 1766.38 00:00 1767.23 1777.69 1765.4 1770 00:00 1770.84 1776.22 1754.12 1761.17 00:00 1761.83 1773.32 1751.97 1771.7 00:00 1771.18 1779.17 1762.09 1770.15 00:00 1769.41 1772.16 1755.8 1768.18 00:00 1767.8 1787.37 1766.57 1772.55 00:00 1771.92 1772.13 1755.5 1764.13 00:00 1763.88 1774.82 1758.65 1760.45 00:00 1760.34 1765.39 1736.28 1752.45 00:00 1753.31 1780.18 1750.88 1776.95 00:00 1776.6 1783.07 1767.16 1771.95 00:00 1770.93 1791.54 1763.27 1774.96 00:00 1775.07 1784.16 1770.45 1774.2 00:00 1774.23 1781.7 1770.77 1777.8 00:00 1777.73 1795.09 1777.55 1790.15 00:00 1789.56 1795.75 1772.89 1780.23 00:00 1779.53 1779.77 1766.6 1774.44 00:00 1775.34 1779.64 1760.31 1763.94 00:00 1764.32 1768.04 1756.77 1761.78 00:00 1761.84 1774.72 1758.39 1766.71 00:00 1767 58697 45973 46646 49415 59816 61103 48798 60686 51840 58832 61790 61235 61748 58527 61507 65054 65620 58912 61464 68340 59882 52811 59755 57948 57595 1772