Hi,
Does anyone know a formula, or any other way to generate a random number from an exponential distribution with a mean of 2?
Thanks!
Jim.
I have a set of macros in a template/starter file for users to open and start a project. Within this workbook contains a bunch of macros. Instead of sending everyone a new workbook with updated macros each time, I would like to host these macros or somehow distribute updated macros to everyone efficiently.
I am unsuccessful in finding a way to have a button call another macro from a workbook on a network drive.
I am also unsuccessful in using an addin. I have saved the macros as an add-in and added it to my workbook, but am unable to call those functions.
I could also just export the modules each time one updates but then I have to rely on the user to replace their current one which I don't want to do.
Essentially, I would like the update to occur without relying on the user to do very much or anything at all.
Thanks
Hi All,
I trying to find (or alternatively write) functions that calculate mean and variance for bivariate probability distributions.
For example:
Skis
Boots 0 1 2
0 0.08 0.14 0.12
1 0.09 0.17 0.13
2 0.05 0.18 0.04
I wrote my own function for a single variable probability distribution, but this is more complicated since you need to sum rows or columns depending on the variable you are calculating for.
If I have to write this, I guess my first question would be how can I sum up either a row or column from a range and store the solution within an array?
i.e For column(i)
Sum all of the row values
Store in array(i)
Next column
Any suggestions on how to do this, where I can find something that already exists, or how to best approach this in general? The help of this forum is, as always, greatly apreciated.
-Zack
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
Hi everyone, first thanks for the help.
I am trying to create a histogram and let me explain some of the data.
I have a list of data separated like so:
3.5
3.6
3.8
3.8
3.9
3.9
etc...
Now I need to calculate the frequencies of these like so:
3.5 (up to but not including) 4.0
4.0 (up to but not including) 4.5
I can count out the frequencies myself but i need to create a histogram (bar graph) with the y axis as the frequency and the x axis as the IMR(infant mortality rate: ie the 3.5 (up to but not including) 4.0).
I am having problems with calculating the frequencies because when setting the bin values because they include 4.0.
If this is confusing I can provide some more information, but cannot find a good tutorial that would create a histogram anywhere remotely close to the histogram i drew by hand.
I have a data set based on an uneven distribution of cards in a 60 card deck, each with a value ranging from 0-5.
I need to build a probability distribution of all the random samples of 10. So, how many random sets of 10. have an average value of 1 (or a total of 10) etc.
Then, I need to build a variable distribution so that it changes as I change the sample size. So, with a sample of 20 cards, what does the distribution look like?
Can this be done in excel? Should I post what I have now to work with?
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.
