Create a Microsoft® Excel® spreadsheet with the two variables from one of the data sets found under Academic Resources on the class home page.
Analyze the data with MegaStat®, StatCrunch®, Microsoft® Excel®or other statistical tool(s), including:
(a) Descriptive stats for each numeric variable
(b) Histogram for each numeric variable
(c) Bar chart for each attribute (non numeric) variable
(d) Scatter plot if the data contains two numeric variables
Determine the appropriate descriptive statistics.
(a) For normally distributed data use the mean and standard deviation.
(b) For significantly skewed data use the median and interquartile range.
Use the Individual Methodology Findings Template to complete the descriptive statistics.