My results when I input the data in Excel
Hawkes' result when they use statistical technology
I have no idea why my results are different from Hawkes, I tried using ANOVA single factor in excel, but I am still wrong. I used Regression as shown in picture 1. Does anyone know how Hawkes was able to get the results shown in 2? Thank you.
I have (heroically) typed your spreadsheet values into my excel. When I compute the total sum of squared deviations on your column C, I get $36.22,$ like Hawkes gets. But you have your $y$ column as column A. So your spreadsheet is using age as the response, while Hawkes is using number of tickets as the response.