Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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).
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) Second company and smallest random number) Type here to search 9:07 PM 5/2/2021 DLL 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) Second company (2nd smallest random number) Third company (3rd smallest random number) Fourth company (4th smallest random number) Fifth company (5th smallest random number) Type here to search 1 a 9:07 PM 5/2/2021 First company mula Used #N/A Second company #N/A Third company #N/A Fourth company Fifth company #N/A 1 Company (Ticker) 2 Alamo Group 3 Alpha and Omega Semiconductor (AOSL) 4 CSS Industries Inc (CSS) 5 Ducommun Incorporated (DCO) 6 Ennis 7 Five Star Quality Care 8 Flexsteel Industries 9 Hardinge Inc (HDNG) 1o Hooker Furniture Corporation (HOFT) 11 International Shipholding Corp (ISH) 12 Key Tronic Corporation (KTCC) 13 Kimball Interational Inc (KBALB) 14 LMI Aerospace 15 Marlin Business Services Corp. (MRLN) 16 Medical Action Industries (MDCI) 17 Mitcham Industries 18 Olympic Steel 19 PC Connection 20 PCM Inc PCMI) RCM Technologies 22 Renewable Energy Group Inc (REGI) 23 REX American Resources Corp (REX) Random Number 0.52790 0.95504 0.05210 0.32776 0.72769 0.93264 0.86040 0.42464 0.76505 0.91923 0.43415 0.78588 0.72055 0.22676 0.50244 0.18694 0.47625 0.60198 0 05149 0.65486 0 33746 0.87347 B Data + Calculator de Stats A E Fourth company #N/A Fifth company #N/A Flexsteel Industries Hardinge Inc. (HDNG) Hooker Furniture Corporation (HOFT) 1 International Shipholding Corp (ISH) 2 Key Tronic Corporation (KTCC) 3 Kimball International Inc (KBALB) 14. LMI Aerospace Marlin Business Services Corp. (MRLN) 16 Medical Action Industries (MDCI) 17 Mitcham Industries 18 Olympic Steel 19 PC Connection 20 PCM Inc (PCMI) RCM Technologies 22 Renewable Energy Group Inc (REGI) 23 REX American Resources Corp (REX) 24. Rocky Brands Inc (RCKY) 25 SigmaTron International (SGMA) Salem Communications Corp (SALM) Shoe Carnival Standard Motor Products TravelCenters of America LLC (TA) 30 VOXX International Corp (VOXX) Willis Lease Finance Corporati (WLFC) 0.86040 0.42464 0.76505 0.91923 0.43415 0.78588 0.72055 0.22676 0.50244 0 18694 047625 0.60198 0.05149 0.65486 0.33746 0 87347 0.98923 0.29592 0.37576 0.65480 0.01156 0_62283 0.76829 0.93024 A Data + Calculation Mode: Automatic Workocok Statistics
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started