The Harleys Daycare. decided to use 20 different water ballooncategories. Their prices (on 100 units) are listed below:

27          25          10          7             13          20          27          15          25          10          

22          16          11          9             12          20          17          17          23          20

a. Construct a grouped frequency distributionwith 6classes.           

Step 1. FindRange

Step 2. Given thenumber of classes, the width of each class is

Step 3. Create classboundaries

Step 4. Find thenumerical frequencies

b. Use Excel toconstruct a Histogram. (Tools à Data Analysis àHistogram à for the input range, select the given values, for thebin range select the classes upper boundaries values à check ChartOutput)

Note: If you don’t have thecapability of using excel for the histogram, draw one by hand.

[D(14 points)] Consider the following set ofdata containing the amount of paid tuition/week forpart-timers:

Child Name	Amount	Z-Score          Â
Marie	70
Philip	80
John	55
Isabela	75
Raymond	55
Richard	75
Edgar	80
Jerry	85
Christiana	60
Juliet	85

Z = ( X – U)/ σ where u is the mean and σ is the standarddeviation.

a. For the set of data given above,calculate the following descriptive statistics (Briefly explain,especially the quartiles calculations. Use the rules given in thehomework 2). For the rest you can use excel tools as long as youshow your work.

Mean	2.71
Median	2
Mode	2
Who is in the lowest quartile? Explain	Q1 = 1 Quartile 1 is the median of the lower half of the data.
Who is in the uppermost quartile?	Q3 = 5 Q3 is the median of the upper half of the data.
Interquartile Range	Interquartile range = q3 – q1 = 5 – 1 =
Range	Range = highest value – lowest value = 9
Standard Deviation	2.49
Variance

b.   Compute the z-scores and enterthem in the first given table. Give the formula you used.

c.   What type of skewness does this data set have?The data set has a left tail skewness.