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?????
Hi, i am a newpie and learning bayes calculation. I found an example from http://en.wikipedia.org/wiki/Naive_B...ifier#Examples and i have no idea how to make it in excel. Can anyone help? Btw i have watched already youtube videos made by excelisfun and still can't do it myself. I appreciate very much if anyone can help. Thanks
Hello
How do you write the following formula in VBA?
PHP Code:
=RADQ(A3^2+B3^2)
Hello all,
I have a spreadsheet of co-ordinates (Eastings & Northings). Columns A & B contain the co-ordinates of school premises. Columns E & F contain the co-ordinates of anti-social behaviour incidents. In column C I'd like to show a count of anti-social behaviour incidents occuring with 100m of the school (Easting & Northings are in metres which is handy)
Easting Northing Results Easting Northing
502871 107008 ------------- 518902 116729
585461 136574 ------------- 531108 108205
487650 135334 -------------
In my actual data I have about 464 anti-social behaviour incidents and 697 schools
I've worked out how to calculate the distance between school and incident using a pythagoras formula like this...
=SQRT((ABS(A2-D2))^2+(ABS(B2-E2))^2)
...but that isn't really what I need. What I really need is a count are incidents where the answer to this formula is >100m
Please help? I've tried everything I can think of.
Hi Lords and Ladies!
I was wondering if there are any statistical tools in excel?
What I need is a comparison program to do the following:
Column A: abcdefgh
Column B: bcaghfrnreo
Column C: 80% match (roughly)
Is that possible to do in excel?
Regards,
Don Defy
I am having difficulty setting up a Excel sheet for the following problem.
An industrial Engineer at ABC Products wants to determine whether there are more units produced on PM shift then AM Shift.
Sample of 54 Am workesr with a mean number of units produced is 345 with a standard deviation of 21.
Sample of 60 PM workser with a mean number of units produced is 351 with a standard deviation of 28 units.
Significance level is .05
Trying to figure out if the PM shift is larger.
Morning All,
Does anyone know of a free tutorial that can explain how to get statistical data in Excel? - I have seen it done before (in excel) for 'Linear regression', I am wondering if the same can be done for "Polynomal"?
Rgs
Neville
