There are different
approaches to analyze these PVs. One way is to
randomly select a single score out of 5 to 10 PVs. This selection
which consists of three steps, can be implemented in Excel.
1. Use the function RANDBETWEEN(1, 5)
to select a number within the range of the plausible values. In this
example the range is between 1
2. Use the function CHOOSE(the number
selected by RANDBETWEEN, the
range of five scores) to select a test score.
3. Grab the corner of
the two cells, and then drag them down to
populate the rest of the two columns.
Alternatively, you can
copy the functions, select the rest of the
cells by holding down the shift key while placing the cursor at the
the end, and the paste the functions.
4. However, in Excel
whenever any update is made, all functions
would automatically re-calculate the values. As shown in the preceding
the numbers in F2 and G2 keep changing because any new action result in
numbers. In order to fix the chosen score, one must copy Column G and
numbers in another column as values.
By doing so the numbers are fixed
column that contains functions can be removed.