Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Function in Excel VBA
|
|
|
Bookmark this page|
The UK's most regular 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. |
Function in Excel VBA
Resolved · Low Priority · Version 2003
Reply
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
For upcoming training course dates see: Pricing & availability
RE: Function in Excel VBA
Hello SarahThanks 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.
|
 |
|
» Forum post: Formulas |
How to link work sheets
