Required information

Royalties received by an investor in an oil well varies according to the price of oil. Data collected from stripper wells in a West Texas oilfield were used to develop the royalty probability relationships shown.

$\backslash$table$[[$Royalties$,\frac{\text{\$}}{?}$ Year,$5,800,8500,9500,11,750,12,500],[$Probability$,0\mathrm{.}1,0\mathrm{.}21,0\mathrm{.}280,0\mathrm{.}280,0\mathrm{.}09]]$

a spreadsheet to plot the probability distribution of royalty income $($RI$)$ with the given information. Please see the attached picture for information for spread sheet