Excel 2007: Business Statistics
Offered By: LinkedIn Learning
Course Description
Overview
Unlock the power of your organization's data. Learn how to perform data analysis in Microsoft Excel.
Syllabus
Introduction
- Analyze your data effectively
- What you should know before starting
- Calculate mean and median values
- Measure maximums, minimums, and other data characteristics
- Analyze data using variance and standard deviation
- Introduce the central limit theorem
- Analyze a population using data samples
- Identify and minimize sources of error
- Challenge: Summarize and analyze business data
- Solution: Summarize and analyze business data
- Group data using histograms
- Identify relationships using XY scatter charts
- Visualize data using logarithmic scales
- Add trendlines to charts
- Forecast future results
- Calculate running averages
- Challenge: Summarize operational data visually
- Solution: Summarize operational data visually
- Formulate a hypothesis
- Interpret the results of your analysis
- Consider the limits of hypothesis testing
- Challenge: Formulate and test a hypothesis
- Solution: Formulate and test a hypothesis
- Use the normal distribution
- Use a uniform distribution
- Use the exponential distribution
- Use the Poisson distribution
- Use the binomial distribution
- Challenge: Model operational data using distributions
- Solution: Model operational data using distributions
- Visualize what covariance means
- Calculate covariance between two columns of data
- Calculate covariance among multiple pairs of columns
- Visualize what correlation means
- Calculate the correlation between two columns of data
- Calculate correlation among multiple pairs of columns
- Challenge: Calculate correlations between columns of data
- Solution: Calculate correlations between columns of data
- Calculate simple probabilities
- Calculate compound probabilities
- Calculate expected value
- Calculate permutations without duplication
- Calculate permutations with duplication
- Calculate combinations without duplication
- Calculate combinations with duplication
- Challenge: Calculate the expected value of a business scenario
- Solution: Calculate the expected value of a business scenario
- Introduce Bayesian analysis
- Analyze a sample problem: Kahneman’s Cabs
- Create a classification matrix
- Calculate Bayesian probabilities in Excel
- Challenge: Perform a Bayesian analysis
- Solution: Perform a Bayesian analysis
- Additional resources
Taught by
Curt Frye
Related Courses
Social Network AnalysisUniversity of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX