Question

Problem 2. A sample of 25 students from the college of business was asked to report their department (major): Accounting, Management, Marketing or Others. The results a given below:

Accounting	Management	Marketing	Marketing	Others
Management	Accounting	Others	Others	Marketing
Marketing	Management	Accounting	Management	Management
Marketing	Marketing	Management	Management	Accounting
Marketing	Accounting	Management	Accounting	Others

              

1. Construct the relative frequency table for this data.

Department	Frequency	Relative Frequency
Accounting
Management
Marketing
Others
Total	25

2. Construct a bar chart for this data.

3. Is it possible to construct a stem-and-leaf plot for this data? Why/Why not?

The question is related to business Statistics

Answer 1

Solution-A:

Department	Frequency	Relative Frequency
Accounting	6	6/25=0.24
Management	8	8/25=0.32
Marketing	7	7/25=0/28
Others	4	4/25=0.16
Total	25

For getting barchart in excel

go to

Insert>2-D Column

we get

Stem and leaf plot is for numercial or continuos data.

allows to detect numerical distribution of the data

Here data is categorical or qualitative.Hence we cannot use stem and leaf plot in this case as data is not numerical