Stats Excel Lab

Document Sample
Stats Excel Lab Powered By Docstoc
					1. Advertising Dollars

FIRM    SPEND MILIMP                           FIRM      SPEND MILIMP
MILLER LITE 50.1  32.1                         Mean
PEPSI       74.1  99.6                         Median
BURGER KING 82.4  60.8                         Mode
COCO-COLA 40.1    78.6                         Range
MC DONALD'S185.9  92.4                         Variance
BUD LITE    45.6  10.4                         Standard Deviation
WENDY'S     49.7  29.2


2. Hotdogs

Type      Calories Sodium                      Type      Calories Sodium
Beef            186     495                    Mean
Beef            132     253                    Median
Meat            173     458                    Mode
Meat            138     339                    Range
Poultry         129     430                    Variance
Poultry          86     358                    Standard Deviation

3. Low Temperatures for the month of January

City       JanTemp                             City      JanTemp
Mobile, AL       44                            Mean
Montgomery, AL 38                              Median
Atlanta, GA      37                            Mode
Louisville, KY 27                              Range
New Orleans, LA 45                             Variance
Charleston, SC 38                              Standard Deviation
Nashville, TN    31
Students Test 1         HW01   HW02   HW03   HW05   HW04   HW06        Test 2
Student 1          89    5      5      5      10     3            10             85
Student 2          74    5      5      5      10     5            10             96
Student 3          75    5      2      5      10     5            10             92
Student 4          86    5      4      5      10     5            10             91
Student 5          93    5      5      0      10     5             8            100
Student 6          88    5      5      5      10     5             8             99
Student 7          75    5      5      5      10     5            10             84
Student 8          67    5      5      5      10     5            10             89
Student 9          70    5      2      5      10     5             8             41
Student 10         72    4      5      5      10     5            10            100
Student 11         77    4      2      5      10     5            10             93
Student 12         78    5      5      5      10     5            10             89
Student 13         71    2      5      2      7      0             4             77
Student 14         88    5      4      5      10     5             8             83
Student 15         72    5      5      5      10     5            10             94
Student 16         84    5      5      5      10     5             8             79
Student 17         64    5      2      5      9      4             8             76
Student 18         73    5      5      5      9      0             8             72
Student 19         61    5      5      5      10     3            10             76
Student 20         74    5      5      5      10     5             6             76
Student 21         98    5      2      5      10     5            10            100
Student 22         85    5      5      5      10     5            10             83
Student 23         79    5      5      5      10     5            10             78
Student 24         78    5      5      5      10     5            10             88
Totals            100    5      5      5      10     5            10            100
Project    Total   Percentage
      70.7
        72
      75.3
        65
        70
      60.3
      68.7
      72.4
      76.6
      77.9
      71.2
      71.4
      63.2
      70.6
      77.8
      71.1
      77.6
      68.7
      76.3
      61.1
      60.8
      72.9
      66.1
      74.4
        80
% color Plain     Peanut   Crispy    Minis     Peanut Almond
                                               Butter
Brown       13%      12%       17%       13%       10%   10%
Yellow      14%      15%       17%       13%       20%   20%
Red         13%      12%       17%       12%       10%   10%
Green       16%      15%       16%       12%       20%   20%
Blue        24%      23%       17%       25%       20%   20%
Orange      20%      23%       16%       25%       20%   20%

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:11/27/2011
language:English
pages:4