O'Reilly logo
live online training icon Live Online training

Excel Statistics for Business Analytics

Explore, visualize, and make inferences about data using spreadsheets

Topic: Data
George Mount

Inferential statistics involves inferring parameters of a population based on the values of a sample. Professionals in ecommerce, manufacturing, and other industries use inferential statistics as the basis for decision making.

Join expert George Mount for a hands-on approach to conducting statistical inference, conducted in Microsoft Excel. By the end of this course, users will be able to organize, present, and draw valid conclusions from data, using inferential statistics for business impact.

What you'll learn-and how you can apply it

By the end of this live online course, you’ll understand:

  • What variables are, and how to explore them given their type
  • How the central limit theorem provides the “missing link” between descriptive and inferential statistics
  • The roles statistics and visualizations each play in effective quantitative analysis

And you’ll be able to:

  • Explore a dataset for potential research questions, check assumptions, and build hypotheses
  • Test formally whether the value of one group is greater than another, on average, given their respective samples
  • Make compelling business recommendations using inferential statistics

This training course is for you because...

  • You want to apply more rigorous methods to your business decision making.
  • You’re an Excel user interested in learning more about data science.
  • You’re a researcher or analyst looking to apply statistical methods to business.

Prerequisites

  • A computer with the Excel Data Analysis ToolPak loaded (instructions)
  • Intermediate Excel skills (relative and absolute cell references, PivotTables, building bar and line charts, etc.)
  • No previous statistical knowledge required

Recommended preparation:

Recommended follow-up:

About your instructor

  • George Mount is an independent analyst and data analytics educator helping clients manage their data so they think more creatively. He’s a technical expert and lead curriculum developer for Thinkful’s Data Analytics program and the instructor of the DataCamp course Survey and Measure Development in R. George blogs about data, innovation, and career development at Georgejmount.com. He holds a master’s degree in information systems with a certificate of achievement in quantitative methods from Case Western Reserve University.

Schedule

The timeframes are only estimates and may vary according to how the class is progressing

Exploratory data analysis in Excel (50 minutes)

  • Presentation: What is a variable, and how do you measure it?; different types of variables, both quantitative and qualitative; how they’re used in business analytics; looking at a variable with visualizations; using histograms and box plots to paint a picture of a variable’s distribution; listening to a variable with descriptive statistics; using measures of central tendency and dispersion to explore the data statistically
  • Hands-on exercise: Identify and visualize variables in a real-world business dataset
  • Q&A

Break (10 minutes)

Foundations of inferential statistics (60 minutes)

  • Presentation: Intro to the Data Analysis ToolPak; loading and exploring the free Office plug-in for various statistical analyses; the central limit theorem—saved by the bell curve; demonstrating the central limit theorem’s role in providing valid inferences about a population, given a sample; What is a hypothesis, and how do you test it?; intro to hypothesis testing in statistical analysis; how to craft one; What is a t-test, and when do you use it?; the use case for an independent samples t-test; how to check for the necessary assumptions and preprocess the data
  • Hands-on exercise: Inspect and prepare a dataset to test
  • Q&A

Break (10 minutes)

T-tests for business impact (50 minutes)

  • Presentation: Evaluating for substantive and statistical significance; analyzing the p-value and confidence interval to make informed and well-rounded business decisions; presenting the results for management buy-in; preparing recommendations and visualizations to present before a general business audience
  • Hands-on exercises: Conduct a t-test using the Data Analysis ToolPak; visualize a t-test’s results
  • Q&A