Question: 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

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?

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

A B C D Year DJIA % Return Russell 1000 % Return 1988 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 9.18 5.57 8 1994 2.75 -1.74 9 1995 31.58 31.92 10 1996 28.67 22.57 11 1997 22.59 28.45 12 1998 19.57 25.27 13 1999 29.55 16.36 14 2000 -5.13 -8.93 15 2001 -10.93 -16.60 16 2002 -16.04 -19.91 17 2003 23.43 24.39 18 2004 -0.37 13.63 19 2005 2.57 9.07 20 2006 12.86 16.23 21 2007 7.95 8.59 22 2008 -30.19 -39.83 23 2009 18.70 28.32 24 2010 13.60 17.79 25 2011 1.09 3.47 26 2012 3.82 13.72 27 28b. Compute the sample mean and standard deviation for each index (to 2 decimals). sample mean standard deviation DJIA : Russell 1000: c. Compute the sample correlation coefficient for these data (to 3 decimals). d. Discuss similarities and differences in these two indexes. The variance of the Russell 1000 is slightly than that of the DJIA

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

I need help analyzing and computing the data found in the attached spreadsheet. (3.5 1A) F2 " X V fx C D E F G H J A B Year DJIA % Return Russell 1000 % Return Part a 1988 10.22 13.43 Use the area to...

To demonstrate to the student that each company belongs to a sector and that particular sector determines how their business operates. For example, a very capital-intensive business such as a utility...

Rebalancing the Russell Indices: Beta and Volatility Every day, global investors used market indices to measure the status of stock, bond, and commodity madsets around the world. The level and change...

- Year 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 B 1999 4 2000 5 2001 6 2002 -7 2003 18 2004 19 2005 20 2006 21 2007 22 2008 2009 24 2010 25 2011 26 2012 27 28 B DJIA % Return 9.65 31.41...

Partially correct Video 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...

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...

help The Russell 1 0 0 0 is a stock market index consisting of the largest U . S . companies. The Dow Jones industrial Average is based on 3 0 large companies. The data giving the annual percentage...

60. Stock Market Indexes Comparison. 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 file...

Most firms attempt to quantify their political risk, although they do not assign specific weights to the respective criteria. Why is this approach so popular? Would the companies be better off...

Juicy Energy Industries develops and produces biomass, an alternative energy source. The company has an outstanding $10,000,000, 30-year, 10% bond issue dated July 1, 2007. The bond issue is due June...

A small company is considering two, mutually exclusive alternative product lines with differing initial investment and annual revenue. Based on an annual interest rate of 2 % and net present worth...

"it is noteworthy that the largerst global advertisers operate primarily in the consumer marketplace" why is this true?

8. Set a goal that you really want to achieve in the near future, lets say 12 years. How does this goal fit in relation to the form roles and values above? What role and what value was it that...

7. Fill out the form below. Only the most important roles and your basic values are to be filled.

10. Try to remember the last communication you entered into. How many times did you fill in information that the other person did not convey? How many times did you speak before the other person...