Need help writing VBA code for the following

3. Generate a Histogram (Frequency Chart 1 Upper Bound Frequency 10 20 30 40 50 60 70 80 90 100 4 10 Once you have the application working, use values between 1 and 100, and a likely value (b value) of 80. Then create a chart to see the triangular shape of the distribution. The first step is to create a frequency table which counts the number of times a number occurs within a specific range. Create a nevw worksheet named Histogram to do this. Option: You may either set this up at design time, or use code to complete this portion a well, or a combination of both. Format Data Series SERIES OPTIONS SERIES OPTIONS Plot Series On 0% Series Qverlap | 0% Gap Width The frequency table shows the values grouped into bins, and the total number of values from your data set that fall into each bin. For this part of the assignment, use the bins shown on the left. You will need tro 3. Generate a Histogram (Frequency Chart 1 Upper Bound Frequency 10 20 30 40 50 60 70 80 90 100 4 10 Once you have the application working, use values between 1 and 100, and a likely value (b value) of 80. Then create a chart to see the triangular shape of the distribution. The first step is to create a frequency table which counts the number of times a number occurs within a specific range. Create a nevw worksheet named Histogram to do this. Option: You may either set this up at design time, or use code to complete this portion a well, or a combination of both. Format Data Series SERIES OPTIONS SERIES OPTIONS Plot Series On 0% Series Qverlap | 0% Gap Width The frequency table shows the values grouped into bins, and the total number of values from your data set that fall into each bin. For this part of the assignment, use the bins shown on the left. You will need tro