Part 1: Create Data File Using Statistical Software

Data in the URL link below were collected from a sample of students. For this project, you need to import the EXCEL (.xls) or Comma Separated Values (.csv) data file provided in the following link into the statistical software R Commander to create a data set (or data file) for producing descriptive statistics needed for this assignment. Both data files have the same data. Choose one of them for this assignment.

Link to Data: http://people.ysu.edu/~gchang/stat/Classdata_13f.xls

Link to Data: http://people.ysu.edu/~gchang/stat/Classdata_13f.csv (Mac users)

Note: Classdata_13f. csv data file uses comma as the separator .

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 read the instruction carefully. Please use only the valid data . Do not include missing values in each analysis. When you are asked to remove any extreme ly unreasonable data values in your data file, please only delete the extreme value. D o not delete the whole case (or whole row of data). The total number of cases in the data file should still be 37.

Learn R and R Commander using the instruction in the following R Instructions web page: http://people.ysu.edu/~gchang/r/R_Instructions.htm

Part 2 : 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 or 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 ].
2. Make a bar chart for gender variable.
3. Report the 5-number summary for the W eight data and make a boxplot for the W eight data with mild and extreme outliers identified using inner and outer fences. Use all data values. Do not delete any data values.
4. Make a histogram to display the distribution of the W eight variable with extreme value or unreliable value removed . You should be able to see them in the boxplot or in the original data set.
5. Make a cluster bar chart (side-by-side bar chart) to examine the correlation between gender and Ate Fried Food variables.
6. 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 extreme values in Height and Weight data before making the scatter plot.]
   Part 3: Descriptive Measures
   (Please remove the extreme or unreasonable data values that you found in Part 2 when answering the following questions.)
   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

1. Report the percentage distribution of the Ate Fried Food variable.

   Ate Fried Food	Percentage
   None	_____ %
   Less than 3 times	_____ %
   At least 3 times	_____ %

2. Report the percentage distribution of Exercise Per Week variable.

   Exercise Per Week	Percentage
   0 Days	____ %
   1 Days	%
   2 Days	%
   3 Days	__ %
   4 Days	___ %
   5 Days	%
   6 Days	____ %
   7 Days	____ %

3. 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):
4. 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 4: Read the following article:

Find the following article:

Calaine Hemans-Henry, MPH, Carolyn M. Greene, MD, and Ram Koppaka, MD, PhD
"Integrating Public Health–Oriented E-Learning Into Graduate Medical Education" American Journal of Public Health : June 2012, Vol. 102, No. S3: S353–S356.

URL for this article: http://ajph.aphapublications.org/doi/pdf/10.2105/AJPH.2012.300669

Read the article and use your judgment to critically evaluate the article and also answer the following questions. Use less than 50 words for each question. (You can download this WORD document and use it to write this assignment.)

1. Why was the study done, and what question were the authors addressing?
2. Does the data constitute a sample or an entire population?  If a sample has been taken, identify both the sample and the population; otherwise, identify the population.
3. What variables have been collected from each individual in the study and what type (qualitative or quantitative) of variables are they? (List and describe variables that were used in the analysis.)
4. Was it an experimental or observational study? If a sample has been observed, is it likely to be representative of the population?  What type of sampling procedure has been used in the study?
5. Was it an inferential study? Explaining why do you think it is an inferential study?
6. What statistical procedure(s) was (or were) used?
7. Is there any misleading information presented in the paper? If there is, explain why it is misleading and what would you suggest to correct it.
8. Use your judgment to critically evaluate the articles. Name two possible biases that may occur in this research.

Price: $30.62

Solution: The downloadable solution consists of 15 pages, 1562 words and 8 charts.
Deliverable: Word Document