I want to analyze data of different workshop (approx 40 workshop) participants data and following two are issues:
A. I want to check out of 4000 participants, How many participants attended multiple workshop
B. Separate the participants data based on their designation, Department, Affiliation
Hi,
about the first question it is sufficient you use the count if function you find in excel.
I don't understand the second question, if it is just a reordering you mean on the base of a column collecting the information about the University affiliation or something else.
I guess you have to use a database. One can also do it in Excel using macros
Agreed with count if for your first question. You can produce a pivot table to get the second, if I understand what you are after.
VBA macro: one can set all the parameters in the script and it'll get the desired output.
I do not reccomend macros. If your base data is structured uniformely, that means a clear flat excel table the best tool in wxcel is the pivot-table. It allows you to cut and filter thru the data anyway you want.
Thanks to all for suggestion, I got some solution in excel after long searching.
I can do it for you.
Or you can do it by your self. See publication.
I used this program on telecom data; on medical data; on stock market data for series interactions.
Program uses VBA.
If you are going to use it please cite, since it is very helpful for any multifactor data representation.
Article COMPILATION OF MEDICAL DATA IN THE MS EXCEL PROGRAM USING TH...
In your case the program may present a distribution of the answer on a particle question from questionnaire. If questionnaire is similar for all workshops than it is possible to see how answer number 2 out of possible answers on question 10 is distributed across different workshop (approx 40 workshop).
Are there any similarities in behavior pattern? or workshop response on workshop teacher?
Another example. It is possible to estimate the satisfaction of attendees on particular teacher's skill.
Moreover, it is possible to see how many attendees have a similar response pattern:
q1: Answer 1
q10: Answer 2
q20: Answer 5
If seminars held in different countries it is possible to distinguish a particular pattern in respect to the territory.
So, it is lots of different opportunities for hypothesis testing.
- Badges
- Science topic
- Similar topics
- Education