Excel Statistics 62: Binomial Experiments & Probabilities

My job requires me to establish the appropriate sample size during very expensive flight testing (i.e. can't afford to do more testing than the minimum required to establish the appropriate confidence). I have a nomograph that was given to me that we use to calculate the right value given confidence and demonstrated reliability (i.e. results). The nomograph can be found at: https://acc.dau.mil/docs/dtepi/pns/doc/nomogr/bdi.pdf.

Assuming we want to show that we have 80% confidence (right axis) that we'll succeed 80% of the time (left axis, also called reliability), I connect those values on each side with a straight edge and the chart shows that with zero failures (upper right boundary) we need 7 trials. If we have one failure (upper left boundary) the chart shows that we need 12 trials (11 successes). I was provided a formula that defines the zero failure curve [n=Log (1-confidence)/Log (reliability)]...What I need is a more generic equation or excel function that will generate these curves with failures not equal to zero.

Any statistics experts out there that can help me?

Thanks

trying to set up some specific code for lab experiments using excel and VBA.

sample is provided.

thanks


'==============
I want to set-up labs on spreadsheets, that force saves upon completion and send those saves to a specific address (say my email address: or better yet, a specific folder at my work.
I have attached a sample of what it is I am trying to do.
I have an Excel file, which would contain 3 worksheets:
Any sheet that is protected by password, the password is 123
Worksheet 1 is just instructions and would be made available at all times, but would be protected using a password.
Worksheet 2 would be for their data entry. Only specific cells would be un-locked. I would like a prompt (button) asking the student for his/her Name, then student Number prior to gaining access to this sheet. I would also like to have that info placed in the appropriate cells C3:E3 and C4:E4. They should not be able to close the file, without a ‘forced’ save via some VBa Code (if this is possible). So they would have 2 choices; 1)Close the file upon completion which will force a save 2)Check the solutions sheet upon completion, which will prompt them and force a save. I would like it for them to not have access to saving the file to wherever they chose, and would like for the program to only allow a save as mentioned above,either address or folder at work.
Worksheet 3 would only be accessed after a prompting the students if they are sure they are done, and that their work is final if they wish to check the solutions. This action should save their work to the above mentioned.

Help With VBA in Excel ? Writing a function using probabilities ?

I need help writing a function in VB in excel that decides the winner of a game, the probabilities are input into an excel worksheet by the user. There are 2 players and 4 different probabilities for each player:

a = probability of first shot being allowed
b = probability of winning first shot
c = probability of second shot being allowed
d = probability of winning second shot

The game is played between 2 players, in each game one is chosen to be the server and the other the receiver. Service alternates game by game. A single game consists of a sequence of points played with the same player serving. A game is won when a player has (a) scored four or more points and (b) has two or more points more than his opponent

My function needs to take the server (chosen at random) and return the winner of a particular point, calculated according to the above probabilities.

I have NO idea where to start here, any help please?????

please help me solve this problem on excel:


Suppose you bought four light bulbs. The manufacturer claims that 85% of their bulbs will last at least 700 hours. If the manufacturer is right,
a. What are the chances that all four your bulbs will last at least 700 hours?
b. That three will last 700 hours, but one will fail before that?

I have already developed a routine to generate a full factorial DoE and have a working simulation model and input sheet.

I would like to take the DoE setup (organized as and indexed by "Run ID"), copy and paste Run ID 1 into the input sheet, run my simulation macro, copy the simulation output into an output row, also indexed at Run ID 1. I want a macro that will repeat this for all Run ID's (n=64).

Is there a simple way to do this?

More Info:

Input sheet:

Variable 1 - [value]
Variable 2 - [value]
Variable 3 - [value]
Variable 4 - [value]
Variable 5 - [value]
Variable 6 - [value]

Output 1 - [value]

DoE Sheet:

Run ID - Variable 1 - Variable 2 - Variable 3 - Variable 4 - Variable 5 - Variable 6 - Output 1

