Data Cleaning and Other tasks


Having Trouble Meeting Your Deadline?

Get your assignment on Data Cleaning and Other tasks  completed on time. avoid delay and – ORDER NOW

Part 2) Data Cleaning

  1. Your data should be on a worksheet titled “data”.
  2. Create a duplicate of your data which you will clean:
    1. Fix any issues with your observations. Our purpose is to make the spreadsheet ready for analysis. For example: School could be listed as Montgomery City Schools or just Montgomery. These would filter as different data points, so they should be corrected to the be the same value.
    2. Create a new variable called age which shows the age of the house in years.
    3. Split the address variable so you have street number/prefix, street, city, state, and zip all separate columns.
    4. Create a new variable called city = 1 if the house is located within the City limits, 0
      • therwise.

Part 3) Assignment Tasks

Create a Word document named housing_report_5880_City.docx (where City is the city you are assigned) with the following information in a report format. This document should be considered a professional document that would be provided to your boss or your colleagues. It should be a minimum of 4 content pages. It should also be double-spaced, with appropriate headers and footers as you see fit.

  1. Create a professional report that you would give your boss at your Real Estate Firm with the following contents.
  2. Cover page with the team name (City) and team members. List what each team member was responsible for and what each worked contributed to the project.
  3. Problem Statement: explain the purpose behind this project, why you would even want to examine these variables and this market.
  4. Create a footer to number each page.

General Requirements:

  • Each section should have a heading.
  • The graphics / charts should be clear and flowing in the document (as well as aligned and sized correctly).
  • Each graphic should be readable. No tiny fonts. Do not use links.

 Explanations should be consistent, clear, and complete. Do not abbreviate or use slang. Professional writing only.

Report contents:

  1. Describe the process of exploring variables and complete the following:
    1. Categorize and describe each variable.
    2. Produce MIN, MAX, MEAN of each variable.
  2. Produce boxplots of price, square feet variables. Interpret and explain your findings.
  3. Produce scatter plots of price and square feet variables. Interpret and explain your findings.
  4. Create a histogram of prices with 10 bins. Show the histogram. Explain what it shows.
  5. Are there outliers in the data collected? Explain.
  6. What are the clusters or groups that appear from the price variable?
    1. Group each property appropriately.
    2. What method do you use to calculate groups?
    3. What are the general parameters of your groups (show range of price, sq feet)?
    4. Show each group’s school zone (or zones). Does each member of each group have the same school zone?
  7. Which property has the largest sales price?
  8. Find the average price per square foot of homes in each of your groups and produce a table with this information.
Explanation & Answer

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

Similar Posts