2.4.1 Simple regression (based on scatter plot and Data Analysis Add-in)
I show how to obtain a regression line (slope and intercept) (a) using a scatter plot and adding a 'trend line', (b) using the mean, standard deviation and correlation of the two variables, and and (c) using the Data Analysis Add-in 'Regression'. Get files and further materials at https://github.com/aloisgeyer/data_analysis_excel
I show how to obtain a regression line (slope and intercept) (a) using a scatter plot and adding a 'trend line', (b) using the mean, standard deviation and correlation of the two variables, and and (c) using the Data Analysis Add-in 'Regression'. Get files and further materials at https://github.com/aloisgeyer/data_analysis_excel