Excel Analytics: Linear Regression Analysis in MS Excel

سرفصل های دوره

Linear Regression analysis in Excel. Analytics in Excel includes regression analysis, Goal seek and What-if analysis

01 - Introduction

001 Introduction

02 - Getting Data Ready for Regression Model

001 Gathering Business Knowledge

002 Data Exploration

003 Course resources.html

003 Excel-Analytics-Linear-Regression-Analysis-in-MS-Excel.zip

004 This is a milestone!

005 House-Price.csv

005 The Data and the Data Dictionary

006 Univariate analysis and EDD

007 Discriptive Data Analytics in Excel

008 Outlier Treatment

009 Identifying and Treating Outliers in Excel

010 Missing Value Imputation

011 Identifying and Treating missing values in Excel

012 Variable Transformation in Excel

013 Dummy variable creation Handling qualitative data

014 Dummy Variable Creation in Excel

015 Correlation Analysis

016 Creating Correlation Matrix in Excel

03 - Creating Regression Model

001 The Problem Statement

002 Basic Equations and Ordinary Least Squares (OLS) method

003 Assessing accuracy of predicted coefficients

004 Assessing Model Accuracy RSE and R squared

005 Creating Simple Linear Regression model

006 Multiple Linear Regression

007 The F - statistic

008 Interpreting results of Categorical variables

009 Creating Multiple Linear Regression model

010 Excel Running Linear Regression using Solver

04 - Optimizing business models - Case Studies

001 Introduction

002 Goal-seek and Scenario Manager in Excel

003 Solver in Excel

004 Different Solving methods of Excel Solver

005 Solving a Transportation problem

006 Price Skimming

007 Excel - Price Skimming model

008 Concept of Customer lifetime Value

009 Excel - Calculating customer lifetime value

05 - Bonus Section

001 Popular Excel charts.html

002 The final milestone!

003 Bonus Lecture.html

235,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy