PDA

View Full Version : suitable data analysis and chart type.


monicca
06-23-2010, 05:07 AM
hello all
i am doing a survey to find out why employees are not filling timesheet.i have designed a questionnaire and distributed in a company n i have got 77 responses out of 150.
Now I am clueless about the data analysis part.:(
I have designed it in a scale of 1-5.
Now how to form hypothesis and what statistical test can i do based on my attached excel sheet.? my professor wants me to project my findings in chart.

I dont have any statistical software. I have only to Microsoft EXCEL.
Please help me. I am a student and this is a part of my summer intern project.
I have yo submit it next monday. pls help me...........:(

omega
07-09-2010, 07:19 PM
What are the questions in the survey? I assume these are Likert scale data, you want to use non-parametric methods to analyze them. A statistics software like SPSS or Minitab would be good for the analysis.