Please do it on excel and show the excel spreadsheet Consider the coal$-$loading operations along the banks of the Blackwarrior River. The total amount of coal required to fill the barges varies based on number of barges and their capacities These barges arrive randomly according to the following data:

$\backslash$table$[[$Distribution of Barge Capacities$],[$Capacity $($tons$),$Percentage,$],[300,2,],[400,5,],[450,8,],[500,17,],[550,18,],[600,24,],[700,14,],[800,7,],[900,5,]]$

a$.$ Create a Random Number generator using this distribution.

b$.$ Generate $10$ Random Numbers with this generator, Le$.,$ assume that $10$ barges arrive and these random numbers represent the size of each barge. Count the number of random numbers that fall into each capacity bucket. $($For instance, $2$ barges with $500$ capacity; $4$ barges with $600$ capacity; $3$ barges with $800$ capacity; $1$ barge with $900$ capacity$).$ You may represent the results using a bar chart and a frequency measure $($eg$..20\%$ with $500,$ etc.$)$

c$.$ Replicate part b with $100$ random numbers using this generator.

d$.$ Replicate the analysis with $1000$ random numbers using this generator.