In one type of nonlinear regression, the function that summarizes the relationship between the variables is called logarithmic regression because the function includes the natural logarithm of the x-variable. This type of regression model is appropriate when x is compounded and y is additive (like the relationship between compound interest and simple interest). Discover how to use Excel to perform this analysis and expand your ability to make predictions.
- View Offline
- [Voiceover] Now I'll tell you about a kind of…nonlinear regression called logarithmic regression.…You use it when multiplicative change in X…results an additive change in Y.…As this happens in a variety of fields,…if you know how to use it.…You'll be a very versatile analyst.…For example, you start out with $100…and have compound interest on the X axis.…In other words you multiply each X by 1.10…to produce the next one.…And simple interest on the Y axis add .10 to each y…to produce the next one.…
The relationship X and Y is logarithmic.…The equation of logarithmic regression looks like this.…And as in any kind of regression analysis,…part of the objective is to find the values of A and B…that best fit the data.…Here's an application of athletics.…Researchers wanted to show that exercises…that build power in the legs and core,…rather than just strengthen the chest and arms…are important in shot putting.…What's a power exercise?…Well the one they studied was the power clean.…
In this move, you take a barbell from the floor…
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