25. Table 1.8 shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors (aaii.com, February 2002). Shadow stocks are common stocks of smaller companies that are not closely followed by Wall Street analysts. The data set is also on the CD accompanying the text in the file named Shadow02.

a. How many variables are in the data set? Name them.

b. Which of the variables are qualitative and which are quantitative?

c. For the Exchange variable, count the number of observations and compute the percent frequencies corresponding to NYSE, AMEX, and OTC. Construct a bar graph similar to Figure 1.4 for the Exchange variable.

d. Count the number of observations for the Gross Profit Margin variable that fall within the following five intervals: 0–15, 15–30, 30–45, 45–60, and 60–75. Using these intervals for the base of each bar, construct a histogram similar to Figure 1.5.

e. Use Excel to compute the average for the Market Cap variable.

f. Use Excel to compute the average for the Price/Earnings Ratio.