1. Comparing US and International Stock ETFs Please download daily data (2019-2023) from Yahoo Finance using...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Comparing US and International Stock ETFs Please download daily data (2019-2023) from Yahoo Finance using the below codes and calculate the daily simple returns. We use VTI for the US bond and VXUS for the Ex-US international stock ETF portfolios. You need to practice your R codes for answering the below questions. = "2018-12-31", to="2023-12-31") library (quantmod) # install.packages ("quantmod") if needed get Symbols ('VTI', from get Symbols ('VXUS', from = "2018-12-31", to="2023-12-31") %23 calculate the simple returns VTI = VTI$VTI. Adjusted; VXUS L = length (VTI) = VXUS$VXUS. Adjusted rtn.VTI = as.numeric (VTI [-1])/as.numeric(VTI [-L]) - 1 rtn.VXUS = as.numeric (VXUS [-1])/as.numeric (VXUS [-L]) - 1 (a) What are the maximum and minimum returns for VTI and VXUS, respectively? (b) Could you plot the histograms for VTI and VXUS, respectively? Do they look like normal distributions? [HINT: use hist() and set breaks=100] (c) What are the percentages of observations within two standard deviations from the aver- age for VTI and VXUS, respectively? Do we have a 95% coverage for the regression fit? [HINT: we use 2 to approximate 1.96 for the 95% confidence interval.] (d) Could you plot the cumulative returns for these two ETFs in the same figure with dif- ferent colors. [HINT: check codes on the notes] (e) Please run a simple regression for VXUS on VTI, report the coefficients, plot the scatter plot with the fitted regression line. Please provide a short summary for explaining the regression results. [HINT: check codes on the notes] (f) Finally, please run a simple regression for VTI on VXUS, and report the coefficients. What is the difference between this model and the previous one? 1. Comparing US and International Stock ETFs Please download daily data (2019-2023) from Yahoo Finance using the below codes and calculate the daily simple returns. We use VTI for the US bond and VXUS for the Ex-US international stock ETF portfolios. You need to practice your R codes for answering the below questions. = "2018-12-31", to="2023-12-31") library (quantmod) # install.packages ("quantmod") if needed get Symbols ('VTI', from get Symbols ('VXUS', from = "2018-12-31", to="2023-12-31") %23 calculate the simple returns VTI = VTI$VTI. Adjusted; VXUS L = length (VTI) = VXUS$VXUS. Adjusted rtn.VTI = as.numeric (VTI [-1])/as.numeric(VTI [-L]) - 1 rtn.VXUS = as.numeric (VXUS [-1])/as.numeric (VXUS [-L]) - 1 (a) What are the maximum and minimum returns for VTI and VXUS, respectively? (b) Could you plot the histograms for VTI and VXUS, respectively? Do they look like normal distributions? [HINT: use hist() and set breaks=100] (c) What are the percentages of observations within two standard deviations from the aver- age for VTI and VXUS, respectively? Do we have a 95% coverage for the regression fit? [HINT: we use 2 to approximate 1.96 for the 95% confidence interval.] (d) Could you plot the cumulative returns for these two ETFs in the same figure with dif- ferent colors. [HINT: check codes on the notes] (e) Please run a simple regression for VXUS on VTI, report the coefficients, plot the scatter plot with the fitted regression line. Please provide a short summary for explaining the regression results. [HINT: check codes on the notes] (f) Finally, please run a simple regression for VTI on VXUS, and report the coefficients. What is the difference between this model and the previous one?
Expert Answer:
Related Book For
Statistics For Business Decision Making And Analysis
ISBN: 9780321890269
2nd Edition
Authors: Robert Stine, Dean Foster
Posted Date:
Students also viewed these finance questions
-
5 1 point A quantitatively savvy, young couple is interested in purchasing a home in northern New York. They collected data on houses that had recently sold in the area. They want to predict the...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Python and most Python libraries are free to download or use, though many users use Python through a paid service. Paid services help IT organizations manage the risks associated with the use of...
-
Suppose you observe the following exchange rates: 1 = $1.50; 120 = $1.00. Calculate the euro-yuan exchange rate. Group of answer choices a. 80 = 1.00 b. 1 = 2.50 c. 133.33 = 1.00 d. 1.00 = 180
-
a. On January 1, 2017, Salt Creek Country Club purchased a new riding mower for $15,000. The mower is expected to have a 10-year life with a $1,000 salvage value . What journal entry would Salt Creek...
-
Senior management of an organization has requested that the internal audit function help educate employees about internal control concepts. This work is an example of: a. An assurance engagement. b....
-
Find the Fourier series of the following: a. \(f(x)=x, x \in[0,2 \pi]\). b. \(f(x)=\frac{x^{2}}{4},|x|
-
The following data are monthly sales of jeans at a local department store. The buyer would like to forecast sales of jeans for the next month, July. (a) Forecast sales of jeans for March through June...
-
Please try your best ... thanks. Instructions: Prepare your own investment project if assuming that you already have a multinational company, and now you want to broaden your business to one more...
-
The set of mobile gaming apps in which the number of monthly users was greater than 12 million. Use the following table, which shows the number of monthly users, in millions, for the 10 most used...
-
13. The Client, an outside salesperson for a local shoe repair company, tells the CPA that she drove about half of her mileage for business. The clients does not keep a mileage log. What should the...
-
The Shirt Shop had the following transactions for T-shirts for Year 1, Its first year of operations: January 20 April 21 July 25 Purchased 400 units @ $4 = Purchased 130 units @ $6 = Purchased 250...
-
Sunland Health is considering two alternatives for the financing of some high technology medical equipment. These two alternatives are: 1. Issue 60,000 shares of $10 par value common stock at $50 per...
-
In June 2023, Sue exchanges a sport-utility vehicle (adjusted basis of $118,880; fair market value of $148,600) for cash of $22,290 ar pickup truck (fair market value of $126,310). Both vehicles are...
-
Find the derivative of the function. y = ln(x = 7) -
-
Stock A has an expected return of 1 1 % and a standard deviation of 3 5 % . Stock B has an expected return of 1 9 % and a standard deviation of 6 5 % . The correlation coefficient between Stocks A...
-
The Casings Plant of Wyoming Machines makes plastics shells for the company's calculators. (Each calculator requires one shell.) For each of the next two years, Wyoming expects to sell 660,000...
-
14. In testing the existence assertion, an auditor ordinarily works from the a. Financial statements to the accounting records. b. General journal to the general ledger. c. Supporting evidence to the...
-
The government wants consumers to have money to spend to keep the economy moving, so it watches the national level of personal disposable income. The Federal Reserve wants to make sure that these...
-
Homes in a community served by a utility company annually use an expected 12,000 kilowatt-hours (kWh) of electricity. The same utility supplies natural gas to these homes, with an annual expected use...
-
Because an ANOVA does not presume a linear trend, it can be used to check for deviations from the straight-enough condition. The procedure requires replicated observations; we need several values of...
-
Banks advertise to attract customers.
-
Discuss how you benefit when interest is compounded monthly as opposed to annually.
-
Identify the services offered by the different financial institutions.
Study smarter with the SolutionInn App