1)Copy the raw data from the EXAMPLE excel pdf worksheet entitled, "grouped frequency distribution" into an excel worksheet and label the worksheet "grouped frequency distribution".

(B)

use the formulas provided on pages 9 - 11 (Grouped Frequency section) to answer:

- How many scores in the dataset fall below 77?

- How many scores are equal to or below 63?

- How many scores fall between 63 and 77?

- How many scores fall below 88, but are greater than or equal to 68

These are the formulas for the excel