Review the attached file. Suzie has an issue. She can either move to NY or FL and needs to review some data that her agent gave her. The agent reviewed house prices and crime ratings for h
Review the attached file. Suzie has an issue. She can either move to NY or FL and needs to review some data that her agent gave her. The agent reviewed house prices and crime ratings for houses that Suzie would be interested in based on her selection criteria. She wants to live in an area with lower crime but wants to know a few things:
- Is it more expensive or less expensive to live in FL or NY?
- Is the crime rate higher in FL or NY (Note a low score in crime means lower crime)?
- Is the crime rate higher in lower or higher house price areas?
Using the R tool, show the data in the tool to answer each of the questions. Also, show the data visualization to go along with the summary.
- If you were Suzie, where would you move based on the questions above?
- After you gave Suzie the answer above (to #4), she gave you some additional information that you need to consider:
- She has $100,000 to put down for the house.
- If she moves to NY she will have a job earning $120,000 per year.
- If she moves to FL she will have a job earning $75,000 per year.
- She wants to know the following:
- On average what location will she be able to pay off her house first based on average housing prices and income she will receive?
- Where should she move and why? Please show graphics and thoroughly explain your answer here based on the new information provided above.
Note: The screenshots should be copied and pasted and must be legible. Only upload the word document. Be sure to answer all of the questions above and number the answers. Be sure to also explain the rational for each answer and also ensure that there are visuals for each question above. Use two peer reviewed articles to support your position.
Sheet1
Location | Price | Crime Rating |
NY | 225,250 | 8 |
NY | 315542 | 5 |
NY | 450265 | 2 |
NY | 750250 | 1 |
NY | 554668 | 2 |
NY | 322124 | 4 |
NY | 411258 | 2 |
NY | 355412 | 4 |
NY | 466251 | 2 |
NY | 701251 | 1 |
NY | 241315 | 4 |
NY | 345215 | 5 |
NY | 198562 | 9 |
NY | 188752 | 8 |
NY | 741245 | 2 |
NY | 642315 | 3 |
NY | 423561 | 2 |
NY | 521446 | 1 |
NY | 245685 | 8 |
NY | 245543 | 4 |
FL | 120321 | 5 |
FL | 152015 | 4 |
FL | 214521 | 6 |
FL | 235213 | 4 |
FL | 263531 | 2 |
FL | 258964 | 4 |
FL | 325645 | 2 |
FL | 325641 | 1 |
FL | 324512 | 2 |
FL | 245120 | 5 |
FL | 245784 | 4 |
FL | 265124 | 5 |
FL | 352156 | 2 |
FL | 359521 | 3 |
FL | 398541 | 1 |
FL | 401213 | 1 |
FL | 402315 | 1 |
FL | 256012 | 5 |
FL | 314021 | 2 |
FL | 159632 | 8 |
FL | 201321 | 6 |
FL | 204201 | 5 |
FL | 205236 | 4 |
FL | 207205 | 6 |
FL | 206201 | 4 |
FL | 198265 | 5 |
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.