BUSA 3110 Statistics for Business
(for sections taught by Kim Melton)

Excel 2010 Tutorials

(under development--This page will grow as more tutorials are established.  )

Topic & Link to Tutorial Data File Brief Description
Introductory Tutorials
Using Formulas, Functions, and Data AnalysisTools Tutor1Data This tutorial provides a summary of how to use formulas (including the use of relative and absolute cell references), introduces some of the functions in Excel, and provides instructions for accessing the Data Analysis Tools along with an example using the Descriptive Statistics option.
Bar Charts and Pie Charts GraphTutorData This tutorial provides guidance using Excel to create two charts that can be used for nominal or ordinal scale data.  Instructions and cautions are provided.
Run Charts GraphTutorData This tutorial provides instructions for creating a graph that gives insight into how data are changing over time (or over some other logically ordered characteristic).  Instructions and cautions are provided. In addition, some of the cautions related to the previous tools are illustrated using the Run Chart.
Scatter Diagrams GraphTutorData This tutorial provides instructions that create a graph showing the relationship between two quantitative variables and shows how to fit a staight line to the data (the line that would result from Simple Linear Regression).
Histograms GraphTutorData This tutorial provides a step-by-step process using Excel's Data Analysis Histogram tool as a starting point to gain insight into the distribution for a quantitative variable.  Examples are porvided where there are logical class breaks and where class breaks are not "driven" by the context of the situation.  Instructions and cautions are provided.
Using Excel to find probabilities from Normal and the t distributions none needed This tutorial illustrates how to use Excel to find probabilities from the Standard Normal Distribution (Z), from a Normal Distribution with a specified mean and standard deviation, and from the t distribution.  In addition, this tutorial shows how to find the Z, X, or t values associated with a given probability in the left or right tail of the distribution.
Regression Tutorials
There are five scenarios that are used to illustrate the different concepts.
The Regression Scenarios file describes these and should be read prior to any of these tutorials.
Obtaining Simple Linear Regression Output Reg1 This tutorial provides step-by-step instructions about how to use Excel 2010's Regression procedure in the Data Analysis tools to obtain output for Simple Linear Regression including Summary Output, the ANOVA table, the coefficients output, residuals and residual plots.  There is a BONUS sheet on the Excel file for this tutorial that includes annotations to the output describing what each value represents.
Obtaining Multiple Regression Output (basic) Reg 2 This tutorial provides step-by-step instructions about how to use Excel 2010's Regression procedure in the Data Analysis tools to obtain output for Multiple Linear Regression where there is more than one quantitative independent variable.  The output includes Summary Output, the ANOVA table, and the coefficients section.
Obtaining Multiple Regression Output (with qualitative variables) Reg3 This tutorial provides step-by-step instructions about how to use Excel 2010's Regression procedure in the Data Analysis tools to obtain output for Multiple Linear Regression where there are qualitative and quantitative independent variables.  The output includes Summary Output, the ANOVA table, and the coefficients section.
Obtaining Multiple Regression Output (with interaction) Reg4 This tutorial provides step-by-step instructions about how to use Excel 2010's Regression procedure in the Data Analysis tools to obtain output for Multiple Linear Regression where interaction is considered and there are qualitative and quantitative independent variables.  The output includes Summary Output, the ANOVA table, and the coefficients section.
Statistical Process Control Tutorials
Setting up Control Charts   none needed This tutorial provides instructions about how to use Excel 2010 to plot control charts with the zone lines for the Runs Tests.