98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Function in Excel VBA
Function in Excel VBA
Resolved · Low Priority · Version 2003
Sarah has attended:
Excel VBA Intro Intermediate course
Access Advanced course
Access Intermediate course
Function in Excel VBA
I want to create a function that enables me to calculate Confidence Intervals but using the 'Wilson Score' method.
To do this I have to do the following:
Find:
Observed number = r
Sample size = n
Proportion with feature of interest = p = r/n
Proportion without feature of interest = q = 1-p
Three values A, B and C then need to be calculated:
A=2r+z^2
B=z * sqrt(z^2 + 4rq)
C=2(n+z^2)
z=1.96
Then
LL= (A-B)/C
UL = (A+B)/C
RE: Function in Excel VBA
Hello Sarah
Thanks for your post, it is certainly interesting and one that we may be able to assist with. It does fall outside of the scope of this forum but we can look to spend some time on it to what solutions we can reach.
Naturally we will be commiting time to this that would be billable, so we would want to see some sample files with a more detailed list of what you are trying to achieve.
We will inform of you of a solution and scope of work before starting anything. If this is something you would like to look into please contact me direct.
Kind regards
Jacob
Mon 22 Mar 2010: Automatically marked as resolved.
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:DATEDIF functionThe DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002. |