Can someone help me breakdown this answer. How do I add the formulas.

Question 5.

Suppose a clinic is interested in the number of visits per person annually. After selecting 25 individuals from the insured population, the following data were obtained:

1, 2, 5, 3, 7, 8, 0, 4, 3, 7, 10, 2, 2, 4, 2, 6, 7, 8, 3, 2, 1, 1, 6, 5, 0

Use Excel to construct.

A frequency distribution table that also has relative frequency distribution and cumulative frequency distribution.

You can follow these steps to achieve that.

Leave all your original data (the numbers used to calculate everything) on the sheet.

Use bin values of 3, 7, and 11. This should be the first column in your newly created table.

Use the Excel "Histogram" tool to create your frequency table. Leave this table in your Excel sheet to "show your work."

Add a new table into which you will paste data from the histogram table Excel creates for you.

To the right of your BIN values column, put another descriptive column denoting the frequency distributions: 0 to 3, 4 to 7, and 8 to 11.

Add a new descriptive column for relative frequency

Add a new descriptive column in your table to identify your cumulative frequencies (i.e., 0 - 3, 0 - 8, 0 - 11). This column will be just to the left of the cumulative frequencies created by your data analysis toolpak table.

Construct a pie chart from the relative frequency distribution (%)

A bar chart and column chart from your frequency distribution data.

Delete or rename "Series 1" from your charts or replace it with the appropriate verbiage.

Add data labels to each chart.

LABEL each axis (x and y) and put an appropriate title on your chart.

Add a summary descriptive statistics table in Excel using the Descriptive Statistics Data Analysis tool

Add a new title above your descriptive statistics table identifying your data.

Describe this dataset using measurements of central tendency and variability (range, mean, mode, median, standard deviation). In approximately three-five sentences, tell me a little about your data (groups, min/max, frequencies, central tendency, variability, etc.) in "vocabulary your grandmother would understand."