Hello,
I have an Excel-worksheet with data of people whom I called on their telephone (for a non-profit survey, members/supporters of a charity organization)
Simplified, it looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Person ID (person that I called)[/TD]
[TD]Call Date[/TD]
[TD]Comment[/TD]
[TD]number of calls[/TD]
[/TR]
[TR]
[TD]2005002[/TD]
[TD]2014-10-01[/TD]
[TD]10:20 AM: answering machine[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2005002[/TD]
[TD]2014-10-03[/TD]
[TD]4:30 PM: answering machine[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2005002[/TD]
[TD]2014-10-06[/TD]
[TD]6:30 PM: busy signal[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2005002[/TD]
[TD]2014-10-09[/TD]
[TD]6:15 PM: contacted person[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2005003[/TD]
[TD]2014-10-01[/TD]
[TD]10:30 AM: answering machine[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2005004[/TD]
[TD]2014-10-01[/TD]
[TD]5:30 PM: busy signal[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2005004[/TD]
[TD]2014-10-03[/TD]
[TD]7:00 PM: contacted person[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
etcetera
It will contain much more datasets for other persons. The Colum "number of calls" will always only show the final number of calls, not the number of calls at a specific date in time.
What I'm trying to do here: I would like to make a compilation of data / a visualization, that compiles the answers to the following questions:
What am I trying to find out? I want to know (for each person and for the whole dataset) whether we called predominantly in the mornings or in the afternoon, So that I know whether we should try to call again at AM or PM. If I for instance called predominantly in the mornings and haven't reached too much persons yet, I could try to call more in the evenings.
Thanks for now. Oh, and I'm using Excel 2010 Standard.
<tbody>
</tbody>
I have an Excel-worksheet with data of people whom I called on their telephone (for a non-profit survey, members/supporters of a charity organization)
Simplified, it looks like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Person ID (person that I called)[/TD]
[TD]Call Date[/TD]
[TD]Comment[/TD]
[TD]number of calls[/TD]
[/TR]
[TR]
[TD]2005002[/TD]
[TD]2014-10-01[/TD]
[TD]10:20 AM: answering machine[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2005002[/TD]
[TD]2014-10-03[/TD]
[TD]4:30 PM: answering machine[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2005002[/TD]
[TD]2014-10-06[/TD]
[TD]6:30 PM: busy signal[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2005002[/TD]
[TD]2014-10-09[/TD]
[TD]6:15 PM: contacted person[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2005003[/TD]
[TD]2014-10-01[/TD]
[TD]10:30 AM: answering machine[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]2005004[/TD]
[TD]2014-10-01[/TD]
[TD]5:30 PM: busy signal[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2005004[/TD]
[TD]2014-10-03[/TD]
[TD]7:00 PM: contacted person[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
etcetera
It will contain much more datasets for other persons. The Colum "number of calls" will always only show the final number of calls, not the number of calls at a specific date in time.
What I'm trying to do here: I would like to make a compilation of data / a visualization, that compiles the answers to the following questions:
- How often did I call each person (data is already there, just needs to be visualized in form of a diagram)?
- For every person: AM vs PM ratio of calls. The same for the whole set of data.
What am I trying to find out? I want to know (for each person and for the whole dataset) whether we called predominantly in the mornings or in the afternoon, So that I know whether we should try to call again at AM or PM. If I for instance called predominantly in the mornings and haven't reached too much persons yet, I could try to call more in the evenings.
Thanks for now. Oh, and I'm using Excel 2010 Standard.
<tbody>
</tbody>
Last edited: