240 CenSARA Statistics Using Excel (9/30/2024 - 10/1/2024)

Information
Description
This 3 half day (8:30am - Noon) course is to prepare the student for future classes where you will need to have the knowledge of Excel and knowledge of the specific statistical functionality. The course puts heavy emphasis on the functions and tools in Excel that are used in Statistical Analysis. It has proven to meets students desires for a refresher course for statistics and for a builder of skills in Excel. Some students appear to gain Excel skills and other gain statistical skills; most have gained both.
Who Should Attend
Anyone wanting to use Excel Statistics
Leaning Objectives
Module 1: After completing this module, the student will be able to:
• Understand why Excel is useful as a statistical tool
• Define what is meant by a worksheet and a workbook
• Enter data into a worksheet
• Create formulas and solve problems with a worksheet using basic arithmetic functions
• Edit data that is in a worksheet
• Edit data by using right-click functions, copy with cross hairs, F4 key cell ($) modifiers

Module 2: After completing this module, the student will be able to:
• Use Excel to create common graphic presentations as pie chart, bar charts, simple histograms, line charts, and scatter plots.
• Edit and modify charts

Module 3: After completing this module, the student will be able to:
• Explain the characteristics and uses of measures of central tendency
• Explain the characteristics and uses of measures of dispersion
• Use Excel functions to calculate the arithmetic mean, median, mode, and standard deviations
• Use Excel’s Analysis ToolPak add-in to find measures of central tendency and dispersion

Module 4: After completing this module, the student will be able to:
• Define point estimate
• Define level of confidence
• Use Excel to calculate a confidence interval for a population when the sample size is 30 or larger

Module 5: After completing this module, the student will be able to:
• Explain linear regression
• Use Excel to draw a scatter diagram
• Use Excel to find a least squares regression line
• Use Excel and the least squares regress equation to predict the value of a dependent variable based on an independent variable

Module 6: After completing this module, the student will be able to:
• Explain lognormal distribution
• Use Excel Lognormal functions to create a lognormal distribution probability
Pre-Requisites
Excel Basics
Classroom Requirements
None
Syllabus
Pre-Test Form (28.32 KB)
Other Files
Day 1 Info (6.53 MB)
History of Changes
None
Dates
-
Location Address

9112 SW 24th St
73128 OK
United States

Map Address
Agenda
Travel Assistance Policy_0.pdf (391.24 KB)
Other Files
Procurement Manual_0.pdf (330 KB)
Class Capacity
30
Instructor1
CenSARA Admin
Instructor2
Contact Info
Phone : 61 3 8376 6284
Email : sanbro@gmail.com

Max Stoiber

Marketing Director

Peter Stumbles is a partner at Financial solutions based in the Sydney office. He is the head of the Asia-Pacific Financial Services practice and is also a leader in the Global Performance Improvement practice.

Education
BS, engineering, Technical University of Denmark
MBA, Rotterdam School of Management, Erasmus University
Drupal
80%
Wordpress
70%
Opencart
75%

Based in London, he is a business transformation expert and 25-year veteran at the firm, working with major corporate and private equity clients in Australia, Japan, China, Europe and North America. He is a leading contributor to Bain’s Results Delivery®, Organization, Consumer Products, Retail and Air Transportation & Services practices.

He joined Financial Solutions in London at graduate entry level in 1987. Prior to moving to Australia in 1991 with Bain, he spent two years in the UK in a senior sales and marketing role.

Peter was the managing partner of Bain’s Australian business between 1998 and 2005 followed by a two-year posting to Japan where he served as managing partner of Bain’s Tokyo office. From 2008 to 2013, he was in the role of regional managing director for Asia Pacific based out of Hong Kong.

Infuse your life with action. Don't wait for it to happen. Make it happen. Make your own future. Make your own hope. Make your own love. And whatever your beliefs, honor your creator, not by passively waiting for grace to come down from upon high, but by doing what you can to make grace happen... yourself, right now, right down here on Earth.