[See Steps] The data from the lung cancer study presented below. The first column is the midpoint age for given age category. The second column for city, third
Question:
The data from the lung cancer study presented below. The first column is the midpoint age for given age category. The second column for city, third column for the number of lung cancer cases in city, and fourth column is population at risk in given age range in the city.
| Age Midpoint | City | Cases | Population |
| 47 | Fred | 11 | 3059 |
| 57 | Fred | 11 | 800 |
| 62 | Fred | 11 | 710 |
| 67 | Fred | 10 | 581 |
| 72 | Fred | 11 | 509 |
| 75 | Fred | 10 | 605 |
| 47 | Horsens | 13 | 2879 |
| 57 | Horsens | 6 | 1083 |
| 62 | Horsens | 15 | 923 |
| 67 | Horsens | 10 | 834 |
| 72 | Horsens | 12 | 634 |
| 75 | Horsens | 2 | 782 |
| 47 | Kolding | 4 | 3142 |
| 57 | Kolding | 8 | 1050 |
| 62 | Kolding | 7 | 895 |
| 67 | Kolding | 11 | 702 |
| 72 | Kolding | 9 | 535 |
| 75 | Kolding | 12 | 659 |
| 47 | Vejle | 5 | 2520 |
| 57 | Vejle | 7 | 878 |
| 62 | Vejle | 10 | 839 |
| 67 | Vejle | 14 | 631 |
| 72 | Vejle | 8 | 539 |
| 75 | Vejle | 7 | 619 |
After a careful model building process an investigator decided to fit the model for which partial output is presented below. Fred is a dummy variable representing city FREDERIC, age_sq is just a square of midpoint age. This analysis used natural logarithm of population size as an offset variable.
Analysis of parameter estimates
Parameter DF Estimate SE 95%CI Chi-sq Pr>Chi-sq
Intercept 1 -21.7892 3.037 (-27.8527,-15.7257) 49.61 <.0001
Frederic1 1 0.3285 0.1480 (0.0383, 0.6187) 4.92 0.0265
Frederic0 0 000 0000 0000 000000
Age_midpt 1 0.5099 0.1021 (0.3097,0.7100) 24.93 <.0001
Age_sq 1 -0.0037 0.0008 (-0.0053,-0.0021) 19.91 <.0001
Please explain (the best you can) the conclusion from this analysis.
Deliverable: Word Document 