Showing posts with label Research Methodology Series. Show all posts
Showing posts with label Research Methodology Series. Show all posts

Thursday, September 25, 2014

Coding the Data

Before Coding the data delete all the irrelevant columns. The final worksheet is ready for coding.
This file has two sheets. First has the form responses directly imported from google docs and second sheet is the file ready for coding (after deleting columns like timestamp, name of the respondent, etc).

Step I: Define the name of the Variables

We need to name the questions as variables as in SPSS there is a strict format of variable. Select the first row of the sheet, right click and copy
Add a new sheet and name it as variables. In the B Column of the Variables sheet right click, paste special. Check Transpose.

Define all the variables.
Now, copy the variables and paste its transpose in the sheet1.

Step II. Coding the Variables


Age:

Use Find and Replace (Ctrl F) feature to change Female to 2 and Male to 1

Background:

Undergraduate - 1 , Graduate - 2, Post Graduate - 3, Phd - 4 and Others - 5

Profession

Working Professional - 1, Service Provider- 2,  Entrepreneur - 3, Management Trainee - 4 and Student - 5

How do you spend leisure time?

Always - 5, Sometimes - 4, Occasionally - 3, Rarely - 2 and Never - 1

What Motivates you to Buy?

I buy goods and services to fulfill my basic needs - 1
I buy products for comfort and convenience - 2
I buy to enhance my status - 3
I buy new and exciting products - 4
I don't need any motivation for my purchases - 5

How particular are you in following category?

I prefer only one brand - 5
I prefer few brands - 4
I am not brand conscious - 3
I look for offers and discounts - 2
I don't buy them - 1

What is your Selfie Quotient

I click a Selfie atleast 5 times a day - 5
I click a Selfie once a day - 4
I may be clicking a Selfie once a week - 3
I don't remember when last I clicked a Selfie - 2
What is Selfie? - 1

Selfie and You

Yes, I am not a Selfie person - 0
No, I am very much into Selfies - 1

People Click Selfie Because

Strongly Agree - 5, Agree - 4, Neutral - 3, Disagree - 2 and Strongly Disagree - 1

The Sheet is ready for SPSS

Step III. Opening the file in SPSS

Save and close the excel file. Open SPSS.

Check on Open an existing data source and press OK.
Change the Files of Type to Excel (.xls, xlsx,xlsm) and select the file from the location where it is saved.


Sunday, August 31, 2014

Editing the Data


The given responses are from my survey, "Are You Selfie Ready?" This is a screen shot from my drive.



To prepare these responses for analysis, we need to download it as excel file. Go to File, Download as and Microsoft Excel (.xlxs)
Select the location in your computer to save the file.
Open the excel file.

The responses are of two types, from those who are selfie types and from those who are not. We need to merge those responses.

Go to the cell from where it is to be super-imposed and select paste special.

From the Paste Special check box, Check the box for skip blanks.
The responses will be merged.
Delete the rest of the columns. The excel sheet is ready for coding.

Sunday, August 24, 2014

Introduction to SPSS - Part 2

Adding Value Labels


Lets take a new variable as Gender. In your survey, you have marked two options - Male and Female. Let us code them as 1- male and 2 - female. These values are nominal. Place the following entries:

Name : Gen
Type: Numeric
Width : 1
Decimal : 0
Label: respondent gender
Measure: Nominal




Take the cursor to the cell for value. A blue ribbon is activated near 'none'. Click the blue ribbon. The following window appears. 





Type Value = 1 and Label = male.
Click Add






"1 = male" appears inside the dialogue box.
Similarly type Value = 2 and Label = female.
Click Add






"2 = female" appears in the dialogue box.
Press OK to save the Value Label.








The following screen will appear.

Now, Similarly define a variable Monthly Income.
Name: Incom
Type: Numeric
Width: 8
Decimal: 0
Label: monthly income
Value: 1 = less than 10000
2 = 10000 - 50000
3 = 50000 - 100000
4 = 100000 - 150000
5 = 150000 and above
(click on Add after defining each label, you can edit also using 'Change' and 'Remove')
Press OK

Change the measure to Scale as Income is a ratio scale variable.






Go to Data view. You can see your variables in the first row. 









When you fill the details for Gender and Income, you need to only put the code defined in Value Label.







If you want to see the actual value, activate the Value Label feature in the second row of task pane. For any analysis in SPSS, the codes are taken into consideration. Hence, deactivate Value Label (by clicking the same feature again) before any analysis.

Next : Importing an Excel file to SPSS

Introduction to SPSS Part 1

Entering Variables in a New File

SPSS or Statistical package for Social Sciences is a useful tool for analyzing data. It enables number of statistical operations. SPSS can be used for univariate, bivariate or multivarite data. For analyzing in SPSS, data can be exported from an excel file. Alternatively, data can also be directly entered in SPSS. Here is step be step process to define variables in SPSS:

1. Opening a New File

Upon opening SPSS following screen appears
Since we are entering variable in a new file, close the IBM SPSS Statistics 19 window. The following screen will appear. On the bottom of the screen look for the view type. Currently, we are in data view.
Click variable view, following screen will appear.
Now, you can enter the variable you want. 

2. Entering the variables.

Suppose the first variable is 'Name'. Type Name in the Name of the variable in the first row.
The other entries will be automatically filled.
Since 'Name' cannot be a numerical variable, the type needs to be changed. 








Click on the right side blue region near numeric, the following window will open.






Select String and Click OK. The Character space is 8, which can be increased, if required.
The following screen will appear. Now, our first variable is 'Name',  It's type is String, width is 8 character and it is of Nominal Scale (see Measurement & Scaling). In the label column, details about the variable is entered, like here, you can enter "respondent name". Now we shall enter second variable as 'Age'.
As we enter the variable it will automatically take other values. Since age is a discrete variable, we need to reduce decimal place from 2 to 0. For age the best measure is ratio scale variable, so we'll define the scale for 'Age'.
The drop down menu for measure shows three scaling types. select scale. Also the label can be defined as "respondent age"
So far we have defined two variables, one is nominal and the other is scale. The value is defined in case of variables where value labels are used.

Next: Using Value Labels for variables in SPSS

Wednesday, August 13, 2014

Testing of Hypothesis

The objective of this presentation is to explain hypothesis and the aim of hypothesis testing. The hypothesis is the backbone of any research. Hypothesis is important as it emphasize on researcher's ability to presume the solution. The job of the researcher is to put forward questions with its proposed answers.
The elaborate research process is eleven step process, where researcher deals with hypothesis twice. Basic hypothesis or supposition should be prepared after literature survey. The extensive study of the area of concern helps researcher identify the gaps, all the important factors to be studied and their relationships. All these acts as ingredients for the statement of hypothesis. This hypothesis is tested using statistical measures on data collected.
Hypothesis is the intuition of the researcher in terms of what are the probable solutions of the problem in hand. It should contain one dependent variable (criterion) and at least one independent variable (predictor). The aim of the hypothesis testing is to see the relationship between the two i.e. whether the predictor variable actually predicting about the criterion variable or not. Usually they are referred to as predictor and criterion variable in non experimental researches and independent and dependent variable only in experimental research.
In these examples, the hypothesis is stated in the form relationship. In the first example, attendance is the predictor variable, predicting marks of students. In the second example, performance is the predictor variable in judging two brands of automobile.
Hypothesis testing is the process that starts as early as in the step 3 of the process, with the statement of hypothesis and continuous till the penultimate step of the research process.
The Null Hypothesis is the statement of no difference. To begin with, researcher needs to assume that things shall not change because of something or anything. In typical marketing context, any effort (advertising, sales promotion, quality improvement, etc) taken to boost sales will not result in any increase in sales. In other words predictor variable has no control over criterion variable. Medicines will not sustain diseases, performances will not improve, are few examples of null hypothesis.

In some other cases, null hypothesis may state that all the predictor variable (if they are more than one) have equal response or no response to criterion variable. For example, all the factors like price, quality, availability, design, promotion are equally responsible for the success of a brand.

Alternate Hypothesis is the statement other than null. It highlights the differences, effects, and anomalies in the research area. It aims at proving anomalies, not stating the reason  behind them though. The aim of the research is prove alternate hypothesis and reject null. For a given null hypothesis there can be many alternate hypothesis.