All run ID's and Variables 1 through 6 are filled in.

Starting at Run ID 1, I want to Paste variables 1 through 6 into hte input sheet, simulate output 1, paste output 1 onto the DoE sheet then move to the next line and continue all the way through until all 64 have been simulated and tabulated.

Hi everyone,

I have posted this question on another forum but hoped that I may be able to get a different perspective from other people.


I have been working on a problem that requires being able to calculate the chances of any winnng a series of coin tosses with a weighted coin.

The coin has for arguments sake a 65% / 35% chance of landing heads or tails and to win the game you need to hit your side 9 times.

Can you use excel to calculate things like: If heads takes the lead 1-0, what does that mean the its overall percentage chance of winning? If the score is 7-3 to tails, what are the chances of either side gaining victory? etc, etc.

I thought that there would be a way of setting up a spreadsheet that listed the goal (first to 9, 12, 15 or whatever) and below this the percentage chance of heads and the percentage chance of tails. Then somewhere would be a box to enter the current score (0-0, 3-5, 1-1 or whatever) and beside this the current chance of heads or tails gaining victory.

I've tried setting up something like this but am a bit of a dufus when it comes to knowing how, where and when to use the different functions of excel.

Would anyone be able to give me a hand in how to set up something like this?


Thanks in advance for any help.


Here is the link to the same question on another board http://www.mrexcel.com/forum/showthread.php?t=340808

I'm sure you've seen a question like this a million times, but any help for a person new to Stats is much appreciated. For this computer lab in class we received this question.

"A research team at Cornell University conudcted a study showing that approximately 10% of all businessmen who wear ties, wear them so tight that they actually reduce blood flow to the brain, damaging cerebral functions. At a board meeting of 20 businessmen, all of whom wear ties, what is the probability that..."

a. at least one tie is too tight?
b. more than two ties are tight?
c. no tie is too tight?
d. at least 18 ties are NOT too tight?

How in excel do I go about putting in the information (not looking for a complete handout here) in the binomial function to get the answers I need?

Hi all,
First of all im sorry if such a thread exists...

What i wanted to know if anyone knows a way to display data in excel(using VBA), where the data is in a binary tree form, as follows:

http://i638.photobucket.com/albums/u...rklide00/1.jpg

The no of periods can vary from 3-10 periods ( or more at times)

What i want is to either have a way to display it as follows:

http://i638.photobucket.com/albums/u...rklide00/2.jpg

But as be able to have trees of different size plus be able to include some info such as the no of periods(at the bottom of each column) and be able to add the initial data from which the data was created. (the code i used above to create a tree like that has two problems: 1. i cant put any labels such as the no of periods and such 2. i need a button to return back to the userform from which the data was taken)

OR
if the above is not possible, i need a way to have a user form the data as it is in the worksheet. Ive thought of textboxes but then i'll have LOTS of them to put since i have about 10 worksheet with different trees of different size

Thx in advance for answering

Hello Everyone

Long time reader, first time poster here and hopefully you may be able to help me.

I have been working on a problem that requires being able to calculate the chances of any winnng a series of coin tosses with a weighted coin.

The coin has for arguments sake a 65% / 35% chance of landing heads or tails and to win the game you need to hit your side 9 times.

Can you use excel to calculate things like: If heads takes the lead 1-0, what does that mean the its overall percentage chance of winning? If the score is 7-3 to tails, what are the chances of either side gaining victory? etc, etc.

I thought that there would be a way of setting up a spreadsheet that listed the goal (first to 9, 12, 15 or whatever) and below this the percentage chance of heads and the percentage chance of tails. Then somewhere would be a box to enter the current score (0-0, 3-5, 1-1 or whatever) and beside this the current chance of heads or tails gaining victory.

I've tried setting up something like this but am a bit of a dufus when it comes to knowing how, where and when to use the different functions of excel.

Would anyone be able to give me a hand in how to set up something like this?