Question: Using the excel database provided below, create a frequency distribution in the form of a histogram column chart, following the steps explained in Chapter 4.
Using the excel database provided below, create a frequency distribution in the form of a histogram column chart, following the steps explained in Chapter 4. Calculate frequency and create a frequency distribution for the products in the database using the input range and bin range steps demonstrated in Chapter 4.
| Sales Units | |||||
| Product | |||||
| Month | A | B | C | D | E |
| January | 7,792 | 5,554 | 3,105 | 3,168 | 10,350 |
| February | 7,268 | 3,024 | 3,228 | 3,751 | 8,965 |
| March | 7,049 | 5,543 | 2,147 | 3,319 | 6,827 |
| April | 7,560 | 5,232 | 2,636 | 4,057 | 8,544 |
| May | 8,233 | 5,450 | 2,726 | 3,837 | 7,535 |
| June | 8,629 | 3,943 | 2,705 | 4,664 | 9,070 |
| July | 8,702 | 5,991 | 2,891 | 5,418 | 8,389 |
| August | 9,215 | 3,920 | 2,782 | 4,085 | 7,367 |
| September | 8,986 | 4,753 | 2,524 | 5,575 | 5,377 |
| October | 8,654 | 4,746 | 3,258 | 5,333 | 7,645 |
| November | 8,315 | 3,566 | 2,144 | 4,924 | 8,173 |
| December | 7,978 | 5,670 | 3,071 | 6,563 | 6,088 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
