50.1K

Verified Solution

Link Copied!

Question 4: The following table presents monthly sales totals for US cities. In cells H208:H209 calculate the total and mean sales using the functions provided in Excel. In cells H210:H211 use the functions provided in Excel to identify the largest and smallest sales total among the cities. Answer the two questions to the right in cells K2, K3.

Which city had the largest total sales? Which city had the smallest total sales? Question 4: The following table presents monthly sales totals for US cities. In cells H208:H209 calculate the total and mean sales using the functions provided in Excel. In cells H210:H211 use the functions provided in Excel to identify the largest and smalest sales total among the cities. Answer the two questions to the right in cells K2, K3. City New York Los Angeles Chicago Houston Philadelphia 2345 Phoenix 2225 San Antonio San Diego Detroit San Jose Austin Jacksonville San Francisco Indianapolis Columbus Fort Worth Charlotte Seattle El Paso Dalas Denver Washington Memphis Boston Nashville Baltimore Oklahoma City Portland Las Vegas Louisvilkt Milwaukee Abuquerque Tucson Fresno Sacramento Long Beach Kansas City Mesa Atlanta Viminia Beach Omaha Colorado Springs Raleigh Mami Oakland Minneapolis Tulsa Cleveland Wichita New Orleans Arlington Bakersfield Tampa Aurora Honolulu Anaheim Santa Ana Corpus Christi Riverside St. Louis Lexington Pittsburgh Stockton Anchorage Cincinnati Saint Paul Greensboro Toledo Newark Plano Henderson Lincoln Orlando Jersey City Chula Vista Buffalo Fort Wayne Chandler January February March April May Total S S 205$ 215S 2003 $ 217 S 185$ 1.022 S 148$ 241 S 214 $ 246 S 157 S 1,006 S 228 $ 152 S 1883 $ 126 S 124 $ 818 S 2023 $ 242 S $ 129S 127S 934 s 1653 $ 126 S 230$ 2B S 160S 709 S 103 $ $ 117 S 133) $ 235s 955 683 s 180$ 200 S 20a $ $ 105 S 27$ 720 S 156 $ $ 164 S 243 $ B2S 246 S $ 891 S 82 $ 126 S 148$ 134S 375 527 S $ 221 S 65 $ B4 S 149 $ 741 S 171 $ $ 190S 50 $ 242S 189 $ 842 S 170$ 146 S 1565 $ 51 S 53$ 576 S 2295 187 S 176 $ 54 S 131 $ 777 S 35$ 38S 26 $ 167 S 26S 292 S 27 $ 175 S 57 $ 213S 200 $ 672 s 111$ 236S 168 $ 248 S 233 S 996 S 224 $ 187 S 1943 $ B2 s 107$ 774 S 103 $ 115 S 182 $ 111s 82 $ 593 S 20a $ $ 147 s 185$ 32S 194$ 766 S 169 $ 47 E S 40$ $ 249S 200 $ 705 S 735 $ 64 S S 164 $ 41 S 28$ 370 S 223 $ 58S 214 $ 95 S 69 $ 659 S 244 $ B1 S 28 $ 185 S 55 $ 593 S 965 $ 74 S 250 $ $ 214 S 67 $ 701 S 47$ 96 S 1425 $ 156 S 1836 624 S 2173 187 S 237$ 57 S 162 $ 860 s 525 $ 83 S 33$ $ 83 S 57S $ 308 S 190$ 143S 2073 50 S 2365 826 S S aa $ B2S 1723 40 S 46 $ 426 S 151 $ 43 S 225$ 71 S 203 $ 693 S 143 $ $ B3 S 122 $ 62 S 1335 $ 543 s 150 $ 59 S 216 $ $ 164 S 89 $ 678 S 232 $ 152 S 225 $ $ B4S 198 $ 891 S 35$ 231S 1946 $ 155 S 1075 $ 722 S 204 $ 93S 96 $ 109S 224 $ 726 S 203$ 181 S 77 $ 138S 76 $ 675 S 1735 28S S 39$ 150 S 87 $ 477 S 47$ 79S 78$ 138S 121 $ 463 S S 99 $ 249S 225$ 165S 965 934 S 199 $ 179S 925 $ 96 S 166 $ 732 S 1333 $ 46 S 1525 $ 130S 121 $ 582 S 173 $ 78 S 57$ 137 s 211 $ 656 S a2 $ 147 S 29 $ 136S 105 $ 499 S 66 $ 70 S 76 $ 131 S 36 5 $ 379 S 176 $ 104S 36 $ $ 108 S 167$ 591 S 142 $ 133S 32 $ 151 S 79 $ 537 S 215$ 139S 72 $ 244S 145$ 815 S 229 $ 215 S 157 $ 49S 57 $ 707 S 110S $ 134S 32 $ 141 S 188$ 605 S 73 $ 214 S 147 $ 72 S 218$ 724 S 214 $ 68S 242 $ 113 S 80$ $ 717 S 155$ 100 S 55$ 187 | S 166 $ 663 s 53 BBS 125$ 245 S 120 S $ 811 S 225$ 183 S 203 $ 101 S 46 $ 758 s 163 $ 170 S 131 $ 180S 240$ 864 S 15$ 132S 47 $ 143S 214 $ 694 S | 77 $ 126 S 115$ 217 S 113 5 $ 648 S 210$ 111 S 193$ 40 S 250 $ BD4 S 182 $ 38 S 92 $ 175 S 188$ 675 S S 236 $ B6 S 117 $ 231S 57$ 727 S 2355 194 S 1225 $ 42 | S 55$ 648 IS 228 $ 69 S 985 $ 1488 234 $ 777 S 2235 71 S 1773 $ 43S 1035 617 S 1525 S 130S $ 204S 138 781 S S 148 $ BBS 1073 B9 S 50S $ 482 S 122 $ 197 S 181 $ $ 1715 70 $ 741 S 1425 $ 78 S 73 $ 195 S 26 $ 512 S 170$ 41 S 74 $ 37 S 148$ 470 S S 192 $ 169S 2435 $ 185S 212$ 1,001 S 72 $ $ 102 S 82 $ 35 S 158$ 449 S 34 $ 112S 1125 $ 38S 53 $ 349 S 2415 151 S 188 $ $ 107S 109 $ 796 S 39$ 53S 202 $ $ 82 S 155$ 531 S 49 $ 141 S S 52 $ 170 S 99 $ 511 S 148$ 198S 585 61 S 141 ls $ 606 S 1485 $ 125 S 39: $ 236 S 83 S S 631 S 216 $ 156S 32 $ 50 S 157 $ 611 S 53$ 142 S a2 $ B3S 20a $ 566 157 Which city had the largest total sales? Which city had the smallest total sales? Question 4: The following table presents monthly sales totals for US cities. In cells H208:H209 calculate the total and mean sales using the functions provided in Excel. In cells H210:H211 use the functions provided in Excel to identify the largest and smalest sales total among the cities. Answer the two questions to the right in cells K2, K3. City New York Los Angeles Chicago Houston Philadelphia 2345 Phoenix 2225 San Antonio San Diego Detroit San Jose Austin Jacksonville San Francisco Indianapolis Columbus Fort Worth Charlotte Seattle El Paso Dalas Denver Washington Memphis Boston Nashville Baltimore Oklahoma City Portland Las Vegas Louisvilkt Milwaukee Abuquerque Tucson Fresno Sacramento Long Beach Kansas City Mesa Atlanta Viminia Beach Omaha Colorado Springs Raleigh Mami Oakland Minneapolis Tulsa Cleveland Wichita New Orleans Arlington Bakersfield Tampa Aurora Honolulu Anaheim Santa Ana Corpus Christi Riverside St. Louis Lexington Pittsburgh Stockton Anchorage Cincinnati Saint Paul Greensboro Toledo Newark Plano Henderson Lincoln Orlando Jersey City Chula Vista Buffalo Fort Wayne Chandler January February March April May Total S S 205$ 215S 2003 $ 217 S 185$ 1.022 S 148$ 241 S 214 $ 246 S 157 S 1,006 S 228 $ 152 S 1883 $ 126 S 124 $ 818 S 2023 $ 242 S $ 129S 127S 934 s 1653 $ 126 S 230$ 2B S 160S 709 S 103 $ $ 117 S 133) $ 235s 955 683 s 180$ 200 S 20a $ $ 105 S 27$ 720 S 156 $ $ 164 S 243 $ B2S 246 S $ 891 S 82 $ 126 S 148$ 134S 375 527 S $ 221 S 65 $ B4 S 149 $ 741 S 171 $ $ 190S 50 $ 242S 189 $ 842 S 170$ 146 S 1565 $ 51 S 53$ 576 S 2295 187 S 176 $ 54 S 131 $ 777 S 35$ 38S 26 $ 167 S 26S 292 S 27 $ 175 S 57 $ 213S 200 $ 672 s 111$ 236S 168 $ 248 S 233 S 996 S 224 $ 187 S 1943 $ B2 s 107$ 774 S 103 $ 115 S 182 $ 111s 82 $ 593 S 20a $ $ 147 s 185$ 32S 194$ 766 S 169 $ 47 E S 40$ $ 249S 200 $ 705 S 735 $ 64 S S 164 $ 41 S 28$ 370 S 223 $ 58S 214 $ 95 S 69 $ 659 S 244 $ B1 S 28 $ 185 S 55 $ 593 S 965 $ 74 S 250 $ $ 214 S 67 $ 701 S 47$ 96 S 1425 $ 156 S 1836 624 S 2173 187 S 237$ 57 S 162 $ 860 s 525 $ 83 S 33$ $ 83 S 57S $ 308 S 190$ 143S 2073 50 S 2365 826 S S aa $ B2S 1723 40 S 46 $ 426 S 151 $ 43 S 225$ 71 S 203 $ 693 S 143 $ $ B3 S 122 $ 62 S 1335 $ 543 s 150 $ 59 S 216 $ $ 164 S 89 $ 678 S 232 $ 152 S 225 $ $ B4S 198 $ 891 S 35$ 231S 1946 $ 155 S 1075 $ 722 S 204 $ 93S 96 $ 109S 224 $ 726 S 203$ 181 S 77 $ 138S 76 $ 675 S 1735 28S S 39$ 150 S 87 $ 477 S 47$ 79S 78$ 138S 121 $ 463 S S 99 $ 249S 225$ 165S 965 934 S 199 $ 179S 925 $ 96 S 166 $ 732 S 1333 $ 46 S 1525 $ 130S 121 $ 582 S 173 $ 78 S 57$ 137 s 211 $ 656 S a2 $ 147 S 29 $ 136S 105 $ 499 S 66 $ 70 S 76 $ 131 S 36 5 $ 379 S 176 $ 104S 36 $ $ 108 S 167$ 591 S 142 $ 133S 32 $ 151 S 79 $ 537 S 215$ 139S 72 $ 244S 145$ 815 S 229 $ 215 S 157 $ 49S 57 $ 707 S 110S $ 134S 32 $ 141 S 188$ 605 S 73 $ 214 S 147 $ 72 S 218$ 724 S 214 $ 68S 242 $ 113 S 80$ $ 717 S 155$ 100 S 55$ 187 | S 166 $ 663 s 53 BBS 125$ 245 S 120 S $ 811 S 225$ 183 S 203 $ 101 S 46 $ 758 s 163 $ 170 S 131 $ 180S 240$ 864 S 15$ 132S 47 $ 143S 214 $ 694 S | 77 $ 126 S 115$ 217 S 113 5 $ 648 S 210$ 111 S 193$ 40 S 250 $ BD4 S 182 $ 38 S 92 $ 175 S 188$ 675 S S 236 $ B6 S 117 $ 231S 57$ 727 S 2355 194 S 1225 $ 42 | S 55$ 648 IS 228 $ 69 S 985 $ 1488 234 $ 777 S 2235 71 S 1773 $ 43S 1035 617 S 1525 S 130S $ 204S 138 781 S S 148 $ BBS 1073 B9 S 50S $ 482 S 122 $ 197 S 181 $ $ 1715 70 $ 741 S 1425 $ 78 S 73 $ 195 S 26 $ 512 S 170$ 41 S 74 $ 37 S 148$ 470 S S 192 $ 169S 2435 $ 185S 212$ 1,001 S 72 $ $ 102 S 82 $ 35 S 158$ 449 S 34 $ 112S 1125 $ 38S 53 $ 349 S 2415 151 S 188 $ $ 107S 109 $ 796 S 39$ 53S 202 $ $ 82 S 155$ 531 S 49 $ 141 S S 52 $ 170 S 99 $ 511 S 148$ 198S 585 61 S 141 ls $ 606 S 1485 $ 125 S 39: $ 236 S 83 S S 631 S 216 $ 156S 32 $ 50 S 157 $ 611 S 53$ 142 S a2 $ B3S 20a $ 566 157

Answer & Explanation Solved by verified expert

See Answer