Question: How to do in an Excel? Table 1.8 shows a data set containing information for 25 of the shadow stocks tracked by the American Association

How to do in an Excel?

Table 1.8 shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors. Shadow stocks are common stocks of smaller companies that are not closely followed by Wall Street analysts. The data set is also on the website that accompanies the text in the WEBfile named Shadow02.

web file Table 1.8. Data Set for 25 Shadow Stocks Company

Exchange

Ticker Symbol

Market Cap ($ millions)

Price/Earnings Ratio

Gross Profit Margin (%)

DeWolfe Companies

AMEX

DWL

36.4

8.4

36.7

North Coast Energy

OTC

NCEB

52.5

6.2

59.3

Hansen Natural Corp.

OTC

HANS

41.1

14.6

44.8

MarineMax, Inc.

NYSE

HZO

111.5

7.2

23.8

Nanometrics Incorporated

OTC

NANO

228.6

38.0

53.3

TeamStaff, Inc.

OTC

TSTF

92.1

33.5

4.1

Environmental Tectonics

AMEX

ETC

51.1

35.8

35.9

Measurement Specialties

AMEX

MSS

101.8

26.8

37.6

SEMCO Energy, Inc.

NYSE

SEN

193.4

18.7

23.6

Party City Corporation

OTC

PCTY

97.2

15.9

36.4

Embrex, Inc.

OTC

EMBX

136.5

18.9

59.5

Tech/Ops Sevcon, Inc.

AMEX

23.2

20.7

35.7

ARCADIS NV

OTC

ARCAF

173.4

8.8

9.6

Qiao Xing Universal Tele.

OTC

XING

64.3

22.1

30.8

Energy West Incorporated

OTC

EWST

29.1

9.7

16.3

Barnwell Industries, Inc.

AMEX

BRN

27.3

7.4

73.4

Innodata Corporation

OTC

INOD

66.1

11.0

29.6

Medical Action Industries

OTC

MDCI

137.1

26.9

30.6

Instrumentarium Corp.

OTC

INMRY

240.9

3.6

52.1

Petroleum Development

OTC

PETD

95.9

6.1

19.4

Drexler Technology Corp.

OTC

DRXR

233.6

45.6

53.6

Gerber Childrenswear Inc.

NYSE

GCW

126.9

7.9

25.8

Gaiam, Inc.

OTC

GAIA

295.5

68.2

60.7

Artesian Resources Corp.

OTC

ARTNA

62.8

20.5

45.5

York Water Company

OTC

YORW

92.2

22.9

74.2

How many variables are in the data set?

Which of the variables are categorical and which are quantitative?

For the Exchange variable, show the frequency and the percent frequency for AMEX, NYSE, and OTC. Construct a bar graph similar to Figure 1.4 for the Exchange variable.

Show the frequency distribution for the Gross Profit Margin using the five intervals: 014.9, 1529.9, 3044.9, 4559.9, and 6074.9. Construct a histogram similar to Figure 1.5.

What is the average price/earnings ratio?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

65 and 90. 25. Table 1.8 shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors. Shadow stocks are common stocks of smaller...

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...

The table below shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors. Shadow stocks are common stocks of smaller companies...

The following table shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors. Shadow stocks are common stocks of smaller...

Table shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors. Shadow stocks are common stocks of smaller companies that are...

The following table shows a data set containing information for 2 5 of the shadow stocks tracked by the American Association of Individual Investors ( aaii.com, February 2 0 0 2 ) . Shadow stocks are...

A very simple square well potential is given 00 x>0 V(x) = {0 0

Suppose an investor holds $80,000 in Facebook stock. She also borrows $20,000 for 1 year at a rate of 4.00% with the principal due at maturity. If Facebook stock returns 6.00% during the one-year...

20. R&D Project Investment Decision. Hemmingway, Inc. is considering a $50 million research and development (R&D) project. Profit projections appear promising, but Hemmingways president is concerned...

Skills necessary for success in marketing include Multiple select question. analytical thinking advertising industry experience infallibility ability to work with others

Able to identify key HRM challenges facing organizations undergoing major change.

Aware of differences in the role of employees unions.

Aware of drivers for ongoing training and development within organizations.