• Log In
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Data Science

Department of Management Information Systems, Temple University

Data Science

MIS 0855.711 ■ Summer 2020 ■ Amy Lavin
  • Home
  • Announcements
  • Assignments
    • Assignment 1: Analyze a Dataset Using Tableau
    • Assignment 2: Cleaning a Dataset
    • Assignment 3: Original Data Analysis
  • About
    • Course details
    • Course materials
    • Grading
    • Gradebook
    • OWLbox
    • Instructor

Assignment 2: Cleaning a Dataset

Task:

You have done such a good job with forecasting and cleaning data from Vandelay Industries that they have asked you to do some further cleaning of their data. The sales group is suspicious that there might be errors in the data for January.

You will be working with a new set of 3,296 orders with 5,182 line items from January 2014. The data is in a file called “VandelayJan2014.xlsx.” A “line item” is just an order for a specified number of a particular product – there can be multiple line items per order.

You’ll be looking for errors in the data in several places:

  • Errors in the product names.
  • Errors in the promotional codes.
  • Errors in the total product price.

You will find, document, and correct the errors in the Excel workbook.

Use these files for the assignment:

In-Class Exercise 2.1 – 2015 Car Fuel Econ [Start]

Assignment 2 – Cleaning a Data Set

Primary Sidebar

RECENT ANNOUNCEMENTS

Welcome to MIS855

Welcome to MIS855 … [More...] about Welcome to MIS855

[More Announcements...]

Copyright © 2025 · Department of Management Information Systems · Fox School of Business · Temple University