![Dr.V.Balamurugan](/img/default-banner.jpg)
- Видео 30
- Просмотров 75 886
Dr.V.Balamurugan
Индия
Добавлен 22 фев 2020
Data Analysis using MS Excel and SPSS
Email: baluvelu@gmail.com
+91-9659068305
Email: baluvelu@gmail.com
+91-9659068305
Eigen Value & Cummunality Manual Calculation in Excel
This video shows how to calculate Eigen Value & Cummunality Manual Calculation in Excel
ruclips.net/video/c_lFDpoaoaw/видео.html
For Excel & SPSS Data Files: drive.google.com/drive/u/0/folders/1klxWk84pzpKWK21xvMYaeNmhJ4QOL7Xk
ruclips.net/video/c_lFDpoaoaw/видео.html
For Excel & SPSS Data Files: drive.google.com/drive/u/0/folders/1klxWk84pzpKWK21xvMYaeNmhJ4QOL7Xk
Просмотров: 1 423
Видео
Factor Score - Manual Calculation in Excel
Просмотров 3,9 тыс.3 года назад
This video demonstrates how to calculate factor score manually ruclips.net/video/AKAeBKOOBgI/видео.html Excel File: drive.google.com/drive/u/0/folders/1J-xFQy5hZzYCuBLxnbIflqsThGM1BHfX SPSS Data File: drive.google.com/drive/u/0/folders/1klxWk84pzpKWK21xvMYaeNmhJ4QOL7Xk
KMO & Bartlett's Test Sperisity Factor Aanalysis Manual Calculation
Просмотров 7 тыс.3 года назад
This video shows how to calculate KMO Sampling Adequacy Score and Bartlett's Test of Sperisity Manually. ruclips.net/video/LG4O2inf2BI/видео.html
CORRELATION A Case Study
Просмотров 2103 года назад
Correlation, Relationship, Linear, Non-linear, Curvilinear, Covariance, Z-Standardized Score ruclips.net/video/Jje1URpZEic/видео.html
CORRELATION Intro
Просмотров 483 года назад
Relationship between variables, linear and non-linear relationship, Correlation, Covariation ruclips.net/video/V-cf6Hm_w8c/видео.html
Time Series Price Analysis Seasonal Variation
Просмотров 1233 года назад
This video shows the analysis of Price Seasonal Variation. Time Series, Multiplicative Model, Moving Average, Purchase or Sales or Inventory Decision Making ruclips.net/video/tStY-a2BErM/видео.html
Time Series Price Data T x C x I
Просмотров 2573 года назад
The video shows how to analyze 20 years price data by using Multiplicative Model. Secular Trend, Cyclical Variation, Irregular Variation and seasonal variation
Time Series - Biological Data
Просмотров 1453 года назад
This video shows how to analyze Biological data in Time series Analysis. Semi-log, Exponential Function, Trend, Compound Growth Rate, Magnitude of Variability
Independent Two Sample t Test
Просмотров 553 года назад
Hypothesis Testing, Null Hypothesis and Alternative Hypothesis, Parameter and Test Statistics, students t Test, Independent Two Sample t Test, Paired t Test, ANOVA, Chi-square Test
ANOVA Hypothesis Testing
Просмотров 853 года назад
Hypothesis Testing, Null Hypothesis and Alternative Hypothesis, Parameter and Test Statistics, students t Test, Independent Two Sample t Test, Paired t Test, ANOVA, Chi-square Test
One Sample t Test - Hypothesis Testing
Просмотров 813 года назад
Hypothesis Testing, Null Hypothesis and Alternative Hypothesis, Parameter and Test Statistics, students t Test, Independent Two Sample t Test, Paired t Test, ANOVA, Chi-square Test
Hypothesis Testing
Просмотров 713 года назад
Hypothesis Testing, Null Hypothesis and Alternative Hypothesis, Parameter and Test Statistics, students t Test, Independent Two Sample t Test, Paired t Test, ANOVA, Chi-square Test
Time Series Financial Data
Просмотров 613 года назад
Time Series Financial Data ruclips.net/video/EY720bWJyHw/видео.html
Multiple Response Analysis in SPSS & MS Excel
Просмотров 11 тыс.3 года назад
Multiple Response Analysis in SPSS & MS Excel ruclips.net/video/_geSqM3m9Bk/видео.html
Factors to Multiple Regression
Просмотров 2693 года назад
The video shows how to perform Multiple Regression with Factor Loadings ruclips.net/video/12W7aGYLkDM/видео.html
How to increase Cronbach Alpha Value Reliability
Просмотров 25 тыс.3 года назад
How to increase Cronbach Alpha Value Reliability
Decision Making through Descriptive Statistics
Просмотров 3113 года назад
Decision Making through Descriptive Statistics
Garrett Ranking Technique - A Case Study
Просмотров 11 тыс.4 года назад
Garrett Ranking Technique - A Case Study
How is Likert Scale Data treated as Interval Data?
Просмотров 3,2 тыс.4 года назад
How is Likert Scale Data treated as Interval Data?
One Objective & Different Statistical Tools
Просмотров 2044 года назад
One Objective & Different Statistical Tools
Cronbach Alpha Manual Calculation with Factors in MS Excel
Просмотров 4,9 тыс.4 года назад
Cronbach Alpha Manual Calculation with Factors in MS Excel
Compare Means Paired t Test in SPSS Part 03
Просмотров 1044 года назад
Compare Means Paired t Test in SPSS Part 03
Compare Means t Test & F Test with Likert Scale Data Part 02
Просмотров 3,2 тыс.4 года назад
Compare Means t Test & F Test with Likert Scale Data Part 02
Compare Means - Intro - t Test & F Test In Part 01
Просмотров 1714 года назад
Compare Means - Intro - t Test & F Test In Part 01
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 🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑🛑
Yes
Percent is 70 so which score should I get?
Thankyou so much sir
nice explain but sound is very low please improve it sir
Your second method is not working. it shows negative value
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
Keep doing the work❤
Very helpful sir, the way you explain is excellent Sir
Thank you sir
Can Rij value be anything? (Like 1-5 ) or it has to be same as the no. Of variable taken for ranking?????
No of Variable upto 10
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.
You are right. (1 - 0.50)
I am from Bangladesh. Thank you so much Sir for this precious video.
Thanks sir. It helped me a lot
Great thanks !
thank you for this video tutorial sir! I learned a lot...God bless you!
Welcome
How to run a maximum and minimum values sir?
good
Welcome!
How to calculate minimum number and maximum number. The formula is not clear
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.
Read blogs on Rensis Likert for developing this kind of scale, Karl Pear for reliability calculation and cronbach's Alpha
@@onlinebusinessindia9870 Thank you so much
THANKYOUUUUUUUU SIR!
can you recommend video tutorial on calculating cronbach's alpha or reliability index for individual question or item? thanks
No
Sir you didn't complete the problem. What about the multiplicative model final step
Thank you Sir for the detailed explanation
How can you improve if you get a negative figure of alpha?
Do you have such data set?
Sir how I calculate standrd error value ? And significant non significant
Sir log function ki jagha Ln function ni le sakte kya ?
Yes
@@dr.v.balamurugan5857 then cgr valu changed ?
@@onlinethesiswork6719 you are right
@@onlinethesiswork6719 call me 91-9659068305
Sir I want this excel sheet with formulas
Mail to baluvelu@gmail.com
Sir this method is applied only for primary data.
Yes. It's opinion based.
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.
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.
crystal clear explanation . Sir, u r a gem in analysis.
Watch all videos and comment
Sir do you have the continuation video
Yes. Please check my channel
@@dr.v.balamurugan5857 okay sir
hi! this is very helpful for my research. thank you so much!
Glad it was helpful!
supper
Welcome! Please subscribe and watch remaining videos.
Do we need to find out combined alpha also?
Cronbach's Alpha is calculated for validity of extracted factors. Every factor has more than one variable.
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
Welcome. Please subscribe and share it with your friends. Also watch videos on Factor Analysis manual calculation in this channel
Very useful in my preparation sir. Thank you
All the best. Please subscribe
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 🙏🙏🙏🙏🙏
Please contact 9659068305 baluvelu@gmail.com
How to treat the N/A in a likert scale , shall i assign zero for it ?!
Five Point Scale may have SA A N DA SDA 5. 4 3 2 1 2. 1 0 -1 -2
It was very useful for my research sir, thank you for the video.
Most welcome. For Data Analysis Support, Mailto baluvelu@gmail.com
Why o.5 is constant?? Why we not use 0.8 or 0.6 or 0.7 etc.
0.5 is a constant value and formula introduced by Psychologist Henry Garret. Will find video regarding this.
Is it mandatory to use SPSS for calculating Cronbach Alpha/ performing any other tests? (especially for PhD)
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.
Please also prepare a video on identifying the factors
Madam, Please write to baluvelu@gmail.com
Your email id please
baluvelu@gmail.com
Request you to please prepare video which shows Factor Analysis in Excel with a case study
Definitely Madam
KMO & Bartlettlet's Test of Sperisity Manual Calculation video uploaded
Please watch another video also
Thank you sir for your quick reply. Really your videos are worthy. Can you provide your email id and contact number sir
Email: baluvelu@gmail.com Whatsapp +260956095387
Sir kindly upload the full video
Please watch second part also
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.
Madam, Thanks for your valuable feedback.
turn down the volume please, it hurts my ears
ok.
Sir can i use Likert scale without parametric test? For my college dissertation
Yes. For median test. But it depends on your objectives
Sir. Can i use rank for measuring satisfaction? 1 for Very satisfied 2 for Satisfied. 3 for not satisfied.?
Likert Five Point Scale is more appropriate. Please watch videos on Likert scale from my channel.
@@dr.v.balamurugan5857 OK. SIR