Reference no: EM131704287
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.