Register Online - Add to Cart

Credits

Product ID: 406877EAU
 

Leveraging Excel for Decision Making and Data Analysis

OnDemand Webinar (87 minutes)

Learn how to utilize Excel® for data analysis including forecasting, regression functions, and more.Microsoft® Excel® is a great tool for creating spreadsheets. The key is how to interpret those numbers in that spreadsheet, and data analysis is a hidden gem in this program. This topic will provide information about data analysis, such as forecasting, rank and percentile, and regression functions. You will also learn about decision trees and how they can help move ideas and changes along. Another data analytic tool that is used across many corporations is Monte Carlo. This information will show what it is and how it is used.

Authors

Jill A. Trehearne, FatDAWGS.com

Agenda

Data Analysis

• What Is It?

• Why Do We Want to Know About It?

• A Look at Data Analysis Tool Pack

• Examples of Data Analysis Tool Use

- Forecasting

- Histogram

- Rank and Percentile

- Regression

Decision Trees

• What Is It?

• How Do We Do It?

• Examples of Decision Trees

Monte Carlo Simulation

• What Is a Random Number?

• Why Use Random Generation?

• Why Monte Carlo?

• Examples of How Monte Carlo Is Used