Reference no: EM133721913
Homework: Introduction to Data Science Databases Paper
Objective:
The purpose of this project is to assess your ability to apply the data science concepts and methods you have learned throughout the course using a real-world scenario. For the midterm project, you will only demonstrate your understanding and application of the concepts covered in the first half of the semester. These are:
A. Understand the problem you are seeking to solve.
B. Formulate a problem statement that is clear, concise, and measurable.
C. Define the dependent and independent variables in the data.
D. Assess, diagnose, and clean the data.
E. Perform a univariate analysis on the quantitative variables.
F. Perform a univariate analysis on the categorical variables.
G. Assess the potential relationships between each independent variable and the dependent variable.
a. Bivariate analysis with one categorical variable and one quantitative variable
b. Bivariate analysis with two quantitative variables
H. Identify the strongest potential relationships that you would like to investigate further.
I. Brainstorm any new variables (or features) you could create using the original data.
Overview:
Imagine you are a data science consultant and you have just been hired by a real estate company to complete an analysis project. You walk in on the first day to get the run-down of why you have been hired. After sitting in on meeting after meeting, listening to the key stakeholders, and asking lots of questions, this is what you walk away with...
You are told by numerous people that they are having a hard time accurately pricing houses. Often, they price houses too low. While they sell quickly, they are not maximizing the profit for themselves and their clients. Other times, they price them too high. The downside in this situation is the house sits on the market for a while, which costs money, and they ultimately lower the prices or spend a lot of time negotiating with potential buyers. In either case, they are missing out on potential earnings.
Currently, they do not have a structured way to come up with a house price other than looking at comparable homes in the area using FMLS (the professional ‘Zillow' for real estate agents), getting an inspection, and simply using their instincts and past experience to come up with what they feel is an accurate price. It would be very helpful if they could more accurately predict the listing price. In addition, they would love to know what the key features (or variables) are that increase the value of a home. With this information, they could better direct clients on what renovations they should do to increase the value of their home and earn more money.
Understanding what increases the value of a home and having the ability to accurately predict the selling price will allow the company to better serve their clients and increase their revenue.
Using the information above, your analysis, and the assigned data, come up with a solution to serve your client's needs.
How to Approach the Completion of the Project:
A. The Midterm Analysis should already have been attempted. You have been chipping away at it little by little with each homework and lab.
B. That said, if you made mistakes on your lab and homework homeworks, they need to be corrected in the midterm. Use your rubric feedback to ensure you are meeting all the criteria.
C. If you did not complete a lab or homework homework, it must be completed in the midterm for credit.
D. If you have been staying on top of your work throughout the semester, all you have to do now is compile your analysis into a cohesive report that highlights what you did and what it means.
E. Use the "Midterm Sample Report" as a guide for completing and assembling your report.
F. Have fun and enjoy this learning opportunity!