Effects of exposure to lead on children
Part 1: Create Data File Using Statistical Software
Data in the URL link below were collected from a sample of students. Import the EXCEL data file provided in the following link to the statistical software to create a data set (and data file) for producing descriptive statistics needed for this assignment.
Link to Data:
Before importing the EXCEL data file into the software, you can rename the variables in the first row of the EXCEL worksheet to give them a shorter name in EXCEL so that it will be easier for data processing later.
Special Note: When producing the statistics or charts in this assignment, please use only the valid data. Do not include missing values in each analysis. Do not remove any extreme data values in your analysis, unless you are instructed to do so in the question.
Assignment Submission: You can use this assignment file to work on the assignment. Delete the example material below and save this file using the file name A1_FirstInitialLastname and submit it through assignment dropbox before the deadline. If I were to submit this assignment, the filename would be A1_AChang.
Some useful links to SPSS instructions:
URL to SPSS tutorial page:
SPSS for Descriptive Statistics:
Part 2: Descriptive Measures
Using the data from Part 1 to answer the following questions by typing them in this document:
1) Find the overall mean, median and sample standard deviation of weight variable in this data set.
Sample Mean = _________
Sample Standard Deviation = ___________
Sample Variance = __________
Sample Median = _________
2) Does the distribution of the weight data have a symmetrical belled-shape by looking at the histogram?
(Circle or underscore your answer) Yes No
3) Report the percentage distribution of the Ate Fried Food variable?
|Ate Fried Food |Relative Frequency |
|None |_____ % |
|Less than 3 times |_____ % |
|At least 3 times |_____ % |
4) Report the percentage distribution of Exercise Per Week variable.
|Exercise Per Week |Relative Frequency |
|0 Days |_____ % |
|1 Days |_____ % |
|2 Days |_____ % |
|3 Days |_____ % |
|4 Days |_____ % |
|5 Days |_____ % |
|6 Days |_____ % |
|7 Days |_____ % |
5) Does the weight data suggest that it was from a normally distributed population? Perform a normality test and report the p-value of the test using .05 or 5% as the cutoff for decision making of the normality test.
Report the p-value from the Shapiro-Wilk’s normality test and it is: __________
Your conclusion on the normality is (type your answer using less than 30 words):
6) Report the mean, median and sample standard deviation of weight variable for female subjects in this data set.
Sample Mean = _________
Sample Standard Deviation = ___________
Sample Median = _________
Part 3: Descriptive Graphs using Statistical Software
Use data file that you created in Part 1 to answer the following questions. Copy all the charts generated from the statistical software into this WORD document and properly label each charts using Figure numbers as in the examples page shown in the later part of this assignment document. Please, for each of the chart you produced, write a sentence or two above of below the chart to comment on what you see from the chart.
1. Make a frequency distribution table for the gender variable to see the frequency and relative frequency distributions.
[Use MS-Word to create a table for putting the frequency information here! Do not just copy and paste the results from SPSS output. If you do copy then please remove the unnecessary information such as cumulative relative frequency.]
2. Make a bar chart for gender variable.
[Copy and paste the graph here!]
[Write a sentence or two to comment on what you see in this chart.]
3. Make a histogram to display the distribution of the Height variable.
[Copy and paste the graph here!]
[Write a sentence or two to comment on what you see in this chart.]
4. Make a cluster bar chart (side-by-side bar chart) to examine the correlation between gender and Ate Fried Food variables.
[Copy and paste the graph here!]
[Write a sentence or two to comment on what you see in this chart.]
5. Make a scatter plot to examine the correlation between Weight and Height variables, and write a sentence to describe the trend you observed from the scatter plot. [Remove the one extreme value in Height data before making the scatter plot.]
[Copy and paste the graph here!]
[Write a sentence or two to comment on what you see in this chart.]
6. Find the 5-number summary for the weight data and make a boxplot for the Height data with mild and extreme outliers identified using inner and outer fences.
Draw the boxplot in the following space.
[Copy and paste the graph here!]
[Write a sentence or two to comment on what you see in this chart.]
7. Use the Internet to find the Internet Browser usage data to see the usage trend. Make a time plot to plot the percentages of users utilizing different browsers starting from September, 2008 till the most recent data. You need to compare the percentages of users using Internet Explorer, Google Chrome, and Fire Fox. Try the data in the following web site:
[Copy and paste the graph here!]
[Write a sentence or two to comment on what you see in this chart.]
Note: (Practice Proper Labeling) Each chart or table in your assignment needs to have proper number and title. (See the following example.)
A Paper Example:
Project: Assignment 1, Descriptive Statistics
Student Name: John Smith
1. The graphs, charts and tables in your report need to be all properly numbered and labeled with proper title. The example in the Figure 1 is for showing a histogram created with SPSS and that you wish to use it to explain or answer a question. Your graph should be large enough so that the information in the chart is readable. But, don’t let a chart take up more than half a page.
Figure 1: Histogram for Pulse Rates
2. If a table is presented in your paper, you should also label it with proper numbering and title as in Table 1 shown below. Don’t copy the whole table that SPSS produced in the output window into your report. Retrieve only the necessary information that you wish to describe in your paper.
Table 1: Descriptive Statistics for Pulse Rate Variable
|Statistics |Pulse Rate |
|Mean |71.5 |
|Standard Deviation |5.11 |
Use page number when your report is more than one page. Always use MS-WORD to prepare SPSS related project assignment.
Few tips on MS-WORD 2003 or earlier version
1) Use Ctrl + Shift + = (press them at the same) to type superscript, and do the
same to go back to normal text. Example: X 2
2) Use Ctrl + = to type subscript, and do the same to go back to normal text.
Example: X2
3) For Greek letters and math symbols, from the MS-WORD menu bar, click and select through the following sequence: Insert / Symbol. You can insert symbols like:( ( ( ( ( ( ( ( ( ( ( and more …
4) Click and select through the following sequence to produce a mathematical equation
with mathematical symbols: Insert / Object / Microsoft Equation
Example: [pic] (If you use the Office 2007, there is an Insert Object option too.)
-----------------------
[pic]
1
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.