jpfranz-SkillCheck_9

jpfranz-SkillCheck_9 - X201 Practice Material Data Accuracy...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
X201 Practice Material 1 of 29 Data Accuracy Make a backup of the data. Cleanse the data. Complete the QuestionableRecords worksheet and the CleansingProcess worksheet as needed. Do not use Find/Replace or Text to Columns. Practice using Excel functions as appropriate. Place any formulas to the right of the data set, do NOT insert columns in the data set. If you have formulas in your data set, StatTools will complain. Valid Data: ID: Unique values only. Gender: allowed numerical values are 1 or 2. Campus: allowed numerical values are 1 or 2. Coffee: numerical values only between 0 and 20. Sleep: numerical values only between 0 and 12. Height, Mother Height, Father Height: numerical values only in inches between 48 and 96. Monitor: numerical values only in inches between 10 and 20. Coke/Pepsi: allowed numerical values are 1 or 2. Birthday Month: text value, correctly spelled, full word for month. Birthday Day: numerical values only. Value correlates correctly with Month StatTools 3. Calculate statistics on Height . 4. Create a box-whisker plot that shows Height by Gender. 5. Create histograms to compare Height by Gender. Histogram 6. Use the Advanced Filter to pull out the unique values for Gender, Campus, Coffee, and Sleep. Sort each variable before using the Advanced Filter. Place the unique values on the Histogram worksheet next to their labels. 7. Using ToolPak, create a histogram of Coffee and one of Sleep. Statistics 8. Using ToolPak, create descriptive statistics on the Statistics worksheet for the Sleep variable and the Coffee variable. Describe the Shape, Center, and Spread for both variables. Pivot Tables 9. Create a pivot table. Rename the worksheet "Pivot1". In the pivot table, if the student is male, find the difference between the father's height and the student's height. If the student is female, find the difference between the mother's height and the student's height. 10. Create another pivot table. Rename the worksheet "Pivot2". In the pivot table, find the percentage of males students who think that they can tell the difference between Pepsi and Coke. Change the codes "1" and "2" to the words "Yes", "No", "Male", "Female". Time Series 11. Create another pivot table. Rename the worksheet "Pivot3". Count the
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
X201 Practice Material 2 of 29 number of birthdays for each month. Paste the data in a worksheet named "TimeSeriesData". Using StatTools, create a time series chart. Describe trends, seasonalityand any other interesting results in the "Time Series" worksheet that StatTools created.
Background image of page 2
ID Gender Campus Coffee Sleep Height 3 1 1 0 6 70 10 2 2 0 7.5 70 12 1 2 2 8 74 14 1 1 0 8 73 15 1 2 0 5 74 16 1 1 0 9 69 18 1 1 0 8 75 20 1 1 0 6.5 66 21 1 1 0 7 67 22 1 2 0 6 73 29 1 1 0 6 66 32 1 1 0 7 70 40 1 2 0 7 76 43 1 1 0 12 68 45 1 2 0 5 72 46 1 2 0 10 66 47 2 1 0 6 64 48 2 1 0 6 65 50 2 1 0 6 1/2 62 56 1 2 0 6 73 57 2 2 2 10 67 60 1 2 0 7 67 63 1 1 1 7 68 68 1 1 2 7 72 69 1 1 15 16 68 72 1 1 0 9 70 73 2 2 0 5.5 62 75 1 2 1 7 71 80 1 2 0 10 69 83 2 2 0 5 65 85 1 1 0 10 66 88 1 2 1 9 70 89 1
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

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

Page1 / 29

jpfranz-SkillCheck_9 - X201 Practice Material Data Accuracy...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online