BrunelASK
BrunelASK
  • Видео 125
  • Просмотров 10 923 231
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.
Просмотров: 14 256

Видео

Scatterplot with two y-axis in Excel
Просмотров 65 тыс.7 лет назад
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
Просмотров 18 тыс.7 лет назад
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
Просмотров 2,1 тыс.7 лет назад
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
Просмотров 214 тыс.7 лет назад
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
Просмотров 31 тыс.7 лет назад
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
Просмотров 3,4 тыс.7 лет назад
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)
Просмотров 96 тыс.8 лет назад
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
Просмотров 9 тыс.8 лет назад
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
Просмотров 12 тыс.8 лет назад
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
Просмотров 90 тыс.8 лет назад
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
Просмотров 303 тыс.8 лет назад
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
Просмотров 22 тыс.8 лет назад
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
Просмотров 41 тыс.8 лет назад
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
Просмотров 12 тыс.8 лет назад
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
Просмотров 18 тыс.8 лет назад
Questionnaire data in SPSS - Open response question
Questionnaire data in SPSS - Ranked response question
Просмотров 43 тыс.8 лет назад
Questionnaire data in SPSS - Ranked response question
Questionnaire data in SPSS - Multi-response question
Просмотров 8 тыс.8 лет назад
Questionnaire data in SPSS - Multi-response question
Code and define missing values in SPSS
Просмотров 145 тыс.8 лет назад
Code and define missing values in SPSS
Import data from Excel into SPSS
Просмотров 14 тыс.8 лет назад
Import data from Excel into SPSS
SPSS: Understand Ordinal, Nominal & Scale (aka Level of measurment)
Просмотров 114 тыс.8 лет назад
SPSS: Understand Ordinal, Nominal & Scale (aka Level of measurment)
Questionnaire data in SPSS - Likert scale question
Просмотров 28 тыс.8 лет назад
Questionnaire data in SPSS - Likert scale question
Questionnaire data in SPSS - Single response question
Просмотров 6 тыс.8 лет назад
Questionnaire data in SPSS - Single response question
Enter data and define variables in SPSS
Просмотров 17 тыс.8 лет назад
Enter data and define variables in SPSS
Compute z-scores for variables using SPSS
Просмотров 2,3 тыс.8 лет назад
Compute z-scores for variables using SPSS
Paired t-test using SPSS
Просмотров 4,6 тыс.8 лет назад
Paired t-test using SPSS
Interpret independent t-test output from SPSS
Просмотров 141 тыс.8 лет назад
Interpret independent t-test output from SPSS
Interpret paired t-test output from SPSS
Просмотров 11 тыс.8 лет назад
Interpret paired t-test output from SPSS
Independent t-test using SPSS
Просмотров 11 тыс.8 лет назад
Independent t-test using SPSS
Repeated measures Clustered Bar or Line chart of means using SPSS (optional error bars)
Просмотров 5 тыс.8 лет назад
Repeated measures Clustered Bar or Line chart of means using SPSS (optional error bars)

