How To Perform Simple Linear Regression In Excel (HINDI)

#YOUCANLEARNECONOMICS
#ECONOMICS
I’m going to show you how you can perform a simple linear regression test by using Microsoft Excel.
After opening XLSTAT, select the XLSTAT / Modeling data / Regression command. Once you've clicked on the button, the Linear Regression dialogue box will appear.
Select the data on the Excel sheet the Dependent variable. The quantitative explanatory variable.
As the column header was selected for the variables, the Variable labels option needs to be activated.
The computations begin once you have clicked on OK.
Interpreting the results of a simple linear regression
The results will then be displayed. The first table displays the goodness of fit coefficients of the model. The R² (coefficient of determination) indicates the % of the variability of the dependent variable which is explained by the explanatory variables. The closer to 1 the R² is, the better the fit.
It is important to examine the results of the analysis of variance. The results enable us to determine whether or not the explanatory variables bring significant information (null hypothesis H0) to the model.
Subscribe me @ / ezclassesfaghsa
Like me on Facebook @ / faghsa
Follow me on Twitter @ ?lang=en
Mail ID: [e-mail]

[@ravianand151]

Shandar topic, liked before watching

[@EZClassesfaghsa]

Thanks for liking

[@hiteshkamboj]

Very good approach, Ma'am plz keep coming up with such videos analysing data with excel. Thnk for this video

[@EZClassesfaghsa]

I will try my best

[@aliakhtar_0807]

Great video, please keep coming up with such videos. Thank you, appreciate the effort.

[@EZClassesfaghsa]

More to come!