Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel 2007: Business Statistics

via LinkedIn Learning

Overview

Shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques.

Excel 2007: Business Statistics with Curtis Frye shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques. The course covers important statistical terms and definitions, and then dives into techniques using the tools in Excel: formulas and functions for calculating averages and standard deviations, charts and graphs for summarizing data, and the Analysis ToolPak add-in for even greater insights into data. Exercise files are included with the course.

Syllabus

Introduction
  • Welcome
  • Using the exercise files
1. Introducing Statistics
  • Introducing statistical analysis
  • Understanding statistical terms
  • Using statistics
2. Learning Useful Excel Techniques
  • Creating and using an Excel table
  • Installing the Analysis ToolPak
  • Auditing formulas step by step
3. Summarizing Data Using Tables and Graphics
  • Creating frequency distributions for qualitative data
  • Summarizing data using bar graphs and pie charts
  • Creating a frequency distribution using the FREQUENCY function
  • Creating a histogram
  • Calculating a running total
  • Summarizing data using a PivotTable
4. Describing Data Using Numerical Methods
  • Calculating mean, median, and mode
  • Calculating a moving average
  • Calculating a seasonal forecast
  • Calculating percentiles and quartiles
  • Calculating variance and standard deviation
  • Summarizing data using descriptive statistics
  • Summarizing data using z-scores
  • Summarizing data using t-scores
  • Calculating covariance
  • Calculating correlation
  • Calculating correlations for more than two data sets
  • Calculating and interpreting chi-square values
5. Using Probability Distributions
  • Visualizing the normal data distribution
  • Generating random values
  • Calculating binomial probabilities
  • Calculating probabilities using the exponential distribution
  • Calculating values using the Poisson distribution
  • Calculating dependent trials using the hypergeometric distribution
  • Calculating probabilities, permutations, and combinations
6. Sampling Values from a Population
  • Selecting effective data samples
  • Inferring a population mean from a sample mean
  • Inferring population distributions based on a proportion of the data set
  • Estimating the size of a population given numbered samples
  • Calculating a confidence interval for a large sample
  • Calculating a confidence interval for a small sample using t-tests
  • Calculating a confidence interval given a population proportion
  • Calculating sample size required for a given confidence level
7. Testing Hypotheses
  • Defining hypotheses and identifying errors
  • Performing one-tailed tests on a large sample's mean
  • Performing two-tailed tests on a large sample's mean
  • Testing a small sample's mean
  • Testing the mean of a population proportion
  • Estimating the difference between two populations' means
  • Testing hypotheses related to population means
  • Inferring results from matched samples selected from two populations
  • Analyzing variance using an F-test
  • Analyzing variance using ANOVA
8. Using Linear and Multiple Regression
  • Creating a linear regression line for an XY (scatter) chart
  • Analyzing and interpreting data from the Regression tool
  • Estimating and predicting data using the regression formula
  • Developing a multiple regression model
Conclusion
  • Additional Resources

Taught by

Curt Frye

Related Courses

Reviews

Start your review of Excel 2007: Business Statistics

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free