How to use excel do stats?

Question

I have a excel are n=121 observations on survival times. choose the model for this data you belive in the most. choose number of classes k=5 and more or less equally spaced class boundaries T_j. estimate the parameters of your model manullay, calculate the statistics X^2, if we still treat it as asymptotically chi-square distributed, would the test accept the hypothesis

can not understand the question.

Answer 1

BINS COUNTS EXPECTED

0-4 48 0.4

4-8 32 0.266666667

8-12 25 0.208333333

12-16 14 0.116666667

16-20 2 0.016666667

CHI-SQUARE "fitness" test is "0" because "EXPECTED" values 'matched' to proportions of BINS. Distribution appears as a downward sloping "staircase".