Join Curt Frye for an in-depth discussion in this video Developing a multiple regression model, part of Excel 2007: Business Statistics.
In the previous movies in this chapter, I showed you how to have Excel use…linear regression to derive an equation used to project future values, and to…estimate how much of the value's variance was due to the data in your samples.…In this movie, I'll show you how to perform a similar analysis for multiple factors.…This technique is called multiple regression.…When you create your source data table, you need to have two regressors, and…those are the independent variables you want to use in the Regression formula to…derive the dependent variable.…Your two regressors--in this case Impressions, which is the number of times an…individual sees one of your company's ads, and Proximity which is the distance…in miles that a person lives from your store--…we want to see how these two factors when working together relate to the revenue…that you generate, or in other words the amount that you sold them.…
To perform multiple regression analysis, you use the Data Analysis tool, and…that is on the Data tab in the Analysis Group.…
Author
Released
12/8/2010- Understanding statistical terms
- Creating a basic Excel table
- Auditing formulas
- Creating frequency distributions for qualitative data
- Calculating a running total
- Creating a histogram
- Using PivotTables
- Calculating mean, median, mode, and other numerical data
- Using probability distributions
- Population sampling
- Testing hypotheses
- Developing liner and multiple regression models
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2007: Financial Analysis
with Curt Frye2h 18m Intermediate -
Creating Business Budgets in Excel 2007
with Curt Frye1h 3m Intermediate -
Excel 2007: Data Validation
with Dennis Taylor58m 31s Intermediate
-
Introduction
-
Welcome1m 22s
-
-
1. Introducing Statistics
-
Using statistics2m 25s
-
2. Learning Useful Excel Techniques
-
3. Summarizing Data Using Tables and Graphics
-
Creating a histogram2m 55s
-
4. Describing Data Using Numerical Methods
-
Calculating a moving average3m 10s
-
Calculating covariance5m 1s
-
Calculating correlation4m 11s
-
5. Using Probability Distributions
-
Generating random values4m 30s
-
6. Sampling Values from a Population
-
7. Testing Hypotheses
-
8. Using Linear and Multiple Regression
-
Conclusion
-
Additional Resources1m 3s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Developing a multiple regression model