Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create a probability distribution in excel?
Is there a way to create a "proability distribution" in Excel? I am in a
statistics class and it would be really helpful. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create a probability distribution in excel?
Spunkybear -
Is there a way to create a "proability distribution" in Excel? I am in a statistics class and it would be really helpful. < You can use Excel's worksheet functions to get the probabilities (probability mass, probability density, or cumulative) for many distributions, including normal, binomial, poisson, and exponential. And you can use Excel charts to display worksheet values for probability mass functions, probability density functions, and cumulative distributions. You can also use Excel's Histogram tool to get the frequency distribution and histogram column chart for data, or you can use the array-entered FREQUENCY function (or COUNTIF functions) and a Column chart type to get a histogram. Or, you can use my free Better Histogram add-in, available from http://www.treeplan.com. Many statistics textbooks have instructions for using Excel for these purposes and more. - Mike http://www.mikemiddleton.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I create a probability distribution in excel?
there are lots of resources to be found via usenet newsgroups, and your main
tool is the newsgroups archive. There are many superb tutorials and samples on MVP and other sites http://groups.google.co.uk/advanced_search?hl=en "Spunkybear" wrote in message ... Is there a way to create a "proability distribution" in Excel? I am in a statistics class and it would be really helpful. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create excel based standalone application | Excel Discussion (Misc queries) | |||
how to create the formula "cumsum" in excel | Excel Worksheet Functions | |||
Create database in excel? | New Users to Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
create price list from excel sheet | Excel Discussion (Misc queries) |