I need help analyzing and computing the data found in the attached…

Question Answered step-by-step I need help analyzing and computing the data found in the attached… I need help analyzing and computing the data found in the attached spreadsheet.  The Russell 1000 is a stock market index consisting of the largest U.S. companies. The Dow Jones industrial Average is based on 30 large companies. The data giving the annual percentage returns for each of these stock indexes for 25 years are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. a. Which of the following scatter diagrams accurately represents the data set? Image transcription textA B C D Year DJIA % Return Russell 1000 % Return1988 13.72 17.46 1989 28.46 25.38 UIAWI 1990 -8.87-8.16 1991 21.11 33.07 1992 0.43 3.30 1993… Show more… Show moreImage transcription textb. Compute the sample mean andstandard deviation for each index (to 2decimals). sample mean s… Show more… Show more  Math Statistics and Probability BUS 308 Share QuestionEmailCopy link Comments (0)