{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

jpfranz-SkillCheck_9

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

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

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

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

View Full Document
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.
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

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

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

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online