I hope someone can help!

I need to calculate an average for a questionnaire.

There is a scale of 1-10 about how much they liked a product (1 being not and 10 being liked it a lot)

Now I need an average of what the people said. (e.g. 6.7)

Example:

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |

56 | 88 | 101 | 97 | 100 | 59 | 62 | 39 | 13 | 18 |

<colgroup><col span="10"></colgroup><tbody>

</tbody>

Is there a formula for this perhaps or a way to calculate it?

Thanks!