Segment Analysis Using Excel

Completing this activity will help you learn to:

create pivot tables for aggregating data.

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 sells event tickets online. The company has five business segments: art, charity, food, music, and sports. You would like to analyze the sales for the six months for

task is to create a spreadsheet that summarizes and compares the five segments.

Required:

Download spreadsheet SegmentAnalysisCaseData$-$e$9$aea$0.$xlsx

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. 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.

How many records of sales do we have for each segment?

How much are total sales for each segment?

What is the average tax for each segment? Round your answers to the nearest cent.