How to do Regression Analysis in Excel? (Hindi) - Linear Regression Analysis in Hindi

How to do regression analysis in Excel? What is regression analysis and how to do it effectively? You will get a explanation about regression with various versions of excel in Hindi. You will learn linear regression analysis with dependent variable and independent variables.
Here is The Regression Analysis template with sample data. You can download it to practice along with the video. drive.google.c...
#Regression #RegressionAnalysis #OfficeGuru

[@OfficeGuruChannel]

Latest Back Office Jobs - All India: tapthe.link/xhev4Lgqd
Learn Basic Excel: ruclips.net/p/PLfnUj_KUudx7SA72DBVbnSNCkU2LPOoLb
Learn Basic MS Word: ruclips.net/p/PLfnUj_KUudx6I4f0DxgRDEkGqtjp7vmfJ

[@chiragunagar4570]

hello sir, why did you use X Value for the square?

[@NinjaNoj]

How to plot the graph

[@chiragunagar4570]

Hello sir, i'm trying to enable the data analysis tab but it's not showing on tab. what should i do so that i can activate it? i can enable solver tab but no data analysis.

[@shivamdwivedi7723]

Sir agar R square is like 0.16 then kaise pta lgega ki ye kitna fit hai data ...koi reference value hai kya ki kitne ke upar sahi hai like in T test alpha = 0.5 hota hai

[@sadiakhansadiakhan7860]

thank you sir nice lecture

[@namirashaikh1353]

Sir can you plz help me solve this using excel?
. Linear regression - . Model the data using linear regression y = w0 + w1xunder the assumption of Gaussian noise of zero mean and variance value σ2 = 2500.
(a) Use the model to predict the mean and variance of the value of the x = 40 claims.
(b) For the noise variance value σ
2 = 2500, calculate the posterior; assume no prior for the bias parameter w0, a Gaussian prior for the slope parameter w1 of mean µ0 = 3 and a fixed variance σ2 = 4.
(c) Calculate the posterior mean and variance for x = 40 claims
x y
108 392.5
19 46.2
13 15.7
124 422.2
40 119.4
57 170.9
23 56.9
14 77.5

[@fish-nature-lover]

Small thing huge explanation 😂

[@rohitgari9317]

You have taken wrong data ... independent and dependent are wrongnly taken

[@aakashranjan3992]

Please give me your email id, I have the data but not sure how to analyse it.

[@OfficeGuruChannel]

Unfortunately I cannot help on email. However you may upload the file on Google Drive and share link here. I would try to review.