In a given set observation, the parameters to represent a variable (criterion or predictor) are mean () and standard deviation (σ). In hypothesis testing the means of a sample () can be tested against the standard mean (µ) or two different samples can be studied ( µ1 and µ2)
The test of difference or no difference would have been be identified by merely looking at means values, but according to the concept of the deviation from mean more precisely, standard deviation (σ), the difference may be because of the extreme values in the observation set. Hence, it is important to see whether the difference in mean values is significant or it is because of the standard deviation. So, the difference is considered as no difference up to a level of significant difference. Since we are checking the probable answer in testing of hypothesis, the level of significance, denoted as αis taken in terms of percentage probability. Usually, it is set at 5%, which means there is 5% probability that the researcher may state the difference when it is not significant. 
This initiates the discussion on errors in hypothesis testing. Type I error or α-error is committed, when the researcher rejects a null hypothesis when it was true. That means good product is rejected. Type II error or  β- error is caused when a null hypothesis is accepted when it was false. That mean accepting a bad product. Type I error is caused due to wrong selection of α. Researcher should have a reasonable level of significance, so that good samples are not rejected. But, in case if the researcher try to increase α he may accept bad samples also and may commit β- error.

It is evident that both types of errors can't be reduced simultaneously. There is  trade-off between two -types of error which means probability of making one type of error can only be reduced if the researcher is willing to increase the probability of making the other type of error.The appropriate level of α is decided examining the costs and penalties associated. If the task is to examine engine failures in aircraft it is advisable to keep a low α, but if they are paper planes, high α can be kept. In pharma industry, though, high α is recommended.

There are number of statistical tests available for testing of hypothesis. Depending upon the number of variables used one can select z-test, t-test,  χ2 test, F-test and so on.
Identification of the critical or rejection region using z-test taking α = 0.05 based on the central limit theorem that states that in a distribution all the values are equally distributed around the mean or in other words, they follow normal distribution.

Normal distribution is represented by bell shaped curve, at the middle of which the mean is located. According to null hypothesis, the hypothesized value, say , is equal to the standard value i.e. µ. This is the state of no difference. If the value of is greater than µ, the z-value moves on the positive (right hand) side and if it is less, z-value moves on negative (left hand) side (see formula for z). Up to some point this more or less is not significant. But as per previously decided value of α , after some z-value the state of difference (more or less) becomes significant.

 The total area of normal curve is 1 (i.e. 100% probability). From the symmetry of normal curve, the area (probability) on each side is 0.50.

Two-tailed Test

When the researcher is only trying to identify the difference and not concerned about more or less, the level of significance is equally divided in both sides (tail) of the normal curve.This type of test is called as Two-tailed test. To determine the critical region, 0.025 (i.e.0.05/2) is subtracted from each side and the acceptance region remains to be 0.475 (i.e. 0.50 - 0.025) on each side.
This value when located in z-table, gives z value equals to 1.96
Again, from the property of normal curve z= -1.96 on left hand side and z=1.96 on the right hand side. hence for two-tailed test the acceptance region is between -1.96 to +1.96. For any value of z less than -1.96 or more than +1.96 null hypothesis will be rejected.

One-tailed Test

For identifying more or less situation, the whole 0.05 level of significance is allocated on one side of the normal curve. 

For the situation when the researcher wants to reject only the values that are less than standard value. Everything on the right hand side will be accepted and treated as no difference. For example, for testing the hypothesis if the overall performance of an institute has degraded or not, researcher is not interested in the parameters where it is improved, but only look for the parameters where there is a shortfall and aims at checking whether these shortfalls are significant or not. 

0.05 will be deducted from left side. the z value will be located for the area 0.45 (i.e. 0.50 - 0.05).
z-table does not have a value equals to 0.45. The two values that are equi-distant from 0.45 are 0.4495 and 0.4505. The z-value for 0.45 is taken as 1.645, the mean of the respective z-value of 0.4495 (i.e. 1.64) and 0.4505 (i.e.1.65). Hence the acceptance region is for anything more than -1.645 and the null hypothesis is rejected for any value of z less than -1.645.
On the other side of the tail, the researcher will only reject if the value is more than some standard value. Here everything on the left hand side is accepted as no difference and the rejection region will lie only on the right tail. For example, if a company wants to know whether the sales of a product is increased or not, it shall only see the higher sales figures for the significant increase.

Here, the null hypothesis is rejected if z value is more than 1.645 and accepted otherwise.


Hopefully, you have now a better understanding of hypothesis and testing of hypothesis. Later, I shall also discuss the alternate method of testing a hypothesis based on p value.