Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. - Basic Excel Business Analytics #44: Intro To Linear Regression & Scatter Chart
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm
Learn:
1) (00:12) Introduction to Introduction to Linear Regression
2) (04:36) How to Create a Scatter Chart to Visually check to see if there is a relationship. This example we see a Direct or Positive Relationship.
3) (08:44) Show Trendline, Equation and R Squared on Chart
4) Create a Scatter Chart with a Negative / Indirect / Inverse Relationship
5) (12:18) Types of Relationships: Negative, Positive or No Relationship.
Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.