Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Vides Morningstar publishes information on 1208 company stocks. A sample of 40 of these stocks is contained in the Excel Online file below. Construct a
Vides 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. Ito 2 decimals) c. Develop a polnt estimate of the proportion of the Morningstar stocks that are rated 3 Stars or less. (to 2 decimals) Check My Work Reset Problem General v G2 A 00 00 2.0 E al Formatting G Sample Size Formula Used #N/A 5 Number of Stocks (Rating of 5 Stars) SOL #NIA Point Estimate (Rating of 5 Stars) ENIA Number of Stocks (Low Business Risk) Point Estimate (Low Business Risk) #N/A Number of Stocks (Rating of 3 Stars or Less) #N/A Point Estimate (Rating of 3 Stars or Less) #NIA B Company Morningstar Rating Business Risk 2 Ameren Corp 4 Star High 3 Apple Inc 3 Star Low At&T Inc 3 Star Average Bank of New York Mellon Corp 2 Star Very Low BlackRack Inc 4 Star Average 7 Buckeye Partners 3 Star Very Low B Cardinal Health Inc 5 Star High 9 CenturyLink Inc 5 Star Average -10 Cintas Corporation 4 Star Low 11 Colgate Palmolive Company 1 Star Average 12. Corning Inc 5 Star Low 13 Darden Restaurants Inc 4 Star High 14 Discover Financial Services 3 Star Low 15 eBay Inc 5 Star Average 16 Endo Health Solutions 4 Star Average 17 Fair Isaaac Corp 3 Star Low 18 Fluor Corp 5 Star Very Low 19. Gentex Corporation 5 Star High 20 Group 1 Automotive Inc 2 Star Average 21 Hess Corp 2 Star Very Low 22 Icon PLC 3 Star Low 23 International Flavors & Fragrances 5 Star Low 24 John Wiley & Sons, Inc. 1 Star LOW 25 Knight Transportation, Inc. 1 Star Average 26 Life Technologies corp 5 Star High 27 Marvell Technology Group, Ltd 3 Star Low 28 Methanex Corporation 5 Star 29 Mylan Inc 5 Star Average 30 New York Times Company 2 Star Low 31 OfficeMax Inc 5 Star Very Low 22 Owens-Corning Inc. 5 Star Average 33 Polaris Industries Inc 4 Star Low 34 Rio Tinto PLC 2 Star Low 35 Sempra Energy 2 Star High 16 Stifel Financial Corp 2 Star Low Texas Instruments, Inc. 5 Star High United Technologies Corp 2 Star High Weight Watchers International, Inc. 2 Star Average DWR Berkley Corp 4 Star High Yum Brands Inc 1 Star Very Low Low e Data - oro Automatic Workbook 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