function excel vba

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Function in Excel VBA

Function in Excel VBA

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

DATEDIF function

The 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.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Server loaded in 0.08 secs.