Exploring statistics and trends: Description and use of histograms in data analysis In this task, you will be able to apply the concepts of central tendency, measures of dispersion, and creating a diagram. Once you make the diagram, you will be able to interpret the data, applying it to daily life.

Instructions After studying the resources required for this module, analyze the following situation and answer the analysis questions at the end:

Situation: Suppose a healthcare company wants to evaluate sales and wants to analyze monthly new sales over the past year. It has monthly data in dollars for each of the months according to what was sold by the sales executives. New monthly sales data (in dollars):

January: $247,000

February: $112,500

March: $90,200

April: $78,000

May: $50,500

June: $97,200

July: $190,000

August: $120,500

September: $121,800

October: $188,700

November: $129,500

December: $122,000

1. Perform the following analyzes using descriptive statistics in the Excel program: Calculate the average of new sales for the entire year.

2. Find the median new monthly sales.

3. Determine if there are outliers in the data and, if so, identify them.

4. Calculate the variance and standard deviation of new monthly sales to measure dispersion.

5. Visually represent data using an appropriate graph, such as a bar chart or line chart.

Open a new tab within your Excel document and answer the following questions:

What deeper understanding of new sales executives' performance throughout the year can be gained after completing the calculations?

How will this information be used to support future strategies and decisions related to sales executives?

Identify what types of data are analyzed in this exercise (qualitative or quantitative). Then, explain how they are distinguished.

use excel sheets