Business Finance Homework Help

Data Description Methods

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.

Develop a frequency distribution for each bread type using& appropriate intervals.

Select which bread type has the greatest and lowest relative variability. 

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.

1. Submit your work in a Word document and attach your Excel file.
2. One method to create frequency tables in Excel is using Pivot tables.
3. Watch VideoExcel Pivot Tables Made EASY: Frequency, Relative Frequency, Percent, and Cumulative Distributions
4. Duration: 8:51
   User: n/a – Added: 9/12/20

For students using  Excel online version or Google sheets see the video below:

Watch VideoUse Google sheets to make frequency distribution for quantitative data

Duration: 4:25

User: n/a – Added: 7/26/16