This formula for Calculated Field returns the intended result in my sample spreadsheet. However i have to add a column "Row" to the original table.
=('Name Avg'-'State Avg')/Row