Economics homework help. Eco 156 Fall 2020
Prof. Lee
Computer Homework for Eco 156 [Due: Dec 3 ( Thurs ) ]
Foreign Exchange Rate & Stock prices in Korea.
Let American investors need a certain amount of cash for maintaining their business on the current economic recession, they would like to sell their Korean stocks quickly to exchange for dollars to send back to the U.S. Therefore the Stock price indices of Korea decline (as the supply of stocks increases) and foreign exchange rate ( won per dollar ) increases (as they demand more dollar). In fact there could exist strong relationship between stock price index and foreign exchange rate.
Using the data of Kospi and exchange rate ( Korean won per dollar), and
utilizing the Excel (in computer), analyze the following things. [Your answer should be followed by the results [printout] of the Excel.]
tip: use www.yahoo.com or www.google.com to surf the internet to obtain the data for daily Kospi index and daily exchange rate. [ current data; 50 or more observations ]
1) Plot the independent variable and dependent variable combo in X-Y plain in that X=independent variable (Kospi), and Y=dependent variable (foreign exchange rate [ won per dollar ].
2) Utilize the Regression in the Excel menu to find the equation of the best fitted line
Won per Dollar^ = b + m * Kospi Index ( b = intercept, and m = slope),and write down the equation of this line.
3) Are this two parameter (b and m) statistically significant? Answer yes or no, and
explain why.
