Question: Countrygirl Makeup is a line of facial products marketed to young women, ages sixteen to twenty four. Although successful when introduced in 1990, in recent years Countrygirl sales have eroded. An independent research firm was commissioned to gather information about the ages of the current users. A nationwide random sample of 50 users yielded the following ages. (2.5 points)

[Please note: Age is quantitative data type of continuous, and ratio level of measurement. Therefore, in categorizing ages of respondents into age groups, you must understand that a respondent selected at random, does not attain a particular age until his or her birthday for that particular age is attained. For example, you are not 20 until you turn 20 on your 20^th birthday. Therefore, an observation of 19.4 (say!), would not belong to an age group of 20 years or above.]

19.4 31.3 22.7 27.6 27.9 30.1 23.1 26.4 32.1 22.5

28.2 25.7 33.8 28.9 18.6 26.8 30.5 34.0 21.6 28.2

32.2 27.3 17.5 23.0 32.8 36.0 29.1 42.7 30.5 39.0

26.2 33.2 36.3 22.7 43.1 28.7 26.3 38.6 24.1 21.3

32.1 28.7 25.8 26.0 18.7 18.2 23.9 28.2 20.2 33.1

a) Talley the data into frequency distribution, using only six classes, with the first class ranging from 15 -19 age group. Form the relative (percentage) frequency distribution! ( 1.0 point)

b) Construct a histogram, using Excel ( 1.0 point)

c) On the basis of the results of (c), and (b), if you had to tell the president of the Countrygilr, the reason why in recent years the sales has plummeted, what advice would you provide as basis for future advertising and promotion decisions?

Should the current age range of 16 to 24 years old be a good basis for the

company to base their future advertising and promotion decisions?. Explain