Hi Guys
I am unable to convert this function formula to VBA ... please advise ...
Formula:
=2*MIN(_xlfn.CHISQ.DIST(H33,H28-1,1),1-_xlfn.CHISQ.DIST(H33,H28-1,1))
Below code ... have substituted the Cells with Variables...
Pval = 2 * Application.WorksheetFunction.Min(WorksheetFunction.Chisq_Dist(Xstat,Size-1,1),1 - WorksheetFunction.Chisq_Dist(Xstat,Size-1,1))
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks