QUANTITATIVE ANALYSIS homework
qwerty12345
AdmiredCompanies.xlsxData
| Rank | Company Name | Return |
| 1 | Apple | 14.8 |
| 2 | Amazon.com | 29.8 |
| 3 | 49.3 | |
| 4 | Berkshire Hathaway | 11.7 |
| 5 | Starbucks | 27.1 |
| 6 | Coca-Cola | 1.4 |
| 7 | Walt Disney | 33.8 |
| 8 | FedEx | 24.4 |
| 9 | Southwest Airlines | 84.5 |
| 10 | General Electric | 12.3 |
| 11 | American Express | 39.6 |
| 12 | Costco Wholesale | 8.1 |
| 13 | Nike | 32.8 |
| 14 | BMW | 15.1 |
| 15 | Procter & Gamble | 4.1 |
| 16 | IBM | -12.4 |
| 17 | Nordstrom | 5.8 |
| 18 | Singapore Airlines | -13.9 |
| 19 | Johnson & Johnson | 20.5 |
| 20 | Whole Foods Market | 13 |
| 21 | Samsung Electronics | -12.9 |
| 22 | McDonald's | 1.8 |
| 23 | 3M | 28.3 |
| 24 | Microsoft | 34.2 |
| 25 | Toyota Motor | 31.3 |
| 26 | Boeing | 63.2 |
| 27 | Exxon Mobil | 2.5 |
| 28 | Wal-Mart Stores | 5.5 |
| 29 | Target | -9.6 |
| 30 | J.P. Morgan Chase | 16.3 |
| 31 | Nestlé | 5.7 |
| 32 | UPS | 19.3 |
| 33 | Caterpillar | -4 |
| 33 | Goldman Sachs Group | 8 |
| 35 | Wells Fargo | 30.6 |
| 36 | Volkswagen | 6.1 |
| 37 | Unilever | -7.3 |
| 38 | 117.1 | |
| 39 | Marriott International | 21.7 |
| 40 | Home Depot | 15.7 |
| 41 | BlackRock | 24.2 |
| 42 | PepsiCo | 11.7 |
| 43 | DuPont | 34.3 |
| 44 | eBay | -5.1 |
| 45 | Accenture | 8.3 |
| 46 | Deere | -7.1 |
| 47 | Intel | 15.3 |
| 48 | Delta Air Lines | 116.6 |
| 49 | Cisco Systems | 7.4 |
| 50 | AT&T | -4.5 |
_STDS_DG140B10F5
| Name | Data Set #1 | StatTools Version that generated sheet, Major | 6 | StatTools Version that generated sheet, Minor | 1 | StatTools Version that generated sheet, Revision | 1 | Min. StatTools Version to Read Sheet, Major (note ST versions before 1.1.1 don't perform forward compatibility check) | 1 | Min. StatTools Version to Read Sheet, Minor | 0 | Min. StatTools Version to Read Sheet, Revision | 0 | Min. StatTools version to not put up warning about extra info, Major | 1 | Min. StatTools version to not put up warning about extra info, Minor | 0 | Min. StatTools version to not put up warning about extra info, Revision | 0 |
| GUID | DG140B10F5 | ||||||||||||||||||
| Format Range | FALSE | ||||||||||||||||||
| Variable Layout | Columns | ||||||||||||||||||
| Variable Names In Cells | TRUE | ||||||||||||||||||
| Variable Names In 2nd Cells | TRUE | ||||||||||||||||||
| Data Set Ranges | ERROR:#REF! | ||||||||||||||||||
| Data Sheet Format | 1 | ||||||||||||||||||
| Formula Eval Cell | 1 | ||||||||||||||||||
| Num Stored Vars | 5 | ||||||||||||||||||
| 1 : Info | VGEF05AB223BFB7F5 | var1 | ST_Listrank | TRUE | 0 | 4 | |||||||||||||
| 1 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 1 : MultiRefs | |||||||||||||||||||
| 2 : Info | VG2A827321227291A1 | var2 | ST_CompanyName | TRUE | 0 | 4 | |||||||||||||
| 2 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 2 : MultiRefs | |||||||||||||||||||
| 3 : Info | VG123F997B145CFFBE | var3 | ST_Location | TRUE | 0 | 4 | |||||||||||||
| 3 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 3 : MultiRefs | |||||||||||||||||||
| 4 : Info | VGBAADE31544D788 | var4 | ST_Score | TRUE | 0 | 4 | |||||||||||||
| 4 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 4 : MultiRefs | |||||||||||||||||||
| 5 : Info | VGB6847B9101AC9A6 | var5 | ST_Return | TRUE | 0 | 4 | |||||||||||||
| 5 : Ranges | ERROR:#REF! | ||||||||||||||||||
| 5 : MultiRefs |
