Posted: October 1st, 2021

Clean excel data | Marketing homework help

Clean excel data in attached file named BUHI Customer Data. The U.S. demographics data will help you replace missing cells within the customer data. 

  • Interpolate missing data using the estimated values from the U.S. demographics dataset based on the customers’ zip codes
  • Remove extreme outliers
  • Correct incorrect value formats (e.g., age = “twelve” instead of 12)
  • Remove impossible values (e.g., age = 203)
  • Identify categories from granular data (e.g., determine the state to which a zip code belongs)
  • Identify problem data with complex problems (e.g., the state is Montana, but the country is Canada; the purchase was $100, but the item is a new car; one column says the gender is female, but another says it is male)

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: