Re: what is formula to find out chi-square



On 26 Jun, 12:10, Tradeorganizer <tradeorgani...@xxxxxxxxx> wrote:
Hi

please help to find out the chi square distribution formula , as i am
hainv the value of observed frequecncy and expected frequency , since
i am trying to find out the chi - squre in programming language called
asp( active server pages ) in which you cannot use the formula of
excel.

its easy to find in Microsoft excel the formula is chidist( x , 1) and
its gives you the value , but using the scripting language i need the
exact formula how to find the chiquare without using excel

so if any body can suggest any link or exact forumla to find out chi -
square for the degree of one then i use that same in my script.

Regards


You can find Javascript code for the chi-square cdf at <http://
members.aol.com/iandjmsmith/CHI2EX.HTM>. This includes the file
<http://members.aol.com/iandjmsmith/myfunctions.js>.

Note Excel's CHIDIST(x,df) returns 1-cdf_chi_square(x,df).

If you really only want values for 1 degree of freedom then

CHIDIST(x,1) = 2*cdf_normal(-x*x)

This would allow you to cut out most of the code in <http://
members.aol.com/iandjmsmith/myfunctions.js>.

If you do not need great accuracy then you could probably get by with
a table of the normal cdf and simple interpolation.


Ian Smith


.



Relevant Pages

  • Re: what is formula to find out chi-square
    ... please help to find out the chi square distribution formula, ... hainv the value of observed frequecncy and expected frequency, ... i am trying to find out the chi - squre in programming language called ... its easy to find in Microsoft excel the formula is chidist ...
    (sci.stat.math)
  • what is formula to find out chi-square
    ... please help to find out the chi square distribution formula, ... hainv the value of observed frequecncy and expected frequency, ... i am trying to find out the chi - squre in programming language called ... its easy to find in Microsoft excel the formula is chidist ...
    (sci.stat.math)
  • Re: Columns
    ... Chi ... it has Columns function that is very useful. ... >> In Excel, I would like to create a sheet, which has 5 columns. ...
    (microsoft.public.excel.newusers)