Business Statistics with Excel ON DEMAND
Available Until
Your Desk
2.0 Credits
Member Price $58.00
Non-Member Price $67.00
Overview
Statistics can be used in business to support better decision-making. In this course, we focus on simple statistical analyses that can be conducted with Microsoft Excel, and show the situations in which these analyses can be used. The topics covered in this course include data sampling, covariance and correlation, regression analysis, probability theory, nonprobability sampling, the confidence interval, and sales forecasting.
Highlights
Data analysis. Covariance and correlation. Variable forecasting options. Probability theory. Sampling techniques. The central limit theorem.
Prerequisites
None.
Designed For
CPAs, financial advisers, business management, and other accounting professionals.
Objectives
Identify the components needed for a statistical analysis. Specify the characteristics of the various charts used to describe data. Identify the characteristics of the coefficient of variation. Specify the characteristics of a binomial distribution. Identify the characteristics of a confidence interval, and describe how it is calculated. Recall how to calculate the different types of forecast options in Excel. Specify components of an Excel regression analysis report.
Preparation
None.
Notice
None.
Leader(s):
Leader Bios
Steven Bragg, Western CPE
Steven M. Bragg, CPA, is a full-time book and course author who has written more than 70 business books. He provides Western CPE with self-study courses in the areas of accounting and finance, with an emphasis on the practical application of accounting standards and management techniques. A sampling of his courses include the The New Controller Guidebook, The GAAP Guidebook, Accountants’ Guidebook, and Closing the Books: An Accountant’s Guide. He also manages the Accounting Best Practices podcast.
Steven has been the CFO or controller of both public and private companies and has been a consulting manager with Ernst & Young and an auditor with Deloitte & Touche. He holds an MBA from Babson College, a Master of Finance from Bentley College, and a BA from the University of Maine (summa cum laude).
Non-Member Price $67.00
Member Price $58.00