Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance A Practical Perspective

Authors: Adrian Buckley

1st Edition

0273731866, 9780273731863

More Books

Students also viewed these Accounting questions

Question

How have psychologists and others confounded sex and gender?

Answered: 1 week ago