Question: According to the National Association of Investment Clubs, PepsiCo Inc. is the most popular club held stock with 11,388 clubs holding it. Intel is a close second, followed by Motorola. A list of the most popular stocks are shown below. Use Descriptive Statistics, EXCEL, to compute the mean, median, mode, range and standard deviation, variance for these figures.

Number of Clubs Holding Stocks

Pepsico 11388

Intel 11019

Motorola 9863

Tricon Global (restaurants) 9168

Merck 8685

AFLAC 6769

Diebold 6552

McDonald’s 6498

Coca-Cola 6101

Lucent 5563

HomeDepot 5414

Clayton Homes 5390

RPM 5033

Cisco 4541

GE 4507

Johnson & Johnson 4464

Microsoft 4152

Wendy’s International 4150

Walt Disney 3999

AT&T 3619