Reference no: EM131005722

Create a Microsoft Excel spreadsheet with sample data using the data collection plan for two variables from your learning team's dataset.

Analyze the data with Microsoft Excel or other statistical tool(s), including:

• Descriptive stats for each numeric variable

• Histogram for each numeric variable

• Bar chart for each attribute (non numeric) variable

• Scatter plot if the data contains two numeric variables

Determine the appropriate descriptive statistics.

• For normally distributed data use the mean and standard deviation.

• For significantly skewed data use the median and interquartile range.

Attachment:- Assignment.rar