Channel Avatar

DrJiang Jingze @UCDVBeMliFFGzxYavtZCIpuQ@youtube.com

1.7K subscribers - no pronouns :c

Hi, I am a Full Professor of Economics and Quantitative Anal


18:47
How to use Excel to exam model assumptions residual plot, residual order plot and standard residual
18:47
Diagnostics model assumptions
05:56
Diagnostics residual and residual plot
17:54
How to use Excel to calculate individual measures to centeral tendency, dispersion and 5 numbers
04:23
How to use Excel to create box whisker plot
04:08
How to use Excel to create box-whisker plot when there are outliers
05:31
What are the different type of data file formats
05:24
What are the different types of variables
18:38
What are the different types of data
07:43
What are the 3 types of business analytics technique
16:26
Business Analytics Introduction
10:57
How to Use Python to perform White and BP test and modify the OLS code to use HC standard errors
18:40
How to formulate the problem for the Transportation Case
14:07
How to formulate the problem for the Investment Case
13:30
How to use Excel Solver to solve the Investment Case
12:21
How to use Excel Solver to solve the Transportation Case
09:07
How to find alternative optimal solution
01:02
How to add Solver to your Excel
18:35
How to use Graph to identify the feasible area
13:00
How to form the problem for the linear optimization maximization problem
28:42
How to use Excel Solver to solve linear optimization maximization problem
16:53
How to use Excel Solver to solver linear optimization minimization problem
15:13
How to form the problem for linear optimization problem-Minimization problem
14:43
Identify decision variables objective function and constraints for linear optimization problem
16:23
How to graphically setup linear optimization problem
03:06
How to identify the DW test from your Python output based on Statsmodels package
08:46
How to use Python to run Regression
16:24
How to use Python to Calculate Correlation Matrix and VIF to detect multicollinearity
06:35
How to Use Excel to Perform Exponential Smoothing Forecasting
12:00
How to use Excel to estimate regression model: Double log, Intersection, Quadratic functional form
26:00
How to Use the Functional Form Template Jupyter Notebook for Excel Regression analysis
03:40
How to upload files to JupyterLab
14:42
How to use Excel to get results for Simple Linear Regression model and How to interpret Slope
19:33
How to use Excel to get results for Multiple Linear Regression model and How to interpret Bs
09:28
How to use Excel to fill in Dummy Variable Values
04:05
How to use Excel regression output to create residual plot
06:17
How to find pvalue for F test and setup 4 step for hypothesis testing of the regression model
06:31
How to find p value for t test and setup 4 step for hypothesis testing of significance of each X
06:29
How to find confidence interval of betas for hypothesis testing of significance of each X variable
07:45
How to use the regression model to forecast the Y value
05:50
How to find statistics measuring goodness of fit from Excel Output and how to interpret it
06:18
Addition Vdieo Use Excel to calculate mean median mode 1st quartile and IDQ one by one
06:10
How to use Excel to find outliers
12:31
How to use Excel to find numeric statistics to measure relationships between two quantiative variabl
05:31
How to use Excel to calculate mean starting salary by English Test Requirment
06:37
How to use Excel to calculate mean starting salary by Work Experience
10:57
How to Use Excel to get descriptive numeric statistics
07:43
How to read Boxplots chart?
08:43
What is quartiles and IQR?
09:09
How to use Excel to Create the Frequency, Percent Frequency, Culmulative and Culmulative Percent Fre
04:05
How to Use Excel to create the Pivot table that can show average or sum of a quantitative data
04:06
How to Use Excel to Create Crosstabulation to find relationship between 2 categorical data
05:43
How to Use Excel to Create Bar and Pie Chart
09:16
How to use Excel to Create the Frequency Distribution and Percent Frequency Distribution for Categor
04:48
How to use Excel to create the Pivottable that can show average max min sum of a quantitative data b
03:12
How to use Excel To Create the Histogram
07:07
How to Use Excel to Create Scatter Plot to find relationship between 2 quantitative data
02:34
How to Add Data Analysis and Solver Add-in to your Windows Excel
08:27
How to Start Anaconda and JupyterLab
09:47
How to Use Excel to create PivotTable to show group average, group min and group total