Assignment 1: Descriptive Statistics Name ______
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: http://people.ysu.edu/~gchang/stat/Classdata2012.xls
Link to Data: http://people.ysu.edu/~gchang/stat/Classdata2012.csv
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. Please remove any extremely unreasonable data values in your analysis.
Try to learn R Command using the instruction in the R Commander Manual: http://people.ysu.edu/~gchang/r/IPSURRcmdr.pdf to work on this assignment. You can also use the other instructions listed in the R Instructions page to learn R and R Commander (http://people.ysu.edu/~gchang/r/R_Instructions.htm).
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.
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 FrequencyNone / _____ %
Less than 3 times / _____ %
At least 3 times / _____ %
4) Report the percentage distribution of Exercise Per Week variable.
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 = ______
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 (a point would be taken off if a chart or table has no number and label) 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 distribution [in MS-Word, click on Insert and select Table].
[Use MS-Word to create a table for putting the frequency information here!]
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 Height 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.]
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.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:m s F W ¹ » Ä Í É ± £ 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