Assignment 1: Descriptive Statistics Name ______
Part 1: Create SPSS Data
Data below were collected from a class of 9th grade students. Use this data to create an SPSS data file.
ID / Gender / Height (m) / Weight (kg) / Exercise per week / Daily hours of TV viewing1 / Female / 1.43 / 42.18 / 4 Days / 2 or fewer hours
2 / Female / 1.57 / 51.62 / 4 Days / 2 or fewer hours
3 / Female / 1.65 / 62.77 / 0 Days / More than 2 hours
4 / Female / 1.68 / 83.40 / 1 Day / More than 2 hours
5 / Female / 1.57 / 49.90 / 1 Day / 2 or fewer hours
6 / Female / 1.60 / 50.80 / 0 Days / More than 2 hours
7 / Male / 1.57 / 46.70 / 1 Day / .
8 / Male / 1.75 / 59.90 / 4 Days / More than 2 hours
9 / Male / 1.68 / 59.88 / 4 Days / More than 2 hours
10 / Male / 1.68 / 68.95 / 7 Days / 2 or fewer hours
11 / Male / 1.65 / 57.63 / 1 Day / 2 or fewer hours
12 / Female / 1.57 / 48.54 / 2 Days / 2 or fewer hours
13 / Female / 1.68 / 73.94 / 0 Days / More than 2 hours
14 / Male / 1.85 / 118.33 / 2 Days / More than 2 hours
15 / Male / 1.68 / 45.36 / 7 Days / More than 2 hours
16 / Female / 1.55 / 75.30 / 0 Days / 2 or fewer hours
17 / Female / 1.60 / 47.63 / 4 Days / 2 or fewer hours
18 / Male / 1.83 / 97.11 / 6 Days / More than 2 hours
19 / Female / 1.73 / 58.06 / 3 Days / 2 or fewer hours
20 / Female / . / . / 2 Days / 2 or fewer hours
21 / Female / 1.57 / 53.52 / 6 Days / 2 or fewer hours
22 / Male / 1.88 / 63.50 / 5 Days / 2 or fewer hours
23 / Male / . / . / 0 Days / 2 or fewer hours
24 / Male / 1.70 / 58.97 / 0 Days / More than 2 hours
25 / Male / 1.75 / 90.16 / 7 Days / 2 or fewer hours
26 / Male / 1.78 / 56.70 / 4 Days / 2 or fewer hours
27 / Female / 1.65 / 58.06 / 4 Days / 2 or fewer hours
28 / Female / 1.57 / 44.45 / 7 Days / More than 2 hours
29 / Female / 1.60 / 49.90 / 3 Days / More than 2 hours
30 / Male / 1.70 / 61.24 / 2 Days / More than 2 hours
“.” means missing value and no information was given for it.
Data coding: When entering data, please use numeric values for different categories of data values in a qualitative (categorical) variable. For instance, use value “1” for male and “0” for female, and then label them with “Male” and “Female”, and use value “1” for 2 or fewer hours and “0” for More than 2 hours and label them respectively.
Part 2: Descriptive Measures
Create the SPSS data file for data used in Part 1and 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 theweight data for these children symmetrical belled-shape by looking at the histogram?
(Circle or underscore your answer) Yes No
3)Report the percentage distribution of the Daily hours of TV viewingvariable?
Hours of TV Viewing / Relative Frequency2 or fewer hours / _____ %
More than 2 hours / _____ %
4)Report the percentage distribution of Exercise Per Weekvariable.
Exercise Per Week / Relative Frequency0 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 = ______
Notes:
- A test of normality video is in the following link:
Part 3: Descriptive Graphs using SPSS
Use the data file you createdin Part 1 to answer the following questions. Copy all the charts into this WORD document and properly label each charts using Figure numbers as the examples shown in the later part of this assignment. 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.You can view video instruction from Dr. Chang’s SPSS References web page or get a copy of SPSS instruction for reference. This documentshows you how to do basic descriptive statistics. URL:
- Make a histogramto display the distribution of the Weightvariable. (Use a class width of 10 starting from 40.)
[Copy and paste the SPSS graph here!]
[Write a sentence or two to comment on what you see in this chart.]
- Make a frequency distribution table for the gender variable to see the frequency distribution and then make a bar chart.
[Copy and paste the SPSS graph here!]
[Write a sentence or two to comment on what you see in this chart.]
- Make a cluster bar chart to examine the correlation between gender and Daily hours of TV viewing variables. (Use the Daily hours of TV viewing variable as the category axis and gender variable as the cluster variable.)
[Copy and paste the SPSS graph here!]
[Write a sentence or two to comment on what you see in this chart.]
- 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.
[Copy and paste the SPSS graph here!]
[Write a sentence or two to comment on what you see in this chart.]
- Find the 5-number summary for the weight data and make a boxplot for the Weight data with mild and extreme outliers identified using inner and outer fences.
Draw the boxplot in the following space.
[Copy and paste the SPSS graph here!]
[Write a sentence or two to comment on what you see in this chart.]
- A nurse took the systolic blood pressure of a patient and recorded it every hour from 8 am to 6 pm. The data is shown in the following table. Produce a time plot to display the trend of the blood pressure measurements.
Time / Blood Pressure mm Hg
8 am / 119
9 am / 119
10 am / 120
11 am / 123
12 am / 125
1 pm / 126
2 pm / 127
3 pm / 127
4 pm / 130
5 pm / 133
6 pm / 136
You may use military time 8:00 to 18:00 (or 8 to 18) for time variable. You may also use values 1 through 11 for time and label them as 8 am, 9 am, …, 6 pm.
[Copy and paste the SPSS graph here!]
[Write a sentence or two to comment on what you see in this chart.]
Note: Each chart or table in your assignment needs to have proper number and title. (See the following example.)
A Paper Example:
Project: Pulse Rates Analysis
Student Name: John Smith
Major: Mathematics
- 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
- 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.5Standard 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) Use Text Box for charts and tables. Creating text box and pasting charts into the text box will help you to have better control in arranging charts in your report. To view drawing box that contains the text box button, click and select through View / Toolbar / Drawing. Drawing tool bar is the bar near the bottom of the picture show below. To create a text box, simply click on the text box button, and then click anywhere in your WORD document and drag you pointer to create a box.
6) Click and select through the following sequence to produce a mathematical equation
with mathematical symbols: Insert / Object / Microsoft Equation
Example: (If you use the Office 2007, there is an Insert Object option too.)
1