Assignment 10
Learning Objectives
- calculate descriptive statistics
- assess normality
- evaluate correlations
Data Files & Tools
Tasks
(40 Points) Perform the tasks below in Excel:
- (10 Points) Using the Cereal Data set, determine the mean, median, range, mode, and standard deviation of the carbs and fiber variables.
- (10 Points) Create histograms for the calories and sugar variables to visually determine normality.
- (20 Points) Calculate the Pearson Moment and the Spearman Rank correlation coefficients for the calories and fiber variables. Evaluate and judge the correlation.
(60 Points) Perform the tasks below in R:
- Using the Grades Data set, determine the mean, median, range, mode, and standard deviation of the Score variable for Fall and Spring.
- Calculate the Pearson Moment correlation coefficient for the Fall Score and Excel Quiz variables. Evaluate and judge the correlation.
- Take a sample of 20% of the Fall Score and calculate the mean; repeat this 1000 times and store the results in a binning data frame (tutorial). Create a frequency plot of the sample means and observe the distribution.
Deliverables & Submission Instructions
Submit your Excel, .Rmd plus your .nb.html file generated by R Notebooks combined into a zip file. Upload the zip file to Blackboard.
Scoring
Total Number of Earnable Points: 100
Approximate Time to Complete: 3-4 hours
Due Date: see Calendar or Blackboard
Approximate Time to Complete: 3-4 hours
Due Date: see Calendar or Blackboard