Statistical Data Analysis in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ก.พ. 2025

ความคิดเห็น • 24

  • @claireyapsiewleng1215
    @claireyapsiewleng1215 3 ปีที่แล้ว +4

    Thank you so much, this video was really helpful to me.

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

    Excellent work and kindness overload. Thank you a lot, Teacher

  • @Inquire98
    @Inquire98 3 ปีที่แล้ว +7

    I Thank GOD 😇 and I thank you 😉 That was REALLY good Do you KNOW of any more examples/samples in a series Or can you recommend a good book Let me know I look forward to hearing from you 😎

  • @LokiZ-cd4ws
    @LokiZ-cd4ws ปีที่แล้ว

    It's very detailed and very clear. Thankyou!💓

  • @saf5854
    @saf5854 7 หลายเดือนก่อน

    Thank you. This video so very easy to follow, and incredibly helpful. Normally videos on this topic are off-putting, but yours was engaging and approachable. Thanks again.

  • @frames3212
    @frames3212 3 ปีที่แล้ว +2

    You deserve a super like

  • @ayeshatariq9578
    @ayeshatariq9578 4 ปีที่แล้ว +4

    I found this video very helpful

  • @risausa4796
    @risausa4796 2 ปีที่แล้ว +3

    Wonderful!

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

    This is a great tutorial but what about for analysies of Categorical Data rather than purely mathematical/cumulative data? Eg. from my studies the other day I compiled a list of Several hundred infants (although many cases are from years ago so not now) Diagnosed with Retinopathy of Prematurity. It lists Sex, Birth weight, birth weeks, Right eye and left eye levels of the condition, treatment given, Presence of Cerebral Palsy, Presence of other disabilities, final visual outcome right and left eye respectively. However most of these categories are just Categorical and not numerical ie ( CP- Yes/No, Level of ROP- 1, 2, 3, 4a, 4b, 5 etc, Treatment needed- Y/N, Treatment Type-Laser, Injection, Encerclage, Lenssparing Vitrectomy, Lensectomy Vitrectomy, Cryo etc) (jargon not important) but as you see most of this is not numerical.
    If I wanted to do a statistical analysis of these eg. CP frequency by ROP type, Sex vs ROP Level, Birth-weight and Treatment, eg compare a variety of columns too each other, how would I go about a task like this? Sorry if you already covered this in another video, if so just link it.
    Thankyou

  • @Lazy-bliss
    @Lazy-bliss 2 ปีที่แล้ว +1

    Bins data are different from 1st column data ? I don't understand.

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

      Yes they are different. bins are for frequency data or histogram. To create bins we have to set a fix class interval among all the values but it should be such that it shouldn't exceed the original data values( must be between min and max) Carefully observe the interval and also see the 1st and last value of bin which ensure the values are between the range of original data. Once we fix a class interval then we don't care about how many bins should be formed, they continue forming upto the max value. Hope you got it.

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

    Thank you so much

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

    Can anyone explain is the bin step is necessary ?

  • @NehaPd
    @NehaPd 3 ปีที่แล้ว +3

    thank u i am in tears

  • @wywlf6912
    @wywlf6912 4 ปีที่แล้ว +12

    why im hearing sirens in the background

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

      I thought it was a crying baby

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

      It's his laptop fan

  • @benward5817
    @benward5817 4 ปีที่แล้ว +3

    how do I use functions if my data set is more than 255 cells

    • @mysticality27
      @mysticality27 3 ปีที่แล้ว +3

      You would select the first cell in the column you are using and press Cntrl, shift, and the down arrow at the same time. This should select all of the values in the column from the first row you select all the way to the bottom of the sheet

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

    Thank u

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

    Thank you

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

    anyway we can zoom for help with mine?

  • @ayeshatariq9578
    @ayeshatariq9578 4 ปีที่แล้ว +1

    Thxxx

  • @khaksoksokkhak4002
    @khaksoksokkhak4002 3 ปีที่แล้ว +4

    I found this video very helpful