Suppose Procter a Gamble sells 2D 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 gures glyen 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 the data using the appropriate tool from the Data Analysis TooIPak. Make sure to specify your own bin ranges oil-rerwlse 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 1t] up to 4D; than, slioilrir where the bin numbers are in the histogram dialog box. it. 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