Colin Wuerthele BMGT230 Section 0306 Column1 Mean 23 5748 Standard Erro 0 83868749 Median 23 93 19 36 Mode Standard Devi 4 193437452 Sample Varia 17 58491767 0 87002648 Kurtosis 0 1092231 Skewness 16 18 Range 15 27 Minimum 31 45 Maximum 589 37 Sum Count 25 Confidence Le1 730965893 19 36 19 87 27 12 26 25 27 71 15 27 20 3 27 56 21 3 19 28 23 53 22 3 27 54 29 27 28 25 25 45 25 44 19 36 23 93 21 5 24 1 31 45 17 1 26 87 19 26 Microsoft 95 Confidence Interval 21 84 25 31 We are 95 confident that the average closing stock price from 26 March 2008 to 27 March 2009 for Microsoft is between 21 48 and 25 31 given that the sample mean is 23 57 and the standard error is 84 Mean 68 786 Standard Erro 4 712472069 Median 62 34 N A Mode Standard Devi 23 56236034 Sample Varia 555 184825 Kurtosis 0 20502187 0 898946514 Skewness 75 84 Range 43 89 Minimum 119 73 Maximum 1719 65 Sum Count 25 Confidence Level 90 0 51 31 119 73 113 43 72 61 71 66 44 8 55 5 56 13 45 5 114 95 49 07 80 05 44 29 68 95 78 51 62 34 87 36 43 89 47 42 89 4 48 59 67 88 97 55 48 35 60 38 Colin Wuerthele BMGT230 Section 0306 Column1 Mean 73 6184 Standard Erro 4 946305041 Median 63 72 48 59 Mode Standard Devi 24 73152521 Sample Varia 611 648339 Kurtosis 1 21491201 0 573372483 Skewness 74 29 Range 39 3 Minimum 113 59 Maximum 1840 46 Sum Count 25 Confidence Le8 462544591 56 5 98 69 49 02 57 34 61 11 63 31 39 3 111 48 48 59 63 72 86 73 72 19 48 59 65 46 110 54 64 14 112 72 90 87 113 15 49 19 95 42 113 59 55 15 58 51 55 15 Chipotle 90 Confidence Interval 65 16 82 08 We are 90 confident that the average closing stock price from 26 March 2008 to 27 March 2009 for Chipotle is between 65 16 and 82 08 given that sample mean is 73 62 and the standard error is 4 95 CLOSE CLOSE CLOSE CLOSE CLOSE DATE S P 500 BOSTON BEER CHIPOTLE COSTCO MICROSOFT 18 13 18 83 17 88 17 93 18 33 17 06 17 14 16 96 16 90 16 25 16 65 17 01 17 11 16 48 15 15 15 28 15 27 16 12 15 88 15 79 16 15 16 42 16 96 17 17 17 21 18 00 17 91 18 12 18 09 19 09 19 26 19 21 18 80 19 44 19 66 19 04 18 63 18 50 17 83 17 10 17 59 18 04 17 66 17 63 17 20 17 11 19 38 18 48 19 71 19 24 19 09 19 82 19 47 19 52 20 12 19 51 815 94 832 86 813 88 806 12 822 92 768 54 784 04 794 35 778 12 753 89 756 55 750 74 721 36 719 60 676 53 683 38 682 55 712 87 696 33 700 82 735 09 752 83 764 90 773 14 743 33 770 05 778 94 788 42 789 17 826 84 835 19 833 74 827 16 869 89 868 60 845 85 832 23 838 51 825 44 825 88 845 14 874 09 845 71 836 57 831 95 827 50 840 24 805 22 850 12 843 74 842 62 871 79 870 26 890 35 909 73 906 65 3 27 2009 3 26 2009 3 25 2009 3 24 2009 3 23 2009 3 20 2009 3 19 2009 3 18 2009 3 17 2009 3 16 2009 3 13 2009 3 12 2009 3 11 2009 3 10 2009 3 9 2009 3 6 2009 3 5 2009 3 4 2009 3 3 2009 3 2 2009 2 27 2009 2 26 2009 2 25 2009 2 24 2009 2 23 2009 2 20 2009 2 19 2009 2 18 2009 2 17 2009 2 13 2009 2 12 2009 2 11 2009 2 10 2009 2 9 2009 2 6 2009 2 5 2009 2 4 2009 2 3 2009 2 2 2009 1 30 2009 1 29 2009 1 28 2009 1 27 2009 1 26 2009 1 23 2009 1 22 2009 1 21 2009 1 20 2009 1 16 2009 1 15 2009 1 14 2009 1 13 2009 1 12 2009 1 9 2009 1 8 2009 1 7 2009 22 25 21 83 21 11 19 70 19 91 19 02 19 13 19 71 19 48 19 21 19 02 18 51 18 33 22 15 21 80 21 77 22 48 22 67 22 68 22 65 23 97 23 40 23 56 24 49 24 46 25 08 25 19 25 91 26 50 27 01 27 96 27 57 27 29 28 29 28 82 27 70 26 46 26 01 25 10 25 24 22 43 24 17 24 37 25 03 25 68 26 57 26 92 27 07 28 30 27 42 27 31 27 95 27 92 27 34 28 20 28 37 47 40 48 46 46 81 46 36 47 54 44 83 45 12 44 46 43 98 42 12 42 20 40 86 39 56 40 14 38 44 38 98 39 56 40 81 40 69 40 84 42 34 41 55 42 00 42 55 41 17 42 76 42 62 42 38 42 12 42 76 44 32 43 54 43 97 45 17 45 21 43 83 42 98 46 12 45 30 45 03 46 45 47 81 47 90 47 35 46 97 47 45 47 90 47 22 48 80 48 47 47 63 48 94 49 43 49 14 50 65 50 12 68 50 70 75 65 46 64 50 63 83 61 11 62 34 63 72 59 20 56 13 56 50 55 15 52 85 52 25 49 07 49 19 49 99 50 75 50 70 52 60 54 63 54 13 55 46 56 23 54 67 55 50 53 74 54 45 53 36 55 05 53 25 47 42 48 11 50 38 51 31 51 53 49 17 49 11 48 10 47 76 48 96 50 38 48 09 48 59 48 95 49 12 50 30 49 60 53 05 51 48 49 97 52 26 54 28 53 41 57 26 58 51 1 6 2009 1 5 2009 1 2 2009 12 31 2008 12 30 2008 12 29 2008 12 26 2008 12 24 2008 12 23 2008 12 22 2008 12 19 2008 12 18 2008 12 17 2008 12 16 2008 12 15 2008 12 12 2008 12 11 2008 12 10 2008 12 9 2008 12 8 2008 12 5 2008 12 4 …
View Full Document
Unlocking...