LTI Launch C Mind Tap Cengage Learning Work Hours Calculator + ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=59965222022380235386256775&elSBN=9780357131596&id=1715664241&snapshotId=3336166& h M Gmail YouTube Q Quiz+ | Search res... Citation Machine... C Home | Chegg.com Courses south tex... RentCafe Residen... Sportsurge Underdog Fantasy... Careers Mutual Of... CENGAGE | MINDTAP Q Search this course ? 7.2 Excel Activity 2a - Random Sample Selection (Structured) Question 1 ? 0/10 Submit 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. X 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) 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? If you found the five smallest random numbers in your spreadsheet, is it likely you would get the the same sample of companies as in part (a)? Back Check My Work Reset Problem Next A+ e A-Z Office LTI Launch Mind Tap - Cengage Learning Excel Online Student Work Work Hours Calculator + h Courses south tex... RentCafe Residen... Sportsurge Underdog Fantasy... Careers Mutual Of... C about:blank M Gmail YouTube Quiz+ | Search res... Citation Machine... C Home | Chegg.com Excel template - Saved Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Arial 10 B ab Number E2 fx AA G H A B C D E F Random 12345 Company (Ticker) Number Formula Used Alamo Group 0.70753 First company #N/A Alpha and Omega Semiconductor (AOSL) 0.87751 CSS Industries Inc (CSS) 0.05947 Second company #N/A Ducommun Incorporated (DCO) 0.90062 6 Ennis 0.96778 Third company #N/A 7 Five Star Quality Care 0.43656 8 Flexsteel Industries 0.30476 Fourth company #N/A 9 Hardinge Inc. (HDNG) 0.78963 10 Hooker Furniture Corporation (HOFT) 0.24669 Fifth company #N/A 11 International Shipholding Corp (ISH) 0.93203 12 Key Tronic Corporation (KTCC) 0.69581 13 Kimball International Inc (KBALB) 0.90293 14 LMI Aerospace 0.64830 15 Marlin Business Services Corp. (MRLN) 0.95101 16 Medical Action Industries (MDCI) 0.77151 17 Mitcham Industries 0.50605 19 PC Connection 21 RCM Technologies 18 Olympic Steel 20 PCM Inc (PCMI) 22 Renewable Energy Group Inc (REGI) 0.05229 0.02870 0.46672 0.38088 0.26330 23 REX American Resources Corp (REX) 0.11701 24 Rocky Brands Inc (RCKY) 0.67608 25 SigmaTron International (SGMA) 0.83052 26 Salem Communications Corp (SALM) 0.71903 27 Shoe Carnival 0.75763 28 Standard Motor Products 0.32362 29 TravelCenters of America LLC (TA) 30 VOXX International Corp (VOXX) 31 Willis Lease Finance Corporati (WLFC) 0.62956 0.44204 0.51204 32 Data Sheet1 + Calculation Mode: Automatic Workbook Statistics 0 .00 .00 0 Comments v v v ... J K L M N Give Feedback to Microsoft - 100% + LTI Launch Mind Tap Cengage Learning C ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=59965222022380235386256775&elSBN=9780357131596&snapshotld=3336166&id=1715664248& h M Gmail YouTube Q Quiz+ | Search res... Citation Machine... C Home | Chegg.com Courses south tex... RentCafe Residen... Sportsurge Underdog Fantasy... Careers Mutual Of... CENGAGE | MINDTAP Q Search this course ? 7.3 Excel Activity 1a - Point Estimates for Proportions (Structured) Question 1 0/10 Submit Video Morningstar publishes information on 1208 company stocks. A sample of 40 of these stocks is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. X ? Open spreadsheet a. Develop a point estimate of the proportion of the stocks that receive Morningstar's highest rating of 5 Stars. (to 2 decimals) b. Develop a point estimate of the proportion of the Morningstar stocks that are rated low with respect to business risk. (to 2 decimals) c. Develop a point estimate of the proportion of the Morningstar stocks that are rated 3 Stars or less. (to 2 decimals) Check My Work Reset Problem Back Next Co A-Z Office A+ LTI Launch Mind Tap - Cengage Learning Excel Online Student Work C about:blank M Gmail Excel template - Saved YouTube Quiz+ | Search res... Citation Machine... C Home | Chegg.com h Courses south tex... RentCafe Residen... Sportsurge Underdog Fantasy... Careers Mutual Of... Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments Arial 10 B ab General AA 0 .00 .00 0 ... G2 fx A B C D E F G H J K L M N 123 + 4 Company Ameren Corp Apple Inc At&T Inc Morningstar Rating Business Risk Formula Used 2 Star High Sample Size #N/A 2 Star Low 2 Star High Number of Stocks (Rating of 5 Stars) #N/A 56 Bank of New York Mellon Corp 5 Star High BlackRock Inc 3 Star Average 7 Buckeye Partners 1 Star Low 8 Cardinal Health Inc 4 Star High Point Estimate (Rating of 5 Stars) Number of Stocks (Low Business Risk) #N/A #N/A 9 CenturyLink Inc 2 Star High 10 Cintas Corporation 2 Star High Point Estimate (Low Business Risk) #N/A 11 Colgate-Palmolive Company 3 Star High 12 Corning Inc 1 Star Low Number of Stocks (Rating of 3 Stars or Less) #N/A 13 Darden Restaurants Inc 5 Star Low 14 Discover Financial Services 1 Star Low Point Estimate (Rating of 3 Stars or Less) #N/A 15 eBay Inc 3 Star Very Low 16 Endo Health Solutions 4 Star Very Low 17 Fair Isaaac Corp 5 Star Low 18 Fluor Corp 2 Star High 19 Gentex Corporation 5 Star High 20 Group 1 Automotive Inc 4 Star Low 21 Hess Corp 5 Star Low 22 Icon PLC 1 Star Low 23 International Flavors & Fragrances 5 Star Average 24 John Wiley & Sons, Inc. 3 Star Average 25 Knight Transportation, Inc. 5 Star High 26 Life Technologies corp 4 Star 27 Marvell Technology Group, Ltd. 3 Star 28 Methanex Corporation 3 Star 29 Mylan Inc 4 Star 30 New York Times Company 5 Star 31 OfficeMax Inc 5 Star 32 Owens-Corning, Inc. 4 Star Low Very Low Average High High Very Low Average 33 Polaris Industries, Inc. 5 Star High 34 Rio Tinto PLC 5 Star Low 35 Sempra Energy 3 Star Low 36 Stifel Financial Corp. 3 Star 37 Texas Instruments, Inc. 1 Star Low 38 United Technologies Corp 5 Star Average Very Low 39 Weight Watchers International, Inc. 4 Star Low 40 WR Berkley Corp 5 Star Low 41 Yum Brands Inc 2 Star Average Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 80% + P