EasyStat: Digital Tutor for Microsoft Excel Complete Descriptions

Descriptions of EasyStat Tutorials:

Tutorial 1: Data Sets and Microsoft® Excel Worksheets

This tutorial provides an introduction to the use of Excel for statistical analysis. A data set containing information for 25 shadow stocks is used to show how data sets are organized in Excel worksheets and to illustrate how to hide rows in a large data set.

Tutorial 2: Inserting and Using Functions

This tutorial demonstrates how to enter statistical functions by typing a formula containing the function directly into the worksheet or by using the Insert Function dialog box to select and enter the function. A data set containing information for 25 shadow stocks is used to illustrate.

Tutorial 3: Frequency Distribution Using COUNTIF Function

This tutorial demonstrates how to construct a frequency distribution for qualitative data using the COUNTIF function. A data set involving soft drink preferences is used.

Tutorial 4: Bar Graph Using Chart Wizard

This tutorial demonstrates how construct a bar graph using Excel's Chart Wizard. A data set involving soft drink preferences is used.

Tutorial 5: Frequency Distribution Using FREQUENCY Function

This tutorial demonstrates how to construct a frequency distribution for quantitative data using the FREQUENCY function. A data set involving the time in days to complete year-end audits of 20 clients is used.

Tutorial 6: Histogram Using Chart Wizard

This tutorial demonstrates how to construct a histogram using Excel's Chart Wizard. A data set involving the time in days to complete year-end audits is used.

Tutorial 7: Crosstabulation Using PivotTable

This tutorial demonstrates how to summarize the data for two variables simultaneously using the PivotTable Report. A data set involving the quality rating and meal price for 300 restaurants is used.

Tutorial 8: Scatter Diagram Using Chart Wizard

This tutorial demonstrates how to construct a graphical presentation of the relationship between two variables using the Chart Wizard. A data set involving two variables, number of commercials and sales, is used.

Tutorial 9: Descriptive Statistics Using Functions

This tutorial demonstrates how descriptive statistics, such as the mean or standard deviation, can be computed using Excel's statistical functions. A data set consisting of monthly starting salaries for a sample of business school graduates is used.

Tutorial 10: Descriptive Statistics Tool

This tutorial demonstrates how to compute a variety of descriptive statistics at once using the Descriptive Statistics tool. A data set consisting of monthly starting salaries for a sample of business school graduates is used.

Tutorial 11: Computing Normal Probabilities

This tutorial demonstrates how to compute probabilities and z values for the standard normal distribution using the NORMSDIST and NORMSINV functions. The tutorial also shows how to compute probabilities and values for any normal probability distribution using the NORMDIST and NORMINV functions.

Tutorial 12: Selecting a Simple Random Sample

This tutorial demonstrates how to select a simple random sample from a population. The data set is a population of 100 U.S. and Canadian cities. A simple random sample of 30 cities is selected.

Tutorial 13: Confidence Interval Estimation of a Population Mean Using z

This tutorial demonstrates how to construct a confidence interval estimate of a population mean using the standard normal distribution. A data set involving monthly credit card balances for a sample of households is used.

Tutorial 14: Confidence Interval Estimation of a Population Mean Using t

This tutorial demonstrates how to construct a confidence interval estimate of a population mean using the t distribution. A data set involving the training time for a sample of employees is used.

Tutorial 15: Confidence Interval Estimation of a Population Proportion

This tutorial demonstrates how to construct a confidence interval estimate of a population proportion. A data set concerning golfer satisfaction with available tee times is used.

Tutorial 16: Hypothesis Test About a Population Mean Using z

This tutorial demonstrates how to conduct a hypothesis test about a population mean using the standard normal distribution. A data set involving the driving distance in yards for a sample of golf balls is used.

Tutorial 17: Hypothesis Test About a Population Mean Using t

This tutorial demonstrates how to conduct a hypothesis test about a population mean using the t distribution. A data set involving the ratings of London's Heathrow Airport provided by a sample of business travelers is used.

Tutorial 18: Hypothesis Test About a Population Proportion

This tutorial demonstrates how to conduct a hypothesis test about a population proportion. A data set involving the gender of a sample of golfers is used.

Tutorial 19: Analysis of Variance Using Single Factor Tool

This tutorial demonstrates how to conduct a hypothesis test about the difference between three or more population means using the ANOVA: Single Factor tool. A data set involving examination scores on a quality awareness exam for employees at three different plants is used.

Tutorial 20: Simple Linear Regression Using Chart Wizard

This tutorial demonstrates how to compute the estimated regression equation and the coefficient of determination for simple linear regression using the Chart Wizard. Sample data for restaurants located near college campuses is used to investigate the relationship between the size of the student population and quarterly sales.

Tutorial 21: Simple Linear Regression Using Regression Tool

This tutorial demonstrates how to perform a complete regression analysis, including statistical tests of significance, using the Regression Tool. Sample data for restaurants located near college campuses is used to investigate the relationship between the size of the student population and quarterly sales.

Tutorial 22: Multiple Regression Analysis Using Regression Tool

This tutorial demonstrates how to perform a complete multiple regression analysis using the Regression Tool. Sample data for a trucking company are used to investigate the relationship between two independent variables, miles traveled and number of deliveries, and a dependent variable, travel time.