Assignment due 11/9 at 8pm

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.

Submit both the spreadsheet and the completed Individual Methodology Findings Template.

Click the Assignment Files tab to submit your assignment.

Please use the variables from this except:

The size of this population is 20 suppliers. These suppliers exclusively produce and make available for sale the material that is needed for manufacturing. In order to develop the sampling design it is important to identify the independent and dependent variables. Independent variables are variables that are manipulated or treated in a study in order to see what effect differences in them will have on those variables proposed as being dependent on them (Riyami, 2008). The independent variable in this research is the cost of the raw material. Dependent variables are variables in which changes are results of the level or amount of the independent variable (Riyami, 2008). The dependent variable in this research is the availability of the raw material based on the price change as it relates to consumption.