Create the below spreadsheet in excel and calculate the following figures using the correct formulas

mean

median

Mode

Min

Max

Total

Range

Variance

Standard Deviation

Coefficient of Variation

From the gross column calculate the above mentioned things in excel

\begin{tabular}{|c|c|c|c|c|c|c|} \hline Date & Details & Ref & Net & VAT & Gross & Date Received \\ \hline 5-Jan & Bandine Butters & 1 & $800 & $140 & $940 & 6-Aug \\ \hline 5-Mar & Chimone and Co & 2 & $2,500 & $437.5 & $2,937.50 & 6-Mar \\ \hline 5-Apr & Mary's Cutlery & 3 & $3,000 & $525 & $3,525 & 11-Jun \\ \hline 8-May & Tower Inc & 4 & $450 & $78.8 & $528.75 & 20-Jun \\ \hline 10-May & Pitchers and Pastas & 5 & $300 & $52.5 & $352.50 & 23-Jun \\ \hline 15-May & Mary's Cutlery & 6 & $2,100 & $367.5 & $2,467.50 & Pending \\ \hline 20-May & Garden Fresh & 7 & $750 & $131.3 & $881.25 & 18-Jun \\ \hline 28-May & Essence Plc & 8 & $1,500 & $262.5 & $1,762.50 & Pending \\ \hline 31-May & Boom Ltd & 9 & $6,000 & $1,050 & $7,050 & 28-Jun \\ \hline & Total & & $17,400 & $3,045 & $20,445 & \\ \hline \end{tabular}