Darragh Kelly
Ton up Member
Hi,
I've done my chi-square test a little different to the IFoA's sol. So I did the same in terms of separating into 10 equal bands and worked out the increment to calculate the ranges eg -17.2% to -13.5%, -13.5% to -9.8% etc. When calculating the expected frequency I use the following formula for say the expected frequency from -17.2% to -13.5%: =[(NORM.DIST(-13.5%, 0%, 2.4%, TRUE))-(NORM.DIST(-17.2%, 0%, 2.4%, TRUE))]*2135. Basically the P(-17.2%<X<-13.5%)*total number. I continue this for the rest of the bands. My numbers each time are v similar to the solution just off eg 340.10 vs 341.85 or 1263.35 vs 1262.64 etc. Finally I sum (A-E)^2/E for all bands and check this against =CHIINV(95%, degrees of freedom =band nr-1).
Does my approach seem ok?
Thanks,
Darragh
I've done my chi-square test a little different to the IFoA's sol. So I did the same in terms of separating into 10 equal bands and worked out the increment to calculate the ranges eg -17.2% to -13.5%, -13.5% to -9.8% etc. When calculating the expected frequency I use the following formula for say the expected frequency from -17.2% to -13.5%: =[(NORM.DIST(-13.5%, 0%, 2.4%, TRUE))-(NORM.DIST(-17.2%, 0%, 2.4%, TRUE))]*2135. Basically the P(-17.2%<X<-13.5%)*total number. I continue this for the rest of the bands. My numbers each time are v similar to the solution just off eg 340.10 vs 341.85 or 1263.35 vs 1262.64 etc. Finally I sum (A-E)^2/E for all bands and check this against =CHIINV(95%, degrees of freedom =band nr-1).
Does my approach seem ok?
Thanks,
Darragh