Тёмный
Dr.V.Balamurugan
Dr.V.Balamurugan
Dr.V.Balamurugan
Подписаться
Data Analysis using MS Excel and SPSS

Email: baluvelu@gmail.com
+91-9659068305
CORRELATION   A Case Study
7:08
3 года назад
CORRELATION   Intro
7:39
3 года назад
Time Series   Price Data T x C x I
8:46
3 года назад
Time Series - Biological Data
11:59
3 года назад
Independent Two Sample t Test
6:06
3 года назад
ANOVA Hypothesis Testing
3:23
3 года назад
Hypothesis Testing
5:30
3 года назад
Time Series   Financial Data
12:49
3 года назад
Factors to Multiple Regression
8:00
3 года назад
Factor Analysis - A Case Study
13:07
3 года назад
Garrett Ranking Technique - Intro
3:39
4 года назад
Reliability and Validity Concept
5:12
4 года назад
Measurement & Test Scenarios   02
6:56
4 года назад
Measurement & Test Intro   01
12:03
4 года назад
Chi Square VBM Tamil
14:39
4 года назад
Комментарии
@arzookhan5528
@arzookhan5528 13 дней назад
I don't understand the alternate method
@shahanazshanu1853
@shahanazshanu1853 3 месяца назад
Excuse me sir . There is a correction in the equation of percent. It is 100*(1-0.5)/8= 6.25 You are typing wrong...its not "0.05" the value is incorrect 🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑
@onlinebusinessindia9870
@onlinebusinessindia9870 3 месяца назад
Yes
@pankajsidam2522
@pankajsidam2522 5 месяцев назад
Percent is 70 so which score should I get?
@agriculturalstudent3890
@agriculturalstudent3890 5 месяцев назад
Thankyou so much sir
@mdkaish95
@mdkaish95 6 месяцев назад
nice explain but sound is very low please improve it sir
@drsaif6274
@drsaif6274 7 месяцев назад
Your second method is not working. it shows negative value
@ishaeconomy1172
@ishaeconomy1172 11 месяцев назад
The presentation is very compact and clear, I have a doubt that I have 35 statements ,on which I have collected data on 5 point likart scale ordinal scale questionnaire
@dhirajpalve2175
@dhirajpalve2175 Год назад
Keep doing the work❤
@mrmd8808
@mrmd8808 Год назад
Very helpful sir, the way you explain is excellent Sir
@esmee8039
@esmee8039 Год назад
Thank you sir
@tuhinsikdar7228
@tuhinsikdar7228 Год назад
Can Rij value be anything? (Like 1-5 ) or it has to be same as the no. Of variable taken for ranking?????
@dr.v.balamurugan5857
@dr.v.balamurugan5857 Год назад
No of Variable upto 10
@nabakumardas1110
@nabakumardas1110 Год назад
Thank You sir for the video. In the formula its (100* ( 1-.50)/ Total rank. However in the excel you are using .05 in place of .50, let me know which is the correct one.
@dr.v.balamurugan5857
@dr.v.balamurugan5857 Год назад
You are right. (1 - 0.50)
@bangladeshimomkid9517
@bangladeshimomkid9517 2 года назад
I am from Bangladesh. Thank you so much Sir for this precious video.
@veerakoushik4192
@veerakoushik4192 2 года назад
Thanks sir. It helped me a lot
@katerinaaranitou1496
@katerinaaranitou1496 2 года назад
Great thanks !
@sherylmedrano8080
@sherylmedrano8080 2 года назад
thank you for this video tutorial sir! I learned a lot...God bless you!
@dr.v.balamurugan5857
@dr.v.balamurugan5857 2 года назад
Welcome
@balakalaid1870
@balakalaid1870 2 года назад
How to run a maximum and minimum values sir?
@manejibansode4862
@manejibansode4862 2 года назад
good
@onlinebusinessindia9870
@onlinebusinessindia9870 2 года назад
Welcome!
@jabezray6113
@jabezray6113 2 года назад
How to calculate minimum number and maximum number. The formula is not clear
@srajansingh
@srajansingh 2 года назад
Sir, Can you please tell me the reference(s) where it is written that Likert scale can be converted in Interval using this method? I am searching this for so long. I am unable to find it. I couldn't find any text where likert scale is added and converted into various categories. I saw this in your video so I am asking. Thank you so much.
@onlinebusinessindia9870
@onlinebusinessindia9870 2 года назад
Read blogs on Rensis Likert for developing this kind of scale, Karl Pear for reliability calculation and cronbach's Alpha
@srajansingh
@srajansingh 2 года назад
@@onlinebusinessindia9870 Thank you so much
@glenverlyalilang7708
@glenverlyalilang7708 2 года назад
THANKYOUUUUUUUU SIR!
@aristondemontelacimoncoraz4647
@aristondemontelacimoncoraz4647 2 года назад
can you recommend video tutorial on calculating cronbach's alpha or reliability index for individual question or item? thanks
@dr.v.balamurugan5857
@dr.v.balamurugan5857 2 года назад
No
@mallikamahendran4385
@mallikamahendran4385 2 года назад
Sir you didn't complete the problem. What about the multiplicative model final step
@mallikamahendran4385
@mallikamahendran4385 2 года назад
Thank you Sir for the detailed explanation
@mariahamante9612
@mariahamante9612 3 года назад
How can you improve if you get a negative figure of alpha?
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Do you have such data set?
@onlinethesiswork6719
@onlinethesiswork6719 3 года назад
Sir how I calculate standrd error value ? And significant non significant
@onlinethesiswork6719
@onlinethesiswork6719 3 года назад
Sir log function ki jagha Ln function ni le sakte kya ?
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Yes
@onlinethesiswork6719
@onlinethesiswork6719 3 года назад
@@dr.v.balamurugan5857 then cgr valu changed ?
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
@@onlinethesiswork6719 you are right
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
@@onlinethesiswork6719 call me 91-9659068305
@onlinethesiswork6719
@onlinethesiswork6719 3 года назад
Sir I want this excel sheet with formulas
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Mail to baluvelu@gmail.com
@sindhamsravanthi780
@sindhamsravanthi780 3 года назад
Sir this method is applied only for primary data.
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Yes. It's opinion based.
@2020-b1t
@2020-b1t 3 года назад
Sir, Thank you very much for sharing your knowledge. If I want to know more about this specific concept what should I search for? is there a book I can read to understand the basic concept (Multiple Response Analysis) and how it is applied in more detail? Thank you again.
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Appreciate your interest in learning more. MRA is based on categorical frequency concept. It does not involve with lengthy statistical calculation. You can analyse it easily with Microsoft Excel as shown in video. For more information browse it in Internet.
@noufalponnan
@noufalponnan 3 года назад
crystal clear explanation . Sir, u r a gem in analysis.
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Watch all videos and comment
@thezasvinikaruppaiah2216
@thezasvinikaruppaiah2216 3 года назад
Sir do you have the continuation video
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Yes. Please check my channel
@thezasvinikaruppaiah2216
@thezasvinikaruppaiah2216 3 года назад
@@dr.v.balamurugan5857 okay sir
@janechuu651
@janechuu651 3 года назад
hi! this is very helpful for my research. thank you so much!
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Glad it was helpful!
@gnanasubramaniamgnanachand9522
@gnanasubramaniamgnanachand9522 3 года назад
supper
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Welcome! Please subscribe and watch remaining videos.
@monikagadre9229
@monikagadre9229 3 года назад
Do we need to find out combined alpha also?
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Cronbach's Alpha is calculated for validity of extracted factors. Every factor has more than one variable.
@kethireddyabhilashreddy
@kethireddyabhilashreddy 3 года назад
It is very helpful video sir, and it helped me a lot as I'm learning this exercise for the first time. Thank you sir
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Welcome. Please subscribe and share it with your friends. Also watch videos on Factor Analysis manual calculation in this channel
@deepad812
@deepad812 3 года назад
Very useful in my preparation sir. Thank you
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
All the best. Please subscribe
@ahmed3820
@ahmed3820 3 года назад
Doctor, Your help please , i have a problem , some constructs are having AVE less than 0.5, i thought it is bcz i insert zero for the " not aaplicable- NA" in likert scale 🥺 Your opinion please 🙏🙏🙏🙏🙏
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Please contact 9659068305 baluvelu@gmail.com
@ahmed3820
@ahmed3820 3 года назад
How to treat the N/A in a likert scale , shall i assign zero for it ?!
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Five Point Scale may have SA A N DA SDA 5. 4 3 2 1 2. 1 0 -1 -2
@archanaa4109
@archanaa4109 3 года назад
It was very useful for my research sir, thank you for the video.
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Most welcome. For Data Analysis Support, Mailto baluvelu@gmail.com
@khushi_ki_aaknksha
@khushi_ki_aaknksha 3 года назад
Why o.5 is constant?? Why we not use 0.8 or 0.6 or 0.7 etc.
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
0.5 is a constant value and formula introduced by Psychologist Henry Garret. Will find video regarding this.
@monikagadre9229
@monikagadre9229 3 года назад
Is it mandatory to use SPSS for calculating Cronbach Alpha/ performing any other tests? (especially for PhD)
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
No. We need to calculate correctly either manually or with Excel Spread or SPSS. SPSS is menu-based, many features and easy to handle. For PhD we should cite the software used for Analysis. Every software has its own features.
@monikagadre9229
@monikagadre9229 3 года назад
Please also prepare a video on identifying the factors
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Madam, Please write to baluvelu@gmail.com
@monikagadre9229
@monikagadre9229 3 года назад
Your email id please
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
baluvelu@gmail.com
@monikagadre9229
@monikagadre9229 3 года назад
Request you to please prepare video which shows Factor Analysis in Excel with a case study
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Definitely Madam
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
KMO & Bartlettlet's Test of Sperisity Manual Calculation video uploaded
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Please watch another video also
@shankarnaagt.8112
@shankarnaagt.8112 3 года назад
Thank you sir for your quick reply. Really your videos are worthy. Can you provide your email id and contact number sir
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Email: baluvelu@gmail.com Whatsapp +260956095387
@shankarnaagt.8112
@shankarnaagt.8112 3 года назад
Sir kindly upload the full video
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Please watch second part also
@monikagadre9229
@monikagadre9229 3 года назад
Thanks a lot Sir... it helped me a lot. It was like a blessing and timely help for which I was looking for a long time.Very nicely explained with simple example.
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Madam, Thanks for your valuable feedback.
@jojget
@jojget 3 года назад
turn down the volume please, it hurts my ears
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
ok.
@ramgovind2118
@ramgovind2118 3 года назад
Sir can i use Likert scale without parametric test? For my college dissertation
@dr.v.balamurugan5857
@dr.v.balamurugan5857 3 года назад
Yes. For median test. But it depends on your objectives