Suppose Procter & Gamble sells about 20 million bars of soap per week

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).a) Construct a histogram chart to represent these data using the appropriate tool from the data analysis toolpack. Make sure to specify your own bin ranges; otherwise, Excel will automatically pick them for you and you will have very strange bin ranges with confusing decimal points. Make a list of numbers in multiples of 5, starting from 10 up to 40; then show Excel where the bin numbers are in the histogram dialog box

ANSWER:

REQUEST HELP FROM A TUTOR