Multiple Regression Analysis with Excel | Data Science Online Course by Udemy

Development Online Course by Udemy, On Sale Here

Learn multiple regression analysis main concepts from basic to expert level through a practical course with Excel.

An excellent training about Data Science

Multiple Regression Analysis with Excel

Full Course Content Last Update 09/2019Learn multiple regression analysis through a practical course with Microsoft Excel using stocks, rates, prices and macroeconomic historical data. It explores main concepts from basic to expert level which can help you achieve better grades, develop your academic career, apply your knowledge at work or do your business forecasting research. All of this while exploring the wisdom of best academics and practitioners in the field. Become a Multiple Regression Analysis Expert in this Practical Course with ExcelDefine stocks dependent or explained variable and calculate its mean, standard deviation, skewness and kurtosis descriptive statistics. Outline rates, prices and macroeconomic independent or explanatory variables and calculate their descriptive statistics. Analyze multiple regression statistics output through coefficient of determination or R square, adjusted R square and regression standard error metrics. Examine multiple regression analysis of variance through regression, residuals and total degrees of freedom, sum of squares, mean square error, regression F statistic and regression p-value. Review multiple regression coefficients through their values, standard errors, t statistics and regression coefficients p-values. Evaluate regression correct specification through individual coefficients statistical significance and correct it through backward elimination stepwise regression. Assess regression no linear dependency through multicollinearity test and correct it through correct specification re-evaluation. Appraise regression correct functional form through Ramsey-RESET test and correct it through non-linear quadratic, logarithmic or reciprocal variables transformations. Evaluate residuals no autocorrelation through Breusch-Godfrey test and correct it by adding lagged dependent variable data as independent variables to original regression. Assess residuals homoscedasticity through White test and correct it through heteroscedasticity consistent standard errors estimation. Appraise residuals normality through Jarque-Bera test. Evaluate regression forecasting accuracy by comparing it with random walk and arithmetic mean benchmarks through mean absolute error, root mean square error and mean absolute percentage error metrics. Become a Multiple Regression Analysis Expert and Put Your Knowledge in PracticeLearning multiple regression analysis is indispensable for business data science applications in areas such as consumer analytics, finance, banking, health care, science, e-commerce and social media. It is also essential for academic careers in data science, applied statistics, economics, econometrics or quantitative finance. And it is necessary for any business forecasting research. But as learning curve can become steep as complexity grows, this course helps by leading you through step by step using stocks, rates, prices and macroeconomic historical data for multiple regression analysis to achieve greater effectiveness. Content and OverviewThis practical course contains 35 lectures and 4.5 hours of content. Its designed for all multiple regression analysis knowledge levels and a basic understanding of Microsoft Excel is useful but not required. At first, youll learn how to perform multiple regression analysis operations using built-in functions and array calculations. Next, youll learn how to do multiple linear regression calculation using Microsoft Excel Add-in. Then, youll define stocks dependent or explained variable. Next, youll define independent or explanatory variables through their rates, prices and macroeconomic areas. After that, youll calculate dependent and independent variables mean, standard deviation, skewness and kurtosis descriptive statistics. Next, youll analyze multiple regression statistics analysis through coefficient of determination or R square, adjusted R square and regression standard error metrics. Then, youll analyze multiple regression analysis of variance or ANOVA through regression, residuals and total degrees of freedom, sum of squares, mean square error, regression F statistic and regression p-value. Later, youll analyze multiple regression coefficient analysis through regression coefficients values, standard errors, t statistics and regression coefficients p-values. After that, youll evaluate multiple regression correct specification through coefficients individual statistical significance and correct it through backward elimination stepwise regression. Then, youll evaluate multiple regression independent variables no linear dependence through multicollinearity test and correct it through correct specification re-evaluation. Next, youll evaluate multiple regression correct functional form through Ramsey-RESET linearity test and correct it through non-linear quadratic, logarithmic and reciprocal transformations of variables. Later, youll evaluate multiple regression residuals no autocorrelation through Breusch-Godfrey test and correct it by including lagged dependent variable data as independent variables

Udemy is the leading global marketplace for learning and instruction

By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.

Study anytime, anywhere.

START HERE