Required information

Lab $2\mathrm{.}4$ Excel: Public, Private, and For$-$Profit Colleges $($LO $2-5)$

Skip to question

$[$The following information applies to the questions displayed below.$]$

Keywords: Pivot Chart, Slicer, Pie Chart, Bar Chart

Decision$-$Making Context: The Sl$$inte brewing company operates locally and distributes its beer across several states in the United States. In particular, it brews the following beers: Pale Ale, Imperial IPA, IPA, Imperial Stout, Stout, and Wheat. After the business analysis team at Sl$$inte has imported the relevant data into Excel, some preliminary analysis can be performed to visualize the data.

Access the text alternative for Lab $2-4$ Excel. Will open in a new tab or window. Internet connection required.

$-4$:$10$

$1$x

Required:

Create a pivot table and pivot chart to assess the sum of product quantity sold by year.

Create a slicer to interactively filter the pivot chart by state in which the products were sold.

Adjust the pivot chart to show horizontal bars.

Data: Lab $2\mathrm{.}4$ Data.xlsx

Specify the Question: How can we use pivot tables and pivot charts to explore different data types?

Obtain the Data: The dataset contains information about sales transactions with different customers. There are $132$ unique transactions but $149$ rows because some of the transactions included multiple products.

Analyze the Data: Refer to lab $2\mathrm{.}4$ in your text for additional instructions and steps.

Lab $2\mathrm{.}4$ Excel: Assessment Questions

Answer the following questions based on the details computed.

$1.$ how many imperial IPAs have sold $($grand total$)?$

$2.$ which product was the only product to sell in Lousina $($LA$)?$

$3.$ how many pale ales sold in nebreska $($NE$)($grand total$)?$

$4.$ how many different products $($ a count of the products$)$ sold in arkansas $($AR$)?$

$5.$ how many products sold overall $,$ across all products and all states?