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.

Course Program:

• Understanding statistical terms
• Creating a basic Excel table
• Auditing formulas
• Creating frequency distributions for qualitative data
• Calculating a running total
• Creating a histogram
• Using PivotTables
• Calculating mean, median, mode, and other numerical data
• Using probability distributions
• Population sampling
• Testing hypotheses
• Developing liner and multiple regression models

Fees:

INR 15, 00 (assuming $ = INR 60)

Duration:

4 Hour 19 minutes

• Excel

• Curtis Frye