Hello, I was wondering if I could get some help with this assignment. I cannot provide the whole data because it is long. Would you please help me with the code I would need to use in R and how to interpret the results to answer 2 as well as how I could construct the test in 2a-d.Please no vague answers! Thank you in advance! Will Rate:)

In this CT assignment, we will use R software to analyze a dataset GoogleAmazonStock.xlsx G. It contains daily closing stock prices for Google and Amazon from 8/22/2017 to 8/22/2018. When we examine stock prices (or other financial assets) we often transform them into a (simple) return series. The return series are computed by the formula: (present price/past price) - 1. The dataset contains both stock prices and return series. 1. Using R, construct time series (line) plots for both stock prices and return series. R functions ts.plot or plot can create the plot. Describe the patterns and compare the plots. 2. Based on the return series, can we claim that the mean Amazon return series is higher than that of Google? a. What would be an appropriate test of the claim above? Explain. b. Write the null and alternative hypotheses. c. Using R, perform the test. d. Write the decision in the problem context