Statistics from string cells

2 Questions.

  1. Is there a way to get statistical values from non integer cells, string cells in my case.

  2. What could be the reason that Single sample t-test outputs 0 ?

adult.data.xlsx

Question.knwf