Brandon Schamp
Brandon Schamp
  • 15
  • 466 111
Data Transformation and Linear Regression in SPSS
This is a short video explaining how to take bi-variate data (an X and Y variable), place them in the statistics program SPSS (version 21), and assess normality of the dependent variable, transform that variable to improve normality, and then run a linear regression analysis to test whether the dependent variable (Y) changes in a linear pattern with variation in the independent variable (X) and whether the slope of that relationship differs significantly from zero.
มุมมอง: 27 324

วีดีโอ

ANOVA in SPSS
มุมมอง 66510 ปีที่แล้ว
This is a short instructional video explaining how to take treatment data from a spreadsheet, place it in SPSS (version 21), and conduct an Analysis of Variance (ANOVA) to determine whether there are significant treatment effects. The video also explains how to implement Post-hoc tests to determine which pairs of treatments significantly differ.
ANCOVA in SPSS
มุมมอง 6K11 ปีที่แล้ว
This short video instructs students on how to use a general linear model approach to assess how well categorical and continuous variables predict variation in a numeric, continuous dependent variable. SPSS is the platform for this explanation.
Scatter Plot in Microsoft Excel
มุมมอง 73811 ปีที่แล้ว
This video explains how to produce a scatter plot in Microsoft Excel, which illustrates the relationship between two variables, for two separate groups. The video also explains how to go about changing elements of the graph to suit preferences.
Bar Plot in Excel
มุมมอง 1.4K11 ปีที่แล้ว
This is a short instructional video on how to make a bar chart in Microsoft Excel. Instructions include how to put error bars on your chart, and to make some basic changes in the graph
Test of normality and data transformation in SPSS
มุมมอง 182K13 ปีที่แล้ว
A short video demonstrating how to test whether a collection of data can be statistically distinguished from a sample drawn from a normal distribution. This test is carried out in SPSS. The video also shows the user how to log transform their data and then test whether this increases the degree to which these data approximate a sample from a normal distribution. Why do this? Well, a lot of comm...
Using If statements to calculate summary statistics in Excel
มุมมอง 3.1K13 ปีที่แล้ว
A short video on how to use If statements in Excel to quickly calculate summary statistics for a list of data with an irregular number of replicates.
Species Evenness Index Calculation (Evar) in Excel
มุมมอง 34K13 ปีที่แล้ว
A short instructional video illustrating how to calculate the Evar evenness index using vegetation plot data in Microsoft Excel
Transformation/Linear Regression in KyPlot (freeware)
มุมมอง 2K13 ปีที่แล้ว
A demonstration of how to transform a dependent variable to meet the normality requirements of linear regression analysis, and perform a linear regression, all using KyPlot, a freeware graphing and statistics program; Download KyPlot free here: www.pricelesswarehome.org/WoundedMoon/win32_freeware.html
Shannon-Wiener Diversity Index (In Excel)
มุมมอง 190K13 ปีที่แล้ว
Demonstration of how to calculate the Shannon-Wiener Diversity Index in Microsoft Excel
ANOVA in KyPlot (freeware)
มุมมอง 1.5K13 ปีที่แล้ว
A demonstration of how to do a Single Factor ANOVA using the freeware program KyPlot; Download KyPlot free here: www.pricelesswarehome.org/WoundedMoon/win32_freeware.html
Countif Function in Excel
มุมมอง 35413 ปีที่แล้ว
A demonstration of how to use the countif function in Microsoft Excel
Copy-Paste Special Transpose Values in Excel
มุมมอง 10K13 ปีที่แล้ว
Demonstration of how to use the copy-paste special function in Microsoft Excel to copy values and transpose paste them as values in another part of your spreadsheet.
Pivot Table Instructions for Excel
มุมมอง 89013 ปีที่แล้ว
Instructions on how to use a pivot table to rearrange data in Microsoft Excel.
Vlookup Instructions in Excel
มุมมอง 7K13 ปีที่แล้ว
A quick demonstration of how to use the vlookup function in Microsoft Excel

