## Lecture: Stratified Regression
## Assigned Reading- Stratified Regression (use instructor's last name for password) Read►
## Assignment
- Use SQL to construct case/control comparisons for each comorbidity of lung cancer.
- Use SQL to estimate the intercept for parameters of the multiplicative function form.
- Report the mortality rate for patients who just have lung cancer and no other comorbidities.
- Provide the equation that calculates the risk for combination of lung cancer and its comorbidities.
- Select 3 comorbidities and calculate the prognosis of a patient with a combination of 3 comorbidities and lung cancer.
- Clean the data using the following steps: The age at death is given as a row of data. For each assessment calcualte if the patient dies in 6 months from the assessment. If the patient never dies assume not dead in 6 months. At death assume that the patient has all disabilities, as is the data indicates no disabilities at death. Drop last assessment as no outcomes can be calculated from last assessment. Assume age of assessment is age at first assessment (given as the second variable) plus days to assessment/365. Residents with negative age should be dropped because of date of birth errors. Residents 100 or more years should be dropped because of small sample. Note that the analysis is done at assessment level and not at patient level. Data► Clean►
- Predict from the patient's assessments (i.e. their age, gender, and disabilities at time of assessment) if the patient is likely to die in the next 6 months and may be a candidate for hospice care. Do not use regression in these analysis and estimate the parameters using SQL. SQL► Answer►
- Calculate the k constant for the multiplicative model using SQL.
SQL►
Generate possible k values and see which one of the k values satisfy the equation:
- Use the model you have developed to predict the probability of
mortality for a 75 year old resident with urine, bowel, and toilet disabilities. Enter the case description into a table
called RecentCases, using
Create Table and Insert Value commands. Then use this table to
predict the probability of mortality for this resident.
SQL►
Make sure that the probability of mortality is adjusted to range between minimum amd maximum probabilities for different strata. Stratfied regression provides a transformed probability that should be adjusted to estimate the actual probability using this formula:
Where Max is the maximum and Min is the minimum probabilities for each strata.
## MoreFor additional information (not part of the required reading), please see the following links: - Multi-attribute preference functions. Health Utilities Index. PubMed►
- Utility functions for health profiles PubMed►
- How decisions reveal our preferences PubMed►
This page is part of the course on Comparative Effectiveness by Farrokh Alemi PhD Home► Email► |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||