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
