Ch 2 Excel Labs Saved 4 Part 2 of 2 12.5 points eBook References Required information Lab 2.4 Alternate: Aggregating and Visualizing Different Data Types (LO 2-5) [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 2.4 to the Alt Lab 2.4 Data.xlsx dataset. The same scenario exists as before with the Sláinte brewery, only this time you are looking at the purchasing transactions (instead of sales). The raw materials that Sláinte orders are hops, barley, malt, wheat, and seasonal items. Required: 1. Create a pivot table and pivot chart to assess the sum of raw materials quantity purchased 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. Data: Alt Lab 2.4 Data.xlsx Analyze the Data: Alternate Labs don't have step-by-step instruction or video support. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab. Lab 2.4 Alternate: Assessment Questions Answer the following questions based on the details computed. Question 1. How many units of Hops were purchased in 2025? 2. Which product was purchased the most from suppliers in Minnesota (MN) in 2025? 3. How many units of Malt - Wheat were purchased from Arkansas suppliers in 2025? 4. How many units of Malt - Wheat were purchased from Washington (WA) suppliers in 2024? 5. How many units, total were purchased from Washington (WA) suppliers in 2025? Answer
Ch 2 Excel Labs Saved 4 Part 2 of 2 12.5 points eBook References Required information Lab 2.4 Alternate: Aggregating and Visualizing Different Data Types (LO 2-5) [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 2.4 to the Alt Lab 2.4 Data.xlsx dataset. The same scenario exists as before with the Sláinte brewery, only this time you are looking at the purchasing transactions (instead of sales). The raw materials that Sláinte orders are hops, barley, malt, wheat, and seasonal items. Required: 1. Create a pivot table and pivot chart to assess the sum of raw materials quantity purchased 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. Data: Alt Lab 2.4 Data.xlsx Analyze the Data: Alternate Labs don't have step-by-step instruction or video support. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab. Lab 2.4 Alternate: Assessment Questions Answer the following questions based on the details computed. Question 1. How many units of Hops were purchased in 2025? 2. Which product was purchased the most from suppliers in Minnesota (MN) in 2025? 3. How many units of Malt - Wheat were purchased from Arkansas suppliers in 2025? 4. How many units of Malt - Wheat were purchased from Washington (WA) suppliers in 2024? 5. How many units, total were purchased from Washington (WA) suppliers in 2025? Answer
Essentials Of Business Analytics
1st Edition
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Camm, Jeff.
Chapter6: Data Mining
Section: Chapter Questions
Problem 3P
Related questions
Question
![Ch 2 Excel Labs
Saved
4
Part 2 of 2
12.5
points
eBook
References
Required information
Lab 2.4 Alternate: Aggregating and Visualizing Different Data Types (LO 2-5)
[The following information applies to the questions displayed below.]
Lab Insight: Apply the same steps in Lab 2.4 to the Alt Lab 2.4 Data.xlsx dataset. The same scenario exists as before with
the Sláinte brewery, only this time you are looking at the purchasing transactions (instead of sales). The raw materials that
Sláinte orders are hops, barley, malt, wheat, and seasonal items.
Required:
1. Create a pivot table and pivot chart to assess the sum of raw materials quantity purchased 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.
Data: Alt Lab 2.4 Data.xlsx
Analyze the Data: Alternate Labs don't have step-by-step instruction or video support. Apply your experience from the
original lab. If needed, reference the text or eBook for instructions and steps from the original lab.
Lab 2.4 Alternate: Assessment Questions
Answer the following questions based on the details computed.
Question
1. How many units of Hops were purchased in 2025?
2. Which product was purchased the most from suppliers in Minnesota (MN) in 2025?
3. How many units of Malt - Wheat were purchased from Arkansas suppliers in 2025?
4. How many units of Malt - Wheat were purchased from Washington (WA) suppliers in 2024?
5. How many units, total were purchased from Washington (WA) suppliers in 2025?
Answer](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F50426ab2-38d4-4dc1-896f-4fe89bbdba74%2F181e1f3f-0af7-46e4-b73b-0423914505fb%2Ftv5wiq3_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Ch 2 Excel Labs
Saved
4
Part 2 of 2
12.5
points
eBook
References
Required information
Lab 2.4 Alternate: Aggregating and Visualizing Different Data Types (LO 2-5)
[The following information applies to the questions displayed below.]
Lab Insight: Apply the same steps in Lab 2.4 to the Alt Lab 2.4 Data.xlsx dataset. The same scenario exists as before with
the Sláinte brewery, only this time you are looking at the purchasing transactions (instead of sales). The raw materials that
Sláinte orders are hops, barley, malt, wheat, and seasonal items.
Required:
1. Create a pivot table and pivot chart to assess the sum of raw materials quantity purchased 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.
Data: Alt Lab 2.4 Data.xlsx
Analyze the Data: Alternate Labs don't have step-by-step instruction or video support. Apply your experience from the
original lab. If needed, reference the text or eBook for instructions and steps from the original lab.
Lab 2.4 Alternate: Assessment Questions
Answer the following questions based on the details computed.
Question
1. How many units of Hops were purchased in 2025?
2. Which product was purchased the most from suppliers in Minnesota (MN) in 2025?
3. How many units of Malt - Wheat were purchased from Arkansas suppliers in 2025?
4. How many units of Malt - Wheat were purchased from Washington (WA) suppliers in 2024?
5. How many units, total were purchased from Washington (WA) suppliers in 2025?
Answer
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Accounting Information Systems
Finance
ISBN:
9781337552127
Author:
Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:
Cengage Learning
