Review View Help Acrobat Tell me what you want to do you need to edit, it's safer to stay in Protected View. Enable Editing W Test 2 (Protected View) - Word The data sheet below has five columns of information. The first column is the total projected universe of the United States. This serves as the base for all the other numbers. Check the totals under the column of Total U.S. (000). This is the population in thousands. For example, in Table 10.1 there are an estimated 52,558,000 adults ages 21-34 in the United States (52,558 x 1,000). The number above this projection is the unweighted sample size. It is abbreviated "unwgted." In this same example, the sample size was 11,960. If you look at the (000) for age 21-34 under the heading of Budweiser drinkers who have had a Budweiser beer in the past six months, you will find the number 8,421. That means that 8,421,000 adults ages 21-34 have had a Budweiser beer in the past six months. 3.1 How many more adults age 21+ have drunk Budweiser in the past six months compared to Miller Lite? Show your calculation. (WARNING: All users include those who are younger than 21). (4 points) I 3.2 What percentage of Budweiser drinkers (all users) is aged 21-34? Show your calculation. (3 points) 3.3 What household income level would you need to target to best reach 50 percent of Miller Lite's heavy users? Use the hard data to explain why. (3 points) DELL 4 View Help Acrobat Test 2 (Protected View) Word Tell me what you want to do Enable Editing need to edit, it's safer to stay in Protected View. W Table 10.1 The Target Group Working to Define the Target Group 91 Total U.S. Total beer/ale: Budweiser (000) all users Budweiser heavy users Total beer/ale: Miller Lite Miller Lite all users All Unwgtd 51.774 6.271 1413 3,040 heavy users 592 (000) 205.368 24.847 5.898 10,492 2,002 Horz % 100 12.1 2.87 5.11 0.97 Vert % 100 100 100 100 100 Index 100 100 100 100 100 Ages 21-34 Unwgtd 11.960 1.911 431 1,001 212 (000) 52.558 8.421 2,099 3,791 739 Horz % 100 16.0 4.0 7.2 1.4 Vert % 25.59 33.9 35.6 36.1 36.9 Index 100 132 139 141 144 Ages 35-44 Unwgtd 11,901 1.694 407 802 149 (000) 44,776 6.099 1,513 2,565 495 Horz % 100 13.6 3.4 5.7 1.1 Vert % 21.8 24.6 25.7 24.5 24.7 Index 100 113 118 112 113 Ages 45-54 Unwgtd 10.109 1,139 252 565 117 (000) 38,134 4170 967 1,904 356 Horz % 100 10.9 2.5 5.0 0.9 Vert % 18.57 16.8 16.4 18.2 17.8 Index 100 90 88 98 96 Age 55+ Unwgtd 16,132 1,266 257 587 99 (000) 57.504 4,306 925 1,666 293 Horz % 100 7.5 1.6 2.9 0.5 Vert % 28 17.3 15.7 15.9 14.7 Index 100 62 56 57 52 Median age Unwgtd (000) Horz % 43.5 38.9 38.3 38.5 37.7 Vert % Index 89 88 89 87 HHI $0-$29,000 Unwgtd (000) Horz % 12.809 1.414 394 398 88 58,615 6,935 2.016 1.537 853 100 11.8 3.4 93 0.6 Vert % 28.54 27.9 34.2 14.6 17.6 Index 100 98 120 51 62 HHI $30,000-$49,000 Unwgtd (000) Horz % 11,847 1,338 347 558 115 43.895 5.261 1.397 1,845 366 100 12.0 3.2 0.8 Vert % 21.37 21.2 28.7 Index 100 99 111 17.6 82 18.3 86 (continued) ELL View Help Acrobat Tell me what you want to do to edit, it's safer to stay in Protected View. Enable Editing Table 10.1 (continued) Test 2 (Protected View) - Word W Total U.S. Total beer/ale: Budweiser Budweiser heavy Total beer/ale: Miller Lite Miller Lite heavy (000) all users users all users users HHI $50,000-$74,000 Unwgtd (000) 10.737 1,330 288 655 137 42.424 4.929 1.118 2,399 443 Horz % 100 11.6 2.6 5.7 1.1 Vert % 20.66 19.8 19.0 22.9 22.2 Index 100 96 92 111 107 HHI $75,000+ Unwgtd 16.381 2.189 384 1,434 257 (000) 60.434 7.722 1,366 4,712 839 Horz % 100 12.8 2.3 7.8 1.4 Vert % Index 29.43 31.1 23.2 44.9 41.9 100 106 79 153 142 HHI $100,000+ Unwgtd 9.715 1,269 197 874 157 (000) 34.544 4310 694 2794 498 Horz % 100 12.5 2.0 8.1 1.4 Vert % 16.82 17.4 11.8 26.6 24.9 Index 100 103 OZ 158 148 Median HHI Married Single Race: White Race: Black Unwatd (000) Horz % $50,093 $51,053 $41.712 $69,193 $65,905 Vert % Index 102 83 138 132 Unwatd (000) 28.252 117,121 3.449 721 1,815 320 13,211 2.960 6.142 1,069 Horz % 100 11.3 2.5 5.2 0.9 Vert % 57.03 53.2 50.2 58.5 53.4 Index 100 93 88 103 94 Unwgtd (000) 10.983 1.740 428 756 172 49.609 8.065 2.021 3.115 641 Horz % 100 16.3 4.1 6.3 1.3 Vert % 24.16 32.5 34.3 29.7 32.0 Index 100 134 142 123 133 Unwatd (000) Horz % Vert % Index 44.370 171,788 5,299 1.188 2.791 546 20,205 4,690 9.490 1.853 100 11.8 2.7 5.5 1.1 83.65 81.3 79.5 90.5 92.6 100 - 97 108 111 Unwgtd (000) 5.325 716 182 158 31 24.335 3.549 973 648 108 Horz % 100 14.6 4.0 0.4 Vert % 11.85 16.5 6.2 5.4 Index 100 121 139 52 46 DELL