$(2)$ PivotTable Analysis

Create a pivot table that looks like the following. Name the tab PivotTable.

$\backslash$table$[[\frac{4}{2},$A$,$B$,$C$,$D$.,$E$],[,,],[3,,,,$Above,iverage? $-,,],[4,$State,$,$Data,Above,Iverage,Below Average,Grand Total$],[5,$Alabama,,Average of Gorwth,,$8005\mathrm{.}00,2191\mathrm{.}00,5098\mathrm{.}00],[6,,,$Count of Above Average?,,$1,1,2],[7,$Arkansas,,Average of Gorwth,,,$2796\mathrm{.}00,2796\mathrm{.}00],[8,,,$Count of Above Average?,,,$1,1],[9,$Colorado,,Average of Gorwth,,$6918\mathrm{.}00,3264\mathrm{.}00,5091\mathrm{.}00],[10,,,$Count of Above Average?,,$1,1,2],[11,$Florida,,Average of Gorwth,,$9277\mathrm{.}00,2675\mathrm{.}00,7076\mathrm{.}33],[12,,,$Count of Above Average?,,$2,1,3],[13,$Georgia,,Average of Gorwth,,$6993\mathrm{.}00,2191\mathrm{.}67,3392\mathrm{.}00],[14,,,$Count of Above Average?,,$1,3,4]]$

Sort by Average of Growth in descending order so that the state with the largest average population growth is at the top.