Scatter Plots and Correlation using Excel 

#businessanalytics #excel #regression
#statistics #analytics #businessanalyticscourse #businessanalytics #linearregression #regression #forecasting #binaryvariables #xlstat #excel #datanalysis
In this video, we will discuss creating a scatterplot and calculating correlation using Excel and Excel Data Analysis ToolPak. These tools are generally very helpful for linear regression.
The dataset used in this video can be downloaded here:
docs.google.co...
💻 Excel for Linear Regression
➡ Using Excel for Scatter Plots and Correlations: • Scatter Plots and Corr...
➡ Simple Linear Regression using Excel • Simple Linear Regressi...
➡ Multiple Linear Regression using Excel • Multiple Linear Regres...
👩‍🏫 Lecture Videos for Linear Regression
➡ Simple Linear Regression Part 1 • Simple Linear Regressi...
➡ Simple Linear Regression Part 2 • Simple Linear Regressi...
➡ Simple Linear Regression Model Diagnostics • Simple Linear Regressi...
➡ Multiple Linear Regression Part 1 • Multiple Linear Regres...
➡ Multiple Linear Regression Part 2 • Multiple Linear Regres...
➡ Regression with Categorical Independent Variables: • Regression with Catego...
👩‍🏫 Other Lecture Videos/Playlists
➡ For All Linear Regression videos: • Everything about Linea...
➡ For other Business Statistics videos: • Intro to Business Stat...
➡ Business Simulation (using @Risk): • Business Simulations
➡ Decision Analysis (using PrecisionTree): • Decision Analysis
➡ Linear Programming (using Lingo): • Linear Programming