Problem Identification and Motivational Exploration Report
Assignment ID Number AFFGEHU83939HD Type of Document Essay Writing Format APA/MLA/Harvard Academic Level Masters/University References/Sources 4 References
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
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
If your group decides to use the MEPS data, go to #3. If not, go to #5
“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 DUPERSID uniquely identifies each person represented on the file. In other words, DUPERSID is a sample person
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
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.
Problem Identification and Motivational Exploration Report
NO RESPONSE POOR / UNSATISFACTORY SATISFACTORY GOOD EXCELLENT Content (worth a maximum of 50% of the total points) Zero points: Student failed to submit the final paper. 20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. 30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. 40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. 50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. Use of Sources (worth a maximum of 20% of the total points). Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. 5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. 10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. 15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. 20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. Grammar (worth maximum of 20% of total points) Zero points: Student failed to submit the final paper. 5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors 10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors 15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. 20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. Structure of the Paper (worth 10% of total points) Zero points: Student failed to submit the final paper. 3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. 5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper 7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. 10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper.
GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME]and Have It Done by Our PhD Qualified Writers!!
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.