Data_Preparation_I_HOMEWORK (1)

Data_Preparation_I_HOMEWORK(1)

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 14 @ KC 10 JAC 32 @ BUF 35 This data is from last year's pre-season NFL schedule - use 2012 as the Year. MIA 13 @ TB 17 ATL 16 @ PIT 34 NOTE: You may or may not need all the columns here. I've put some columns here to give you space to work with the data. If you can DAL 23 @ MIN 17 combine functions or tasks, that's okay. Make sure you have completed the blue cells. If you don't need all of the white columns I've CHI 13 @ TEN 14 provided, feel free to leave them blank. Likewise, if you need additional columns, you can work to the right of the table. NE 10 @ DET 34 HOU 30 @ SF 7 Also, feel free to move this box out of your way once you've read the instructions. SEA 20 @ DEN 23 SD 34 @ ARI 31 NO 40 @ OAK 20 NYJ 17 @ NYG 3 DET 16 @ BUF 6 IND 17 @ CIN 13 TB 24 @ WAS 29 STL 24 @ JAC 17 DAL 3 @ MIA 17 PHI 24 @ NYJ 14 NYG 18 @ NE 17 BAL 21 @ ATL 7 KC 19 @ GB 20 TEN 32 @ NO 9 CLE 14 @ CHI 24 HOU 0 @ MIN 28 PIT 33 @ CAR 17 DEN 7 @ ARI 26 SF 20 @ SD 17 OAK 3 @ SEA 20 The next 3 worksheet tabs contain the same data. I'd like you to explore the three different methods of separating the data in the first column. Be careful not to leave any leading or trailing spaces on the Cities, States or Zip Codes. As you work through these three methods, make note of how long it takes you to solve the problem. Which method to you prefer? Which one is most efficient for you? Each one has benefits and challenges - what challenges do you encounter for each one, and do the benefits outweigh those challenges? Area ELLETTSVILLE, IN 4 74 29 CASNOVIA, MI 4 9 318 BLOOMINGTON, IN 4 74 08 DAYTON, OH 4 54 07 SHADY COVE, OR 9 7539 BLOOMINGTON, IN 4 74 04 LANSING, IL 14 035 DOWNERS GROVE, IL 4 2526 PALATINE, IL 6 0055 HAUBSTADT, IN 4 74 06 JAROSO, CO 14 103 PHOENIX, AZ 85013 SAND CREEK, MI 4 9 279 STINESVILLE, IN 4 74 6 4 COFFEEN, IL 4 29 06 CROWN POINT, IN 4 6 307 STURGIS, KY 216 6 4 BLOOMINGTON, IN 4 74 04 INDIANAPOLIS, IN 4 6 24 7 LATONIA, KY 4 2104 GERMANTOWN, OH 4 5327 PLAIN CITY, OH 234 9 7 SAYBROOK, IL 25736 COLLEGE CORNER, OH 4 5003 MIDLAND, IN 4 74 4 5 GROVEPORT, OH 4 319 5 LIZ TON, IN 4 6 14 9 HAMERSVILLE, OH 4 5130 EAST CHICAGO, IN 4 6 312 EAST SPRINGFIELD, OH 4 39 25 SILVER SPRINGS, NV 89 4 29 COVINGTON, KY 4 1739 LINDRITH, NM 87029 GRAND RAPIDS, MI 4 9 54 4 CINCINNATI, OH 4 5220 LOS ANGELES, CA 9 0080 LOWPOINT, IL 16 6 03 TERRE HAUTE, IN 4 7803 SPRINGFIELD, OH 4 5503 COATSBURG, IL 4 5831 OAKLAND, IL 15876 TERERRO, NM 87573 BLOOMINGTON, IN 4 74 04 CHICAGO, IL 206 12 OVERLAND PARK,...
View Full Document

This note was uploaded on 01/30/2014 for the course BUS-X 201 taught by Professor Goodrich during the Fall '08 term at Indiana.

Ask a homework question - tutors are online