Japolli Bakery makes a variety of bread types that it sells to supermarket chains in the area. One of the problems is that the number of loaves of each type of bread sold each day b

 Japolli Bakery makes a variety of bread types that it sells to supermarket chains in the area. One of the problems is that the number of loaves of each type of bread sold each day by the chain stores varies considerably, making it difficult to know how many loaves to bake. A sample of daily demand data is contained in the file, Japolli Bakery Download Japolli Bakery.

1. Develop a frequency distribution for each bread type using appropriate intervals.
2. Select which bread type has the greatest and lowest relative variability.
3. Assuming that these sample data are representative of demand during the year, determine how many loaves of each type of bread should be made such that demand would be met on at least 75% of the days during the year.
4. Submit your work in a Word document and attach your Excel file.