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$.$ Compute the sample mean and standard deviation for each index $($to $2$ decimals $).$ sample mean DJIA: $\_\_$standard deviation DJIA:$\_\_\_$Russell $1000$ sample mean:. $\_\_\_$Russell $1000$Standard deviation$\_\_$B$.$ Compute the sample correlation coefficient for these data $($to $3$ decimals $).\_\_\_\_|$
  

A B 1234 Year DJIA % Return C Russell 1000% Return 2 1988 13.03 9.62 3 1989 31.90 23.37 4 1990 -6.47 -9.22 5 1991 16.89 28.22 6 1992 8.51 1.97 7 1993 11.99 4.57 8 1994 2.50 0.01 9 1995 31.31 39.21 10 1996 23.59 22.01 11 1997 20.53 32.90 12 1998 17.72 20.18 13 1999 28.69 17.53 14 2000 -3.17 -11.88 15 2001 -9.64 -13.06 16 2002 -12.02 -27.78 17 2003 23.06 30.70 18 2004 4.40 11.38 19 2005 1.77 7.56 20 2006 18.76 17.09 21 2007 4.78 5.60 22 2008 -29.24 -40.74 23 2009 22.48 29.95 24 2010 14.93 15.62 25 2011 8.44 -2.09 26 2012 5.47 18.28 27 28 D