|Perfect Number of Pages to Order||5-10 Pages|
Problem Identification and Motivational Exploration Report
The purpose of the phase 1 report is to find a medical condition for which you want to conduct data analyses and to have a basic understanding of the medical condition, such as the background, causes of the disease, treatments, status, and influential factors. You need data to conduct data analyses. Therefore, you need to find a dataset with which you can conduct your project. I strongly encourage you to use the Medical Expenditure Panel Survey (MEPS) data in this class, while I provide a list of potential datasets below. It should be noted that I will provide sample codes only for the MEPS data. For the data analysis, you should have at least 500 data instances. Therefore, please find a medical condition of interest and then check whether there are 500 data instances. More details will be explained below.
MEPS is a set of large-scale surveys of families and individuals, their medical providers, and employers across the United States. MEPS is a complete source of data on the cost and use of health care and health insurance coverage in the US. For more details, please visit the official website (Links to an external site.) and Github repository (Links to an external site.) and read the attached appendix document Download attached appendix document(p.1 – 13).
MEPS data consists of various variables such as medical condition, socioeconomic factors (e.g., gender, region, race, and family income), and medical expenditure. MEPS data also consist of various files such as person-level (e.g., health status, demographics, and total $$ of care), event-level (e.g., healthcare service use), and condition-level (e.g., medical condition). For the full review of those variables, please look at codebooks (person-level (Links to an external site.)) and condition-level (Links to an external site.)). I also coded those variables regarding usefulness for analysis (included vs. excluded, Heejun_Inclusion field) and variable type (independent vs. dependent, Heejun_Variable_Type field). You can find my version of the codebook from this link (Links to an external site.). In particular there are some dependent variables you can utilize:
Total health expenditures
Total inpatient expenditures
Total emergency care expenditures
Severity of Illness (attacks/year)
Number of School Days Missed (Children)
Number of Work Days Missed (Adult)
You should explore the dataset in depth to understand what you can do and to decide what you will do. It is a complex dataset, and you need to merge a number of files into one for your project. Do not feel overwhelmed. I will introduce all procedures step by step.
Depending on the medical condition (e.g., allergic rhinitis), research goals you can set will include but are not limited to:
Predict the yearly medical expenditure of persons with allergic rhinitis
Compare healthcare costs in different social determinant factors (e.g., sex, region, family income, and race)
Find relationships between allergic rhinitis and environmental factors
If you are skilled in Python and want to use other datasets, then it is up to your group. However, please be noted that I cannot fully support your group, and my sample codes should be tweaked a lot to reflect the difference between the dataset you choose and the MEPS dataset. The following datasets are publicly available and free:
What to Do for the Phase 1 Report
Please find a medical condition that interests your group and find an ICD-9 code of the condition from the FINDACODE.COM (Links to an external site.)
If your group decides to use the MEPS data, go to #3. If not, go to #5
Download a condition-level file (h128.csv Download h128.csv), open the file with MS Excel, and apply a filter to the “ICD9CODX” field. Select the ICD-9 code of your condition (e.g., 493 for asthma) and check the number of records (i.e., number of rows selected) related to your condition. This number would include duplicated records
To remove duplicated records and count the number of unique records,
Select the “DUPERSID” field and copy all selected DUPERSIDs. While copying, you should copy visible cells only. If not, you are going to copy all DUPERSIDs in the column. To copy “visible cells only”, please follow the instruction found at the Microsoft Support (Links to an external site.)
The DUPERSID uniquely identifies each person represented on the file. In other words, DUPERSID is a sample person identifier
Then, paste copied DUPERSIDs to another sheet (+ menu in the bottom)
Remove duplicates (“Data” -> “Remove Duplicates”) and count the number of records (i.e., DUPERSIDs).
If the number of DUPERSIDs is larger than 500, you are good. Congratulations! Your medical condition meets the requirement of the project. If not, you do not have enough data for the project. Unfortunately, you need to find another medical condition and iterate the steps from 3 to 4.D until you can find a condition with more than 500 records
If you selected another dataset, it’s your responsibility to conduct steps from 3 to 4.D by yourself. Your workflow should do the same procedures as my suggested workflow does
How to write
Please write a report and cite appropriately.reason of your interest.
What to include
Your submission of the report should include:
Names of students in your project group (up to three students)
EUIDs of group members
Title of the project
Number of data records
What I asked you in the “How to Write”
The order of contributions (i.e., work distribution) like authorship (e.g., first author, second author, third author, and so on.)
If you believe that some of you or all of you contributed equally, then you need to state it
Here, contributions include all phases you worked to submit this project report
Please attach a .docx file. All group members should submit the same copy of the report.
GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
Problem Identification and Motivational Exploration Report
Tired of getting an average grade in all your school assignments, projects, essays, and homework? Try us today for all your academic schoolwork needs. We are among the most trusted and recognized professional writing services in the market.
We provide unique, original and plagiarism-free high quality academic, homework, assignments and essay submissions for all our clients. At our company, we capitalize on producing A+ Grades for all our clients and also ensure that you have smooth academic progress in all your school term and semesters.
High-quality academic submissions, A 100% plagiarism-free submission, Meet even the most urgent deadlines, Provide our services to you at the most competitive rates in the market, Give you free revisions until you meet your desired grades and Provide you with 24/7 customer support service via calls or live chats.