The Dow Jones Industrial Average (DJIA) and the Standard & Poors 500 (S&P500) indexes are used as measures of overall movement in the stock market. The DJIA is based on the price movements of 30 large companies; the S&P 500 is an index composed of 500 stocks. Some say the S&P is a better measure of stock market performance because it is broader based. The closing prices for the DJIA and S&P500 for 20 weeks starting on 9/9/2005 are included in cells E1 to G21. The DJIA data is in cells F1 to F21 and the data for S&P 500 is in cells G1 to G21. Both data sets have labels in first row.      Develop the estimated regression equation using DJIA as the independent variable. Place output in cell H1     Is the relationship between DJIA and S&P500 significant using alpha .05?     Did the estimated regression equation provide a good fit? (explain)     Suppose that the closing price for DJIA is 11,000. Estimate the closing price for the S&P500     Date DJIA S&P500 9-Sep 10679 1241 16-Sep 10642 1238 23-Sep 10420 1215 30-Sep 10569 1229 7-Oct 10292 1196 14-Oct 10287 1187 21-Oct 10215 1180 28-Oct 10403 1198 4-Nov 10531 1220 11-Nov 10686 1235 18-Nov 10766 1248 25-Nov 10932 1268 2-Dec 10878 1265 9-Dec 10779 1259 16-Dec 10876 1267 23-Dec 10883 1269 30-Dec 10718 1248 6-Jan 10959 1285 13-Jan 10960 1288 20-Jan 10667 1261

The data in the accompanying table represent the total rates of return (in percentages) for three stock exchanges over the four-year period from 2009 to 2012. Calculate the geometric mean rate of return for each of the three stock exchanges. Click the icon to view data table for total rate of return for stock market indices. Click the icon to view data table for total rate of return for platinum, gold, and silver. a. Compute the geometric mean rate of return per year for the stock indices from 2009 through 2012. For stock exchange A, the geometric mean rate of return for the four-year period 2009-2012 was %. (Type an integer or decimal rounded to two decimal places as needed.) Data table for total rate of return Year A B C 2012 6.52 13.15 15.93 2011 4.79 0.00 -2.47 2010 10.00 11.85 16.38 2009 18.63 23.62 43.12 Print Done - X C Geometric mean rate of return for stock market indices Metal Platinum Gold Silver Geometric mean rate of return D 13.54% 15.78% 20.52% Print Done X

What is ranked data?

Please help answering this one:

The following table gives the2009 estimates of crude oil reserves(in billionsof barrels)..   Please answer step by step.Don,t skip any part. ANswer follow image.Answer must be correct.Do all calculation and classify

DuPont Automotive releases a Color Popularity Report which provides the percentages of car colors in North America. The most recent report is shown in the following table.

What is the approximate forecast for November using a four-month moving average? Oct - 700Sept - 600Aug - 880July - 670June - 430

Find the Fan Cost Index for the New York Knicks.   Team Ticket Other Drink Soft Drink Hot Dog Parking Hat FCI NY Knicks $190 $11.50 $8 $6 $30 $31

The national center for educational statistics reported that in 2008-2009, 178,564 master's degrees in education were awarded in the United States, and that this represented 27% of all master's degrees awarded. How many master's degrees were awarded in 2008-2009?

The following table shows the square footage of houses in an area that sold recently along with the selling price. Sq. Ft. Price 2096, 295000, 3160, 338000, 2320, 265000, 3150, 365000, 2760, 330000, 3650, 412000, 2125, 320000, 3085, 342000, 4750, 485000, 2100, 320000, 3100, 316000, 2240, 321000, 3300, 347000, 2800, 350000, 2825, 330000, 3275, 420000 1. Find the equation of the regression line (line of best fit). 2. Determine if there is a strong linear correlation. 3. If there is a strong linear correlation predict the selling price of a 3333 sq. ft. home