A general practitioner in a rural area is interested in knowing when there are a greater number of demands for home care to reinforce the hours that are most needed. For this, he has collected data on the latest demands he has had and has classified them as morning, afternoon, evening or holiday visits depending on the time and day in which they occurred. The data that she has obtained are the following: MORNING MORNI
Please use excel to solve this problem, show the formulas that I occupy and also indicate the results that are stated, thank you very much
I would like to see the excel document, I do not know if I can share it, if not, then with the captures it is fine and the information that must be indicated, thank you very much
PROBLEM
A general practitioner in a rural area is interested in knowing when there are a greater number of demands for home care to reinforce the hours that are most needed. For this, he has collected data on the latest demands he has had and has classified them as morning, afternoon, evening or holiday visits depending on the time and day in which they occurred. The data that she has obtained are the following:
| MORNING | MORNING | NIGHT | HOLIDAY | NIGHT | AFTERNOON | NIGHT |
| MORNING | MORNING | NIGHT | AFTERNOON | HOLIDAY | AFTERNOON | MORNING |
| MORNING | MORNING | NIGHT | MORNING | HOLIDAY | AFTERNOON | AFTERNOON |
| MORNING | AFTERNOON | HOLIDAY | MORNING | NIGHT | HOLIDAY | AFTERNOON |
| AFTERNOON | HOLIDAY | AFTERNOON | HOLIDAY | NIGHT | HOLIDAY | MORNING |
A). Determine if the analyzed data is qualitative or quantitative
B) Simple frequency distribution table, Conversion of frequencies to degrees, Conversion of frequencies to percentage
C) Graph of sectors (colors, percentage within the corresponding sector, nomenclature that identifies the sectors)
Given information:
The data of last demands classified as morning, afternoon, evening or holiday is given.
Step by step
Solved in 4 steps with 2 images
