I need some help with this homework assignment, especially with the descriptive statistics worksheet. I have attach my Excel spreadsheet with my data for Walmart.

CreateaMicrosoftExcelspreadsheet with the two variables from your learning team's dataset.

Analyzethe data with MicrosoftExcelor 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

Determinethe appropriate descriptive statistics.

• For normally distributed data use the mean and standard deviation.
• For significantly skewed data use the median and interquartile range.

UsetheIndividual Methodology Findings Templateto complete the descriptive statistics. UsetheDescriptive Statistics and Interpretation Exampleto develop an interpretation of the descriptive statistics.

6 1 60 10 6 70 60 50 40 Column A 30 20 10 0 0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 Column1 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%) 16.6 10.9434912162 6 6 24.4703902707 598.8 4.6692700699 2.140666003 59 1 60 83 5 30.3840026211 6 1 60 10 6 Bin Frequency 1 1 30.5 3 More 1 6 1 60 10 6 6 1 60 10 6 70 60 50 40 Column A 30 20 10 0 1 2 3 4 5 Running head: DESCRIPTIVE STATISTICS Descriptive Statistics Latricia Bolden QNT/561 April 12, 2016 Marsha Smith 1 DESCRIPTIVE STATISTICS 2 Descriptive Statistics Determine the appropriate descriptive statistics. Note: If the data was normally distributed, use the mean and standard deviation. If the data was skewed significantly, use the median and interquartile range. Numeric Variable Name1 Distribution: State if not normally distributed Central Tendency: 16.6 Dispersion: 24.47039027 Number: 60 Min/Max: 10 Confidence Interval: (if distribution is normal)95% Numeric Variable Name2 (if applicable) Distribution: State if not normally distributed Central Tendency: Dispersion: Number: Min/Max: Confidence Interval: (if distribution is normal) Attribute Variable Name (if applicable) Create a bar chart. Describe the proportions. DESCRIPTIVE STATISTICS Descriptive Statistics Interpretation Numeric Variable Name1 Describe the variable in laymen terms. Numeric Variable Name2 (if applicable) Describe the variable in laymen terms. 3 DESCRIPTIVE STATISTICS 4 Appendix A Raw data used in the analysis Fit data to one page. DESCRIPTIVE STATISTICS 5 Appendix B Charts and Tables This part of the paper will include items that are then cited in the body of the paper. Usually, large items are placed here not to distract from reading the paper. DESCRIPTIVE STATISTICS 6 Appendix C Descriptive Statistics This part of the paper will include descriptive statistics