Homework SourseCountry of Origin 0 is import beer 1 is domestic beer Given
Country of Origin: 0 is import beer 1 is domestic beer
Given: Population standard deviation on calories (import) = 50 calories Population standard deviation on calories (domestic) = 67 calories
On Excel, Calculate Average calories for import beer and Average calories for domestic beer.
Do domestic beer have more calories than import beer at 90% confidence?
Brand
Price($)
Calories
%Alcohol Content
Type
Country of Origin
| Brand | Price($) | Calories | %Alcohol Content | Type | Country of Origin |
| BrooklynBrand | 6.24 | 159 | 5.2 | 1 | 1 |
| Leinenkugel\'sRed | 4.79 | 160 | 5 | 1 | 1 |
| SamuelAdamsBoston | 5.96 | 160 | 4.9 | 1 | 1 |
| GeorgeKillian\'sIrishRed | 4.7 | 162 | 4.9 | 1 | 1 |
| RedWolf | 4.11 | 157 | 5.5 | 1 | 1 |
| HenryWeinhard\'sPrivateRes. | 3.85 | 151 | 4.9 | 1 | 1 |
| Sterling | 2.52 | 155 | 4.7 | 1 | 1 |
| Legacy | 5.46 | 135 | 5.1 | 1 | 1 |
| Dominion | 6 | 162 | 5.4 | 1 | 1 |
| LoneStar | 3.71 | 142 | 4.8 | 1 | 1 |
| AbitaAmber | 6.7 | 146 | 4.4 | 1 | 1 |
| YuenglingPremium | 4.99 | 148 | 4.3 | 1 | 1 |
| BerghoffOriginal | 4.1 | 170 | 5.1 | 1 | 1 |
| SamuelAdamsBoston | 5.96 | 160 | 5 | 2 | 1 |
| SierraNevadaPale | 6.31 | 172 | 5.8 | 2 | 1 |
| FullSailAmber | 6.42 | 170 | 5.9 | 2 | 1 |
| Liberty | 7.79 | 184 | 6 | 2 | 1 |
| ElkMountainAmber | 5.05 | 201 | 5.6 | 2 | 1 |
| CelisPaleBock | 5.26 | 155 | 4.7 | 2 | 1 |
| Pete\'sWicked | 5.84 | 170 | 5.3 | 2 | 1 |
| AnchorSteam | 7.22 | 158 | 4.9 | 2 | 1 |
| DockStreetAmber | 6.12 | 159 | 5.4 | 2 | 1 |
| Bass | 7.37 | 150 | 5.1 | 2 | 0 |
| RedhookESB | 6.47 | 177 | 5.6 | 2 | 1 |
| NewAmsterdamNewYork | 6.72 | 146 | 3.7 | 2 | 1 |
| CatamountAmber | 7.59 | 151 | 4.9 | 2 | 1 |
| RedNectar | 6.36 | 163 | 5.3 | 2 | 1 |
| OldDetroitAmber | 6.52 | 186 | 5.9 | 2 | 1 |
| BridgePortBlueHeronPale | 6.34 | 168 | 5.9 | 2 | 1 |
| Geary\'sPale | 7.1 | 142 | 4.7 | 2 | 1 |
| MolsonGolden | 4.78 | 148 | 5 | 3 | 0 |
| LabattBlue | 4.63 | 150 | 5 | 3 | 0 |
| Foster\'s | 5.41 | 140 | 5 | 3 | 0 |
| Kirin | 6.39 | 150 | 5 | 3 | 0 |
| DosEquis | 5.52 | 160 | 4.8 | 3 | 0 |
| Heineken | 6.38 | 160 | 5 | 3 | 0 |
| CoronaExtra | 5.68 | 148 | 4.6 | 3 | 0 |
| St.PauliGirl | 5.82 | 148 | 4.9 | 3 | 0 |
| Beck\'s | 5.83 | 148 | 4.3 | 3 | 0 |
| PilsnerUrquell | 7.8 | 160 | 4.1 | 3 | 0 |
| OldMilwaukee | 2.82 | 145 | 4.5 | 4 | 1 |
| Stroh\'s | 3.2 | 142 | 4.4 | 4 | 1 |
| RedDog | 3.83 | 147 | 5 | 4 | 1 |
| Budweiser | 4.02 | 148 | 4.9 | 4 | 1 |
| Icehouse | 3.88 | 149 | 5.5 | 4 | 1 |
| MolsonIce | 4.79 | 155 | 5.6 | 4 | 0 |
| Michelob | 4 | 159 | 5 | 4 | 1 |
| BudIce | 3.95 | 148 | 5.5 | 4 | 1 |
| Busch | 3.27 | 143 | 4.9 | 4 | 1 |
| CoorsOriginal | 4.02 | 137 | 4.6 | 4 | 1 |
| GeneseeCreamAle | 3.26 | 153 | 4.6 | 4 | 1 |
| MillerHighLife | 3.19 | 143 | 5 | 4 | 1 |
| PabstBlueRibbon | 2.9 | 144 | 4.7 | 4 | 1 |
| Milwaukee\'sBest | 2.36 | 133 | 4.6 | 4 | 1 |
| MillerGenuineDraft | 3.93 | 143 | 5 | 4 | 1 |
| RollingRock | 4.25 | 143 | 4.6 | 4 | 1 |
| MichelobLight | 4.03 | 134 | 4.3 | 5 | 1 |
| BudLight | 4.02 | 110 | 4.2 | 5 | 1 |
| NaturalLight | 2.86 | 110 | 4.2 | 5 | 1 |
| CoorsLight | 4.03 | 105 | 4.2 | 5 | 1 |
| MillerLite | 4.02 | 96 | 4.5 | 5 | 1 |
| AmstelLight | 6.49 | 95 | 3.6 | 5 | 0 |
| Sharp\'s | 3.24 | 58 | 0 | 5 | 1 |
| CoorsCutter | 3.6 | 82 | 0 | 5 | 1 |
| Kingsbury | 2.99 | 60 | 0 | 5 | 1 |
| OldMilwaukee | 2.75 | 72 | 0 | 5 | 1 |
| O\'Doul\'s | 3.9 | 70 | 0 | 5 | 1 |
| Kaliber | 5.42 | 71 | 0 | 5 | 0 |
| Clausthaler | 5.63 | 96 | 0 | 5 | 0 |
Solution
Thus,
the null hypothesis that domestic beer has more calories than imported beer is rejected.
Hope this helps.
| Type 0 | Type 1 | z-Test: Two Sample for Means | |||
| 150 | 159 | ||||
| 148 | 160 | Variable 1 | Variable 2 | ||
| 150 | 160 | Mean | 138.6 | 143.388889 | |
| 140 | 162 | Known Variance | 50 | 67 | |
| 150 | 157 | Observations | 15 | 54 | |
| 160 | 151 | Hypothesized Mean Difference | 0 | ||
| 160 | 155 | z | -2.23914988 | ||
| 148 | 135 | P(Z<=z) one-tail | 0.01257308 | ||
| 148 | 162 | z Critical one-tail | 1.28155157 | ||
| 148 | 142 | P(Z<=z) two-tail | 0.02514617 | ||
| 160 | 146 | z Critical two-tail | 1.64485363 | ||
| 155 | 148 | ||||
| 95 | 170 | ||||
| 71 | 160 | ||||
| 96 | 172 | ||||
| 170 | |||||
| 184 | |||||
| 201 | |||||
| 155 | |||||
| 170 | |||||
| 158 | |||||
| 159 | |||||
| 177 | |||||
| 146 | |||||
| 151 | |||||
| 163 | |||||
| 186 | |||||
| 168 | |||||
| 142 | |||||
| 145 | |||||
| 142 | |||||
| 147 | |||||
| 148 | |||||
| 149 | |||||
| 159 | |||||
| 148 | |||||
| 143 | |||||
| 137 | |||||
| 153 | |||||
| 143 | |||||
| 144 | |||||
| 133 | |||||
| 143 | |||||
| 143 | |||||
| 134 | |||||
| 110 | |||||
| 110 | |||||
| 105 | |||||
| 96 | |||||
| 58 | |||||
| 82 | |||||
| 60 | |||||
| 72 | |||||
| 70 |
