Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Ask] Triangle Distribution and Latin Hypercube Sampling
Could anyone help to describe how to create macros for Triangle
Distribution and Latin Hypercube Sampling? Any answer would be helpful. thx and rgds, Sukab |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Ask] Triangle Distribution and Latin Hypercube Sampling
Lets answer the 2nd question 1st.
the are tables for Latin Hypercube Sampling depending on the size of your arrays. I don't think you want a macro to create your own arrays orthogonal table). If you are doinhg sampling get a book with the standard tables and enter the table into an excel spreadsheet. I macro can then use the standard table. (see http://en.wikipedia.org/wiki/Latin_hypercube_sampling) Now the 1st question, Triangle Distribution. (see http://en.wikipedia.org/wiki/Triangular_distribution) Which results are you looking for? what is the formula you are using? I assume you have data which you collected. Is the data actually g=giving you triangular results. Or is this just a class asignment to plot triangule results? If it is a class asignment you need to pas into the a UDF function the 3 corners of the triangle and a point along one side of the triangle. The PDF results would be the height of the triagle for the point provided. function TrianglePDF(AX,AY,BX,BY,CX,CY,X,Y) End function what "sukab" wrote: Could anyone help to describe how to create macros for Triangle Distribution and Latin Hypercube Sampling? Any answer would be helpful. thx and rgds, Sukab |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sampling | Excel Worksheet Functions | |||
Adding together two Latin Squares | Excel Discussion (Misc queries) | |||
Sampling | Excel Discussion (Misc queries) | |||
How do I automatically insert the latin tree names | Excel Discussion (Misc queries) | |||
VB strings, MSXML, Latin 9, and the Euro | Excel Programming |