Math for Business Operations

Applied Accounting with Excel

UNIT04 - Lesson 3

Application Practice: Outliers & Descriptive Statistics

45 minutes
Lesson Overview

Lesson Focus

Identify outliers and compute key statistics using Analysis ToolPak

Key Unit Objectives

Enduring Understandings:

  • Data-driven decisions provide competitive advantages in business operations
  • Statistical analysis reveals patterns that guide inventory and staffing optimization
  • Forecasting models enable proactive business planning and risk management
  • Outlier identification prevents skewed analysis and faulty business conclusions

Lesson Activities

Activity 1: The Outlier Detective Challenge
8 minutes

Frame outlier identification as business detective work

Details:

  • Present scenario: Some weekend transactions seem unusually high or low
  • Question: Are these data errors or legitimate business insights?
  • Introduce z-score analysis as the statistical detective tool
  • Teams predict what outliers they might find in café data
Activity 2: Z-Score Analysis Instruction
17 minutes

Learn to identify outliers using statistical methods

Details:

  • Calculate z-scores for transaction amounts: z = (x - μ) / σ
  • Apply rule: |z| > 2 suggests potential outlier requiring investigation
  • Use Analysis ToolPak to compute descriptive statistics efficiently
  • Interpret results: mean, median, standard deviation in business context
Z-Score Business Interpretation

Z-scores reveal how unusual specific transactions are

  • Z > +2: Transaction is unusually high (large orders, special events)
  • Z < -2: Transaction is unusually low (refunds, errors, small orders)
  • |Z| < 2: Normal transaction within expected business range
  • Business context matters: Holiday rushes create legitimate outliers
Activity 3: Analysis ToolPak Practice
15 minutes

Hands-on statistical analysis of café transaction data

Details:

  • Teams use Analysis ToolPak Descriptive Statistics on their cleaned data
  • Calculate z-scores for transaction amounts and identify potential outliers
  • Investigate outliers: Are they errors or valid business events?
  • Document decisions about outlier treatment with business justification
Activity 4: Milestone 1 Assessment
5 minutes

Verify completion of data cleaning and outlier analysis

Details:

  • Teams demonstrate clean dataset with documented outlier analysis
  • Quick peer review using milestone criteria checklist
  • Preview Day 4: Building visualizations to reveal data patterns
Required Materials
  • Analysis ToolPak quick-start guide
  • Z-score calculation templates and examples
  • Outlier investigation worksheet
  • Milestone 1 assessment checklist
Differentiation Strategies

For Struggling Students

  • • Guided Analysis Templates: Step-by-step worksheets for statistical calculations
  • • Simplified Datasets: Smaller, cleaner data samples for initial practice
  • • Visual Learning Supports: Screencasts demonstrating Analysis ToolPak procedures
  • • Peer Mentoring: Partner with students strong in statistical analysis
  • • Alternative Presentations: Poster session format instead of elevator pitch

For Advanced Students

  • • Multiple Regression Models: Explore relationships between multiple variables
  • • Seasonal Trend Analysis: Investigate more complex time-based patterns
  • • Statistical Significance Testing: Apply t-tests and confidence intervals
  • • Advanced Visualization: Create interactive dashboards or animated charts
  • • Consulting Role: Support other teams while completing their own analysis

For English Language Learners

  • • Statistical Vocabulary Support: Bilingual glossary of key terms with examples
  • • Visual Communication Emphasis: Focus on charts and infographics over verbal presentations
  • • Collaborative Team Roles: Pair with native speakers for presentation support
  • • Template-Based Writing: Structured formats for analysis documentation and reflection