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.

I have to give you a website where you do this work at and then log in to canvas to submit it Work through each of the following items to conduct an ANOVA F-test using the variables listed above for your unique IAT sample. 1 What is the explanatory variable, and what is the response variable? 2 What are the populations for the F-test? 3 State your hypotheses. 4 Create side-by-side (or stacked) boxplots for the quantitative variable (IAT Score) grouped by your chosen categorical variable. Select the option to display the mean within the boxplots (directions) . ◦ Download the StatCrunch output window (your boxplots) and embed the .png file with your response. ◦ Do the boxplots suggest that the samples come from populations with different means? Briefly explain. 5 Next, we need to create a table with these summary statistics: sample size, mean, and standard deviation for each of the populations you listed above. To do this, use StatCrunch to create a table of the indicated summary statistics for the quantitative variable (IAT Score) grouped by your chosen categorical variable. The summary statistics should be listed in the order given with no other statistics in your table. ◦ Copy the table in the StatCrunch output window and paste it into your response. ◦ To make your table readily understood by any reader, complete each of the following. ▪ Enter a descriptive title above your table. ▪ In your table, each group from your chosen categorical variable is labeled with a number. A reader will not understand what the number represents. Replace the numeric labels with descriptive words for each group of your selected categorical variable (see the Variables section above for your data set). ◦ Determine whether conditions are met to use the ANOVA F-test. For each condition explain why the condition is met or not met. 6 Conducting the ANOVA F-test at the 5% significance level: ◦ If conditions are met, use StatCrunch to conduct the ANOVA F-test (copy and paste the contents of the StatCrunch output window into your response). Identify the F-statistic and the P-value. Then state your conclusion in context. ◦ If conditions are not met for your selected categorical variable, start over and use the list of categorical variables provided in the Variables section above to select a different categorical variable for which conditions are met.◦ If conditions are not met for all categorical variables listed above for your data set, contact me.