Data_Preparation_I_HOMEWORK (1)

1974 25 206 06 7535 11111970 28 534 41 0891 1261972

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: 974 25 206-06-7535 11/11/1970 28 534-41-0891 12/6/1972 26 194-22-7493 3/18/1930 69 672-69-5924 11/17/1969 29 875-28-8755 12/15/1941 57 125-45-8674 8/8/1934 64 162-45-8307 2/27/1963 36 564-84-1811 4/26/1960 38 915-34-7935 11/4/1969 29 784-76-5592 9/20/1947 51 770-69-3679 6/11/1971 27 967-97-4228 7/4/1963 35 454-43-8780 4/1/1931 68 468-87-3003 8/17/1952 46 334-68-8772 10/16/1970 28 775-12-0976 6/9/1939 59 768-37-0100 6/5/1942 56 953-23-4733 4/3/1949 50 647-44-5302 12/2/1930 68 181-76-4160 6/13/1975 23 788-44-0652 1/26/1934 65 063-28-6152 7/1/1974 24 255-28-7936 3/25/1933 66 222-51-7185 9/12/1937 61 066-43-9484 8/21/1966 32 641-82-7061 9/6/1941 57 671-99-1436 3/31/1939 60 680-48-7491 1/19/1965 34 871-67-5568 12/27/1961 37 837-30-4860 9/7/1968 30 888-80-7230 8/2/1931 67 952-37-0747 12/20/1953 45 342-90-9558 3/21/1949 50 215-85-7882 8/29/1969 29 348-23-6500 9/26/1952 46 835-52-7079 2/3/1951 48 282-29-3449 4/25/1936 62 547-25-5491 1/27/1974 25 607-31-2701 9/23/1965 33 020-54-3715 4/9/1976 23 249-22-7600 5/1/1973 25 681-99-3381 6/30/1972 26 638-10-5414 7/4/1968 30 924-03-2874 8/11/1944 54 347-89-9576 12/22/1944 54 614-57-0660 9/16/1961 37 598-74-8558 9/24/1965 33 013-61-7460 6/10/1938 60 393-62-5010 6/2/1967 31 598-60-5201 6/15/1950 48 032-41-3842 2/18/1942 57 830-84-9777 9/18/1950 48 185-00-4920 2/7/1953 46 What's wrong with this data? And, what tools within Excel can we use to answer this question? (Table, FIlter, Sort, etc.) Day, Date Thu, Aug 25 Thu, Aug 25 Thu, Aug 25 Fri, Aug 26 Fri, Aug 26 Sat, Aug 27 Sat, Aug 27 Sat, Aug 27 Sat, Aug 27 Sat, Aug 27 Sat, Aug 27 Sat, Aug 27 Sat, Aug 27 Sat, Aug 27 Sun, Aug 28 Mon, Aug 29 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Thu, Sep 01 Fri, Sep 02 Day of the week Month Month (number Day (number Winning Visiting Team score @ Host Team score Date (as given) (Extracted) value) value) Date (as serial value) Visiting Team Visiting Team Final Score Host Team Host Team Final Score Team CAR 13 @ CIN 24 CLE 14 @ PHI 24 WAS 31 @ BAL 34 GB 24 @ IND 21 Reconstruct this data I found on the NFL website into the columns as titled in columns C thru L. STL...
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