![BrunelASK](/img/default-banner.jpg)
- 125
- 11 020 250
BrunelASK
Registrace 3. 05. 2012
T-test and F-test in Excel using the Data Analysis Toolpak add-in
Excel isn't brilliant at running statistical tests, but the Data Analysis Toolpak add-in does make it a bit easier. If you don't have this add-in you'll need to add it in first.
zhlédnutí: 14 334
Video
Scatterplot with two y-axis in Excel
zhlédnutí 65KPřed 7 lety
It's pretty straight forward to make a scatterplot in Excel. But what if you want to plot 2 y-axis variables? In this video I show how to add a secondary y-axis to a scatterplot in Excel.
Create a chart of means for multiple groups on one graph with error bars
zhlédnutí 18KPřed 7 lety
Ever want to show several charts of means on one graph rather than have separate graphs? Excel doesn't make it easy! In this video I show you how to create a line chart of means and bar chart of means for multiple groups.
Excel: Sort data, compute average, stdev, SE and create a bar/line chart of means with error bars
zhlédnutí 2,2KPřed 7 lety
Excel: Sort data, compute average, stdev, SE and create a bar/line chart of means with error bars
Scatterplot with 2 x-axis variables in Excel
zhlédnutí 214KPřed 7 lety
Need to make a graph, but have two x-axis variables? In this video I show you how to plot a second x-axis variable on a scatterplot. For this to work though, both x-axis variables need to be the same units!
Regression in Excel using the Data Analysis Toolpak add-in
zhlédnutí 31KPřed 7 lety
Excel isn't brilliant at running statistical tests, but the Data Analysis Toolpak add-in does make it a bit easier. If you don't have this add-in you'll need to add it in first.
Format a series on a scatterplot in Excel
zhlédnutí 3,4KPřed 7 lety
Don't like Excel's default graph? Want to make it look more professional and/or personalise it? In this video I show how to format a graph using a scatterplot as the Example.
Chi-squared test and interpretation using SPSS (assumptions violated)
zhlédnutí 99KPřed 8 lety
A chi-squared test is preferred when correlating two categorical variables, one or both of which are nominal. This video shows how to compute a chi-squared test and how to interpret the output when assumptions have been violated. Please see the other chi-squared test video if assumptions have not been violated.
Reverse the coding of an ordinal variable in SPSS
zhlédnutí 9KPřed 8 lety
This example shows how to reverse code a likert scale question. This is useful when we have a mix of positively and negatively worded questions from a questionnaire and you need to test for reliability.
Reduce the number of groups of a categorical variable in SPSS
zhlédnutí 12KPřed 8 lety
This example shows how to reduce a 5pt likert scale to a 3pt likert scale by combining 'Strongly agree' with 'Agree' and combining 'Strongly disagree' with 'Disagree'. This is useful when we are mainly interested in whether or not people agree, disagree or have no opinion, but it's not important to know whether they strongly agree or strongly disagree.
Compute a total score from several variables in SPSS
zhlédnutí 90KPřed 8 lety
If you have 2 or more variables measuring the same factor or construct (often this happens in questionnaires), then you can combine them into one measure using a mean score or total score. This will create a new variable in your dataset. This new variable is what you will use for further analysis. This video shows how to compute a total score.
Compute a mean score from several variables in SPSS
zhlédnutí 304KPřed 8 lety
If you have 2 or more variables measuring the same factor or construct (often this happens in questionnaires), then you can combine them into one measure using a mean score or total score. This will create a new variable in your dataset. This new variable is what you will use for further analysis. This video shows how to compute a mean score.
Create dummy variables from an existing categorical variable in SPSS
zhlédnutí 22KPřed 8 lety
If you want to use a nominal or ordinal variable with 3 or more categories in linear regression you first need to dummy code the variable. This is because independent variables in linear regression must be either scale or dichotomous. Dichotomous just means the variable is categorical with only 2 categories (e.g., Male/Female, Yes/No, etc.)
Change the coding of a variable using 'Recode into same variable' in SPSS
zhlédnutí 42KPřed 8 lety
If you need to change the coding of a variable and prefer to replace the existing coding rather than create a new variable, use the 'Recode into same variable' option in SPSS. In this example I change the coding of Gender from 1=Male, 2=Female to 0=Male and 1=Female.
Recode a scale variable into categories in SPSS
zhlédnutí 12KPřed 8 lety
This example shows how to recode a scale variable (e.g. Age) into a categorical variable (e.g. Age groups).
Questionnaire data in SPSS - Open response question
zhlédnutí 18KPřed 8 lety
Questionnaire data in SPSS - Open response question
Questionnaire data in SPSS - Ranked response question
zhlédnutí 44KPřed 8 lety
Questionnaire data in SPSS - Ranked response question
Questionnaire data in SPSS - Multi-response question
zhlédnutí 8KPřed 8 lety
Questionnaire data in SPSS - Multi-response question
Code and define missing values in SPSS
zhlédnutí 146KPřed 8 lety
Code and define missing values in SPSS
SPSS: Understand Ordinal, Nominal & Scale (aka Level of measurment)
zhlédnutí 115KPřed 8 lety
SPSS: Understand Ordinal, Nominal & Scale (aka Level of measurment)
Questionnaire data in SPSS - Likert scale question
zhlédnutí 28KPřed 8 lety
Questionnaire data in SPSS - Likert scale question
Questionnaire data in SPSS - Single response question
zhlédnutí 6KPřed 8 lety
Questionnaire data in SPSS - Single response question
Enter data and define variables in SPSS
zhlédnutí 17KPřed 8 lety
Enter data and define variables in SPSS
Compute z-scores for variables using SPSS
zhlédnutí 2,4KPřed 8 lety
Compute z-scores for variables using SPSS
Interpret independent t-test output from SPSS
zhlédnutí 142KPřed 8 lety
Interpret independent t-test output from SPSS
Interpret paired t-test output from SPSS
zhlédnutí 11KPřed 8 lety
Interpret paired t-test output from SPSS
Repeated measures Clustered Bar or Line chart of means using SPSS (optional error bars)
zhlédnutí 5KPřed 8 lety
Repeated measures Clustered Bar or Line chart of means using SPSS (optional error bars)
How do I sum up these mean scores?
thank u so much!!! no other tutorial ive looked at explains this 😭😭😭😭😭😭 you saved my degree
Thank you very much for the appropriate information to give me!
Thank you for this video. It is very helpful. 💯
The first video about how to conect 2 paragraphs🐿✨️
Well done. Examples helped.
Nice❤
What if the dependent variable is more than 2?
My exact dilemma
Thank you! very helpful!
Never usually comment on YT videos but this saved me when writing my diss, thank you so much.
Thank you so much, Madam! You have cleared the confusion I had about independent samples t-test
Thank you
This is perfect and straight forward, Thanks so much
This is amazing! Thank you
Thank you. You saved me
This is a very well elaborated, clear, and helpful video. thank you!
God bless you
How about when it is exactly 20%? My Pearson's is not statistically significant while my Linear-by-Linear is.
Makalanga bring me here😂😂😂😂
Paying for college classes to end up having to teach myself from another person to learn something the irony…. Thank you very much for this video it helped me a lot.
Just wanted to say you are incredibly awesome for making this video! Over a decade later and you're still impacting others. Thank you so much!
my problem was solved with this simple and instructive explanation. thank you.
Great lesson. Thank you 😊
Thank you
the lock 🔒 is not changing it still remains there wha to do
thanks for violating the assumption. Found no such videos
Thnkuuuuuuuu
What a video! Really appreciate it
Thanks
Hello , can you help me…😭😭😭 my value is yes(1), no(0), do not know(0)… as you can see the value same so i cannot put (0) twice but this question about knowledge thats why im not doing it in likert scale, it is more to right and wrong answer. So how i need to do in the spss?😭😭😭
Can I get the reference for 0.5 alpha value if items lower than 10?
Thank you! Very helpful!
Thank you very much!!!!!
Very helpful thank you.
you saved my life thanks
Thank you so much! Your video was very straightforward and concise and you saved me a lot of time and effort <3
Thank Youuu
Seriously God made you for us we were on the edge of doing suicide due to pressue from our supervisor you saved us you deserve noble prize literally 11 years ago I would have never thought that you would have such a help I love you no no no my 4 friends also love you you are a true being thank you❤️😘😘❤️
Thanks for the quite explanatory video. Please, I do have a question: under item-total statistics, subsection "corrected item-total correlation, if item in the scale is a reverse of the construct, can the digit be lesser than 0.40?
Thank you for the video, it's very easy to follow. I have tried to use the same 'style' in my book 'From Data to Insights: A Beginner's Guide to Cross-Tabulation Analysis' which will be published in July (2024) with Routledge. Perhaps it might interest you. Regards.
and I'm here 10 years later!
Great job, more grease to your elbows.
i could kiss you on the mouth for this video
THANKS ALOT ....it was helpful
Thank You Soo Much Literally saved my Internship
So basically, if the 20% rule is violated, we take likelihood instead of pearson as the p-value?
So basically, if the 20% rule is violated, we take likelihood instead of pearson as the p-value?
what can I do if the 20% is violated?
By far one of the most easy to understand videos I've ever seen- think I learned more from this than the module I took!