ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data analysis in EXCEL..help! (https://www.excelbanter.com/charts-charting-excel/265352-data-analysis-excel-help.html)

monicca

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

mchel_27

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:

Originally Posted by monicca (Post 958724)
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



All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com