If the mean height is 72 inches, the standard deviation is 4 inches, and the heights are normally distributed, how can I determine the following:
Between what 2 heights would you expect to find the middle 50%?
Thank you.
Hi All,
I've created a sheet in which I would like to calculate mean and standard
deviation for a user selected range.
I have a number of ranges of data (arranged in columns and of varying
length) which the user may select.
Once the user has selected a range, I'd like them to be able to click a
button to run a macro that will
display the mean and st.dev. (as a string maybe) in the cell immediately
below and to the right of the lowest
cell selected by the user.
Example, the user selects the range (C24:C31), runs the macro and ends up
with the mean and st.dev. in cell D32.
The output I'm after can be achieved using a formula like,
'="The mean is "&ROUND(AVERAGE(C24:C31),1)&" and the standard deviation is
"&ROUND(STDEV(C24:C31),1)'
Any thoughts ?
TIA,
Neil
The idea behind the design of this spreadsheet is that it logs how many darts you throw for each target, and how many are successful hits you get from those throws. I was also hoping it would add your percentage for each target and display them on a graphic representation of a dartboard.
An example of the input columns for one target would be:
Treble 20 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3
Treble 19 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3
Treble 18 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3
the first 3 - 2 - 1 would be red buttons (which count as a miss) that adds to the amount of throws for the target, but does not add anything to the 'hit' column. The 1 - 2 - 3 buttons would be green, and add the relevant amount to the 'hit' column as well as the 'throws' column.
So lets say I aim at Treble 20, miss with 2 darts and hit with 1 dart, I would click the red button labelled '2' and click the green button labelled '1'. Pressing these buttons would update the columns for darts 'thrown' and 'hit' showing that I've thrown three darts and had one dart on target.
I've got the layout for the above, but I am new at this and don't know what code to add for the buttons. So if you guys could supply me with the code then that is the main purpose of this spreadsheet.
Now for the graphic representation of the board... Excel doesn't seem to have a lot of capabilities with combining data with graphics, but I was basically hoping that my above example which would give a percentage of '33.33%' would be added at the Treble 20 on a graphic of a dart board. Are there any ways of doing this?
I am trying to use NormSInv(Rnd) and get the following error when I try to compile my code. I don't know why though...when you type normsinv, VBA changes it to NormSInv so it does recognize it as a function.
"Compile error:
Sub or Function not defined"
Hi,
I currently have a pivot table that returns min(date) and max(date) for each by-group 'Name.' So it looks something like this:
Name Min of Date Max of Date
John 1/1/2000 9/1/2000
Mary 4/1/1999 3/1/2000
Chris 2/1/2000 6/1/2006
Now I would like to create a new field that returns the difference between these two dates for each name. However Min of Date and Max of Date do not show up under Field List when I go into Calculated Field. How could I do it and still stay within the pivot table (i.e. not create a formula outside it)?
Thank you in advance for your help.
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 guys
I've looked at all the available threads on this and everyone seems to be telling me this particular error is due to missing libraries but my code (which works fine otherwise), stops at the follwing and I can't understand what a missing library would have to do with it:
finalrow = Cells(2000, 1).End(xlUp).Offset(1, 0).Row
Does anyone know what's wrong?
Thanks in advance
Hi folks,
I'm looking for a macro that I can use to thange all Normal text to bold & all Italic text to normal. I would like it to do the entire current sheet.
Any help is appreciated.
Option 1:
Mean 26,000 standard deviation =4,000
Option 2:
Mean 28,000 standard deviation =2,000
Which option has higher chance of being 23,000 or bellow?
NORMDIST
By how much is the likelihood higher?
subtract probabilities
95% higher that option A will be 23,000 or less?
NORMINV
