Descriptive Statistics

Post ID: 3425974

Overview

Hi, I need help with a question:

I need to calculate, develop, and interpret descriptive statistics and develop a graphical representation of data.

Step 1: Calculate and interpret the following from the provided data file:

Measures of Central Tendency
Measures of Dispersion
Pie Chart of Majors
Bar chart of Salaries
Scatter plot of age and salaries

All calculations must be placed on the Week 1 Answer Sheet, using the formulas in Excel. This assignment must be completed in the uploaded Excel file, showing all formulas.

Step 2: Use the calculated data to create a presentation. Provide an in-depth interpretation of the results. Relate the findings to

real-world business implications. Support the interpretation with evidence (findings, charts graphs, etc.). Acknowledge any limitations of the data or analysis, such as sample size, data quality, or assumptions made. The slide presentation include the following (minimum of 8 slides) with 1-2 minute speaker notes for each slide:

Title Page
Measures of Central Tendency
Measures of Dispersion
Pie Chart of Majors
Bar chart of Salaries
Scatter plot of age and salaries
Conclusion
References