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