Create a microsoftreg excelreg spreadsheet with the two

Question

Create a Microsoft® Excel® spreadsheet with the two variables from your learning team's dataset.

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.

Use the Descriptive Statistics and Interpretation Example to develop an interpretation of the descriptive statistics.

Format your paper consistent with APA guidelines.

Answer 1

The following spreadsheet is about to two variables of dataset so describe the appropriate descriptive statistics. Build a Microsoft® Excel® spreadsheet through the two variables from your learning team's dataset. Examine the data through MegaStat, StatCrunch, Microsoft Excel or other statistical tool(s), as well as: (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 encloses 2 numeric variables