SQL query question
$30-250 USD
Paid on delivery
Logistics:
brief background to the case and outline an analytic task.
Things to note:
This case will primarily assess your analytic and coding skills, but it’s also designed to be fun and informative .
You will have a full day to complete the task at your own pace; however, the task is designed to be completed in ~1 hour. Please do not feel compelled to spend significantly more time.
We cannot guarantee real-time responses to content or analytics questions you may have about the case. We advise that you make reasonable assumptions and explain your assumptions to your interviewer.
Our Director wants to design an initiative to address the high inpatient spend we observe and close our medical expense deficit. She has come to you for more insight on our inpatient stays. Specifically, she has requested the following (your task):
Among the inpatient (IP) stays1, design and conduct an analysis specifically for members to:
Perform descriptive analysis of the inpatient stays for members and the members themselves
Identify the cost drivers2 of the inpatient stays for members
Calculate the readmission rate (readmission definition: an admission that occurs within a 30 day period after a prior inpatient discharge)
[Optional: identify any statistically significant disparities you observe in the data, if any]
For the descriptive analysis and cost drivers, she has left the choice of variables up to you to determine what is most important
Please choose a coding language (e.g. R, SAS, SQL, etc) and write down your code.
Note: you are free to use Excel to complete the analysis, but you must write up the code you would have used in your software of choice
Output your findings into tables or charts to present to your interviewer
Project ID: #36154038
About the project
Awarded to:
Please give me chance! Dear Mr Client, I have checked project description and I have enough experience in "SAS, SQL", 100% sure about that. Let's connect over CHAT for further details. Over the last 12+ years, I have More
26 freelancers are bidding on average $150 for this job
Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on SQL, Statistics, MySQL, Database Administration, Datab More
Dear Client, I am writing to submit my proposal for the logistics job you have posted on Freelancer that aims to address the high inpatient spend and close the medical expense deficit. My name is Dawood Shahid and I a More
MASTERS IN SOFTWARE DEVELOPMENT AND ARCHITECTURE. Hi there! I have carefully read the project description and I would like to take part in this project. I will work according to your requirement to provide the best qua More
Greetings, This is Umair I am familiar with your MySQL, Database Programming, SQL, Database Administration and Statistics. I have done similar projects before. Let's have a quick chat on this project to clear furth More
SQL expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from t More
Hi Eric O., I read your project description (SQL query question ). Can we discuss more about the project? I am good with Statistics, Database Administration, MySQL, Database Programming and SQL. Please give me a chanc More
Hello sir how are you doing? I have read the project detail and really interested in your project, I am full stack developer with multiple frameworks, I have great experience doing similar jobs regarding to these skill More
I have read and understood all your project details "SQL query question " and I feel my self the best candidate to complete this project with 100 percent accuracy. I have vast amount of experience in this industry si More
Hi, Eric. I have gone through the job posting. It seems that you're looking for a senior web developer who has expertise in building page. I've worked with another client in this space, and I think you might find it v More
SQL query question My name is Rabia Faisal, I am working in the writing industry since 2011. During this time, I have served countless clients with a full amount of satisfaction by providing them with TOP Quality Sol More
Hi, I have seen your your project details and I am the "BEST CANDIDATE" for this job "SQL query question ". I am an experienced Engineer & Mathematician with more than 8 years of experience who can provide you with T More
I have read and understood all your project details "SQL query question " and I feel my self the best candidate to complete this project with 100 percent accuracy. I am a Highly-Skilled Mathematician and Engineer who More
I have read and understood the details of this project "SQL query question ". I am a Highly-Qualified & Skilled ACADEMIC WRITER with more than 10-Years of experience. In last 10 years, I have served more than 2,500 More
I am an academic expert who can help you with your solutions like; Case Studies, Summaries, Reports, Thesis & Dissertations, and Online Exams and Courses in almost every language. I am new to this website but I assure More
Hey, I have evaluated the requirement and willing to do task of Statistics, SQL, MySQL, Database Administration and Database Programming as I have expertise in Data Analytics. I am practicing these areas: - Data minin More
⭐⭐⭐Senior Web & Mobile developer⭐⭐⭐ Hey Eric O., My name is Ihor and I am a full stack developer with 6 years of experience working on various projects. I understand how important it is for you to do this project! More
SQL query question I am Minahil Hameed with a vast amount of experience in multiple fields like; Finance & Economics, Accounting & Cost Accounting, Business & Management, and Taxation & Auditing. I have achieved a gr More