ความคิดเห็น

  • @ibriibri60
    @ibriibri60 4 หลายเดือนก่อน

    Nandri😊

  • @naturelover7040
    @naturelover7040 8 หลายเดือนก่อน

    Sir Can I contact with You??

    • @DrBSchamp
      @DrBSchamp 8 หลายเดือนก่อน

      sure, but keep in mind, I don't recommend the use of this index. :)

    • @naturelover7040
      @naturelover7040 8 หลายเดือนก่อน

      @DrBSchamp please I need your help regarding quantifying the spatial structure of forest by nearest neighbourhood method. Please can you help me in this regard

  • @mateohernandez8016
    @mateohernandez8016 ปีที่แล้ว

    Thanks a lot!

  • @umerabdela8984
    @umerabdela8984 ปีที่แล้ว

    good

  • @ProTech_2023
    @ProTech_2023 ปีที่แล้ว

    Suppose that, you transformed pretest data and the post test is already normally distributed, now to run the analysis, shall we transform the post test as well? Or we can use transformed pretest values and actual posttest value? I am confuse. Please help,

  • @ProTech_2023
    @ProTech_2023 ปีที่แล้ว

    After the transformation, the sig for sapiro wilk is still 0.03 which is less than 0.05, how can we agree the data are now normally distributed?

  • @walterakeyo9828
    @walterakeyo9828 ปีที่แล้ว

    Wouw!! Its wonderful

  • @TheRealIdyg
    @TheRealIdyg 2 ปีที่แล้ว

    your mic sucks bro

  • @Flaviamoetapele
    @Flaviamoetapele 2 ปีที่แล้ว

    Geez thank you!!!

  • @teiganroberts2297
    @teiganroberts2297 2 ปีที่แล้ว

    Thank you so much, this was very helpful.

  • @Hilu8D
    @Hilu8D 3 ปีที่แล้ว

    It was still useful! Thank you! :)

  • @cuteegirl114
    @cuteegirl114 3 ปีที่แล้ว

    Hi can you elaborate why we measure both shannon dominance index and shannon diversity index at a time to measure diversity.. Why we calculate both? Plz explain what's the difference between them

  • @noelmunda5387
    @noelmunda5387 3 ปีที่แล้ว

    Sir Brandon, what if the data are still not normal after having the transformation?

  • @welxadnum
    @welxadnum 3 ปีที่แล้ว

    Thank you, Sir Brandon.

  • @benojiryasmin9174
    @benojiryasmin9174 3 ปีที่แล้ว

    I can't say how much I helped from your work......🙏🙏🙏🙏🙏🙏 Lots of respect form India.

  • @benojiryasmin9174
    @benojiryasmin9174 3 ปีที่แล้ว

    👍

  • @jhusticemensah9566
    @jhusticemensah9566 3 ปีที่แล้ว

    Please how do I find overall Sharnon Weiner index

  • @theuniverse8937
    @theuniverse8937 3 ปีที่แล้ว

    Excellent!

  • @andreawiley8279
    @andreawiley8279 4 ปีที่แล้ว

    I've been trying to avoid QIIME/R to obtain this index for a microbiome dataset, and your explanation through this video was incredibly helpful! Thank you so much!

  • @judyuwa4583
    @judyuwa4583 4 ปีที่แล้ว

    Thank You!

  • @beverlyjaspe8365
    @beverlyjaspe8365 4 ปีที่แล้ว

    It would be better if you italicized the species names. Anyway, thank you so much for this 😊

  • @afaquehussain7678
    @afaquehussain7678 4 ปีที่แล้ว

    Qno.1 I have 3 dependent variables. Two of them are in range of normal skewness value i.e. +1 to -1 and have kurtosis in range of +3 to -3, but the third remaining dependent variable is not in normal range of skewnes or kurtosis. I want to transform that variable with square root transform to run parametric tests. So the question is, Can I transform that one variable only and run parametric test on the variables or I should transform all three variables before doing test? should I transform all three variables together even the two of them are already normally distributed? will it create problems to transform only one non normal variable? q.no.2 Can I infer and interpret my data for normality on the basis of skewness and kurtosis only rather than gooing for shapiro wilk test?

  • @faizimalik5520
    @faizimalik5520 4 ปีที่แล้ว

    Sir my data is not normally distributed now what to do to normal my data in SPSS?

  • @mma8836
    @mma8836 5 ปีที่แล้ว

    Oh my Goodness, you're teaching people a wrong information.. 0.012 is still non normality... You're so bad person

  • @immanuelhaokip
    @immanuelhaokip 5 ปีที่แล้ว

    it is very useful, thanks

  • @HealthbeautyluckyshahBlogspot
    @HealthbeautyluckyshahBlogspot 5 ปีที่แล้ว

    I have this unique problem whatever test I apply my skewness decreases to an acceptable range of less than 2 and kurtosis less than 7 but Shapiro walk test and Kolmogorov-Smirnov(test of normality) still comes as significant. can i do this like transform score and mention this range of skewness as test of normality than test of normality?

  • @liviatanjung6429
    @liviatanjung6429 5 ปีที่แล้ว

    Thank you for the video, Dr. Schamp. It's very well explained, short, clear, and very helpful.

  • @lindseylilly790
    @lindseylilly790 5 ปีที่แล้ว

    I am running a MANCOVA and have 4 dependent variable.. Do i need to transform all variables before running my test? or can i just transform the 2 that are needed to ?

  • @Nklecz1980
    @Nklecz1980 6 ปีที่แล้ว

    Hey Brandon you may already be a winner!

  • @RickyVWorld
    @RickyVWorld 6 ปีที่แล้ว

    Hey, at the start of the calculation, how comes you're using numbers like =ln(0.26), as in, how do you get 0.26 species? Where did those numbers come from that you started with in other words? I am doing mine and all mine are like 1, 6, 9, 2, 1 abundance... etc? Hope you understand the question, Thanks

  • @beamierjukkam.6291
    @beamierjukkam.6291 6 ปีที่แล้ว

    Thank you Brandon!

  • @mohammadalkurdi4460
    @mohammadalkurdi4460 6 ปีที่แล้ว

    when became variable negative need to log10 ?not result

  • @Urelob
    @Urelob 6 ปีที่แล้ว

    how would I go about doing this if I used percent cover for abundance?

  • @ishaui2416
    @ishaui2416 6 ปีที่แล้ว

    After the transformation, p-values were still below 0.05, why did then assume they are normal

    • @DrBSchamp
      @DrBSchamp 6 ปีที่แล้ว

      Yes, I added a comment to the video about that. It is true that the transformation did not alter the data so that it approximates a sample from a normal distribution. Sometimes it is not possible to normalize data by transformation, and sometimes a different transformation is needed.

  • @000sunita
    @000sunita 6 ปีที่แล้ว

    very helpful thanks

  • @claireel-jor4149
    @claireel-jor4149 6 ปีที่แล้ว

    My skewness and kurtosis values are between 1 and -1 but Shapiro-Wilk test and Kolmogorov-Smernov test are significant ... help?!

  • @iamavinaba
    @iamavinaba 6 ปีที่แล้ว

    Hi, Could please cite the resulting CLRM (regression equation) after the transformation is done

  • @ibrahimsaid28
    @ibrahimsaid28 6 ปีที่แล้ว

    could you please send me amended video in reply? 0.012 is still significant.

    • @DrBSchamp
      @DrBSchamp 6 ปีที่แล้ว

      If you read the below comments, you will see my response to this. A different transformation may help, but this will depend on your particular data set. If your data are right/positively skewed, log (try several bases), root, or reciprocal tranformations may help. Good luck to you!

    • @ibrahimsaid28
      @ibrahimsaid28 6 ปีที่แล้ว

      Thank you for your polite corporation

  • @louisjackai4756
    @louisjackai4756 6 ปีที่แล้ว

    Extremely helpful for our IPM/applied ecology group, especially for our students. Thanks.

  • @krisramonda1494
    @krisramonda1494 6 ปีที่แล้ว

    Great video, thank you!

  • @thelolipopkisser
    @thelolipopkisser 7 ปีที่แล้ว

    Dude, you saved me on the all nighter I had to do to complete my assignment, and for that I thank you :)

  • @digambar95
    @digambar95 7 ปีที่แล้ว

    Thanks alot, its a very useful calculation. Can we calculate diversity index if we have only biomass of that species?

    • @DrBSchamp
      @DrBSchamp 7 ปีที่แล้ว

      Any measure of abundance is fine for this. The values in the video are in fact biomass values.

  • @marcgarvida532
    @marcgarvida532 7 ปีที่แล้ว

    HELLO ,ONCE i have already transformed my data into a normally distributed data set, how will i able to use those obtained data in data analysis? for instance is in multiple regression analysis wherein an equation model will be created. What will happen to the independent variables? can dependent variable be predicted using the original data value of the independent variables??

  • @gilbertkim2176
    @gilbertkim2176 7 ปีที่แล้ว

    Thank you!

  • @akshaypunde3968
    @akshaypunde3968 7 ปีที่แล้ว

    Hi. What if i have a categorical variable. Do i need to transform the data then?

  • @mesha-3944
    @mesha-3944 7 ปีที่แล้ว

    I love you! Saved my life. My Allah bless you and your family!

    • @DrBSchamp
      @DrBSchamp 7 ปีที่แล้ว

      You're very welcome.

  • @eminememinemful
    @eminememinemful 7 ปีที่แล้ว

    Can do this with Ordinal data ( Likert Scale)? Thanks in advance for your answer.

    • @DrBSchamp
      @DrBSchamp 7 ปีที่แล้ว

      Hey there. Normalizing the data is typically done to use it in a linear model. I wouldn't. The ordinal data are essentially ranks, so you'd likely want to use something non-parametric to analyze them. That said, I don't have a lot of experience with that. This page might provide some help: davidmlane.com/hyperstat/viswanathan/Kolmogorov.html

  • @saharsarhan
    @saharsarhan 7 ปีที่แล้ว

    Hi, I did all steps but Kolmogorov-Smirnov and Shapiro-Wilk are still significant so Data sill not normal how can i solve this problem Plz? the sample = 193

    • @DrBSchamp
      @DrBSchamp 7 ปีที่แล้ว

      Hi there. You'll need to do other transformations on the data to try to normalize them. Different transformations will work for different data sets. Also, not all data can be normalized.

  • @aikonomic
    @aikonomic 7 ปีที่แล้ว

    I was hoping to ask a question but seeing that you haven't replied anyone of the questions in previous comments, well...

    • @DrBSchamp
      @DrBSchamp 7 ปีที่แล้ว

      Hi there. I answer questions when I can. Please feel free to send one.

  • @elbowrinkles
    @elbowrinkles 7 ปีที่แล้ว

    worthless - cant see what you are writing in the formula box - text too damn small

    • @DrBSchamp
      @DrBSchamp 7 ปีที่แล้ว

      Hi there. I suspect the default video settings are too low on your browser. But at the bottom of the video, there's a cog that allows you to change the video quality. At HD, you can read everything. I hope this helps you out.

    • @DrBSchamp
      @DrBSchamp 7 ปีที่แล้ว

      Also, if you can't read something because perhaps you are working with a small screen, just let me know and I can post the codes here. Best wishes.