Mupper AR WA WA 3 3 MN MN 7 3 3 0 WA MN MN MN AR MN 1 2 3 4 S 6 7 8 9 Purce_v_VPCEE wel veerude_cinpropee Mupper VuLLY_FUCIEU MRW_Midler_purchase_PICE raw_derd_werpuun 20500 11/1/19 1009 3 3 19.99 Malt. Barley 20501 11/5/19 1009 2 10 29 Hops 20502 11/10/19 1009 2 6 29 Hops 20503 11/13/19 1008 1 12 44.99 Malt Wheat 20504 11/16/19 1009 1 19.99 Malt-Barley 20505 11/19/19 1008 2 12 19.99 Malt-Barley 20505 11/23/19 1009 1 5 19.99 Malt-Barley 20506 11/23/19 1009 1 1 29 Hops 20507 11/26/19 1009 1 1 19.99 Malt. Harley 20508 11/29/19 1009 3 4 19.99 Malt-Barley 20509 12/4/19 1009 1 12 19.99 Malt-Barley 20510 12/9/19 1009 2 11 19.99 Malt-Barley 20511 12/12/19 1008 3 3 6 29 Hops 20512 12/16/19 1009 3 7 19.99 Malt. Barley 20513 12/19/19 1008 2 11 44.99 Malt - Wheat 20514 12/24/19 1009 3 11 44.99 Malt - Wheat 20515 12/28/19 1009 1 44.99 Malt - Wheat 20516 1/2/20 1008 1 11 29 Hops 20517 1/5/20 1009 2 10 19.99 Malt-Barley 20518 1/9/20 1009 1 12 29 Hops 20519 1/14/20 1008 2 1 19.99 Malt-Barley 20520 1/18/20 1008 1 12 29 Hops 20521 1/23/20 1008 3 6 19.99 Malt-Barley 20522 1/26/20 1009 2 10 44.99 Malt - Wheat 20523 1/31/20 1009 1 8 19.99 Malt-Barley 20524 2/4/20 1009 2 1 19.99 Malt-Barley 20525 2/8/201008 3 5 44.99 Malt - Wheat 20525 2/8/20 1009 3 2 44.99 Malt - Wheat 20525 2/8/20 1008 3 6 29 Hops 20526 2/13/20 1009 2 11 19.99 Malt-Barley 20527 2/16/20 1009 z 12 19.99 Malt-Barley 20527 2/16/20 1009 2 6 29 Hops 20528 2/21/20 1008 1 3 19.99 Malt-Barley 20529 2/24/20 1008 3 10 29 Hops 20530 2/28/20 1008 3 Z 19.99 Malt-Barley 20530 2/28/20 1009 3 2 29 Hops 20531 3/4/201008 3 7 29 Hops 20532 3/7/20 1008 1 z 44.99 Malt - Wheat 20533 3/12/20 1009 1 12 44.99 Malt-Wheat 20534 3/15/20 1008 2 5 44.99 Malt - Wheat 20535 3/19/20 1009 3 7 44.99 Malt - Wheat 20536 3/23/20 1009 2 12 19.99 Malt. Barley 20537 3/27/201008 2 6 6 29 Hops 20538 3/31/20 1009 5 44.99 Malt - Wheat 20539 4/4/201008 3 61 6 29 Hops 20540 4/8/20 1008 2 3 3 19.99 Malt-Barley 20541 4/11/20 1009 3 10 29 Hops 20541 4/11/20 1008 3 3 3 29 Hops 20542 4/14/20 1009 1 6 29 Hops 20542 4/14/20 1009 1 5 44.99 Malt Wheat 20543 4/18/20 1009 1 1 44.99 Malt - Wheat 20544 4/21/20 1008 2 2 4 44.99 Malt Wheat WA AR AR WA AR MN MN WA MN WA MN AR AR MN WA AR 0 1 2 3 4 5 6 7 8 9 O 1 2 3 4 5 6 7 8 _ Fayetteville Mabton Mabton Minneapolis Minneapolis Mabton Minneapolis Minneapolis Minneapolis Fayetteville Minneapolis Mabtor Fayetteville Fayetteville Mabton Fayetteville Minneapolis Minneapolis Mabton Minneapolis Mabton Minneapolis Fayetteville Fayetteville Minneapolis Mabton Fayetteville Fayetteville Fayetteville Mabton Mabton Mabton Minneapolis Fayetteville Fayetteville Fayetteville Fayetteville Minneapolis Minneapolis Mabton Fayetteville Mabton Mabton Minneapolis Fayetteville Mabton Fayetteville Fayetteville Minneapolis Minneapolis Minneapolis Mabton AR AR WA WA WA MN AR AR AR AR MN MN WA AR 9 0 WA 1 2 3 3 4 5 6 7 8 8 9 9 0 1 2 3 WA MN AR WA AR AR MN MN MN WA Required information [The following information applies to the questions displayed below.) NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Create a pivot table and pivot chart to assess the sum of raw materials quantity ordered by year. 2. Create a slicer to interactively filter the pivot chart by state from which the products were ordered. 3. Adjust the pivot chart to show horizontal bars. Ask the Question: How can we use pivot tables and pivot charts to explore different data types? Master the Data: Apply the same steps as Lab 3-4 to the Lab 3-4 Alt Data.xlsx dataset. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 3-4 Alt Data.xlsx. Perform the Analysis: Refer to Lab 3-4 Alternate in the text for instructions and Lab 3-4 steps for each of the lab parts. Share the Story: You have explored your data using pivot charts to see how visualizing data makes it easier to interpret and present to others. Part 1: Upload Your Files Part 2: Assessment supplier_st AR WA WA MN MN WA MN MN MN AR MN WA AR AR WA AR MN MN WA MN WA MN AR AR 1 Purchase_Order_ID Purchase Order Date Purchase_Employee_ID Supplier_ID Quantity_Purchased Raw_Material_Purchase_Price raw_materials_description 2 20500 11/1/19 1009 3 3 19.99 Malt-Barley 3 20501 11/5/19 1009 2 10 29 Hops 4 20502 11/10/19 1009 2 5 29 Hops 5 20503 11/13/19 1008 1 1 12 44.99 Malt - Wheat 6 20504 11/16/19 1009 1 4 19.99 Malt-Barley 7 2050S 11/19/19 1009 2 12 19.99 Malt Barley 8 20506 11/23/19 1009 1 5 19.99 Malt-Barley 9 20506 11/23/19 1009 1 1 29 Hop: 10 20507 11/26/19 1009 1 1 19.99 Malt-Barley 11 20508 11/29/19 1009 3 4 19.99 Malt-Barley 12 20509 12/4/19 1009 1 12 19.99 Malt-Barley 13 20510 12/9/19 1009 2 11 19.99 Malt-Barley 14 20511 12/12/19 1009 3 3 6 6 29 Haps 15 20512 12/16/19 1009 3 7 19.99 Malt-Barley 16 20513 12/19/19 100B 2 11 44.99 Malt-Wheat 17 20514 12/24/19 1009 3 11 44.99 Malt - Wheat 18 20515 12/28/19 1009 1 1 4 44.99 Malt - Wheat 19 20515 1/2/201008 1 11 29 Haps 20 20517 1/5/20 1009 2 10 19.99 Malt. Barley 21 20518 1/9/20 1009 1 1 12 29 Hops 22 20519 1/14/20 1000 2 1 19.99 Malt-Barley 23 20520 1/18/20 1008 1 12 29 Hops 24 20521 1/23/201008 3 5 19.99 Malt-Barley 25 20522 1/26/201009 3 10 44.99 Malt Wheat 26 20523 1/31/20 1009 1 9 19.99 Malt Barley 27 20524 2/4/20 1009 2 1 19.99 Malt-Barley 28 20525 2/8/201008 3 5 44.99 Malt-Wheat 29 20525 2/8/20 1009 3 2 44.99 Malt-Wheat 30 20525 2/8/201008 3 5 29 Hops 21 20525 2/13/20 1009 2 11 19.99 Malt Barley 22 20522 2/16/20 1009 12 19.99 Malt. Barley 33 20527 2/16/20 1009 2 6 29 Hops 34 20528 2/21/20 1008 1 19.99 Malt-Barley 35 20529 2/24/201008 3 10 29 Hops 36 20530 2/28/20 1008 3 2 19.99 Malt-Barley 97 20530 2/28/201009 3 3 2 29 Hops 39 20531 3/4/20 100g 3 2 29 Haps 39 20532 3/7/20 1009 1 2 44.99 Malt-Wheat 40 20533 3/12/20 1009 1 12 44.99 Malt - Wheat 41 20534 3/15/20 100 2 5 44.99 Malt-Wheat 42 20535 3/19/20 1009 3 7 44.99 Malt - Wheat 43 20586 3/28/20 1000 2 12 19.99 Malt-Barley 44 20537 3/27/20 1009 2 5 29 Haps 45 20539 3/31/20 1009 1 5 44.99 Malt-Wheat 46 20539 4/4/201008 3 6 29 Hops 47 20540 4/8/20 100B 2 3 19.99 Malt-Barley 48 20541 4/11/20 1009 3 10 29 Hops 49 20541 4/11/201008 3 3 29 Hops 50 20542 4/14/201009 1 29 Haps 51 20542 4/14/20 1009 1 5 44.99 Malt - Wheat 52 20543 4/18/20 1009 1 1 1 44.99 Malt Wheat 53 20544 4/21/20 1008 2 4 44.99 Malt - Wheat MN WA supplier_city Fayetteville Mabton Mabton Minneapolis Minneapolis Mahtan Minneapolis Minneapolis Minneapolis Fayetteville Minneapolis Mabtan Fayetteville Fayetteville Mabton Fayetteville Minneapolis Minneapolis Mabtan Minneapolis Mabton Minneapolis Fayetteville Fayetteville Minneapolis Matton Fayetteville Fayetteville Fayetteville Mahtan Mabtan Mabtan Minneapolis Fayetteville Fayetteville Fayetteville Fayetteville Minnespolis Minneapolis Mabton Fayetteville Mahtan Mabtan Minnespolis Fayetteville Mabton Fayetteville Fayetteville Minneapolis Minneapolis Minneapolis Mabton AR AR WA WA WA MN AR AR AR AR MN MN MN WA AR WA WA MN AR WA AR AR MN MN MN WA 54 Required: 1. Which product was purchased the most in 2019? O Barley O Hops O Wheat 2. Which product was purchased the most across both years? O Wheat O Barley O Hops 3. Which product was the most frequently purchased from Arkansas suppliers in 2019? O Wheat O Hops O Barley 4. Which product was the least frequently purchased from Minnesota in 2020? O Barley O Wheat O Hops 5. What was the grand total quantity of items purchased in 2020 (across all states and all products)? 0 77 O 116 39 Mupper AR WA WA 3 3 MN MN 7 3 3 0 WA MN MN MN AR MN 1 2 3 4 S 6 7 8 9 Purce_v_VPCEE wel veerude_cinpropee Mupper VuLLY_FUCIEU MRW_Midler_purchase_PICE raw_derd_werpuun 20500 11/1/19 1009 3 3 19.99 Malt. Barley 20501 11/5/19 1009 2 10 29 Hops 20502 11/10/19 1009 2 6 29 Hops 20503 11/13/19 1008 1 12 44.99 Malt Wheat 20504 11/16/19 1009 1 19.99 Malt-Barley 20505 11/19/19 1008 2 12 19.99 Malt-Barley 20505 11/23/19 1009 1 5 19.99 Malt-Barley 20506 11/23/19 1009 1 1 29 Hops 20507 11/26/19 1009 1 1 19.99 Malt. Harley 20508 11/29/19 1009 3 4 19.99 Malt-Barley 20509 12/4/19 1009 1 12 19.99 Malt-Barley 20510 12/9/19 1009 2 11 19.99 Malt-Barley 20511 12/12/19 1008 3 3 6 29 Hops 20512 12/16/19 1009 3 7 19.99 Malt. Barley 20513 12/19/19 1008 2 11 44.99 Malt - Wheat 20514 12/24/19 1009 3 11 44.99 Malt - Wheat 20515 12/28/19 1009 1 44.99 Malt - Wheat 20516 1/2/20 1008 1 11 29 Hops 20517 1/5/20 1009 2 10 19.99 Malt-Barley 20518 1/9/20 1009 1 12 29 Hops 20519 1/14/20 1008 2 1 19.99 Malt-Barley 20520 1/18/20 1008 1 12 29 Hops 20521 1/23/20 1008 3 6 19.99 Malt-Barley 20522 1/26/20 1009 2 10 44.99 Malt - Wheat 20523 1/31/20 1009 1 8 19.99 Malt-Barley 20524 2/4/20 1009 2 1 19.99 Malt-Barley 20525 2/8/201008 3 5 44.99 Malt - Wheat 20525 2/8/20 1009 3 2 44.99 Malt - Wheat 20525 2/8/20 1008 3 6 29 Hops 20526 2/13/20 1009 2 11 19.99 Malt-Barley 20527 2/16/20 1009 z 12 19.99 Malt-Barley 20527 2/16/20 1009 2 6 29 Hops 20528 2/21/20 1008 1 3 19.99 Malt-Barley 20529 2/24/20 1008 3 10 29 Hops 20530 2/28/20 1008 3 Z 19.99 Malt-Barley 20530 2/28/20 1009 3 2 29 Hops 20531 3/4/201008 3 7 29 Hops 20532 3/7/20 1008 1 z 44.99 Malt - Wheat 20533 3/12/20 1009 1 12 44.99 Malt-Wheat 20534 3/15/20 1008 2 5 44.99 Malt - Wheat 20535 3/19/20 1009 3 7 44.99 Malt - Wheat 20536 3/23/20 1009 2 12 19.99 Malt. Barley 20537 3/27/201008 2 6 6 29 Hops 20538 3/31/20 1009 5 44.99 Malt - Wheat 20539 4/4/201008 3 61 6 29 Hops 20540 4/8/20 1008 2 3 3 19.99 Malt-Barley 20541 4/11/20 1009 3 10 29 Hops 20541 4/11/20 1008 3 3 3 29 Hops 20542 4/14/20 1009 1 6 29 Hops 20542 4/14/20 1009 1 5 44.99 Malt Wheat 20543 4/18/20 1009 1 1 44.99 Malt - Wheat 20544 4/21/20 1008 2 2 4 44.99 Malt Wheat WA AR AR WA AR MN MN WA MN WA MN AR AR MN WA AR 0 1 2 3 4 5 6 7 8 9 O 1 2 3 4 5 6 7 8 _ Fayetteville Mabton Mabton Minneapolis Minneapolis Mabton Minneapolis Minneapolis Minneapolis Fayetteville Minneapolis Mabtor Fayetteville Fayetteville Mabton Fayetteville Minneapolis Minneapolis Mabton Minneapolis Mabton Minneapolis Fayetteville Fayetteville Minneapolis Mabton Fayetteville Fayetteville Fayetteville Mabton Mabton Mabton Minneapolis Fayetteville Fayetteville Fayetteville Fayetteville Minneapolis Minneapolis Mabton Fayetteville Mabton Mabton Minneapolis Fayetteville Mabton Fayetteville Fayetteville Minneapolis Minneapolis Minneapolis Mabton AR AR WA WA WA MN AR AR AR AR MN MN WA AR 9 0 WA 1 2 3 3 4 5 6 7 8 8 9 9 0 1 2 3 WA MN AR WA AR AR MN MN MN WA Required information [The following information applies to the questions displayed below.) NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab. In this lab, you will: Required: 1. Create a pivot table and pivot chart to assess the sum of raw materials quantity ordered by year. 2. Create a slicer to interactively filter the pivot chart by state from which the products were ordered. 3. Adjust the pivot chart to show horizontal bars. Ask the Question: How can we use pivot tables and pivot charts to explore different data types? Master the Data: Apply the same steps as Lab 3-4 to the Lab 3-4 Alt Data.xlsx dataset. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 3-4 Alt Data.xlsx. Perform the Analysis: Refer to Lab 3-4 Alternate in the text for instructions and Lab 3-4 steps for each of the lab parts. Share the Story: You have explored your data using pivot charts to see how visualizing data makes it easier to interpret and present to others. Part 1: Upload Your Files Part 2: Assessment supplier_st AR WA WA MN MN WA MN MN MN AR MN WA AR AR WA AR MN MN WA MN WA MN AR AR 1 Purchase_Order_ID Purchase Order Date Purchase_Employee_ID Supplier_ID Quantity_Purchased Raw_Material_Purchase_Price raw_materials_description 2 20500 11/1/19 1009 3 3 19.99 Malt-Barley 3 20501 11/5/19 1009 2 10 29 Hops 4 20502 11/10/19 1009 2 5 29 Hops 5 20503 11/13/19 1008 1 1 12 44.99 Malt - Wheat 6 20504 11/16/19 1009 1 4 19.99 Malt-Barley 7 2050S 11/19/19 1009 2 12 19.99 Malt Barley 8 20506 11/23/19 1009 1 5 19.99 Malt-Barley 9 20506 11/23/19 1009 1 1 29 Hop: 10 20507 11/26/19 1009 1 1 19.99 Malt-Barley 11 20508 11/29/19 1009 3 4 19.99 Malt-Barley 12 20509 12/4/19 1009 1 12 19.99 Malt-Barley 13 20510 12/9/19 1009 2 11 19.99 Malt-Barley 14 20511 12/12/19 1009 3 3 6 6 29 Haps 15 20512 12/16/19 1009 3 7 19.99 Malt-Barley 16 20513 12/19/19 100B 2 11 44.99 Malt-Wheat 17 20514 12/24/19 1009 3 11 44.99 Malt - Wheat 18 20515 12/28/19 1009 1 1 4 44.99 Malt - Wheat 19 20515 1/2/201008 1 11 29 Haps 20 20517 1/5/20 1009 2 10 19.99 Malt. Barley 21 20518 1/9/20 1009 1 1 12 29 Hops 22 20519 1/14/20 1000 2 1 19.99 Malt-Barley 23 20520 1/18/20 1008 1 12 29 Hops 24 20521 1/23/201008 3 5 19.99 Malt-Barley 25 20522 1/26/201009 3 10 44.99 Malt Wheat 26 20523 1/31/20 1009 1 9 19.99 Malt Barley 27 20524 2/4/20 1009 2 1 19.99 Malt-Barley 28 20525 2/8/201008 3 5 44.99 Malt-Wheat 29 20525 2/8/20 1009 3 2 44.99 Malt-Wheat 30 20525 2/8/201008 3 5 29 Hops 21 20525 2/13/20 1009 2 11 19.99 Malt Barley 22 20522 2/16/20 1009 12 19.99 Malt. Barley 33 20527 2/16/20 1009 2 6 29 Hops 34 20528 2/21/20 1008 1 19.99 Malt-Barley 35 20529 2/24/201008 3 10 29 Hops 36 20530 2/28/20 1008 3 2 19.99 Malt-Barley 97 20530 2/28/201009 3 3 2 29 Hops 39 20531 3/4/20 100g 3 2 29 Haps 39 20532 3/7/20 1009 1 2 44.99 Malt-Wheat 40 20533 3/12/20 1009 1 12 44.99 Malt - Wheat 41 20534 3/15/20 100 2 5 44.99 Malt-Wheat 42 20535 3/19/20 1009 3 7 44.99 Malt - Wheat 43 20586 3/28/20 1000 2 12 19.99 Malt-Barley 44 20537 3/27/20 1009 2 5 29 Haps 45 20539 3/31/20 1009 1 5 44.99 Malt-Wheat 46 20539 4/4/201008 3 6 29 Hops 47 20540 4/8/20 100B 2 3 19.99 Malt-Barley 48 20541 4/11/20 1009 3 10 29 Hops 49 20541 4/11/201008 3 3 29 Hops 50 20542 4/14/201009 1 29 Haps 51 20542 4/14/20 1009 1 5 44.99 Malt - Wheat 52 20543 4/18/20 1009 1 1 1 44.99 Malt Wheat 53 20544 4/21/20 1008 2 4 44.99 Malt - Wheat MN WA supplier_city Fayetteville Mabton Mabton Minneapolis Minneapolis Mahtan Minneapolis Minneapolis Minneapolis Fayetteville Minneapolis Mabtan Fayetteville Fayetteville Mabton Fayetteville Minneapolis Minneapolis Mabtan Minneapolis Mabton Minneapolis Fayetteville Fayetteville Minneapolis Matton Fayetteville Fayetteville Fayetteville Mahtan Mabtan Mabtan Minneapolis Fayetteville Fayetteville Fayetteville Fayetteville Minnespolis Minneapolis Mabton Fayetteville Mahtan Mabtan Minnespolis Fayetteville Mabton Fayetteville Fayetteville Minneapolis Minneapolis Minneapolis Mabton AR AR WA WA WA MN AR AR AR AR MN MN MN WA AR WA WA MN AR WA AR AR MN MN MN WA 54 Required: 1. Which product was purchased the most in 2019? O Barley O Hops O Wheat 2. Which product was purchased the most across both years? O Wheat O Barley O Hops 3. Which product was the most frequently purchased from Arkansas suppliers in 2019? O Wheat O Hops O Barley 4. Which product was the least frequently purchased from Minnesota in 2020? O Barley O Wheat O Hops 5. What was the grand total quantity of items purchased in 2020 (across all states and all products)? 0 77 O 116 39