QNT 561 Week 4 Individual Assignment Descriptive Statistics and Interpretation 111
Create a Microsoft® Excel® spreadsheet with the two variables from a dataset for your choosing.
Analyze the data with MegaStat®, StatCrunch®, Microsoft® Excel®or other statistical tool(s), including:
(a) Descriptive stats for each numeric variable and
(b) Histogram for each numeric variable and either (c) or (d)
(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.
Submit the spreadsheet/work and explain your thought process and results.