Комментарии

  • @riemorjang6296
    @riemorjang6296 3 дня назад

    Thank you. You saved me

  • @michaelotienookumu7367
    @michaelotienookumu7367 10 дней назад

    This is a very well elaborated, clear, and helpful video. thank you!

  • @foodiet7518
    @foodiet7518 14 дней назад

    God bless you

  • @bezahunasrat1335
    @bezahunasrat1335 15 дней назад

    How about when it is exactly 20%? My Pearson's is not statistically significant while my Linear-by-Linear is.

  • @simkangamodestus6109
    @simkangamodestus6109 15 дней назад

    Makalanga bring me here😂😂😂😂

  • @TheGamingPrivate
    @TheGamingPrivate 16 дней назад

    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.

  • @frostedtaylos
    @frostedtaylos 20 дней назад

    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!

  • @aliyazici1214
    @aliyazici1214 27 дней назад

    my problem was solved with this simple and instructive explanation. thank you.

  • @dengbolisbartalam3776
    @dengbolisbartalam3776 Месяц назад

    Great lesson. Thank you 😊

  • @namatovuhadiijah1226
    @namatovuhadiijah1226 Месяц назад

    Thank you

  • @husnainindustries9685
    @husnainindustries9685 Месяц назад

    the lock 🔒 is not changing it still remains there wha to do

  • @arundeepsingha5441
    @arundeepsingha5441 Месяц назад

    thanks for violating the assumption. Found no such videos

  • @MisbahKaleem-jq3ju
    @MisbahKaleem-jq3ju Месяц назад

    Thnkuuuuuuuu

  • @bchen4593
    @bchen4593 Месяц назад

    What a video! Really appreciate it

  • @saulthetaxidriver6100
    @saulthetaxidriver6100 Месяц назад

    Thanks

  • @sharkkkdudu7040
    @sharkkkdudu7040 Месяц назад

    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?😭😭😭

  • @bacillusanthracis69
    @bacillusanthracis69 Месяц назад

    Can I get the reference for 0.5 alpha value if items lower than 10?

  • @denisadoko4794
    @denisadoko4794 Месяц назад

    Thank you! Very helpful!

  • @johnkaimenyi9292
    @johnkaimenyi9292 Месяц назад

    Thank you very much!!!!!

  • @GF86123
    @GF86123 Месяц назад

    Very helpful thank you.

  • @stefannylopes5218
    @stefannylopes5218 Месяц назад

    you saved my life thanks

  • @suliatbello2307
    @suliatbello2307 Месяц назад

    Thank you so much! Your video was very straightforward and concise and you saved me a lot of time and effort <3

  • @sithuminijayasekara4782
    @sithuminijayasekara4782 Месяц назад

    Thank Youuu

  • @aminatariq8842
    @aminatariq8842 Месяц назад

    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❤️😘😘❤️

  • @omilabubukola8667
    @omilabubukola8667 Месяц назад

    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?

  • @nikeforo2612
    @nikeforo2612 2 месяца назад

    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.

  • @luciddream4892
    @luciddream4892 2 месяца назад

    and I'm here 10 years later!

  • @obngJUDE
    @obngJUDE 2 месяца назад

    Great job, more grease to your elbows.

  • @meganvanmilo
    @meganvanmilo 2 месяца назад

    i could kiss you on the mouth for this video

  • @eyobtesfaye4042
    @eyobtesfaye4042 2 месяца назад

    THANKS ALOT ....it was helpful

  • @johntony3757
    @johntony3757 2 месяца назад

    Thank You Soo Much Literally saved my Internship

  • @neptunians
    @neptunians 2 месяца назад

    So basically, if the 20% rule is violated, we take likelihood instead of pearson as the p-value?

  • @neptunians
    @neptunians 2 месяца назад

    So basically, if the 20% rule is violated, we take likelihood instead of pearson as the p-value?

  • @neptunians
    @neptunians 2 месяца назад

    what can I do if the 20% is violated?

  • @jacquelinekilkelly2076
    @jacquelinekilkelly2076 2 месяца назад

    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!

  • @EGHOSAAGBONLAHOR-bv9zw
    @EGHOSAAGBONLAHOR-bv9zw 2 месяца назад

    thank you so much

  • @AishaTahir-ll3dr
    @AishaTahir-ll3dr 3 месяца назад

    Mam ..I have a question ...why in the value of idf there is one box missing ..I've checked my all the data of this scale but all boxes are filled and I also do this idf inverse again but still one box is empty ..mam can u plzz guide me about it

  • @stevestuart3075
    @stevestuart3075 3 месяца назад

    Thank you that made it so much clearer

  • @deepaksingh-ut7lh
    @deepaksingh-ut7lh 3 месяца назад

    Thank u🎉

  • @jullisaregales6227
    @jullisaregales6227 3 месяца назад

    Thank you for making me graduate this year

  • @vivianemattos6142
    @vivianemattos6142 3 месяца назад

    Love your video. Thank you so much for sharing! So why would you calculate 4 different means? Is it necessary in a real analysis world?

  • @nahidhasan-ks6gh
    @nahidhasan-ks6gh 4 месяца назад

    Thank you so much

  • @williammuk886
    @williammuk886 4 месяца назад

    👍🏾🙏🏾

  • @OroojAzmi
    @OroojAzmi 4 месяца назад

    Can we use the chi-square test between an ordinal data type and a nominal data type?

  • @mujahidali3686
    @mujahidali3686 4 месяца назад

    Explanation was clear and example was also relavant

  • @simonefrancis5433
    @simonefrancis5433 5 месяцев назад

    Very helpful! Thank you

  • @sarasolomon7971
    @sarasolomon7971 5 месяцев назад

    Thanks so much for this video, it was really helpful. I had a question regarding coding answers that are inapplicable. In my survey, some people wrote their nationality rather than their ethnicity. Under another question, "what year are you in? (University)", I have a variety of answers that do not apply, like the year they were born, the year they expect to graduate, the study program etc. How would I begin to code and define these values? Should I just code all of them with "99" for example, and define them as missing? Would appreciate any help I can get :)

  • @user-bv8ug7xm5d
    @user-bv8ug7xm5d 6 месяцев назад

    hi dear Brunel, this an interesting lesson. but how laboratory based research raw data was interred and variables was defined in spss?????

  • @starry.nights9740
    @starry.nights9740 6 месяцев назад

    Thank you so much for this straightforward explanation

  • @dr.pallavi
    @dr.pallavi 6 месяцев назад

    How to calculate mean scores