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 Carnival0.93049 Standard Motor Products0.74160 TravelCenters of America LLC (TA)0.62555 VOXX International Corp (VOXX)0.86738 Willis Lease Finance Corporati (WLFC)0.42914 3586ISHN 97803574226708id 11431018288snapshotld32336877&MINDTAPQ Search this com:Structured ActivityI VideoJack Lawler, a financial analyst, wants to prepare an article on the Shadow Stock portfolio developed by the American Association ofIndividual Investors (AAII). A list of the 30 companies in the Shadow Stock portfolio as of March is contained in the Excel Online filebelow. Use the spreadsheet to answer the following questions.Open spreadsheetJack 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 randomnumber for each of the companies. Use these random numbers to select a simple random sample of 5 of these companies for Jack byfinding 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.04123Second company (2nd smallest random number) 0.05743Third company (3rd smallest random number) 0.05894Fourth company (4th smallest random number) 0 15106Fifth company (5th smallest random number) 0.23796BackNext Exceltemplate - SavedP Sealch (At Q)FileHomeInsertDrawFormulasDataReviewViewHelpO Editing vBE v AArialv 10...GeneralC2FGRandom1.Company (Ticker)NumberFormula UsedAlamo GroupAlpha and Omega Semiconductor (AOSL)CSS Industries Inc (CSS)Ducommun Incorporated (DCO)Ennis0.139600.61063First companyNIA40.23226Second company#NIA0.782820.68366Third company6.Five Star Quality CareFlexsteel Industries9 Hardinge Inc. (HDNG)10 Hooker Furniture Corporation (HOFT)International Shipholding Corp (ISH)12 Key Tronic Corporation (KTCC)13#NIA7.0.277030.31076Fourth company8.INIA0.324520.039400 498390 05497Fh company#NIA11Kimball International Inc (KBALB)14 LMI Aerospace0.657500.445240.862840 451840.9692015Marlin Business Services Corp. (MRLN)16 Medical Action Industries (MDCI)17 Mitcham Industries18 Olympic Steel19 PC Connection20 PCM Inc (PCMI)21 RCM Technologies22 Renewable Energy Group Inc (REGI)0.948480.397240.922840 059850.77966A DataCalculation Mode AutomaticWorkbook StatisticsO Type here to search行

Name: REX American Resources Corp (REX)0.72831 Rocky Brands Inc (RCKY)0.7923
Uploaded: 2024-03-05T11:52:21.000Z
Channel: Bartleby
Description: 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 Carnival0.93049 Standard Motor Products0.74160 TravelCenters of America LLC (TA)0.62555 VOXX In

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 Carnival0.93049 Standard Motor Products0.74160 TravelCenters of America LLC (TA)0.62555 VOXX International Corp (VOXX)0.86738 Willis Lease Finance Corporati (WLFC)0.42914 3586ISHN 97803574226708id 11431018288snapshotld32336877&MINDTAPQ Search this com:Structured ActivityI VideoJack Lawler, a financial analyst, wants to prepare an article on the Shadow Stock portfolio developed by the American Association ofIndividual Investors (AAII). A list of the 30 companies in the Shadow Stock portfolio as of March is contained in the Excel Online filebelow. Use the spreadsheet to answer the following questions.Open spreadsheetJack 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 randomnumber for each of the companies. Use these random numbers to select a simple random sample of 5 of these companies for Jack byfinding 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.04123Second company (2nd smallest random number) 0.05743Third company (3rd smallest random number) 0.05894Fourth company (4th smallest random number) 0 15106Fifth company (5th smallest random number) 0.23796BackNext Exceltemplate - SavedP Sealch (At Q)FileHomeInsertDrawFormulasDataReviewViewHelpO Editing vBE v AArialv 10...GeneralC2FGRandom1.Company (Ticker)NumberFormula UsedAlamo GroupAlpha and Omega Semiconductor (AOSL)CSS Industries Inc (CSS)Ducommun Incorporated (DCO)Ennis0.139600.61063First companyNIA40.23226Second company#NIA0.782820.68366Third company6.Five Star Quality CareFlexsteel Industries9 Hardinge Inc. (HDNG)10 Hooker Furniture Corporation (HOFT)International Shipholding Corp (ISH)12 Key Tronic Corporation (KTCC)13#NIA7.0.277030.31076Fourth company8.INIA0.324520.039400 498390 05497Fh company#NIA11Kimball International Inc (KBALB)14 LMI Aerospace0.657500.445240.862840 451840.9692015Marlin Business Services Corp. (MRLN)16 Medical Action Industries (MDCI)17 Mitcham Industries18 Olympic Steel19 PC Connection20 PCM Inc (PCMI)21 RCM Technologies22 Renewable Energy Group Inc (REGI)0.948480.397240.922840 059850.77966A DataCalculation Mode AutomaticWorkbook StatisticsO Type here to search行

Accepted Answer

The random numbers from the first five companies are given as:

Company
Random Number

Alamo…

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