![]() |
Data analysis in EXCEL..help!
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!
Quote:
|
All times are GMT +1. The time now is 05:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com