REX American Resources Corp (REX) 0.72831   Rocky Brands Inc (RCKY) 0.79236   SigmaTron International (SGMA) 0.51658   Salem Communications Corp (SALM) 0.95128   Shoe Carnival 0.93049   Standard Motor Products 0.74160   TravelCenters of America LLC (TA) 0.62555   VOXX International Corp (VOXX) 0.86738   Willis Lease Finance Corporati (WLFC) 0.42914

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Topic Video
Question
REX American Resources Corp (REX) 0.72831  
Rocky Brands Inc (RCKY) 0.79236  
SigmaTron International (SGMA) 0.51658  
Salem Communications Corp (SALM) 0.95128  
Shoe Carnival 0.93049  
Standard Motor Products 0.74160  
TravelCenters of America LLC (TA) 0.62555  
VOXX International Corp (VOXX) 0.86738  
Willis Lease Finance Corporati (WLFC) 0.42914  
3586ISHN 97803574226708id 11431018288snapshotld32336877&
MINDTAP
Q Search this com
:Structured Activity
I Video
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.
Open spreadsheet
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)0.04123
Second company (2nd smallest random number) 0.05743
Third company (3rd smallest random number) 0.05894
Fourth company (4th smallest random number) 0 15106
Fifth company (5th smallest random number) 0.23796
Back
Next
Transcribed Image Text:3586ISHN 97803574226708id 11431018288snapshotld32336877& MINDTAP Q Search this com :Structured Activity I Video 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. Open spreadsheet 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)0.04123 Second company (2nd smallest random number) 0.05743 Third company (3rd smallest random number) 0.05894 Fourth company (4th smallest random number) 0 15106 Fifth company (5th smallest random number) 0.23796 Back Next
Excel
template - Saved
P Sealch (At Q)
File
Home
Insert
Draw
Formulas
Data
Review
View
Help
O Editing v
BE v A
Arial
v 10
...
General
C2
F
G
Random
1.
Company (Ticker)
Number
Formula Used
Alamo Group
Alpha and Omega Semiconductor (AOSL)
CSS Industries Inc (CSS)
Ducommun Incorporated (DCO)
Ennis
0.13960
0.61063
First company
NIA
4
0.23226
Second company
#NIA
0.78282
0.68366
Third company
6.
Five Star Quality Care
Flexsteel Industries
9 Hardinge Inc. (HDNG)
10 Hooker Furniture Corporation (HOFT)
International Shipholding Corp (ISH)
12 Key Tronic Corporation (KTCC)
13
#NIA
7.
0.27703
0.31076
Fourth company
8.
INIA
0.32452
0.03940
0 49839
0 05497
Fh company
#NIA
11
Kimball International Inc (KBALB)
14 LMI Aerospace
0.65750
0.44524
0.86284
0 45184
0.96920
15
Marlin Business Services Corp. (MRLN)
16 Medical Action Industries (MDCI)
17 Mitcham Industries
18 Olympic Steel
19 PC Connection
20 PCM Inc (PCMI)
21 RCM Technologies
22 Renewable Energy Group Inc (REGI)
0.94848
0.39724
0.92284
0 05985
0.77966
A Data
Calculation Mode Automatic
Workbook Statistics
O Type here to search
行
Transcribed Image Text:Excel template - Saved P Sealch (At Q) File Home Insert Draw Formulas Data Review View Help O Editing v BE v A Arial v 10 ... General C2 F G Random 1. Company (Ticker) Number Formula Used Alamo Group Alpha and Omega Semiconductor (AOSL) CSS Industries Inc (CSS) Ducommun Incorporated (DCO) Ennis 0.13960 0.61063 First company NIA 4 0.23226 Second company #NIA 0.78282 0.68366 Third company 6. Five Star Quality Care Flexsteel Industries 9 Hardinge Inc. (HDNG) 10 Hooker Furniture Corporation (HOFT) International Shipholding Corp (ISH) 12 Key Tronic Corporation (KTCC) 13 #NIA 7. 0.27703 0.31076 Fourth company 8. INIA 0.32452 0.03940 0 49839 0 05497 Fh company #NIA 11 Kimball International Inc (KBALB) 14 LMI Aerospace 0.65750 0.44524 0.86284 0 45184 0.96920 15 Marlin Business Services Corp. (MRLN) 16 Medical Action Industries (MDCI) 17 Mitcham Industries 18 Olympic Steel 19 PC Connection 20 PCM Inc (PCMI) 21 RCM Technologies 22 Renewable Energy Group Inc (REGI) 0.94848 0.39724 0.92284 0 05985 0.77966 A Data Calculation Mode Automatic Workbook Statistics O Type here to search 行
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Application of Algebra
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman