Hi,
I really appreciate the course - it helped me to learn data analysis tool pak in an efficient way.
I've got one question here fore sampling:
For the sample we generated, are they just random number picked by excel or it will actually follow the data's distribution?
For example, if the original data has 1000 number and they are in normal distribution with standard deviation of 10, will the excel try to pick the sample with similar distribution& standard deviation?
Thanks heaps 
Hello
Thank you for your kind words.
The Data Analysis is choosing the data randomly and it will probably have the same distribution as the original normal distribution.
If you want to generate, using Excel, a random normally distributed sample with a certain average and standard deviation you can use the following function:
=NORM.INV(RAND(),average,standard_deviation)
For an average of 100 and a standard deviation of 10:
=NORM.INV(RAND(),100,10)
I tried it many times and it works very well.
