Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Jack Lawler, a financial analyst, wants to prepare an article on the Shadow Stock portfolio developed by the American Association of Individual Investors (AAII). A

Jack Lawler, a financial analyst, wants to prepare an article on the Shadow Stock portfolio developed by the American Association of Individual Investors (AAII). A list of the 30 companies in the Shadow Stock portfolio as of March is contained in the Excel Online file below. Use the spreadsheet to answer the following questions.

Jack would like to select a simple random sample of 5 of these companies for an interview concerning management practices.

a. The Shadow Stock companies are listed in column A of the Excel worksheet provided above. In column B we have generated a random number for each of the companies. Use these random numbers to select a simple random sample of 5 of these companies for Jack by finding the smallest random number, the second smallest random number, etc. in column B using an Excel function.

The random numbers corresponding to the first 5 companies selected are (to 5 decimal places):

First company (smallest random number) ____

Second company (2nd smallest random number) ____

Third company (3rd smallest random number) _____

Fourth company (4th smallest random number) _____

Fifth company (5th smallest random number)______

0.15106
0.78664
0.46736
0.31288
0.05743
0.96845
0.70824
0.43701
0.68709
0.49262
0.69531
0.04123
0.51061
0.23796
0.92181
0.91875
0.97469
0.78824
0.30299
0.61512
0.83291
0.05894
0.76809
0.85076
0.61597
0.42998
0.92434
0.36411
0.72285
0.29854

Step by Step Solution

3.35 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

Let us suppose that the random numbers are in colum... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Modern Business Statistics With Microsoft Excel

Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams

6th Edition

978-1305445628, 1305445627, 978-1285867045

More Books

Students also viewed these Chemistry questions

Question

Briefly explain the qualities of an able supervisor

Answered: 1 week ago

Question

Define policy making?

Answered: 1 week ago

Question

Define co-ordination?

Answered: 1 week ago

Question

What are the role of supervisors ?

Answered: 1 week ago