a. Suppose the health service organization is interested in the number of visits per person per year. 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, a relative frequency distribution, a cumulative less distribution, and a cumulative more distribution.
b. Using the results obtained in #1, use Excel to construct a bar chart and a pie chart from the frequency and relative frequency distributions derived for the distribution of patients, grouped by number of visits per person per year.