Here are the profit for 50 companies I have so far from Fortune 1000 website.
Find profit or loss of 50 companies. Calculate the population parameters for all 50 companies profit or loss Select a sample of 10 Calculate the point estimators of the sample Compare the results (Point estimators with Pop. Parameters) Use RandBetween command or Ch. 7 Random number table to select your samples Your work should include: 1. The name of all companies 2. List of all companies profit/loss 3. List of your sample 4. Point estimators and population parameters, for Pop. Proportion use those who have less than a certain value of profit/loss. This project is due on or before 5/6/20 (MW), 5/7/20 (TTH). Some suggested websites to get the info: Money Magazine Fortune 1000 Help Excel File Edit View Insert Format Tools Data Window . AutoSave ONIO ES U . Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 12 - AA == = Tell me 360 X fx 9 Company 10 1. Walmart 11 2. Exxon Mobil 12 3. Apple 13 4. Berkshire Hathaway 14 5. Amazon.com 15 6. United Health Group 16 7.McKesson 17 8. CVS Health 18 9. AT&T 19 10. AmerisourceBergen 20 11. Chevron 21 12. Ford Motor 22 13. General Motors 23 14. Costco Wholesale 24 15. Alphabet 25 16. Cardinal Health 26 17. Walgreens Boots Alliance 27 18. JPMorgan Chase 28 19. Verizon Communications 29 20. Kroger 30 21. General Electric 31 22. Fannie Mae 32 23. Phillips 66 33 24. Valero Energy 34 25. Bank of America Sheet1 + Ready Profit $6,670.0 $20,840.0 $59,531.0 $4,021.0 $10,073.0 $11,986.0 $67.0 -$594.0 $19,370.0 $1,658.4 $14,824.0 $3,677.0 $8,014.0 $3,134.0 $30,736.0 $256.0 $5,024.0 $32,474.0 $15,528.0 $3,110.0 -$22,355.0 $15,959.0 $5,595.0 $3,122.0 $28,147.0 Tools Data Window Help Excel File Edit View Insert Format AutoSave ON S U . Home Insert Draw Page Layout Formulas Calibri (Body) 12 A A Paste BLUE LA E Data View Review = Tell me 20 S B60 35 26. Microsoft 36 27. Home Depot 37 28. Boeing 38 29. Wells Fargo 39 30. Citigroup 40 31. Marathon Petroleum 41 32. Comcast 42 33. Anthem 43 34. Dell Technologies 44 35. DuPont de Nemours 45 36. State Farm Insurance 46 37. Johnson & Johnson 47 38. IBM 48 39. Target 49 40. Freddie Mac 50 41. United Parcel Service 51 42. Lowe's 52 43. Intel 53 44. MetLife 54 45. Procter & Gamble 55 46. United Technologies 56 47. FedEx 57 48. PepsiCo 58 49. Archer Daniels Midland 59 50. Prudential Financial 60 $16,571.0 $11,121.0 $10,460.0 $22,393.0 $18,045.0 $2,780.0 $11,731.0 $3,750.0 -$2,310.0 $3,844.0 $8,788.4 $15,297.0 $8,728.0 $2,937.0 $9,235.0 $4,791.0 $2,314.0 $21,053.0 $5,123.0 $9,750.0 $5,269.0 $4,572.0 $12,515.0 $1,810.0 $4,074.0 Sheet1 Ready OA Find profit or loss of 50 companies. Calculate the population parameters for all 50 companies profit or loss Select a sample of 10 Calculate the point estimators of the sample Compare the results (Point estimators with Pop. Parameters) Use RandBetween command or Ch. 7 Random number table to select your samples Your work should include: 1. The name of all companies 2. List of all companies profit/loss 3. List of your sample 4. Point estimators and population parameters, for Pop. Proportion use those who have less than a certain value of profit/loss. This project is due on or before 5/6/20 (MW), 5/7/20 (TTH). Some suggested websites to get the info: Money Magazine Fortune 1000 Help Excel File Edit View Insert Format Tools Data Window . AutoSave ONIO ES U . Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 12 - AA == = Tell me 360 X fx 9 Company 10 1. Walmart 11 2. Exxon Mobil 12 3. Apple 13 4. Berkshire Hathaway 14 5. Amazon.com 15 6. United Health Group 16 7.McKesson 17 8. CVS Health 18 9. AT&T 19 10. AmerisourceBergen 20 11. Chevron 21 12. Ford Motor 22 13. General Motors 23 14. Costco Wholesale 24 15. Alphabet 25 16. Cardinal Health 26 17. Walgreens Boots Alliance 27 18. JPMorgan Chase 28 19. Verizon Communications 29 20. Kroger 30 21. General Electric 31 22. Fannie Mae 32 23. Phillips 66 33 24. Valero Energy 34 25. Bank of America Sheet1 + Ready Profit $6,670.0 $20,840.0 $59,531.0 $4,021.0 $10,073.0 $11,986.0 $67.0 -$594.0 $19,370.0 $1,658.4 $14,824.0 $3,677.0 $8,014.0 $3,134.0 $30,736.0 $256.0 $5,024.0 $32,474.0 $15,528.0 $3,110.0 -$22,355.0 $15,959.0 $5,595.0 $3,122.0 $28,147.0 Tools Data Window Help Excel File Edit View Insert Format AutoSave ON S U . Home Insert Draw Page Layout Formulas Calibri (Body) 12 A A Paste BLUE LA E Data View Review = Tell me 20 S B60 35 26. Microsoft 36 27. Home Depot 37 28. Boeing 38 29. Wells Fargo 39 30. Citigroup 40 31. Marathon Petroleum 41 32. Comcast 42 33. Anthem 43 34. Dell Technologies 44 35. DuPont de Nemours 45 36. State Farm Insurance 46 37. Johnson & Johnson 47 38. IBM 48 39. Target 49 40. Freddie Mac 50 41. United Parcel Service 51 42. Lowe's 52 43. Intel 53 44. MetLife 54 45. Procter & Gamble 55 46. United Technologies 56 47. FedEx 57 48. PepsiCo 58 49. Archer Daniels Midland 59 50. Prudential Financial 60 $16,571.0 $11,121.0 $10,460.0 $22,393.0 $18,045.0 $2,780.0 $11,731.0 $3,750.0 -$2,310.0 $3,844.0 $8,788.4 $15,297.0 $8,728.0 $2,937.0 $9,235.0 $4,791.0 $2,314.0 $21,053.0 $5,123.0 $9,750.0 $5,269.0 $4,572.0 $12,515.0 $1,810.0 $4,074.0 Sheet1 Ready OA
