Solved

# Generate Multivariate Normal Distribution

Posted on 2010-04-05
Medium Priority
940 Views
How do I generate a set of data of Multivariate Normal Distribution, give mean, std dev? Any available free software to do the job?
0
Question by:hongjun

LVL 50

Expert Comment

ID: 29866030
There is VBA code to do exactly this at http://www.anthony-vba.kefra.com/vba/vba4.htm

Cheers

Dave
0

LVL 33

Author Comment

ID: 29866139
Sorry. Choose to delete wrong question.
0

LVL 50

Expert Comment

ID: 29866172
It looks like the other question has already been deleted so this one (as the earlier question) is live

Regards

Dave
0

LVL 85

Accepted Solution

ozo earned 800 total points
ID: 29866176
0

LVL 50

Expert Comment

ID: 29866183
No probs :)
0

LVL 33

Author Comment

ID: 29866279
Yes, but I need a multivariate one instead.
0

LVL 22

Expert Comment

ID: 29921748
Are you talking about multiple independent normally distributed variables or a group of variables with an associated covariance matrix?
0

LVL 33

Author Comment

ID: 30251390
How do you interpret the below statement?

"To generate the discrete normal distribution, we ¿rst generated the mul-tivariate normal distribution, and then discretized the values of each attribute into equal-width ranges."
0

LVL 1

Assisted Solution

rkursem earned 600 total points
ID: 30510417
That means to divide the interval spanned by the numbers into a number of subintervals each having same length. Then take your data and determine what interval each point belongs to. Finally, you count the number of occurances in each subinterval.

As a simple example, you might see something like below for 11 sub-intervals:
1: *
2: *
3: **
4: ****
5: ******
6: ********
7: *******
8: *****
9: ***
A: *
B: *

0

LVL 33

Author Comment

ID: 30511437
Do you mean we will only generate ONE series of normal distribution numbers?
0

LVL 2

Assisted Solution

KarlHeinz123 earned 600 total points
ID: 30538754
Te answer to that goes back to the original statement:

"To generate the discrete normal distribution, we ¿rst generated the mul-tivariate normal distribution, and then discretized the values of each attribute into equal-width ranges" [key phrase "each attribute"]

One needs to know how many attributes are being generated. If one, then rkursem had the full answer, If two and a bi-variate normal distribution is desired, then ozo was correct. For more more then two you would have to define the relationship between the attributes and their distributions. A simple model would be to assume for N attributes an n-space matrix with each attribute applied orthogonaly to the rest. Then each attribute would be itself normaly distributed along its axis and you would generate n sets of normaly distributed numbers.
0

LVL 33

Author Comment

ID: 32633179
How to split myself? I can't seem to find the option.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Each password manager has its own problems in dealing with certain websites and their login methods. In Part 1, I review the Top 5 Password Managers that I've found to be the best. In Part 2 we'll look at which ones co-exist together and why it'…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
###### Suggested Courses
Course of the Month7 days, 8 hours left to enroll