Visão Geral

Curso Excel For Statistical Analysis, Este curso desenvolverá suas habilidades atuais do Excel, ensinando a usar as poderosas ferramentas do Excel para formatar estatísticas. O curso também irá guiá-lo na apresentação das melhores práticas dessas estatísticas e como analisá-las.

Publico Alvo

• Qualquer pessoa que atualmente usa o Excel em nível avançado e precisa usar as ferramentas do Excel para fazer análises estatísticas sobre os dados.

Pre-Requisitos

• Proficiência em Excel com comprovação de experiência em ferramentas do Básico ao Avançado. Conclua nosso Curso de Excel Básico a Avançado, caso contrário.

Materiais

Conteúdo Programatico

Introducing Excel Tables

1. Simple statistics
2. Sorting
3. AutoFilter
4. Custom AutoFilter
5. Advanced Filtering

Cleaning Data

1. Importing into Workbook
2. Move, copy, resize and delete columns and/or rows and/or sheets
3. Format cell contents
4. Clear formatting and cell contents
5. Find and Replace data
6. Cleaning Data with Text Functions
7. Conditional Formatting

Working with PivotTables

1. Running the PivotTable Wizard
2. Pivot Table Field Options (right click)
3. Pivot Table Design and Options

Building PivotTable Formulas

1. Adding Another Standard Calculation
2. Creating Custom Calculations
3. Using Calculated Fields and Items
4. Reviewing and changing solve order (new sheet)
5. Retrieving Data from a Pivot Table (new sheet)
6. Arguments of the GETPIVOTDATA function

Working with PivotCharts

1. Running the PivotChart Wizard
2. Filter data
3. Refresh data
4. Group data

Customizing Charts

1. Selecting a Chart Type
2. Working with Chart Styles
3. Changing Chart Layout
4. Changing a Chart’s Location
5. Formatting 3-D Charts

Ten Things You Ought to Know about Statistics

1. Descriptive Statistics Are Straightforward
2. Averages Aren’t So Simple Sometimes
3. Standard Deviations Describe Dispersion
4. An Observation Is an Observation
5. A Sample Is a Subset of Values
6. Inferential Statistics Are Cool but Complicated
7. Probability Distribution Functions Aren’t Always Confusing
8. Parameters Aren’t So Complicated
9. Skewness and Kurtosis Describe a Probability Distribution’s Shape
10. Confidence Intervals Seem Complicated at First, but Are Useful

Ten Tips for Presenting Table Results & Analyzing Data

1. Work Hard to Import Data
2. Design Information Systems to Produce Rich Data
3. Don’t Forget about Third-Party Sources
4. Just Add It
5. Always Explore Descriptive Statistics
6. Watch for Trends
7. Slicing and Dicing: Cross-Tabulation
8. Chart It, Baby
9. Be Aware of Inferential Statistics

Using the Statistics Functions

1. Counting Items in a Data Set
2. Means, Modes, and Medians
3. Finding Values, Ranks, and Percentiles
4. Standard Deviations and Variances
5. Normal Distributions

Using the Statistics Functions cont.

1. z-standard deviations
2. t-distributions
3. f-distributions
4. Binomial Distributions
5. Chi-Square Distributions
6. Regression Analysis
7. Correlation
8. Some Really Esoteric Probability Distributions

Descriptive Statistics

1. Using the Descriptive Statistics Tool
2. Creating a Histogram
3. Ranking by Percentile
4. Calculating Moving Averages
5. Exponential Smoothing

Inferential Statistics

1. Using the t-test Data Analysis Tool
2. Performing z-test Calculations
3. Creating a Scatter Plot
4. Using the Regression Data Analysis Tool
5. Using the Correlation Analysis Tool
6. Using the Covariance Analysis Tool
7. Using the ANOVA Data Analysis Tools
8. Creating an f-test Analysis
9. Using Fourier Analysis
10. Box and Whiskers Chart
11. Pareto Chart

Ten Tips for Visually Analyzing and Presenting Data

1. Using the Right Chart Type
2. Using Your Chart Message as the Chart Title
3. Beware of Pie Charts
4. Consider Using Pivot Charts for Small Data Sets
5. Avoiding 3-D Charts
6. Never Use 3-D Pie Charts
7. Be Aware of the Phantom Data Markers
8. Use Logarithmic Scaling
9. Don’t Forget to Experiment
10. Get Tufte