Use Random number generator (under Data Analysis) to simulate the following data set. Create 10 columns, each 20 points long and use the following parameters: Number of variables (10), number of data point (20), Distribution (Normal), Mean (40), Standard Deviation (10), Random seed (1234). The data should be in columns: A, B,C,….,I, J.

Randomly pick two columns (say Column B and Column H) and perform 2-sided t-test on these two data columns. Record the P-value and repeat this procedure several times (at least 5 times). That is, each time randomly pick two columns, perform 2-sided t-test and record the P-value. And answer the questions. (Pick the closest answer)

What did you observe?

a. Most of the P-values are very small, and some below 5%.
b. P-values are very different, some small and some large, but very few, if any, below 5%
c. Most of the P-values are very large, around 0.9 and 0.95 range.
d. Essentially all P-values are below 5% and some even below 1% range.