Class Details

Price: $1,850

Course Includes:

  • Class exercises in addition to training instruction
  • Courseware books, notepads, pens, highlighters and other materials
  • Full breakfast with variety of bagels, fruits, yogurt, doughnuts and juice
  • Tea, coffee, and soda available all day
  • Freshly baked cookies every afternoon - * only at participating locations

 

Get Your Group Trained for Less with Our Federal Training Dollars Savings Plan


Course Outline

Module 1: Excel for Data Analysis

Module 2: Cluster Analysis Part 1: Using K-Means to Segment Your Customer Base

Module 3: Naive Bayes

Module 4: Optimization Modeling

Module 5: Cluster Analysis Part 2: Network Graphs

Objectives

Upon successful completion of this course, participants will be able to do the following:

Use Excel to apply statistical techniques to the analysis of data

  • Use Microsoft Excel for data analysis and decision-making
  • Properly handle data collection from multiple sources and data retention in Excel
  • Integrate data from multiple sources
  • Summarize data to quickly gain a better understanding of it
  • Use advanced features in Excel to assist in complex problem-solving
  • Visualize data through Excel’s graphic functionality
  • Construct a frequency distribution to analyze data and translate it into relevant information
  • Calculate and select the most appropriate measures of central tendency
  • Identify and avoid the potential for hidden bias in expressing statistical findings