izatiorn The following is a list of publicly traded companies having the greates

Question

izatiorn The following is a list of publicly traded companies having the greatest market capital (hypothetical values). Market Value -(in billion US dollars Company Name PetroChina Wells Fargo Company Name Market Value Cin billion U.S, dollars) 700 350 330 280 Apple Exxon Mobil Berkshire Hathaway Google 279 Industrial &Commercial; 275 267 1356 345 Bank of China Novartis Microsoft 330 01 Please compute the mean for these top 10 companies. 02: What are the mode and median market capitalization for the top 10 companies? What are this dataset's Q1 and P80 (percentile)? Q3: Calculate variance and standard deviation. Q4: What are the Z scores for Apple and Wells Fargo? 05: Which compunies' minlzation ar twem 1 SD7 06: Sketch a box-and-whisker plot

Explanation / Answer

First enter Data into EXCEL

Q1)

We have to find the sample mean.

Excel command is =AVERAGE(Select data)

mean =351.2

Q2)

We have to find the median

Excel command is =MEDIAN(Select data)

Median = 330

We have to find the sample mode

Excel command is = MODE(Select data)

Mode =330

We have to find Q1

Excel command is = QUARTILE(array,quart)

Q1 =279.25

We have to find the P80(percentile)

Excel command is =PERCENTILE(array,k)

P80=351.2

Q3)

We have to find the sample variance

Excel command is =VAR(Select data)

Variance = 16200.18

Now we have to find sample standard deviation.

Excel command is =STDEV(Select data)

standard deviation = 127.2799

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.