My stats knowledge is pretty limited so I would appreciate any help available on the following question.

I want to generate a scatter plot with 231 random data points, where the correlation coefficient is 0.64 between the two variables. Is this a possible to solve problem?

Alternatively I need to two sets of data - both 231 data points each, one with a mean of 1.8 with a S.D of 0.6 and the other with a mean of 6.8 with an S. D of 1.0. these two sets of data need to correlate with a coefficient of 0.64. Is this sort of query possible? and how would I go about generating that random data?

I have access to Excel, Minitab and SPSS if necessary.

Any help would be so gratefully received!!!