ft Excel: Structured Activity Section 7.2 Selecting a Sample Q Search this cours Video Jack Lawler, a financial analyst, wants to prepare an article on the Shadow Stock portfolio developed by the American Association of Individual Investors (AAI). 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 3 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) b. If you were to create your own spreadsheet like the one above and assign random numbers to each observation for sampling purposes, in which column would those random numbers be placed? B und the five smallest random numbers in your spreadsheet, is it likely you would get the the same sample of companies as in part (a)? . Next Back Headings Keep Exit New EO Editing ding View D ant Views View Gridlines New Freeze Window Panes Window Sheet View Show E2 D F G First company Formula Used #N/A Second company #NA Third company #N/A Fourth company NA Fifth company #N/A 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. (HONG) 10 Hooker Furniture Corporation (HOFT) 11 International Shipholding Corp (ISH) 12 Key Tronic Corporation (KTCC) 13 Kimball International Inc (KBALB) 14 LMI Aerospace 15 Martin 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) 23 REX American Resources Corp (REX) 24 Rocky Brands Inc (RCKY) 25 Sigma Tron International (SGMA) 26 Salem Communications Corp (SALM) 27 Shoe Carnival 28 Standard Motor Products B Random Number 043168 0.81128 0.69385 0.05902 0.78315 0.88506 0.92273 0.51871 0.32545 0.64289 0.74005 0.62431 0.93637 0.17513 0.44250 0.04283 0.92729 0.76362 0.65049 0.97406 0.20289 0.50112 0.05933 0.71276 0.21396 0.76451 0.95607 Data o Calculation Mode: Automatic Workbook Statistics Keep Exit w Options Editing Reading View View Document views Headings New Freeze Gridines Window Panes Window Show Sheet View E2 E F D Fifth company G WNIA 10 Hooker Furniture Corporation (HOFT) 11 International Shipholding Corp (ISH) 12 Key Tronic Corporation (KTCC) 13 Kimball International 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) 21 RCM Technologies 22 Renewable Energy Group Inc (REGI) 23 REX American Resources Corp (REX) 24 Rocky Brands Inc (RCKY) 25 Sigma Tron International (SGMA) 26 Salem Communications Corp (SALM) 27 Shoe Carnival 28 Standard Motor Products 29 TravelCenters of America LLC (TA) 30 VOXX International Corp (VOXX) 31 Willis Lease Finance Corporati (WLFC) 32 33 34 35 36 37 38 0.32545 0.64289 0.74005 0.62431 0.93637 0.17513 0.44250 0.04283 0.92729 0.76362 0.65049 0.97406 0.20289 0.50112 0.05933 0.71276 0.21396 0.76451 0.95607 0.32472 0.38703 0.46469 an Data Anar Altmatic Workbook Statistics ft Excel: Structured Activity Section 7.2 Selecting a Sample Q Search this cours Video Jack Lawler, a financial analyst, wants to prepare an article on the Shadow Stock portfolio developed by the American Association of Individual Investors (AAI). 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 3 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) b. If you were to create your own spreadsheet like the one above and assign random numbers to each observation for sampling purposes, in which column would those random numbers be placed? B und the five smallest random numbers in your spreadsheet, is it likely you would get the the same sample of companies as in part (a)? . Next Back Headings Keep Exit New EO Editing ding View D ant Views View Gridlines New Freeze Window Panes Window Sheet View Show E2 D F G First company Formula Used #N/A Second company #NA Third company #N/A Fourth company NA Fifth company #N/A 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. (HONG) 10 Hooker Furniture Corporation (HOFT) 11 International Shipholding Corp (ISH) 12 Key Tronic Corporation (KTCC) 13 Kimball International Inc (KBALB) 14 LMI Aerospace 15 Martin 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) 23 REX American Resources Corp (REX) 24 Rocky Brands Inc (RCKY) 25 Sigma Tron International (SGMA) 26 Salem Communications Corp (SALM) 27 Shoe Carnival 28 Standard Motor Products B Random Number 043168 0.81128 0.69385 0.05902 0.78315 0.88506 0.92273 0.51871 0.32545 0.64289 0.74005 0.62431 0.93637 0.17513 0.44250 0.04283 0.92729 0.76362 0.65049 0.97406 0.20289 0.50112 0.05933 0.71276 0.21396 0.76451 0.95607 Data o Calculation Mode: Automatic Workbook Statistics Keep Exit w Options Editing Reading View View Document views Headings New Freeze Gridines Window Panes Window Show Sheet View E2 E F D Fifth company G WNIA 10 Hooker Furniture Corporation (HOFT) 11 International Shipholding Corp (ISH) 12 Key Tronic Corporation (KTCC) 13 Kimball International 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) 21 RCM Technologies 22 Renewable Energy Group Inc (REGI) 23 REX American Resources Corp (REX) 24 Rocky Brands Inc (RCKY) 25 Sigma Tron International (SGMA) 26 Salem Communications Corp (SALM) 27 Shoe Carnival 28 Standard Motor Products 29 TravelCenters of America LLC (TA) 30 VOXX International Corp (VOXX) 31 Willis Lease Finance Corporati (WLFC) 32 33 34 35 36 37 38 0.32545 0.64289 0.74005 0.62431 0.93637 0.17513 0.44250 0.04283 0.92729 0.76362 0.65049 0.97406 0.20289 0.50112 0.05933 0.71276 0.21396 0.76451 0.95607 0.32472 0.38703 0.46469 an Data Anar Altmatic Workbook Statistics