Question

Suppose Procter & Gamble sells about 20 million bars of soap per week, but the demand is not constant and production management would like to get a better handle on how sales are distributed over the year. Let the following sales figures given in units of million bars represent the sales of bars per week over 1 year (in no particular order).

17.1 22.3 17 25.2 19.6 12.2 18.3 26.3 15.4 19.9 13.6 23.9 17.4 21.5 39.8 30.6 15 20.4 20.7 25.2 18.5 20.3 21.3 26.2 20.6 15.5 22.5 26.9 18.4 23.6 21.4 32.8 20 19.1 23.4 26.3 20.9 20.4 23.1 26.6 19.3 15.4 22.8 24.3 18.2 20.3 21.4 26.2 14.7 24.4 24 23.8

Required:
a. Construct a histogram chart to represent the data.
b. Creating a chart is not useful in and of itself unless it is properly interpreted. Write a brief analysis of the graph. What do you see in the graph that might be helpful to the production and sales people?

Answer 1

Kindly check explanation

Step-by-step explanation:

Given the data :

17.1

22.3

17

25.2

19.6

12.2

18.3

26.3

15.4

19.9

13.6

23.9

17.4

21.5

39.8

30.6

15

20.4

20.7

25.2

18.5

20.3

21.3

26.2

20.6

15.5

22.5

26.9

18.4

23.6

21.4

32.8

20

19.1

23.4

26.3

20.9

20.4

23.1

26.6

19.3

15.4

22.8

24.3

18.2

20.3

21.4

26.2

14.7

24.4

24

23.8

From the histogram plot generated below, it enabled us to get a better annd clearer distribution of weekly sales of the company's product over the course of a year. Most of the weekly sales recorded lies between 15 - 30 million units, with a sale of 20 - 25 million units being sold during 23 different weeks. The sales unit fell below 15 million units on 3 different occasions (weeks) and a maximum sale of 39.8 million units in a single week within the year.