The Excel Analysis ToolPak Regression tool enables you to carry out multiple regression analysis. Joe shows you how to use this tool to find the regression coefficients and he shows you the meaning of all the features of the analysis output. Watch this video for a complete understanding of all the components of this important analytic tool.
- View Offline
- [Voiceover] Now let's look at the very useful multiple…regression, regression analysis that involves…more than one independent variable.…You can think of it as an extension of linear regression.…When do you use it?…If you can use more than one piece of information,…more than one x-variable, to make a prediction about y.…If you can, your predictions are typically more on target…than if you use only one piece of information.…Here's an example.…We're trying to model Miles Per Gallon…of 392 different automobiles from 1970 through 1982,…given information on six other variables.…
The Miles Per Gallon is in Column A.…Columns B through G hold Model Year, Weight, Cylinders,…Displacement, Horsepower, and Acceleration.…I define each column header as the name of the data array…in its column beginning with Row 1.…The data came from the Machine Learning Data Repository…of the University of California, Irvine.…The general equation for this multiple regression…is the first equation.…Or naming the variables, its the second.…
He explains how to organize and present data and how to draw conclusions using Excel's functions, charts, and 3D maps and the Solver and Analysis ToolPak add-ons. Learn to calculate mean, variance, standard deviation, and correlation; visualize sampling distributions; and test differences with analysis of variance (ANOVA). Then find out how to use linear, multiple, and nonlinear regression testing to analyze relationships between variables and make predictions. Joseph also shows how to perform advanced correlations, variable frequency testing, and simulations.
By the end of this course, you should have the foundational knowledge you need to take other statistics-related courses and perform basic analysis in the workplace.
- Using Excel's statistical functions and 3D charts
- Visualizing sampling distributions
- Performing comparisons with ANOVA
- Performing two-way analysis with ANOVA
- Analyzing linear regression
- Performing multiple regression and nonlinear regression analysis
- Making advanced correlations
- Testing variable frequencies
- Running simulations