1. How many records of sales do we have for each segment? 2. How much are total sales for each segment? \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 316 & 4/22 Art & $30.00 & $3.00 \\ \hline 317 & 4/23 Food & $40.00 & $4.00 \\ \hline 318 & 4/23 Music & $120.00 & $12.00 \\ \hline 319 & 4/23 Food & $20.00 & $2.00 \\ \hline 320 & 4/23 Sports & $100.00 & $10.00 \\ \hline 321 & 4/23 Food & $20.00 & $2.00 \\ \hline 322 & 4/23 Food & $40.00 & $4.00 \\ \hline 323 & 4/24 Music & $80.00 & $8.00 \\ \hline 324 & 4/24 Food & $60.00 & $6.00 \\ \hline 325 & 4/24 Food & $60.00 & $6.00 \\ \hline 326 & 4/24 Charity & $20.00 & $2.00 \\ \hline 327 & 4/24 Sports & $50.00 & $5.00 \\ \hline 328 & 4/24 Music & $40.00 & $4.00 \\ \hline 329 & 4/24 Charity & $20.00 & $2.00 \\ \hline 330 & 4/24 Food & $20.00 & $2.00 \\ \hline 331 & 4/25 Food & $40.00 & $4.00 \\ \hline 332 & 4/25 Music & $120.00 & $12.00 \\ \hline 333 & 4/25 Charity & $40.00 & $4.00 \\ \hline 334 & 4/26 Art & $20.00 & $2.00 \\ \hline 335 & 4/27 Charity & $60.00 & $6.00 \\ \hline 336 & 4/27 Food & $60.00 & $6.00 \\ \hline 337 & 4/29 Sports & $150.00 & $15.00 \\ \hline 338 & 4/29 Music & $80.00 & $8.00 \\ \hline 339 & 4/29 Food & $20.00 & $2.00 \\ \hline 340 & 4/29 Charity & $60.00 & $6.00 \\ \hline 341 & 4/30 Art & $10.00 & $1.00 \\ \hline 342 & 4/30 Art & $30.00 & $3.00 \\ \hline 343 & 5/1 Charity & $40.00 & $4.00 \\ \hline 344 & 5/2 Art & $20.00 & $2.00 \\ \hline 345 & 5/3 Charity & $40.00 & $4.00 \\ \hline 346 & 5/3 Charity & $60.00 & $6.00 \\ \hline 347 & 5/3 Food & $60.00 & $6.00 \\ \hline 348 & 5/4 Food & $20.00 & $2.00 \\ \hline 349 & 5/4 Art & $10.00 & $1.00 \\ \hline 350 & 5/4 Sports & $100.00 & $10.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 211 & 3/11 Sports & $100.00 & $10.00 \\ \hline 212 & 3/12 Sports & $50.00 & $5.00 \\ \hline 213 & 3/13 Sports & $150.00 & $15.00 \\ \hline 214 & 3/14 Music & $120.00 & $12.00 \\ \hline 215 & 3/14 Music & $40.00 & $4.00 \\ \hline 216 & 3/15 Music & $80.00 & $8.00 \\ \hline 217 & 3/15 Music & $120.00 & $12.00 \\ \hline 218 & 3/15 Charity & $20.00 & $2.00 \\ \hline 219 & 3/16 Charity & $40.00 & $4.00 \\ \hline 220 & 3/16 Sports & $100.00 & $10.00 \\ \hline 221 & 3/16 Music & $120.00 & $12.00 \\ \hline 222 & 3/16 Charity & $20.00 & $2.00 \\ \hline 223 & 3/16 Music & $80.00 & $8.00 \\ \hline 224 & 3/16 Sports & $50.00 & $5.00 \\ \hline 225 & 3/18 Music & $80.00 & $8.00 \\ \hline 226 & 3/18 Food & $40.00 & $4.00 \\ \hline 227 & 3/19 Charity & $20.00 & $2.00 \\ \hline 228 & 3/19 Sports & $100.00 & $10.00 \\ \hline 229 & 3/19 Art & $10.00 & $1.00 \\ \hline 230 & 3/20 Food & $20.00 & $2.00 \\ \hline 231 & 3/21 Charity & $60.00 & $6.00 \\ \hline 232 & 3/21 Food & $40.00 & $4.00 \\ \hline 233 & 3/22 Music & $40.00 & $4.00 \\ \hline 234 & 3/22 Art & $30.00 & $3.00 \\ \hline 235 & 3/22 Music & $80.00 & $8.00 \\ \hline 236 & 3/22 Sports & $150.00 & $15.00 \\ \hline 237 & 3/23 Food & $60.00 & $6.00 \\ \hline 238 & 3/23 Sports & $50.00 & $5.00 \\ \hline 239 & 3/23 Music & $40.00 & $4.00 \\ \hline 240 & 3/24 Food & $20.00 & $2.00 \\ \hline 241 & 3/24 Music & $120.00 & $12.00 \\ \hline 242 & 3/24 Music & $40.00 & $4.00 \\ \hline 243 & 3/24 Art & $10.00 & $1.00 \\ \hline 244 & 3/24 Sports & $150.00 & $15.00 \\ \hline 245 & 3/25 Sports & $50.00 & $5.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 246 & 3/25 Music & $120.00 & $12.00 \\ \hline 247 & 3/26 Food & $20.00 & $2.00 \\ \hline 248 & 3/28 Art & $20.00 & $2.00 \\ \hline 249 & 3/28 Food & $60.00 & $6.00 \\ \hline 250 & 3/28 Music & $40.00 & $4.00 \\ \hline 251 & 3/28 Music & $120.00 & $12.00 \\ \hline 252 & 3/28 Food & $60.00 & $6.00 \\ \hline 253 & 3/30 Art & $30.00 & $3.00 \\ \hline 254 & 3/30 Sports & $150.00 & $15.00 \\ \hline 255 & 3/30 Sports & $150.00 & $15.00 \\ \hline 256 & 3/31 Food & $20.00 & $2.00 \\ \hline 257 & 4/1 Music & $120.00 & $12.00 \\ \hline 258 & 4/1 Art & $30.00 & $3.00 \\ \hline 259 & 4/2 Art & $10.00 & $1.00 \\ \hline 260 & 4/2 Art & $30.00 & $3.00 \\ \hline 261 & 4/3 Art & $30.00 & $3.00 \\ \hline 262 & 4/4 Music & $40.00 & $4.00 \\ \hline 263 & 4/5 Art & $20.00 & $2.00 \\ \hline 264 & 4/5 Charity & $20.00 & $2.00 \\ \hline 265 & 4/6 Food & $40.00 & $4.00 \\ \hline 266 & 4/6 Art & $30.00 & $3.00 \\ \hline 267 & 4/6 Art & $20.00 & $2.00 \\ \hline 268 & 4/6 Sports & $100.00 & $10.00 \\ \hline 269 & 4/6 Food & $40.00 & $4.00 \\ \hline 270 & 4/6 Music & $120.00 & $12.00 \\ \hline 271 & 4/7 Sports & $50.00 & $5.00 \\ \hline 272 & 4/7 Music & $120.00 & $12.00 \\ \hline 273 & 4/8 Music & $120.00 & $12.00 \\ \hline 274 & 4/8 Sports & $100.00 & $10.00 \\ \hline 275 & 4/8 Music & $120.00 & $12.00 \\ \hline 276 & 4/8 Sports & $100.00 & $10.00 \\ 277 & 4/8 Music & $120.00 & $12.00 \\ \hline 278 & 4/9 Food & $40.00 & $4.00 \\ \hline 279 & 4/9 Sports & $50.00 & $5.00 \\ 280 & 4/9 Food & $40.00 & $4.00 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 351 & 5/5 Art & $20.00 & $2.00 \\ \hline 352 & 5/5 Sports & $150.00 & $15.00 \\ \hline 353 & 5/5 Sports & $50.00 & $5.00 \\ \hline 354 & 5/5 Art & $10.00 & $1.00 \\ \hline 355 & 5/6 Charity & $40.00 & $4.00 \\ \hline 356 & 5/7 Art & $20.00 & $2.00 \\ \hline 357 & 5/7 Sports & $50.00 & $5.00 \\ \hline 358 & 5/7 Art & $20.00 & $2.00 \\ \hline 359 & 5/7 Charity & $20.00 & $2.00 \\ \hline 360 & 5/7 Sports & $100.00 & $10.00 \\ \hline 361 & 5/7 Charity & $20.00 & $2.00 \\ \hline 362 & 5/8 Art & $30.00 & $3.00 \\ \hline 363 & 5/8 Food & $40.00 & $4.00 \\ \hline 364 & 5/8 Art & $10.00 & $1.00 \\ \hline 365 & 5/9 Music & $120.00 & $12.00 \\ \hline 366 & 5/9 Music & $120.00 & $12.00 \\ \hline 367 & 5/9 Sports & $50.00 & $5.00 \\ \hline 368 & 5/9 Art & $30.00 & $3.00 \\ \hline 369 & 5/9 Charity & $20.00 & $2.00 \\ \hline 370 & 5/9 Food & $20.00 & $2.00 \\ \hline 371 & 5/9 Charity & $20.00 & $2.00 \\ \hline 372 & 5/9 Food & $40.00 & $4.00 \\ \hline 373 & 5/10 Sports & $150.00 & $15.00 \\ \hline 374 & 5/10 Sports & $50.00 & $5.00 \\ \hline 375 & 5/10 Sports & $150.00 & $15.00 \\ \hline 376 & 5/10 Sports & $150.00 & $15.00 \\ \hline 377 & 5/11 Food & $20.00 & $2.00 \\ \hline 378 & 5/12 Music & $120.00 & $12.00 \\ \hline 379 & 5/12 Sports & $150.00 & $15.00 \\ \hline 380 & 5/12 Sports & $100.00 & $10.00 \\ \hline 381 & 5/13 Food & $20.00 & $2.00 \\ \hline 382 & 5/13 Charity & $20.00 & $2.00 \\ \hline 383 & 5/13 Charity & $20.00 & $2.00 \\ \hline 384 & 5/14 Art & $30.00 & $3.00 \\ \hline 385 & 5/14 Sports & $100.00 & $10.00 \\ \hline \end{tabular} \begin{tabular}{r|r|r|r|} & \multicolumn{1}{c}{ A } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c}{ D } \\ \hline 491 & 6/26 Music & $40.00 & $4.00 \\ \hline 492 & 6/27 Food & $60.00 & $6.00 \\ \hline 493 & 6/27 Art & $30.00 & $3.00 \\ \hline 494 & 6/27 Sports & $150.00 & $15.00 \\ \hline 495 & 6/28 Sports & $100.00 & $10.00 \\ \hline 496 & 6/28 Charity & $60.00 & $6.00 \\ \hline 497 & 6/29 Sports & $50.00 & $5.00 \\ \hline 498 & 6/29 Music & $120.00 & $12.00 \\ \hline 499 & 6/29 Music & $80.00 & $8.00 \\ \hline 500 & 6/30 Sports & $100.00 & $10.00 \\ \hline 501 & 6/30 Music & $40.00 & $4.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ A } \\ \hline 176 & 2/27 Charity & $20.00 & $2.00 \\ \hline 177 & 2/27 Sports & $100.00 & $10.00 \\ \hline 178 & 2/27 Sports & $50.00 & $5.00 \\ \hline 179 & 2/28 Charity & $40.00 & $4.00 \\ \hline 180 & 3/1 Charity & $40.00 & $4.00 \\ \hline 181 & 3/2 Sports & $100.00 & $10.00 \\ \hline 182 & 3/2 Food & $60.00 & $6.00 \\ \hline 183 & 3/2 Sports & $50.00 & $5.00 \\ \hline 184 & 3/2 Charity & $40.00 & $4.00 \\ \hline 185 & 3/3 Music & $40.00 & $4.00 \\ \hline 186 & 3/4 Sports & $100.00 & $10.00 \\ \hline 187 & 3/4 Food & $20.00 & $2.00 \\ \hline 188 & 3/4 Food & $20.00 & $2.00 \\ \hline 189 & 3/4 Food & $60.00 & $6.00 \\ \hline 190 & 3/4 Food & $40.00 & $4.00 \\ \hline 191 & 3/5 Charity & $40.00 & $4.00 \\ \hline 192 & 3/6 Art & $30.00 & $3.00 \\ \hline 193 & 3/6 Music & $40.00 & $4.00 \\ \hline 194 & 3/6 Art & $20.00 & $2.00 \\ \hline 195 & 3/6 Sports & $50.00 & $5.00 \\ \hline 196 & 3/7 Music & $120.00 & $12.00 \\ \hline 197 & 3/7 Food & $40.00 & $4.00 \\ \hline 198 & 3/7 Sports & $50.00 & $5.00 \\ \hline 199 & 3/8 Music & $120.00 & $12.00 \\ \hline 200 & 3/9 Food & $20.00 & $2.00 \\ \hline 201 & 3/9 Art & $20.00 & $2.00 \\ \hline 202 & 3/10 Charity & $40.00 & $4.00 \\ \hline 203 & 3/10 Art & $30.00 & $3.00 \\ \hline 204 & 3/10 Food & $60.00 & $6.00 \\ \hline 205 & 3/10 Food & $20.00 & $2.00 \\ \hline 206 & 3/10 Art & $20.00 & $2.00 \\ \hline 207 & 3/10 Charity & $60.00 & $6.00 \\ \hline 208 & 3/10 Music & $80.00 & $8.00 \\ \hline 209 & 3/10 Food & $40.00 & $4.00 \\ \hline 210 & 3/10 Charity & $60.00 & $6.00 \\ \hline \end{tabular} Segment Analysis Using Excel Completing this activity will help you learn to: 1. create pivot tables for aggregating data. 2. analyze data by different statistical calculations with pivot tables. 3. analyze data by using filters with pivot tables. Case scenario: You are working at a company that selis event tickets online, The company has five business segments: art, chanty, food, music, and sports. You would like to analyze the sales for the six months for each segment. Your task is to create a spreadsheet that summarizes and compares the five segments. Required: Download spreadsheet SegmentAnalysisCaseData-db1f69.xisx HINT: STEP-BY-STEP WALKTHROUGH Build a spreadsheet that can show only sales for each segment; calculate the sum and average of sales for each month; and then compare the segments, You will also apply filtering. 1. How many records of sales do we have for each segment? \begin{tabular}{|c|c|c|c|c|} \hline 4 & A & B & C & D \\ \hline 36 & 5/15 & Charity & $40.00 & $4.00 \\ \hline 77 & 5/15 & Music & $120.00 & $12.00 \\ \hline & 5/15 & Art & $10.00 & $1.00 \\ \hline & 5/15 & Charity & $60.00 & $6.00 \\ \hline & 5/15 & Charity & $20.00 & $2.00 \\ \hline & 5/15 & Music & $80.00 & $8.00 \\ \hline & 5/15 & Charity & $20.00 & $2.00 \\ \hline & 5/16 & Charity & $20.00 & $2.00 \\ \hline & 5/16 & Charity & $40.00 & $4.00 \\ \hline & 5/16 & Sports & $50.00 & $5.00 \\ \hline & 5/17 & Art & $30.00 & $3.00 \\ \hline & 5/18 & Sports & $100.00 & $10.00 \\ \hline & 5/18 & Charity & $60.00 & $6.00 \\ \hline & 5/19 & Sports & $100.00 & $10.00 \\ \hline & 5/19 & Sports & $50.00 & $5.00 \\ \hline & 5/19 & Charity & $20.00 & $2.00 \\ \hline & 5/20 & Food & $20.00 & $2.00 \\ \hline & 5/20 & Art & $10.00 & $1.00 \\ \hline & 5/20 & Music & $40.00 & $4.00 \\ \hline & 5/20 & Music & $80.00 & $8.00 \\ \hline & 5/20 & Charity & $60.00 & $6.00 \\ \hline & 5/21 & Food & $60.00 & $6.00 \\ \hline & 5/21 & Food & $20.00 & $2.00 \\ \hline & 5/21 & Art & $20.00 & $2.00 \\ \hline & 5/22 & Charity & $20.00 & $2.00 \\ \hline & 5/23 & Sports & $150.00 & $15.00 \\ \hline & 5/23 & Art & $10.00 & $1.00 \\ \hline & 5/24 & Sports & $50.00 & $5.00 \\ \hline & 5/24 & Food & $60.00 & $6.00 \\ \hline & 5/24 & Art & $20.00 & $2.00 \\ \hline & 5/25 & Food & $40,00 & $4.00 \\ \hline & 5/25 & Art & $10.00 & $1.00 \\ \hline & 5/26 & Sports & $100.00 & $10.00 \\ \hline & 5/26 & Art & $30.00 & $3.00 \\ \hline & 5/26 & Music & $120.00 & $12.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 106 & 2/6 Music & $40.00 & $4.00 \\ \hline 107 & 2/6 Sports & $100.00 & $10.00 \\ \hline 108 & 2/6 Sports & $150.00 & $15.00 \\ \hline 109 & 2/6 Charity & $60.00 & $6.00 \\ \hline 110 & 2/6 Food & $20.00 & $2.00 \\ \hline 111 & 2/7 Food & $40.00 & $4.00 \\ \hline 112 & 2/7 Sports & $150.00 & $15.00 \\ \hline 113 & 2/7 Sports & $150.00 & $15.00 \\ \hline 114 & 2/7 Food & $40.00 & $4.00 \\ \hline 115 & 2/7 Sports & $100.00 & $10.00 \\ \hline 116 & 2/8 Sports & $150.00 & $15.00 \\ \hline 117 & 2/9 Charity & $20.00 & $2.00 \\ \hline 118 & 2/9 Charity & $60.00 & $6.00 \\ \hline 119 & 2/9 Sports & $50.00 & $5.00 \\ \hline 120 & 2/9 Sports & $150.00 & $15.00 \\ \hline 121 & 2/9 Music & $120.00 & $12.00 \\ \hline 122 & 2/9 Sports & $150.00 & $15.00 \\ \hline 123 & 2/9 Music & $80.00 & $8.00 \\ \hline 124 & 2/10 Art & $30.00 & $3.00 \\ \hline 125 & 2/10 Charity & $60.00 & $6.00 \\ \hline 126 & 2/10 Charity & $40.00 & $4.00 \\ \hline 127 & 2/10 Food & $40.00 & $4.00 \\ \hline 128 & 2/10 Charity & $40.00 & $4.00 \\ \hline 129 & 2/10 Music & $80.00 & $8.00 \\ \hline 130 & 2/11 Music & $80.00 & $8.00 \\ \hline 131 & 2/11 Art & $30.00 & $3.00 \\ \hline 132 & 2/12 Charity & $20.00 & $2.00 \\ \hline 133 & 2/12 Sports & $100.00 & $10.00 \\ \hline 134 & 2/12 Art & $20.00 & $2.00 \\ \hline 135 & 2/13 Sports & $150.00 & $15.00 \\ \hline 136 & 2/13 Charity & $20.00 & $2.00 \\ \hline 137 & 2/13 Charity & $20.00 & $2.00 \\ \hline 138 & 2/14 Food & $60.00 & $6.00 \\ \hline 139 & 2/14 Music & $120.00 & $12.00 \\ \hline 140 & 2/15 Charity & $40.00 & $4.00 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c}{ D } \\ \hline 141 & 2/15 Art & $20.00 & $2.00 \\ \hline 142 & 2/15 Music & $80.00 & $8.00 \\ \hline 143 & 2/15 Art & $10.00 & $1.00 \\ \hline 144 & 2/16 Charity & $20.00 & $2.00 \\ \hline 145 & 2/16 Charity & $40.00 & $4.00 \\ \hline 146 & 2/16 Art & $10.00 & $1.00 \\ \hline 147 & 2/16 Food & $20.00 & $2.00 \\ \hline 148 & 2/18 Art & $10.00 & $1.00 \\ \hline 149 & 2/18 Charity & $40.00 & $4.00 \\ \hline 150 & 2/18 Charity & $60.00 & $6.00 \\ \hline 151 & 2/19 Food & $60.00 & $6.00 \\ \hline 152 & 2/19 Charity & $40.00 & $4.00 \\ \hline 153 & 2/19 Music & $120.00 & $12.00 \\ \hline 154 & 2/20 Art & $10.00 & $1.00 \\ \hline 155 & 2/20 Art & $20.00 & $2.00 \\ \hline 156 & 2/20 Art & $30.00 & $3.00 \\ \hline 157 & 2/20 Food & $60.00 & $6.00 \\ \hline 158 & 2/20 Art & $20.00 & $2.00 \\ \hline 159 & 2/21 Art & $10.00 & $1.00 \\ \hline 160 & 2/21 Sports & $150.00 & $15.00 \\ \hline 161 & 2/21 Food & $60.00 & $6.00 \\ \hline 162 & 2/21 Food & $40.00 & $4.00 \\ \hline 163 & 2/21 Art & $20.00 & $2.00 \\ \hline 164 & 2/21 Food & $40.00 & $4.00 \\ \hline 165 & 2/22 Sports & $150.00 & $15.00 \\ \hline 166 & 2/22 Food & $20.00 & $2.00 \\ \hline 167 & 2/23 Music & $120.00 & $12.00 \\ \hline 168 & 2/23 Art & $30.00 & $3.00 \\ \hline 169 & 2/24 Art & $10.00 & $1.00 \\ \hline 170 & 2/24 Art & $30.00 & $3.00 \\ \hline 171 & 2/24 Sports & $100.00 & $10.00 \\ \hline 172 & 2/24 Charity & $40.00 & $4.00 \\ \hline 173 & 2/25 Food & $40.00 & $4.00 \\ \hline 174 & 2/25 Charity & $20.00 & $2.00 \\ \hline 175 & 2/27 Music & $40.00 & $4.00 \\ \hline \end{tabular} 3. What is the average tax for each segment? Round your answers to the nearest cent. 4. Explain what can be accomplished by analyzing this segment data. \begin{tabular}{|c|c|c|c|c|} \hline & A & B & c & D \\ \hline 1 & Date & Segment & Sales & Tax \\ \hline 2 & 1/1 & Sports & $50.00 & $5.00 \\ \hline 3 & 1/1 & Art & $30.00 & $3.00 \\ \hline 4 & 1/2 & Art & $30.00 & $3.00 \\ \hline 5 & 1/3 & Art & $30.00 & $3.00 \\ \hline 6 & 1/3 & Charity & $20.00 & $2.00 \\ \hline 7 & 1/3 & Music & $120.00 & $12.00 \\ \hline 8 & 1/3 & Sports & $150.00 & $15.00 \\ \hline 9 & 1/3 & Music & $120.00 & $12.00 \\ \hline 10 & 1/3 & Music & $120.00 & $12.00 \\ \hline 11 & 1/4 & Charity & $20.00 & $2.00 \\ \hline 12 & 1/4 & Art & $30.00 & $3.00 \\ \hline 13 & 1/5 & Sports & $150.00 & $15.00 \\ \hline 14 & 1/5 & Food & $40.00 & $4.00 \\ \hline 15 & 1/6 & Sports & $100.00 & $10.00 \\ \hline 16 & 1/6 & Food & $20.00 & $2.00 \\ \hline 17 & 1/6 & Sports & $150.00 & $15.00 \\ \hline 18 & 1/6 & Art & $30.00 & $3.00 \\ \hline 19 & 1/7 & Music & $80.00 & $8.00 \\ \hline 20 & 1/7 & Sports & $100.00 & $10.00 \\ \hline 21 & 1/7 & Food & $40.00 & $4.00 \\ \hline 22 & 1/7 & Sports & $150.00 & $15.00 \\ \hline 23 & 1/7 & Sports & $50.00 & $5.00 \\ \hline 24 & 1/8 & Food & $40.00 & $4.00 \\ \hline 25 & 1/8 & Sports & $100.00 & $10.00 \\ \hline 26 & 1/9 & Charity & $40.00 & $4.00 \\ \hline 27 & 1/9 & Sports & $50.00 & $5.00 \\ \hline 28 & 1/10 & Sports & $100.00 & $10.00 \\ \hline 29 & 1/11 & Food & $60.00 & $6.00 \\ \hline 30 & 1/11 & Food & $20.00 & $2.00 \\ \hline 31 & 1/11 & Sports & $50.00 & $5.00 \\ \hline 32 & 1/12 & Charity & $20.00 & $2.00 \\ \hline 33 & 1/12 & Food & $40.00 & $4.00 \\ \hline 34 & 1/12 & Charity & $40.00 & $4.00 \\ \hline 35 & 13 & Art & $20.00 & $2.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 71 & 1/25 Charity & $40.00 & $4.00 \\ \hline 72 & 1/25 Music & $120.00 & $12.00 \\ \hline 74 & 1/26 Music & $120.00 & $12.00 \\ \hline 75 & 1/26 Sports & $150.00 & $15.00 \\ \hline 76 & 1/26 Art & $20.00 & $2.00 \\ \hline 77 & 1/27 Art & $20.00 & $2.00 \\ \hline 78 & 1/27 Food & $40.00 & $4.00 \\ \hline 79 & 1/28 Sports & $100.00 & $10.00 \\ \hline 80 & 1/28 Sports & $150.00 & $15.00 \\ \hline 81 & 1/28 Sports & $50.00 & $5.00 \\ \hline 82 & 1/28 Music & $40.00 & $4.00 \\ \hline 83 & 1/28 Food & $40.00 & $4.00 \\ \hline 84 & 1/29 Sports & $100.00 & $10.00 \\ \hline 85 & 1/29 Music & $120.00 & $12.00 \\ \hline 86 & 1/29 Music & $120.00 & $12.00 \\ \hline 87 & 1/29 Food & $20.00 & $2.00 \\ \hline 88 & 1/30 Food & $20.00 & $2.00 \\ \hline 89 & 1/30 Art & $20.00 & $2.00 \\ \hline 90 & 1/30 Art & $20.00 & $2.00 \\ \hline 91 & 1/31 Food & $20.00 & $2.00 \\ \hline 92 & 1/31 Sports & $50.00 & $5.00 \\ \hline 93 & 1/31 Sports & $50.00 & $5.00 \\ \hline 94 & 1/31 Sports & $100.00 & $10.00 \\ \hline 95 & 2/1 Food & $20.00 & $2.00 \\ \hline 96 & 2/1 Charity & $60.00 & $6.00 \\ \hline 97 & 2/1 Music & $80.00 & $8.00 \\ \hline 98 & 2/1 Art & $20.00 & $2.00 \\ \hline 99 & 2/2 Sports & $100.00 & $10.00 \\ \hline 100 & 2/3 Art & $20.00 & $2.00 \\ \hline 102 & 2/3 Sports & $150.00 & $15.00 \\ \hline 103 & 2/3 Charity & $20.00 & $2.00 \\ \hline 105 & 2/3 Art & $30.00 & $3.00 \\ \hline 14 & 2/4 Sports & $150.00 & $15.00 \\ \hline 2/4 Charity & $150.00 & $15.00 \\ \hline 120.00 & $2.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & A & B & C & D \\ \hline 456 & 6/13 & Music & $120.00 & $12.00 \\ \hline & 6/13 & Charity & $40.00 & 54.00 \\ \hline & 6/13 & Food & $40.00 & $4.00 \\ \hline & 6/14 & Sports & $100.00 & $10.00 \\ \hline 0 & 6/14 & Music & $120,00 & $12.00 \\ \hline 51 & 6/15 & Art & $10.00 & $1.00 \\ \hline 52 & 6/16 & Art & $20.00 & $2.00 \\ \hline 53 & 6/17 & Food & $60.00 & $600 \\ \hline 54 & 6/17 & Music & $40.00 & 54.00 \\ \hline 55 & 6/17 & Art & $10,00 & $1.00 \\ \hline 56 & 6/17 & Art & $20.00 & $2.00 \\ \hline 57 & 6/17 & Art & $10,00 & $100 \\ \hline 68 & 6/17 & Food & $20,90 & 5200 \\ \hline 69 & 6/18 & Sports & $100,00 & 5:000 \\ \hline 70 & 6/18 & Food & $60.00 & 3400 \\ \hline 71 & 6/18 & Sports & $10000 & $1000 \\ \hline 72 & 6/18 & Sports & $100.00 & 51000 \\ \hline 73 & 6/19 & Art & $10.00 & 5100 \\ \hline 74 & 6/19 & Charity & $40.00 & $4.00 \\ \hline 475 & 6/19 & Art & $30.00 & $3.00 \\ \hline 476 & 6/19 & Art & $30.00 & $3.00 \\ \hline 477 & 6/20 & Food & $60,00 & $6.00 \\ \hline 478 & 6/20 & Music & $80.00 & $8.00 \\ \hline 479 & 6/20 & Art & $20.00 & $2.00 \\ \hline 480 & 6/22 & Sports & $150.00 & $15.00 \\ \hline 481 & 6/23 & Sports & $100.00 & $10.00 \\ \hline 482 & 6/23 & Charity & $20.00 & $2.00 \\ \hline 483 & 6/24 & Charity & $20.00 & $2.00 \\ \hline 484 & 6/24 & Music & $40.00 & 54.00 \\ \hline 485 & 6/24 & Art & $30.00 & $3.00 \\ \hline 486 & 6/24 & Art & $30.00 & $3.00 \\ \hline 487 & 6/24 & Music & $40.00 & $4.00 \\ \hline 488 & 6/25 & Music & $120.00 & $12.00 \\ \hline 489 & 6/26 & Food & $40.00 & $4.00 \\ \hline 190 & 6/26 & Art & $10.00 & $1.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline 4 & A & B & C & D \\ \hline 281 & 4/9 & Sports & $150.00 & $15.00 \\ \hline 282 & 4/10 & Music & $120.00 & $12.00 \\ \hline 283 & 4/10 & Music & $80.00 & $8.00 \\ \hline 84 & 4/11 & Food & $20.00 & $2.00 \\ \hline 85 & 4/11 & Charity & $40.00 & $4.00 \\ \hline 86 & 4/11 & Art & $30.00 & $3.00 \\ \hline 287 & 4/12 & Art & $10.00 & $1.00 \\ \hline 88 & 4/12 & Music & $40.00 & $4.00 \\ \hline 39 & 4/12 & Sports & $50.00 & $5.00 \\ \hline 90 & 4/13 & Food & $60.00 & $6.00 \\ \hline 91 & 4/13 & Food & $60.00 & $6.00 \\ \hline 92 & 4/13 & Music & $40.00 & $4.00 \\ \hline 93 & 4/13 & Food & $20.00 & $2.00 \\ \hline 94 & 4/14 & Food & $40.00 & $4.00 \\ \hline 95 & 4/14 & Music & $40.00 & $4.00 \\ \hline 96 & 4/15 & Food & $20.00 & $2.00 \\ \hline 97 & 4/16 & Art & $30.00 & $3.00 \\ \hline 98 & 4/16 & Sports & $150.00 & $15.00 \\ \hline 99 & 4/16 & Sports & $50.00 & $5.00 \\ \hline 300 & 4/17 & Music & $80.00 & $8.00 \\ \hline 01 & 4/17 & Charity & $60.00 & $6.00 \\ \hline 02 & 4/17 & Food & $20.00 & $2.00 \\ \hline 03 & 4/18 & Sports & $150.00 & $15.00 \\ \hline 04 & 4/18 & Charity & $40.00 & $4.00 \\ \hline 05 & 4/18 & Food & $40.00 & $4.00 \\ \hline 06 & 4/19 & Music & $40.00 & $4.00 \\ \hline 07 & 4/19 & Sports & $50.00 & $5.00 \\ \hline 308 & 4/20 & Sports & $150.00 & $15.00 \\ \hline 09 & 4/20 & Art & $30.00 & $3.00 \\ \hline 10 & 4/20 & Sports & $150.00 & $15.00 \\ \hline 11 & 4/20 & Music & $120.00 & $12.00 \\ \hline 12 & 4/21 & Charity & $40.00 & $4.00 \\ \hline 13 & 4/21 & Art & $30.00 & $3.00 \\ \hline 14 & 4/21 & Music & $80.00 & $8.00 \\ \hline 15 & 4/21 & Art & $30.00 & $3.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 36 & 1/13 Art & $30.00 & $3.00 \\ \hline 37 & 1/13 Art & $30.00 & $3.00 \\ \hline 38 & 1/14 Music & $120.00 & $12.00 \\ \hline 39 & 1/14 Food & $20.00 & $2.00 \\ \hline 40 & 1/14 Sports & $50.00 & $5.00 \\ \hline 41 & 1/14 Music & $80.00 & $8.00 \\ \hline 42 & 1/15 Music & $80.00 & $8.00 \\ \hline 43 & 1/15 Music & $120.00 & $12.00 \\ \hline 44 & 1/15 Art & $30.00 & $3.00 \\ \hline 45 & 1/16 Food & $20.00 & $2.00 \\ \hline 46 & 1/16 Art & $30.00 & $3.00 \\ \hline 47 & 1/16 Art & $10.00 & $1.00 \\ \hline 48 & 1/17 Art & $30.00 & $3.00 \\ \hline 49 & 1/17 Music & $120.00 & $12.00 \\ \hline 50 & 1/17 Food & $60.00 & $6.00 \\ \hline 51 & 1/17 Food & $20.00 & $2.00 \\ \hline 52 & 1/18 Music & $40.00 & $4.00 \\ \hline 53 & 1/19 Sports & $150.00 & $15.00 \\ \hline 54 & 1/19 Art & $30.00 & $3.00 \\ \hline 55 & 1/19 Food & $40.00 & $4.00 \\ \hline 56 & 1/20 Food & $20.00 & $2.00 \\ \hline 57 & 1/20 Charity & $20.00 & $2.00 \\ \hline 58 & 1/20 Sports & $150.00 & $15.00 \\ \hline 59 & 1/20 Sports & $100.00 & $10.00 \\ \hline 60 & 1/20 Food & $40.00 & $4.00 \\ \hline 61 & 1/21 Charity & $60.00 & $6.00 \\ \hline 62 & 1/22 Sports & $50.00 & $5.00 \\ \hline 63 & 1/22 Charity & $60.00 & $6.00 \\ \hline 64 & 1/22 Food & $40.00 & $4.00 \\ \hline 65 & 1/22 Charity & $20.00 & $2.00 \\ \hline 66 & 1/23 Food & $20.00 & $2.00 \\ \hline 67 & 1/23 Charity & $20.00 & $2.00 \\ \hline 68 & 1/24 Food & $60.00 & $6.00 \\ \hline 69 & 1/24 Music & $80.00 & $8.00 \\ \hline 70 & 1/25 Food & $60.00 & $6.00 \\ \hline \end{tabular} 1. How many records of sales do we have for each segment? 2. How much are total sales for each segment? \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 316 & 4/22 Art & $30.00 & $3.00 \\ \hline 317 & 4/23 Food & $40.00 & $4.00 \\ \hline 318 & 4/23 Music & $120.00 & $12.00 \\ \hline 319 & 4/23 Food & $20.00 & $2.00 \\ \hline 320 & 4/23 Sports & $100.00 & $10.00 \\ \hline 321 & 4/23 Food & $20.00 & $2.00 \\ \hline 322 & 4/23 Food & $40.00 & $4.00 \\ \hline 323 & 4/24 Music & $80.00 & $8.00 \\ \hline 324 & 4/24 Food & $60.00 & $6.00 \\ \hline 325 & 4/24 Food & $60.00 & $6.00 \\ \hline 326 & 4/24 Charity & $20.00 & $2.00 \\ \hline 327 & 4/24 Sports & $50.00 & $5.00 \\ \hline 328 & 4/24 Music & $40.00 & $4.00 \\ \hline 329 & 4/24 Charity & $20.00 & $2.00 \\ \hline 330 & 4/24 Food & $20.00 & $2.00 \\ \hline 331 & 4/25 Food & $40.00 & $4.00 \\ \hline 332 & 4/25 Music & $120.00 & $12.00 \\ \hline 333 & 4/25 Charity & $40.00 & $4.00 \\ \hline 334 & 4/26 Art & $20.00 & $2.00 \\ \hline 335 & 4/27 Charity & $60.00 & $6.00 \\ \hline 336 & 4/27 Food & $60.00 & $6.00 \\ \hline 337 & 4/29 Sports & $150.00 & $15.00 \\ \hline 338 & 4/29 Music & $80.00 & $8.00 \\ \hline 339 & 4/29 Food & $20.00 & $2.00 \\ \hline 340 & 4/29 Charity & $60.00 & $6.00 \\ \hline 341 & 4/30 Art & $10.00 & $1.00 \\ \hline 342 & 4/30 Art & $30.00 & $3.00 \\ \hline 343 & 5/1 Charity & $40.00 & $4.00 \\ \hline 344 & 5/2 Art & $20.00 & $2.00 \\ \hline 345 & 5/3 Charity & $40.00 & $4.00 \\ \hline 346 & 5/3 Charity & $60.00 & $6.00 \\ \hline 347 & 5/3 Food & $60.00 & $6.00 \\ \hline 348 & 5/4 Food & $20.00 & $2.00 \\ \hline 349 & 5/4 Art & $10.00 & $1.00 \\ \hline 350 & 5/4 Sports & $100.00 & $10.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 211 & 3/11 Sports & $100.00 & $10.00 \\ \hline 212 & 3/12 Sports & $50.00 & $5.00 \\ \hline 213 & 3/13 Sports & $150.00 & $15.00 \\ \hline 214 & 3/14 Music & $120.00 & $12.00 \\ \hline 215 & 3/14 Music & $40.00 & $4.00 \\ \hline 216 & 3/15 Music & $80.00 & $8.00 \\ \hline 217 & 3/15 Music & $120.00 & $12.00 \\ \hline 218 & 3/15 Charity & $20.00 & $2.00 \\ \hline 219 & 3/16 Charity & $40.00 & $4.00 \\ \hline 220 & 3/16 Sports & $100.00 & $10.00 \\ \hline 221 & 3/16 Music & $120.00 & $12.00 \\ \hline 222 & 3/16 Charity & $20.00 & $2.00 \\ \hline 223 & 3/16 Music & $80.00 & $8.00 \\ \hline 224 & 3/16 Sports & $50.00 & $5.00 \\ \hline 225 & 3/18 Music & $80.00 & $8.00 \\ \hline 226 & 3/18 Food & $40.00 & $4.00 \\ \hline 227 & 3/19 Charity & $20.00 & $2.00 \\ \hline 228 & 3/19 Sports & $100.00 & $10.00 \\ \hline 229 & 3/19 Art & $10.00 & $1.00 \\ \hline 230 & 3/20 Food & $20.00 & $2.00 \\ \hline 231 & 3/21 Charity & $60.00 & $6.00 \\ \hline 232 & 3/21 Food & $40.00 & $4.00 \\ \hline 233 & 3/22 Music & $40.00 & $4.00 \\ \hline 234 & 3/22 Art & $30.00 & $3.00 \\ \hline 235 & 3/22 Music & $80.00 & $8.00 \\ \hline 236 & 3/22 Sports & $150.00 & $15.00 \\ \hline 237 & 3/23 Food & $60.00 & $6.00 \\ \hline 238 & 3/23 Sports & $50.00 & $5.00 \\ \hline 239 & 3/23 Music & $40.00 & $4.00 \\ \hline 240 & 3/24 Food & $20.00 & $2.00 \\ \hline 241 & 3/24 Music & $120.00 & $12.00 \\ \hline 242 & 3/24 Music & $40.00 & $4.00 \\ \hline 243 & 3/24 Art & $10.00 & $1.00 \\ \hline 244 & 3/24 Sports & $150.00 & $15.00 \\ \hline 245 & 3/25 Sports & $50.00 & $5.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 246 & 3/25 Music & $120.00 & $12.00 \\ \hline 247 & 3/26 Food & $20.00 & $2.00 \\ \hline 248 & 3/28 Art & $20.00 & $2.00 \\ \hline 249 & 3/28 Food & $60.00 & $6.00 \\ \hline 250 & 3/28 Music & $40.00 & $4.00 \\ \hline 251 & 3/28 Music & $120.00 & $12.00 \\ \hline 252 & 3/28 Food & $60.00 & $6.00 \\ \hline 253 & 3/30 Art & $30.00 & $3.00 \\ \hline 254 & 3/30 Sports & $150.00 & $15.00 \\ \hline 255 & 3/30 Sports & $150.00 & $15.00 \\ \hline 256 & 3/31 Food & $20.00 & $2.00 \\ \hline 257 & 4/1 Music & $120.00 & $12.00 \\ \hline 258 & 4/1 Art & $30.00 & $3.00 \\ \hline 259 & 4/2 Art & $10.00 & $1.00 \\ \hline 260 & 4/2 Art & $30.00 & $3.00 \\ \hline 261 & 4/3 Art & $30.00 & $3.00 \\ \hline 262 & 4/4 Music & $40.00 & $4.00 \\ \hline 263 & 4/5 Art & $20.00 & $2.00 \\ \hline 264 & 4/5 Charity & $20.00 & $2.00 \\ \hline 265 & 4/6 Food & $40.00 & $4.00 \\ \hline 266 & 4/6 Art & $30.00 & $3.00 \\ \hline 267 & 4/6 Art & $20.00 & $2.00 \\ \hline 268 & 4/6 Sports & $100.00 & $10.00 \\ \hline 269 & 4/6 Food & $40.00 & $4.00 \\ \hline 270 & 4/6 Music & $120.00 & $12.00 \\ \hline 271 & 4/7 Sports & $50.00 & $5.00 \\ \hline 272 & 4/7 Music & $120.00 & $12.00 \\ \hline 273 & 4/8 Music & $120.00 & $12.00 \\ \hline 274 & 4/8 Sports & $100.00 & $10.00 \\ \hline 275 & 4/8 Music & $120.00 & $12.00 \\ \hline 276 & 4/8 Sports & $100.00 & $10.00 \\ 277 & 4/8 Music & $120.00 & $12.00 \\ \hline 278 & 4/9 Food & $40.00 & $4.00 \\ \hline 279 & 4/9 Sports & $50.00 & $5.00 \\ 280 & 4/9 Food & $40.00 & $4.00 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 351 & 5/5 Art & $20.00 & $2.00 \\ \hline 352 & 5/5 Sports & $150.00 & $15.00 \\ \hline 353 & 5/5 Sports & $50.00 & $5.00 \\ \hline 354 & 5/5 Art & $10.00 & $1.00 \\ \hline 355 & 5/6 Charity & $40.00 & $4.00 \\ \hline 356 & 5/7 Art & $20.00 & $2.00 \\ \hline 357 & 5/7 Sports & $50.00 & $5.00 \\ \hline 358 & 5/7 Art & $20.00 & $2.00 \\ \hline 359 & 5/7 Charity & $20.00 & $2.00 \\ \hline 360 & 5/7 Sports & $100.00 & $10.00 \\ \hline 361 & 5/7 Charity & $20.00 & $2.00 \\ \hline 362 & 5/8 Art & $30.00 & $3.00 \\ \hline 363 & 5/8 Food & $40.00 & $4.00 \\ \hline 364 & 5/8 Art & $10.00 & $1.00 \\ \hline 365 & 5/9 Music & $120.00 & $12.00 \\ \hline 366 & 5/9 Music & $120.00 & $12.00 \\ \hline 367 & 5/9 Sports & $50.00 & $5.00 \\ \hline 368 & 5/9 Art & $30.00 & $3.00 \\ \hline 369 & 5/9 Charity & $20.00 & $2.00 \\ \hline 370 & 5/9 Food & $20.00 & $2.00 \\ \hline 371 & 5/9 Charity & $20.00 & $2.00 \\ \hline 372 & 5/9 Food & $40.00 & $4.00 \\ \hline 373 & 5/10 Sports & $150.00 & $15.00 \\ \hline 374 & 5/10 Sports & $50.00 & $5.00 \\ \hline 375 & 5/10 Sports & $150.00 & $15.00 \\ \hline 376 & 5/10 Sports & $150.00 & $15.00 \\ \hline 377 & 5/11 Food & $20.00 & $2.00 \\ \hline 378 & 5/12 Music & $120.00 & $12.00 \\ \hline 379 & 5/12 Sports & $150.00 & $15.00 \\ \hline 380 & 5/12 Sports & $100.00 & $10.00 \\ \hline 381 & 5/13 Food & $20.00 & $2.00 \\ \hline 382 & 5/13 Charity & $20.00 & $2.00 \\ \hline 383 & 5/13 Charity & $20.00 & $2.00 \\ \hline 384 & 5/14 Art & $30.00 & $3.00 \\ \hline 385 & 5/14 Sports & $100.00 & $10.00 \\ \hline \end{tabular} \begin{tabular}{r|r|r|r|} & \multicolumn{1}{c}{ A } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c}{ D } \\ \hline 491 & 6/26 Music & $40.00 & $4.00 \\ \hline 492 & 6/27 Food & $60.00 & $6.00 \\ \hline 493 & 6/27 Art & $30.00 & $3.00 \\ \hline 494 & 6/27 Sports & $150.00 & $15.00 \\ \hline 495 & 6/28 Sports & $100.00 & $10.00 \\ \hline 496 & 6/28 Charity & $60.00 & $6.00 \\ \hline 497 & 6/29 Sports & $50.00 & $5.00 \\ \hline 498 & 6/29 Music & $120.00 & $12.00 \\ \hline 499 & 6/29 Music & $80.00 & $8.00 \\ \hline 500 & 6/30 Sports & $100.00 & $10.00 \\ \hline 501 & 6/30 Music & $40.00 & $4.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ A } \\ \hline 176 & 2/27 Charity & $20.00 & $2.00 \\ \hline 177 & 2/27 Sports & $100.00 & $10.00 \\ \hline 178 & 2/27 Sports & $50.00 & $5.00 \\ \hline 179 & 2/28 Charity & $40.00 & $4.00 \\ \hline 180 & 3/1 Charity & $40.00 & $4.00 \\ \hline 181 & 3/2 Sports & $100.00 & $10.00 \\ \hline 182 & 3/2 Food & $60.00 & $6.00 \\ \hline 183 & 3/2 Sports & $50.00 & $5.00 \\ \hline 184 & 3/2 Charity & $40.00 & $4.00 \\ \hline 185 & 3/3 Music & $40.00 & $4.00 \\ \hline 186 & 3/4 Sports & $100.00 & $10.00 \\ \hline 187 & 3/4 Food & $20.00 & $2.00 \\ \hline 188 & 3/4 Food & $20.00 & $2.00 \\ \hline 189 & 3/4 Food & $60.00 & $6.00 \\ \hline 190 & 3/4 Food & $40.00 & $4.00 \\ \hline 191 & 3/5 Charity & $40.00 & $4.00 \\ \hline 192 & 3/6 Art & $30.00 & $3.00 \\ \hline 193 & 3/6 Music & $40.00 & $4.00 \\ \hline 194 & 3/6 Art & $20.00 & $2.00 \\ \hline 195 & 3/6 Sports & $50.00 & $5.00 \\ \hline 196 & 3/7 Music & $120.00 & $12.00 \\ \hline 197 & 3/7 Food & $40.00 & $4.00 \\ \hline 198 & 3/7 Sports & $50.00 & $5.00 \\ \hline 199 & 3/8 Music & $120.00 & $12.00 \\ \hline 200 & 3/9 Food & $20.00 & $2.00 \\ \hline 201 & 3/9 Art & $20.00 & $2.00 \\ \hline 202 & 3/10 Charity & $40.00 & $4.00 \\ \hline 203 & 3/10 Art & $30.00 & $3.00 \\ \hline 204 & 3/10 Food & $60.00 & $6.00 \\ \hline 205 & 3/10 Food & $20.00 & $2.00 \\ \hline 206 & 3/10 Art & $20.00 & $2.00 \\ \hline 207 & 3/10 Charity & $60.00 & $6.00 \\ \hline 208 & 3/10 Music & $80.00 & $8.00 \\ \hline 209 & 3/10 Food & $40.00 & $4.00 \\ \hline 210 & 3/10 Charity & $60.00 & $6.00 \\ \hline \end{tabular} Segment Analysis Using Excel Completing this activity will help you learn to: 1. create pivot tables for aggregating data. 2. analyze data by different statistical calculations with pivot tables. 3. analyze data by using filters with pivot tables. Case scenario: You are working at a company that selis event tickets online, The company has five business segments: art, chanty, food, music, and sports. You would like to analyze the sales for the six months for each segment. Your task is to create a spreadsheet that summarizes and compares the five segments. Required: Download spreadsheet SegmentAnalysisCaseData-db1f69.xisx HINT: STEP-BY-STEP WALKTHROUGH Build a spreadsheet that can show only sales for each segment; calculate the sum and average of sales for each month; and then compare the segments, You will also apply filtering. 1. How many records of sales do we have for each segment? \begin{tabular}{|c|c|c|c|c|} \hline 4 & A & B & C & D \\ \hline 36 & 5/15 & Charity & $40.00 & $4.00 \\ \hline 77 & 5/15 & Music & $120.00 & $12.00 \\ \hline & 5/15 & Art & $10.00 & $1.00 \\ \hline & 5/15 & Charity & $60.00 & $6.00 \\ \hline & 5/15 & Charity & $20.00 & $2.00 \\ \hline & 5/15 & Music & $80.00 & $8.00 \\ \hline & 5/15 & Charity & $20.00 & $2.00 \\ \hline & 5/16 & Charity & $20.00 & $2.00 \\ \hline & 5/16 & Charity & $40.00 & $4.00 \\ \hline & 5/16 & Sports & $50.00 & $5.00 \\ \hline & 5/17 & Art & $30.00 & $3.00 \\ \hline & 5/18 & Sports & $100.00 & $10.00 \\ \hline & 5/18 & Charity & $60.00 & $6.00 \\ \hline & 5/19 & Sports & $100.00 & $10.00 \\ \hline & 5/19 & Sports & $50.00 & $5.00 \\ \hline & 5/19 & Charity & $20.00 & $2.00 \\ \hline & 5/20 & Food & $20.00 & $2.00 \\ \hline & 5/20 & Art & $10.00 & $1.00 \\ \hline & 5/20 & Music & $40.00 & $4.00 \\ \hline & 5/20 & Music & $80.00 & $8.00 \\ \hline & 5/20 & Charity & $60.00 & $6.00 \\ \hline & 5/21 & Food & $60.00 & $6.00 \\ \hline & 5/21 & Food & $20.00 & $2.00 \\ \hline & 5/21 & Art & $20.00 & $2.00 \\ \hline & 5/22 & Charity & $20.00 & $2.00 \\ \hline & 5/23 & Sports & $150.00 & $15.00 \\ \hline & 5/23 & Art & $10.00 & $1.00 \\ \hline & 5/24 & Sports & $50.00 & $5.00 \\ \hline & 5/24 & Food & $60.00 & $6.00 \\ \hline & 5/24 & Art & $20.00 & $2.00 \\ \hline & 5/25 & Food & $40,00 & $4.00 \\ \hline & 5/25 & Art & $10.00 & $1.00 \\ \hline & 5/26 & Sports & $100.00 & $10.00 \\ \hline & 5/26 & Art & $30.00 & $3.00 \\ \hline & 5/26 & Music & $120.00 & $12.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 106 & 2/6 Music & $40.00 & $4.00 \\ \hline 107 & 2/6 Sports & $100.00 & $10.00 \\ \hline 108 & 2/6 Sports & $150.00 & $15.00 \\ \hline 109 & 2/6 Charity & $60.00 & $6.00 \\ \hline 110 & 2/6 Food & $20.00 & $2.00 \\ \hline 111 & 2/7 Food & $40.00 & $4.00 \\ \hline 112 & 2/7 Sports & $150.00 & $15.00 \\ \hline 113 & 2/7 Sports & $150.00 & $15.00 \\ \hline 114 & 2/7 Food & $40.00 & $4.00 \\ \hline 115 & 2/7 Sports & $100.00 & $10.00 \\ \hline 116 & 2/8 Sports & $150.00 & $15.00 \\ \hline 117 & 2/9 Charity & $20.00 & $2.00 \\ \hline 118 & 2/9 Charity & $60.00 & $6.00 \\ \hline 119 & 2/9 Sports & $50.00 & $5.00 \\ \hline 120 & 2/9 Sports & $150.00 & $15.00 \\ \hline 121 & 2/9 Music & $120.00 & $12.00 \\ \hline 122 & 2/9 Sports & $150.00 & $15.00 \\ \hline 123 & 2/9 Music & $80.00 & $8.00 \\ \hline 124 & 2/10 Art & $30.00 & $3.00 \\ \hline 125 & 2/10 Charity & $60.00 & $6.00 \\ \hline 126 & 2/10 Charity & $40.00 & $4.00 \\ \hline 127 & 2/10 Food & $40.00 & $4.00 \\ \hline 128 & 2/10 Charity & $40.00 & $4.00 \\ \hline 129 & 2/10 Music & $80.00 & $8.00 \\ \hline 130 & 2/11 Music & $80.00 & $8.00 \\ \hline 131 & 2/11 Art & $30.00 & $3.00 \\ \hline 132 & 2/12 Charity & $20.00 & $2.00 \\ \hline 133 & 2/12 Sports & $100.00 & $10.00 \\ \hline 134 & 2/12 Art & $20.00 & $2.00 \\ \hline 135 & 2/13 Sports & $150.00 & $15.00 \\ \hline 136 & 2/13 Charity & $20.00 & $2.00 \\ \hline 137 & 2/13 Charity & $20.00 & $2.00 \\ \hline 138 & 2/14 Food & $60.00 & $6.00 \\ \hline 139 & 2/14 Music & $120.00 & $12.00 \\ \hline 140 & 2/15 Charity & $40.00 & $4.00 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c}{ D } \\ \hline 141 & 2/15 Art & $20.00 & $2.00 \\ \hline 142 & 2/15 Music & $80.00 & $8.00 \\ \hline 143 & 2/15 Art & $10.00 & $1.00 \\ \hline 144 & 2/16 Charity & $20.00 & $2.00 \\ \hline 145 & 2/16 Charity & $40.00 & $4.00 \\ \hline 146 & 2/16 Art & $10.00 & $1.00 \\ \hline 147 & 2/16 Food & $20.00 & $2.00 \\ \hline 148 & 2/18 Art & $10.00 & $1.00 \\ \hline 149 & 2/18 Charity & $40.00 & $4.00 \\ \hline 150 & 2/18 Charity & $60.00 & $6.00 \\ \hline 151 & 2/19 Food & $60.00 & $6.00 \\ \hline 152 & 2/19 Charity & $40.00 & $4.00 \\ \hline 153 & 2/19 Music & $120.00 & $12.00 \\ \hline 154 & 2/20 Art & $10.00 & $1.00 \\ \hline 155 & 2/20 Art & $20.00 & $2.00 \\ \hline 156 & 2/20 Art & $30.00 & $3.00 \\ \hline 157 & 2/20 Food & $60.00 & $6.00 \\ \hline 158 & 2/20 Art & $20.00 & $2.00 \\ \hline 159 & 2/21 Art & $10.00 & $1.00 \\ \hline 160 & 2/21 Sports & $150.00 & $15.00 \\ \hline 161 & 2/21 Food & $60.00 & $6.00 \\ \hline 162 & 2/21 Food & $40.00 & $4.00 \\ \hline 163 & 2/21 Art & $20.00 & $2.00 \\ \hline 164 & 2/21 Food & $40.00 & $4.00 \\ \hline 165 & 2/22 Sports & $150.00 & $15.00 \\ \hline 166 & 2/22 Food & $20.00 & $2.00 \\ \hline 167 & 2/23 Music & $120.00 & $12.00 \\ \hline 168 & 2/23 Art & $30.00 & $3.00 \\ \hline 169 & 2/24 Art & $10.00 & $1.00 \\ \hline 170 & 2/24 Art & $30.00 & $3.00 \\ \hline 171 & 2/24 Sports & $100.00 & $10.00 \\ \hline 172 & 2/24 Charity & $40.00 & $4.00 \\ \hline 173 & 2/25 Food & $40.00 & $4.00 \\ \hline 174 & 2/25 Charity & $20.00 & $2.00 \\ \hline 175 & 2/27 Music & $40.00 & $4.00 \\ \hline \end{tabular} 3. What is the average tax for each segment? Round your answers to the nearest cent. 4. Explain what can be accomplished by analyzing this segment data. \begin{tabular}{|c|c|c|c|c|} \hline & A & B & c & D \\ \hline 1 & Date & Segment & Sales & Tax \\ \hline 2 & 1/1 & Sports & $50.00 & $5.00 \\ \hline 3 & 1/1 & Art & $30.00 & $3.00 \\ \hline 4 & 1/2 & Art & $30.00 & $3.00 \\ \hline 5 & 1/3 & Art & $30.00 & $3.00 \\ \hline 6 & 1/3 & Charity & $20.00 & $2.00 \\ \hline 7 & 1/3 & Music & $120.00 & $12.00 \\ \hline 8 & 1/3 & Sports & $150.00 & $15.00 \\ \hline 9 & 1/3 & Music & $120.00 & $12.00 \\ \hline 10 & 1/3 & Music & $120.00 & $12.00 \\ \hline 11 & 1/4 & Charity & $20.00 & $2.00 \\ \hline 12 & 1/4 & Art & $30.00 & $3.00 \\ \hline 13 & 1/5 & Sports & $150.00 & $15.00 \\ \hline 14 & 1/5 & Food & $40.00 & $4.00 \\ \hline 15 & 1/6 & Sports & $100.00 & $10.00 \\ \hline 16 & 1/6 & Food & $20.00 & $2.00 \\ \hline 17 & 1/6 & Sports & $150.00 & $15.00 \\ \hline 18 & 1/6 & Art & $30.00 & $3.00 \\ \hline 19 & 1/7 & Music & $80.00 & $8.00 \\ \hline 20 & 1/7 & Sports & $100.00 & $10.00 \\ \hline 21 & 1/7 & Food & $40.00 & $4.00 \\ \hline 22 & 1/7 & Sports & $150.00 & $15.00 \\ \hline 23 & 1/7 & Sports & $50.00 & $5.00 \\ \hline 24 & 1/8 & Food & $40.00 & $4.00 \\ \hline 25 & 1/8 & Sports & $100.00 & $10.00 \\ \hline 26 & 1/9 & Charity & $40.00 & $4.00 \\ \hline 27 & 1/9 & Sports & $50.00 & $5.00 \\ \hline 28 & 1/10 & Sports & $100.00 & $10.00 \\ \hline 29 & 1/11 & Food & $60.00 & $6.00 \\ \hline 30 & 1/11 & Food & $20.00 & $2.00 \\ \hline 31 & 1/11 & Sports & $50.00 & $5.00 \\ \hline 32 & 1/12 & Charity & $20.00 & $2.00 \\ \hline 33 & 1/12 & Food & $40.00 & $4.00 \\ \hline 34 & 1/12 & Charity & $40.00 & $4.00 \\ \hline 35 & 13 & Art & $20.00 & $2.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 71 & 1/25 Charity & $40.00 & $4.00 \\ \hline 72 & 1/25 Music & $120.00 & $12.00 \\ \hline 74 & 1/26 Music & $120.00 & $12.00 \\ \hline 75 & 1/26 Sports & $150.00 & $15.00 \\ \hline 76 & 1/26 Art & $20.00 & $2.00 \\ \hline 77 & 1/27 Art & $20.00 & $2.00 \\ \hline 78 & 1/27 Food & $40.00 & $4.00 \\ \hline 79 & 1/28 Sports & $100.00 & $10.00 \\ \hline 80 & 1/28 Sports & $150.00 & $15.00 \\ \hline 81 & 1/28 Sports & $50.00 & $5.00 \\ \hline 82 & 1/28 Music & $40.00 & $4.00 \\ \hline 83 & 1/28 Food & $40.00 & $4.00 \\ \hline 84 & 1/29 Sports & $100.00 & $10.00 \\ \hline 85 & 1/29 Music & $120.00 & $12.00 \\ \hline 86 & 1/29 Music & $120.00 & $12.00 \\ \hline 87 & 1/29 Food & $20.00 & $2.00 \\ \hline 88 & 1/30 Food & $20.00 & $2.00 \\ \hline 89 & 1/30 Art & $20.00 & $2.00 \\ \hline 90 & 1/30 Art & $20.00 & $2.00 \\ \hline 91 & 1/31 Food & $20.00 & $2.00 \\ \hline 92 & 1/31 Sports & $50.00 & $5.00 \\ \hline 93 & 1/31 Sports & $50.00 & $5.00 \\ \hline 94 & 1/31 Sports & $100.00 & $10.00 \\ \hline 95 & 2/1 Food & $20.00 & $2.00 \\ \hline 96 & 2/1 Charity & $60.00 & $6.00 \\ \hline 97 & 2/1 Music & $80.00 & $8.00 \\ \hline 98 & 2/1 Art & $20.00 & $2.00 \\ \hline 99 & 2/2 Sports & $100.00 & $10.00 \\ \hline 100 & 2/3 Art & $20.00 & $2.00 \\ \hline 102 & 2/3 Sports & $150.00 & $15.00 \\ \hline 103 & 2/3 Charity & $20.00 & $2.00 \\ \hline 105 & 2/3 Art & $30.00 & $3.00 \\ \hline 14 & 2/4 Sports & $150.00 & $15.00 \\ \hline 2/4 Charity & $150.00 & $15.00 \\ \hline 120.00 & $2.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & A & B & C & D \\ \hline 456 & 6/13 & Music & $120.00 & $12.00 \\ \hline & 6/13 & Charity & $40.00 & 54.00 \\ \hline & 6/13 & Food & $40.00 & $4.00 \\ \hline & 6/14 & Sports & $100.00 & $10.00 \\ \hline 0 & 6/14 & Music & $120,00 & $12.00 \\ \hline 51 & 6/15 & Art & $10.00 & $1.00 \\ \hline 52 & 6/16 & Art & $20.00 & $2.00 \\ \hline 53 & 6/17 & Food & $60.00 & $600 \\ \hline 54 & 6/17 & Music & $40.00 & 54.00 \\ \hline 55 & 6/17 & Art & $10,00 & $1.00 \\ \hline 56 & 6/17 & Art & $20.00 & $2.00 \\ \hline 57 & 6/17 & Art & $10,00 & $100 \\ \hline 68 & 6/17 & Food & $20,90 & 5200 \\ \hline 69 & 6/18 & Sports & $100,00 & 5:000 \\ \hline 70 & 6/18 & Food & $60.00 & 3400 \\ \hline 71 & 6/18 & Sports & $10000 & $1000 \\ \hline 72 & 6/18 & Sports & $100.00 & 51000 \\ \hline 73 & 6/19 & Art & $10.00 & 5100 \\ \hline 74 & 6/19 & Charity & $40.00 & $4.00 \\ \hline 475 & 6/19 & Art & $30.00 & $3.00 \\ \hline 476 & 6/19 & Art & $30.00 & $3.00 \\ \hline 477 & 6/20 & Food & $60,00 & $6.00 \\ \hline 478 & 6/20 & Music & $80.00 & $8.00 \\ \hline 479 & 6/20 & Art & $20.00 & $2.00 \\ \hline 480 & 6/22 & Sports & $150.00 & $15.00 \\ \hline 481 & 6/23 & Sports & $100.00 & $10.00 \\ \hline 482 & 6/23 & Charity & $20.00 & $2.00 \\ \hline 483 & 6/24 & Charity & $20.00 & $2.00 \\ \hline 484 & 6/24 & Music & $40.00 & 54.00 \\ \hline 485 & 6/24 & Art & $30.00 & $3.00 \\ \hline 486 & 6/24 & Art & $30.00 & $3.00 \\ \hline 487 & 6/24 & Music & $40.00 & $4.00 \\ \hline 488 & 6/25 & Music & $120.00 & $12.00 \\ \hline 489 & 6/26 & Food & $40.00 & $4.00 \\ \hline 190 & 6/26 & Art & $10.00 & $1.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline 4 & A & B & C & D \\ \hline 281 & 4/9 & Sports & $150.00 & $15.00 \\ \hline 282 & 4/10 & Music & $120.00 & $12.00 \\ \hline 283 & 4/10 & Music & $80.00 & $8.00 \\ \hline 84 & 4/11 & Food & $20.00 & $2.00 \\ \hline 85 & 4/11 & Charity & $40.00 & $4.00 \\ \hline 86 & 4/11 & Art & $30.00 & $3.00 \\ \hline 287 & 4/12 & Art & $10.00 & $1.00 \\ \hline 88 & 4/12 & Music & $40.00 & $4.00 \\ \hline 39 & 4/12 & Sports & $50.00 & $5.00 \\ \hline 90 & 4/13 & Food & $60.00 & $6.00 \\ \hline 91 & 4/13 & Food & $60.00 & $6.00 \\ \hline 92 & 4/13 & Music & $40.00 & $4.00 \\ \hline 93 & 4/13 & Food & $20.00 & $2.00 \\ \hline 94 & 4/14 & Food & $40.00 & $4.00 \\ \hline 95 & 4/14 & Music & $40.00 & $4.00 \\ \hline 96 & 4/15 & Food & $20.00 & $2.00 \\ \hline 97 & 4/16 & Art & $30.00 & $3.00 \\ \hline 98 & 4/16 & Sports & $150.00 & $15.00 \\ \hline 99 & 4/16 & Sports & $50.00 & $5.00 \\ \hline 300 & 4/17 & Music & $80.00 & $8.00 \\ \hline 01 & 4/17 & Charity & $60.00 & $6.00 \\ \hline 02 & 4/17 & Food & $20.00 & $2.00 \\ \hline 03 & 4/18 & Sports & $150.00 & $15.00 \\ \hline 04 & 4/18 & Charity & $40.00 & $4.00 \\ \hline 05 & 4/18 & Food & $40.00 & $4.00 \\ \hline 06 & 4/19 & Music & $40.00 & $4.00 \\ \hline 07 & 4/19 & Sports & $50.00 & $5.00 \\ \hline 308 & 4/20 & Sports & $150.00 & $15.00 \\ \hline 09 & 4/20 & Art & $30.00 & $3.00 \\ \hline 10 & 4/20 & Sports & $150.00 & $15.00 \\ \hline 11 & 4/20 & Music & $120.00 & $12.00 \\ \hline 12 & 4/21 & Charity & $40.00 & $4.00 \\ \hline 13 & 4/21 & Art & $30.00 & $3.00 \\ \hline 14 & 4/21 & Music & $80.00 & $8.00 \\ \hline 15 & 4/21 & Art & $30.00 & $3.00 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|} \hline & \multicolumn{1}{|c}{ B } & \multicolumn{1}{c}{ C } & \multicolumn{1}{c|}{ D } \\ \hline 36 & 1/13 Art & $30.00 & $3.00 \\ \hline 37 & 1/13 Art & $30.00 & $3.00 \\ \hline 38 & 1/14 Music & $120.00 & $12.00 \\ \hline 39 & 1/14 Food & $20.00 & $2.00 \\ \hline 40 & 1/14 Sports & $50.00 & $5.00 \\ \hline 41 & 1/14 Music & $80.00 & $8.00 \\ \hline 42 & 1/15 Music & $80.00 & $8.00 \\ \hline 43 & 1/15 Music & $120.00 & $12.00 \\ \hline 44 & 1/15 Art & $30.00 & $3.00 \\ \hline 45 & 1/16 Food & $20.00 & $2.00 \\ \hline 46 & 1/16 Art & $30.00 & $3.00 \\ \hline 47 & 1/16 Art & $10.00 & $1.00 \\ \hline 48 & 1/17 Art & $30.00 & $3.00 \\ \hline 49 & 1/17 Music & $120.00 & $12.00 \\ \hline 50 & 1/17 Food & $60.00 & $6.00 \\ \hline 51 & 1/17 Food & $20.00 & $2.00 \\ \hline 52 & 1/18 Music & $40.00 & $4.00 \\ \hline 53 & 1/19 Sports & $150.00 & $15.00 \\ \hline 54 & 1/19 Art & $30.00 & $3.00 \\ \hline 55 & 1/19 Food & $40.00 & $4.00 \\ \hline 56 & 1/20 Food & $20.00 & $2.00 \\ \hline 57 & 1/20 Charity & $20.00 & $2.00 \\ \hline 58 & 1/20 Sports & $150.00 & $15.00 \\ \hline 59 & 1/20 Sports & $100.00 & $10.00 \\ \hline 60 & 1/20 Food & $40.00 & $4.00 \\ \hline 61 & 1/21 Charity & $60.00 & $6.00 \\ \hline 62 & 1/22 Sports & $50.00 & $5.00 \\ \hline 63 & 1/22 Charity & $60.00 & $6.00 \\ \hline 64 & 1/22 Food & $40.00 & $4.00 \\ \hline 65 & 1/22 Charity & $20.00 & $2.00 \\ \hline 66 & 1/23 Food & $20.00 & $2.00 \\ \hline 67 & 1/23 Charity & $20.00 & $2.00 \\ \hline 68 & 1/24 Food & $60.00 & $6.00 \\ \hline 69 & 1/24 Music & $80.00 & $8.00 \\ \hline 70 & 1/25 Food & $60.00 & $6.00 \\ \hline \end{tabular}