In this CT assignment, we will use R software to analyze a dataset GoogleAmazonStock.xlsx.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.Take the screenshots of the R graphs and output as well as the code. Paste them into a Word document along with your answers to the questions above. Clearly label the questions and answers. Submit the Word file in Canvas.

This is a 2 part project and needs to be done in xcel format and all questions need to be answered I have attached both sheets if you have any questions feel free to ask!

Consider a situation that you might want to study through a statistical lens. The situation would require you to study a small sample and make an inference to the population. For example, you might want to understand how likely children are to complete their homework when considering their individual characteristics or maybe you want to understand if children who eat broccoli are more likely to complete their homework than those who do not.Respond to the following in a minimum of 175 words without references:How would you select a test that was appropriate to answer your question?How would you rule out tests that were not appropriate to answer your question?