Share this: Google+

In this tutorial, you will learn how to analyze your questionnaire survey. You don't need to have advance statistical software. All you need is just MS Excel. Online interactive programs for data analysis, cross tabulation and chi-square independent test are also provided. You will learn the statistical concept and practical step by step to do simple research using MS excel Data Analysis – Descriptive Statistics and Pivot Table to analyze your data from questionnaire survey. You will also learn about Conditional probability, independent events and Bayes Theorem.

You may download the spreadsheet example of this tutorial here

The tutorial can be divided into several sections:

Questionnaire & Data Preparation

Data Example & Research QuestionsSimple Data Analysis

Data Coding

Data Analysis of single variableInteractive Programs

Cross Tabulation (Data analysis of two variables)

Descriptive Statistics (Interpretation of Tabular Datainteractive calculator)

Contingency Table (interactive calculator)

Chi-Square Independent Test (interactive calculator)

Conditional probabilitySend your comments, questions and suggestions

Independent events

Bayes Theorem

See also: Regression Tutorial, Learning from Data, Mean and Average

**Preferable reference for this tutorial is**

Teknomo, Kardi. Data Analysis from Questionnaires. http:\\people.revoledu.com\kardi\ tutorial\Questionnaire\