Course Description
In these lessons, you’ll jump into the world of statistics by learning about linear and nonlinear regression. We’ll go over how Excel uses linear and nonlinear functions to do all the math for you, and how you can use such functions to create linear trendlines to illustrate any correlations within a data set.
Using Excel’s built-in functions for linear regression, you will learn how to access the data analysis section to perform linear regression to learn more about the results. You will also learn about strong and weak relationships and how to plot points that fall on a regression line.
What You'll Learn
- Distinguish between linear and nonlinear functions
- Use Excel's built-in functions to perform the math for linear and nonlinear regression
- Create linear trendlines to illustrate correlations within a data set
- Access Excel's data analysis section to run linear regression
- Run and interpret linear regression summaries
- Identify strong and weak relationships and plot points that fall on a regression line
Key Takeaways
- Excel uses linear and nonlinear functions to perform the regression math for you.
- Linear trendlines can be created in Excel to illustrate correlations within a data set.
- Excel's data analysis section can be used to perform linear regression and review the results.
- The course covers strong and weak relationships and how to plot points that fall on a regression line.
Frequently Asked Questions
What will I learn in this course?
You will learn the difference between linear and nonlinear functions, how to create a linear trendline, and how to run linear regression summaries, using Excel's built-in functions to do the math.
Which topics does this course cover?
The course covers linear and nonlinear functions, linear trendlines, and linear regression, including accessing Excel's data analysis section and understanding strong and weak relationships.
What skills does this course help me develop?
It helps you develop skills in simple linear regression, regression analysis, linear and nonlinear regression, linear models, and ordinary least squares (regression analysis).
How are the lessons structured?
The course is organized into three lessons: Linear and Non-Linear Functions, Linear Trendlines, and Linear Regression.
