math 2100 4
Statcrunch Chapter 3
This project requires you to look at income data from 51 different areas (50 states and D.C.). This data has a column for each of the following: White Women, Black Women, All Men. This is actual data comprised from the Census 2013 American Consumer Surveys. The goal is to work with real data, run statistics and draw conclusion on the difference or similarities in income based on race. There are 5 parts to this project that you will work on during 5 different weeks of the course. You will be writing conclusions, differences and similarities between the data sets after each part so in the end you have a complete report that will be submitted. In the end your findings should discuss the discrepancies in income based on race. Each week I will grade your submission and provide feedback on parts you should redo before completing the final project at the end of the semester.
Part 1
Task 1: Open the Income data set in Statcrunch.
Task 2: Run the descriptive statistics for the three columns (White Women, Black Women, and Men). Be sure to save an image of the results.
Task 3: Create a boxplot for each of the three columns (White, Black, and Men). Be sure to save an image of the result
Task 4: Type up your findings. Things you can discuss similarities, differences, mean, standard deviation, outliers, spread, etc. Be sure to paste your Statcrunch results in the project for reference. Are there any overall discrepancies between the 3 groups of data that you can see? Upload to blackboard when finished.
***Step by Step directions for Statcrunch are on the following Pages
***Please follow formatting guidance provided in the case study template
Opening a data set in Statcrunch:
Log into blackboard and first download the Income dataset
Navigate to Pearson, and then open Statcrunch.
Click Data Load From file on my computer. Click browse and locate the Income file you just downloaded. Scroll down and click upload.
Running Descriptive Statistics in Statcrunch:
Click Stats Summary Stats Columns. To select more than one variable hold down the ctrl key as you click the columns you want. Then click compute.
The results screen you get here needs to be copied into your report. You can take a screenshot, use the snipping tool, or highlight copy and paste. You will discuss these findings.
Creating a Boxplot:
Click Graph Boxplot. Like the summary stats it is best to run all three together so that you can easily compare them on the same scale. Hold down the ctrl button as you select the variables. You do not need to adjust any other settings.
The graphs constructed will need to be copied into your write up. To copy a graph please follow these steps. Click Options Copy. A new graph has appeared. You can right click and select copy here. Then when you go to your word document you will hit CTRL+ALT+v then select device independent bitmap. This will paste the graph in the proper format to your word document.
Now you need to type up and discuss your findings for this data. Be sure to discuss similarities and differences between the 3 groups. Compare/contrast the mean, median, mode, min/max, spread of data etc. You should also discuss similarities and differences in the boxplots. This can involve spread, max/min, outliers, etc. Please refer to the case study template in order to type this up correctly.