Listed companies recorded their dividend yields

Reference no: EM13990165

A survey of 44 JSE-listed companies recorded their dividend yields (as a percentage) for last year as shown in the following table:

5.3	4.8	3.1	4.1	6.1	4.1	3.2	4.6	7.6	1.6
4.6	1.9	4.8	2.9	1.5	5.1	2.8	3.6	3.3	5.5
2.8	4.2	3.6	3.1	5.9	2.9	3.6	4.1	4.9	2.7
3.7	7.1	6.2	2.8	5.1	3.8	3.4	3.9	5.8	6.3
6.8	4.3	5.1	5.4

(a) Define the random variable and its data type.

(b) Use Excel's Data > Data Analysis > Descriptive Statistics option to find the mean, median, mode, standard deviation and skewness measure of the dividend yields of the JSE-listed companies.

(d) Which central location measure would you use to report on the dividend yields of companies? Why?

(e) Use Excel's Data > Data Analysis > Histogram option to compute a numeric frequency distribution and a histogram of the dividend yields of the sampled JSE companies. (Hint: Use the bin range given in the database.)

(f) Use Excel's function key operations (MIN, MAX, MEDIAN and QUARTILE) to compute the five-number summary table.

(g) Construct a box plot of the dividend yields of the JSE-listed companies and interpret the profile of the dividend yields declared by JSE companies last year.

(h) What was the minimum dividend yield declared by the top 10% of JSE companies? (Hint: Use thePERCENTILE function key.)

(i) What percentage of JSE companies did not declare more than a 3.5% dividend yield last year? (Hint: Compute the ogive to find the cumulative percentages.)

Reference no: EM13990165

Questions Cloud

Describe how winogrand uses the edges of the frame : and then: use the PowerPoint (2slidea) 1.photograph with a brief description of the subject 2.write a 1-2 paragraph discription of how you used elements of framing in the composition of your photograph. assess how effective you were at achieving y..

Define the positive quality my character has : How can I best explain/define the positive quality my character has? Why is this positive quality important to a culture, not just an individual person

Define the random variable and data type : A commercial flower grower in Hazyview sells fresh-cut rosebuds to retailers in Johannesburg. The unit price per rosebud (in cents) varies according to supply and demand. The grower has recorded the unit selling price for 100 transactions over the..

How long does it take an electron to traverse : Electrons move through a certain electrical circuit at an average speed of 1.4 x 10-2 m/s. How long (in minutes) does it take an electron to traverse a 1.9 -m light bulb filament coil?

Listed companies recorded their dividend yields : A survey of 44 JSE-listed companies recorded their dividend yields (as a percentage) for last year as shown in the following table:

What is the wavelength of the light : Electrons in a photoelectric-effect experiment emerge from a copper surface with a maximum kinetic energy of 1.10 eV. What is the wavelength of the light?

What charge must drop of paint have to arrive : These droplets are then repelled by the paint sprayer toward the object to be painted. This object is grounded and therefore the electric potential is taken to be zero everywhere on the object. What charge must a 0.700 mg drop of paint have to ar..

Explanation of a strategy a marketer might use : An explanation of a strategy a marketer might use with this segmentation classification to influence this segment's buyer behavior

What is the purpose of the policy : A discussion of asymmetric information should include defining how the information is unequal between consumers and producers as well as any adverse selection or moral hazard issues involved.

User Account

All Pages