In excel, I have a column of numbers 1,2,3,4,5 and prices $9.50, 10.50, 11.50, 15.00, 27.00 respectively.

Instead of doing an ordinary weighted average (with sumproduct etc), I want to do a weighted average where both extreme numbers (1 and 5) are weighted less than the ones in the middle (2, 3, 4) with 3 being the most weighted. Is there a method and coding for this in excel?

Also, what is this method of averaging called?

Thanks