Excel (12) Chi Square GOF Test to Check Normal Distribution

Поділитися
Вставка
  • Опубліковано 2 лис 2024

КОМЕНТАРІ • 6

  • @andrewrollins2084
    @andrewrollins2084 Місяць тому

    Thank you so much, I am doing the Thesis and this help me a lot. I m appreciate it

  • @emialcaraz
    @emialcaraz 8 місяців тому

    Thank you very much Ms Wu. Excel tip: you can also establish the frequences with the function COUNTIF: =COUNTIF(Where do you want to look?, What do you want to look for?). So if you set the intervals: =COUNTIF([your data set]">=[left bound of the interval]") - COUNTIF([your data set]">[right bound of the interval]")

  • @kiraq8966
    @kiraq8966 Рік тому

    thank you for the guide Ms Wu! Very helpful.

  • @mayrajloredo87
    @mayrajloredo87 6 місяців тому

    Will this process be same for exponential distribution?

  • @thanhtuan5465
    @thanhtuan5465 Рік тому

    Can u explain for me why the degree of freedom in this case equal to 3 please? thank you.

    • @ms.wusmathclass
      @ms.wusmathclass  Рік тому

      normally df=#of intervals - number of parameters. In this situation, I assume three parameters are total number of data, mean and standard deviation. That is why 6-3=3