Trying to fully understand CHITEST function (or Goodness of Fit problem)

[zennie]

Hello.
Hope it's the right place to post such question.

Recently I have been dealing with logistic/sigmoidal function fitting with quite good results, thanks to this forum.
But now I am kinda stuck trying to figure the best way to use Excel to calculate how much two functions I have created fit each other.

I have created a simple two columns file, each column describes a certain sigmoidal curve (attached).
By plotting these curves together, one can obviously see they do not fit each other quite so good (although not VERY different).

When trying to measure the goodness of fit between these two functions using CHITEST, I come out with a very good fit of .99999 which seems quite untrue considering the apparent differences between the functions.

I'm beginning to think I have some major flaw in understanding the correct\appropriate use of CHITEST function. Maybe i should use a whole new way to assess the fit between these two columns?



Thanks so much for any reply.