hello
i have collected feedback regarding the usage of timesheet as a part of my MBA project.
the feedback is in MS EXCEL.
I would like to do some data analysis and put the data in form of charts.
pie charts are too elementary.
my professor insists in statistical tools which i dnt have.
the questions are given and the employees were asked to give the opinion on based of 5 point scale.
Strongly Disagree 1
Disagree 2
Undecided 3
Agree 4
Strongly Agree 5

what can i do in excel? I have no clue about it...:(
pls help me out...
total 8 questions...BOLD numbers
and below is the response ....
TIMESHEET CONCEPT TIMESHEET USE
1 2 3 4 5 6 7 8
4 3 2 2 2 3 1 3
4 4 3 3 3 4 2 4
5 5 2 1 2 5 4 4
5 4 2 2 3 4 1 5
5 5 2 2 2 5 1 5

You could do summary statistics on the results (mean, median, mode, range, std dev, etc.). You can do this by getting the analysis toolpak add-in, then running it and selecting "summary statistics" with your data as the range. It will populate all of the numbers for you!