Q9: Open the dataset Earnings2005 which contains data on current and previous earnings. We want to know whether the population mean for current is the same as that for previous. Conduct the appropriate test and provide the p value. Round up to four decimal places.

Answer:

A B C D E F G A1 1 Per Share Qtr. Earnings 2 Company Current Predicted 3 ADVO 0.38 0.26 4 Alaska Air -1.15 -1.66 5 Amgen 0.66 0.53 3 6 AT&T 0.46 0.21 5 Becton Dickinson 0.85 0.75 6 8 Brunswick 0.9 0.59 7 9 Conexant -0.05 -0.26 8 10 Dow Jones 0.49 0.43 9 11 First Data 0.52 0.56 10 Franklin Resources 1.21 0.92 11 13 Gentex 0.19 0.18 12 4 Honeywell 0.62 0.3 13 15 Kirby 0.76 0.53 14 16 LSI Logic 0.09 -0.51 15 17 Lockheed Martin 1.29 0.83 16 18 MarineMax 0.04 0.17 17 19 Merchants Bncshrs 0.46 0.51 18 20 NCR 0.81 0.68 19 20 21 Newell Rubbermaid 0.28 0.45 21 22 Novellus Systems 0.17 0.27 22 23 Pantry Inc. 1.45 0.59 23 24 Qualcomm 0.36 0.3 24 25 Suncor Energy 1.48 0.72 25 26 United Parcel 0.95 0.76 26 27 Washington Trust 0.45 0.4 27 28 28 29 29 30 30 31 31 32 32 33 33 34 34 35 35 36 36 37 Data Sheet2 Sheet3 + 38 Ready Ready