Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Column A contains the relevant data. Here you will find 30 values between 1-30. For this exercise we will be using 15 samples of 3
Column A contains the relevant data. Here you will find 30 values between 1-30. For this exercise we will be using 15 samples of 3 values per sample. Columns E-S instruct you which values to use for each sample. For example, if a column says A2, A9 and A16, you are to calculate the mean of the sample of the values you find in cell A2, cell A9 and cell A16 (here, 41, 11 and 42).
Please calculate the sample mean of each sample outlined in columns E-S and report these values at the bottom of each sample (so in cells E5- S5).