Question


Revenues for the top Global 500 companies in 2014 Revenues Company Name Wal-Mart Stores Sinopec Group Revenues (Sb) 181.2 172.3 Company Name 485.7 McKesson 446.8 Daimler 431.3 ndustrial Commercial Bank o Royal Dutch Shell China National Petroleunm ExxonMobil BP State Grid Volkswagen Toyota Motor Glencore Total Chevron Samsung Electronics 195.8 Berkshire Hathaway Apple 163.2 China 428.6 Exor Group 382.6 AXA 58.7 General Motors 339.4 E.On 268.6 Phillips 66 247.7 General Electric 221.0 ENI 212.0 Gazprom 203.8 Ford Motor 162.1 161.2 155.9 151.5 149.4 148.3 147.2 144.4 144.1 143.7 139.9 139.4 Petrobras 194.7 China Construction Bank 182.8 CVS Health To access the complete data set, click the link for your preferred software format:
stion 14 of 18 Attempt ! (a) Use the software of your choice to calculate the five-number summary, Enter your answers rounded to one place.) Min 130.7 146.9 Median169.6 0 267.4 Max 479.5 Explain why this summary suggests that this distribution is right-skewed. Select the correct explanation. The first quartile is farther below the median than the third quartile is above the median O The third quartile is farther above the median than the first quartile is below the median. The first and third quartiles are equally distant from the median
on 14 of 18> O The first quartile is farther below the median than the third quartile is above the median. O The third quartile is farther above the median than the first quartile is below the median 。The first and third quartiles are equally distant from the median. b) Which companies are outliers according to the 1.5 x 1OR rule? Calculate the IQR, and 1.5 x IOR. (Enter your answer rounded to one decimal place.) IQR 120.5 1.5 x 1OR180.75 How many companies are outliers according to the 1.5 IOR rule? (Enter your answers as whole numbers.) low outliers: 0 high outliers: 3 Revenues for the Global 500 companies can be found at fortune.com/global500/
0 0
Add a comment Improve this question Transcribed image text
Answer #1

As mentioned above in the question, 500 global fortune companies are considered for preparing five number summaries. But in the question as mentioned only 30 companies revenue. so considering only available data of 30 companies , i had prepared five number summary and placing the results

AutoSa Copy of 5numbersummary-boxplot-outliers.xlsx - Excel File Home Insert Page Layout Formulas Data Review View Developer Help Power Pivot Analysis Prabhu Tell me what yo Wrap Text t 의 Merge & Center ▼ $ ▼ % , Minion Pro11A A Number Normal E Copy Paste B 1 u ▼ ww ▼ O.. 트, 00Conditional Format as Neutral Format Painter Formatting Table- Clipboard Font Alignment Number D18 1 Data 485.7 446.8 Min 431.3 Q1 428.6 Median (Q2 382.6 Q3 358.7 Max 339.4 268.6 247.7 Box1 Hidden 5 Numbers Summa 139.4 149.9 182.0 263.4 485.7 Box-and - Whisker 600.0 Boxplot 149.9 32.1 81.4 10 221 Box2 lower 12 13 212 Box3- upper 203.8 195.8 Whiser Top 194.7 Whisker Bottom 182.8 181.2 172.3 163 162.1 161 155.9 IQ 151.5 1.5 iqr 149.4 148.3 147 144.4 144.1 143 139.9 139.4 222.3 10.5 16 100.0 18 0.0 Boxplot 20 21 Outliers 113.5 170.2 23 24 25 27 28 29 30 32

formula reference:

AutoSave off Copy of 5numbersummary-boxplot-outliers File Home Insert Page Layout Formulas Data Review View Developer Help Power Pivot Analysis Prabhu Tell Define Name Use in Formula Create from Selection Trace Precedents Trace Dependents Remove Arrows Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Manage Function Used Time-Reference- Trig. Functions Function Library Defined Names Formu D18 1 Data 2 485.7 3 446.8 4 431.3 5 428.6 6 382.6 7 358.7 8 339.4 9 268.6 10 247.7 11 221 12 212 13 203.8 14 195.8 15 194.7 16 182.8 17 181.2 18 172.3 19 163.2 20 162.1 21 161.2 22 155.9 23 151.5 24 149.4 25 148.3 26 147.2 27 144.4 28 144.1 29 143.7 30 139.9 31 139.4 32 5 Numbers Summa Min Q1 Median (Q2 Q3 Max -MIN(A2:A31 -QUARTILE ($A$2:$A$120,1) -QUARTILE $A$2:$A$120,2) QUARTILE ($A$2:$A$120,3) MAX(A2:A120 Boxplot Box1 Hidden Box2 lower Box3 upper D4 -D5-D4 -D6-D5 Whiser Top -D7-D6 -D4-D3 Whisker Bottomm IQR 1.5 * iqr Outliers -D6-D4 -D22*1.5

high outliers

17 which means 17 companies are having revenue above 170.2

Add a comment
Know the answer?
Add Answer to:
Revenues for the top Global 500 companies in 2014 Revenues Company Name Wal-Mart Stores Sinopec Group...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The following data were collected as part of a study of coffee consumption among medical students....

    The following data were collected as part of a study of coffee consumption among medical students. The following reflect cups per day consumed: First, put the data in order from lowest to highest: 0, 1, 2, 2, 3, 4, 6, 8 This will help you to find the median and the quartiles! 1) Compute the sample mean and round to ane decimal place (see page 100 2) Compute the sample median and round to one decimal place (see page 88)....

  • The following data were collected as part of a study of coffee consumption among medical students....

    The following data were collected as part of a study of coffee consumption among medical students. The following reflect cups per day consumed: 3          4          6          8          2          1          0          2 First, put the data in order from lowest to highest: 0, 1, 2, 2, 3, 4, 6, 8 This will help you to find the median and the quartiles! 1) Compute the sample mean and round to one decimal place (see page 100). ____ 2) Compute the sample median...

  • Name: Continuous Random Variables: Continuous Distribution Lab Collect the Data: Use a random num...

    Name: Continuous Random Variables: Continuous Distribution Lab Collect the Data: Use a random number generator to generate 50 values between 0 and 1 (inclusive). List them below. Round the numbers to 4 decimal places or set the calculator MODE to 4 places. Complete the table Calculate the following: 1t quartile Organize the Data Construct a histogram of the empirical data. 3rd quartile median Construct a histogram of the empirical data. Make 8 bars. Make 5 bars. Relative Frequency Relative Frequency...

  • Rank Company Name Return 1 Apple 14.8 2 Amazon.com 29.8 3 Google 49.3 4 Berkshire Hathaway...

    Rank Company Name Return 1 Apple 14.8 2 Amazon.com 29.8 3 Google 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...

  • TRY IT 1.11 You are going to use the random number generator to generate different types...

    TRY IT 1.11 You are going to use the random number generator to generate different types of samples from the data. This table displays six sets of quiz scores (each quiz counts 10 points for an elementary statistics class #1 #2 #3 34 #5 #6 5 7 10 9 8 10 5 9 8 7 6 9 10 8 6 7 9 9 10 10 9 8 9 7 8 9 5 7 4 9 9 9 10 8 7...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT