Excel Sheet

ANNEXURE

EXCEL SHEET Questions Respondent 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

1

2

3

4

5

6

7. 1

7. 2

7. 3

7. 4

7. 5

7. 6

7. 7

7.8

5 1,2,3,4, 5 4 1,2,3,4, 5 1,2,3,4, 5 1 1,2,3,4, 5 1,2,3,4, 5 3,4 1,2,3,4 1,5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 2 1,2,3,4, 5 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5

3 3

5 5

1 1

2 2

1 2

4 4

7 1

5 8

2 3

1 2

6 7

8 5

3 6

3 3

3 3

3 1

3 5

5 5

6 2

7 3

5 5

8 1

4 7

2 8

3 6

1 4

3

5

1

4

1

6

3

5

2

1

8

7

4

3 3

3 5

3 3

2 4

5 3

3 6

7 7

8 2

6 4

2 5

5 3

1 8

4 1

1

1

3

3

5

5

6

7

1

2

3

8

4

3 3 1 1

3 3 1 1

1 1 1 1

3 5 1 1

5 5 1 1

6 3 3 1

5 5 1 4

8 6 6 2

4 4 2 3

1 2 4 6

3 7 8 8

2 1 5 5

7 8 7 7

1

1

1

1

1

1

3

2

4

6

5

7

8

1

1

1

1

1

3

1

4

2

6

8

5

7

4

2

1

1

1

1

2

5

3

4

8

6

7

2 5

2 5

1 1

2 5

2 5

3 2

1 3

6 4

2 1

5 5

7 6

4 7

8 8

4 5

1 3

1 1

4 5

5 1

3 3

5 1

7 6

4 2

2 4

8 8

1 5

6 7

3

3

1

2

5

3

4

6

5

1

8

2

7

3

5

1

3

5

1

4

3

5

2

7

6

8

1

3

1

5

5

3

1

5

2

4

8

6

7

2

4

1

2

2

4

2

5

3

8

7

6

1

3

3

1

3

1

4

1

5

2

3

8

6

7

2

3

1

2

5

3

1

6

2

4

8

5

7

1

1

1

1

1

3

1

4

2

5

7

6

8

5

5

1

5

5

1

2

5

4

3

6

8

7

3

3

1

3

4

3

5

2

6

1

4

7

8

60

29 30 31 32

3,4,5 2 3 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1,2,3,4, 5 1 1,2,3,4, 5 1,3,4 3 1,2,3,4, 5

33 34 35 36 37 38 39 40 41 42 43 44

45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60

1 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,4,5 1,3,4,5 3,4 2 5 1,2,3,4 ,5

3 2 5 3

5 1 5 2

1 1 1 2

5 2 2 2

5 2 1 2

2 7 3 1

8 6 2 2

6 8 6 6

1 3 5 3

3 2 8 5

4 5 7 8

5 1 4 7

7 4 1 4

2

2

1

3

5

4

1

6

2

5

7

8

3

3

5

1

3

1

1

4

2

3

6

8

7

5

3

3

1

3

5

2

3

1

4

7

5

8

6

3

3

1

3

5

2

4

7

1

3

8

5

6

5

5

1

5

5

3

2

5

1

6

8

7

4

4

2

1

2

2

1

5

6

2

7

8

3

4

3

5

1

2

1

7

3

4

2

1

8

6

5

1 2

1 1

1 1

1 4

1 2

1 1

2 3

7 7

3 2

8 5

4 8

5 6

6 4

1 5 3

1 5 5

1 1 1

1 5 5

1 5 5

5 2 4

3 3 3

1 4 6

4 1 1

2 8 5

6 7 8

7 6 2

8 3 7

1

1

1

1

1

2

6

4

3

1

8

5

7

3

3

1

5

5

4

3

1

5

2

7

8

6

3

3

1

4

4

6

2

5

3

1

8

4

7

4

3

1

3

5

3

1

6

2

4

8

5

7

3

3

1

2

2

7

6

4

8

2

5

1

3

2

5

1

4

4

1

2

5

3

4

8

6

7

3

3

1

3

5

1

3

8

2

4

7

6

5

1

5

1

5

5

1

3

2

4

5

8

7

6

1

3

1

3

5

5

7

1

4

2

6

3

8

3 1 2 5 2 4

3 1 2 3 5 2

1 1 1 1 1 1

4 1 1 5 2 2

5 1 1 5 5 1

2 2 4 2 1 1

4 1 1 4 3 2

3 5 7 5 2 7

5 3 3 3 4 3

7 4 5 6 5 8

8 7 8 8 7 6

6 6 6 7 6 5

1 8 2 1 8 4

1

1

1

1

1

1

3

5

2

6

8

4

7

61

61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80

1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 1,2,3,4 ,5 3 2 3

Questions Respondent 1 2 3 4 5 6 7 8 9 10

1

5

1

2

5

3

4

6

5

2

8

1

7

3

5

1

2

2

1

2

6

4

3

8

5

7

4

3

1

4

4

4

2

8

5

3

7

1

6

4

4

1

4

4

3

5

1

4

2

7

8

6

3

3

1

3

1

3

1

7

2

4

8

5

6

3

5

1

3

5

1

2

5

3

6

7

8

4

1

1

1

1

1

3

1

5

2

6

8

7

4

2

3

1

2

5

3

2

6

1

5

8

7

4

3

5

1

2

2

4

3

6

2

5

7

8

1

3

3

1

3

5

1

2

6

3

8

7

4

5

5

5

1

5

5

3

2

7

1

4

8

6

5

1

1

1

1

1

3

1

7

2

4

8

5

6

1

1

1

1

1

3

1

7

2

4

8

5

6

1

1

1

1

1

3

1

7

2

4

8

5

6

1

1

1

1

1

3

1

7

2

4

8

5

6

1

1

1

1

1

3

1

7

2

4

8

5

6

3 3 2 3

3 5 2 3

1 1 1 1

5 5 2 5

4 5 5 5

5 1 2 3

3 6 3 2

4 4 1 6

1 2 4 1

2 5 5 4

7 8 6 7

8 3 8 5

6 7 7 8

8

9

1 0.1

1 0.2

1 0.3

1 0.4

1 0.5

1 0.6

11

1 1 1 1 1 4 1 2

1 2 1 3 2 2 2 3

2 2 2 2 3 1 3 2

2 3 3 4 2 5 4 2

1 2 3 2 2 4 3 4

2 1 1 3 2 5 1 3

2 2 2 3 3 5 4 1

1 1 1 1 1 1 1 1

3 3 3 1 3 2 2 1

2 2

1 1

2 4

3 1

3 3

62

3 1

1 1

1 1

1 4

11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56

4 1 2 4 2 4 3 3 1 4 3 4 4 1 2 2 1 3 2 4 3 2 5 1 2 1 2 2 1 3 1 2 2 1 1 4 1 2 5 3 3 1 5 1 4 5

1 1 1 1 1 1 2 2 3 2 3 3 3 1 3 1 2 2 1 1 1 2 3 1 2 3 1 3 2 1 3 3 3 2 1 2 1 3 2 2 2 3 2 3 1 1

1 2 2 2 1 2 3 4 3 3 3 3 3 3 3 2 2 4 3 2 3 4 2 2 2 3 2 2 3 2 3 2 4 3 2 3 2 2 2 3 3 3 4 1 1 2

1 2 2 2 2 2 2 5 3 3 2 2 2 3 3 2 3 3 2 1 2 4 2 1 2 2 3 3 1 2 4 3 2 3 1 4 1 2 2 3 3 2 3 2 1 3

1 3 1 1 2 2 2 1 2 2 2 2 3 2 2 2 3 3 3 3 3 3 1 1 3 2 2 4 2 2 2 1 2 2 2 4 1 2 2 3 2 2 1 1 1 1

1 2 2 3 3 3 3 4 3 3 3 3 3 2 2 2 2 2 2 2 3 2 5 1 2 3 2 3 1 2 2 3 4 4 1 1 1 3 3 3 2 2 3 3 1 2

1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 2 1 1 1 4 4 3 3 3 3 3 3 2 2 2 3 3 3 3 3 4 4 2 3

1 1 3 3 3 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 4 5 5 2 2 2 2 1 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3

2 1 2 1 2 3 2 3 1 4 2 1 2 1 2 2 4 3 3 2 1 1 1 3 2 4 2 1 3 2 1 1 2 3 2 3 2 1 4 2 4 1 1 2 4 2

57 58 59 60 61

1 5 3 3 3

3 2 1 1 1

2 1 2 2 1

2 3 3 2 2

1 2 2 1 1

2 1 4 2 3

3 3 3 2 2

3 3 2 2 2

1 1 2 3 4

63

62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80

2 1 3 1 3 1 2 4 1 2 2 2 2 2 2 4 3 5 2

3 2 3 3 3 1 1 2 1 2 1 1 1 1 1 1 3 2 2

4 3 2 3 3 1 3 2 2 2 1 1 1 1 1 3 2 1 4

2 2 3 4 2 2 4 4 2 2 2 2 2 2 2 2 4 3 2

2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 1 3 2 1

3 3 3 2 2 2 4 2 3 4 1 1 1 1 1 2 2 1 2

2 2 1 1 1 1 2 4 3 3 3 3 3 3 3 2 2 1 2

2 2 3 3 3 3 4 4 1 4 2 2 2 2 2 2 4 4 4

2 2 2 3 2 3 3 1 1 2 1 1 1 1 1 1 4 1 3

QUESTIONNAIRE We, Yuvraj Anand and Deepa of MBA (II) of Apeejay Institute of Management, Jalandhar are conducting a research on 'Competitive effect of Reliance GSM on other GSM players’. So we request you to spare few minutes from your busy schedule and fill this form. We assure you that the information provided by you will be kept confidential. Demographic Information:Name

- ____________________________________________

Age

- 15-25years

26-35years

36-45years

Above 45years Address

- ____________________________________________

Occupation - Student

Business

Service

Housewife

If any other please specify_________________________________ Contact No -____________________________________________

64

QUESTIONS Q1. Which of the following GSM players are you aware of? (i) Reliance

(ii) Vodafone

(iv) Airtel

(v) Idea

(iii) BSNL

Q2. Which GSM operator is the most innovative in its service offerings? (i) Reliance

(ii) Vodafone

(iv) Idea

(v) BSNL

(iii) Airtel

Q3. Which GSM operator has the widest network coverage? (i) Reliance

(ii) Vodafone

(iv) Idea

(v) BSNL

(iii) Airtel

Q4. Are promotional schemes offered by GSM operators affecting purchasing decision of customer? (i) Yes

(ii) No

(iii) Can’t say Q5. Which GSM operator will be preferred by you? (i) Reliance

(ii) Vodafone

(iv) Idea

(v) BSNL

(iii) Airtel

Q6. According to you which GSM player is providing better services at cheaper rate? (i) Reliance

(ii) Vodafone

(iv) Idea

(v) BSNL

(iii) Airtel

Q7. Kindly rank the following factors from 1-8 that affect purchasing decision of customer regarding any GSM player? (i) Service

(ii) Connectivity

(iii) Brand

(iv) Network range

65

(v) Price

(vi) Sale

(vii) Marketing Schemes

(viii) Technology

Q8. What is the impact of Reliance GSM on other players? a) It will lead to cheaper GSM services. b) Quality of the GSM services will suffer due to competition. c) Competition has gone up sharply in the mobile space, with Vodafone snapping HutchEssar and the recently-listed Idea Cellular outlining its expansion plans. d) Reliance Communications is likely to remain one of the key beneficiaries of the explosive multi-year mobile expansion story. e) The entry of Vodafone through Hutchison Essar and the listing of Idea Cellular may have the potential to shake up the mobile market share in terms of incremental subscriber additions.

Q9. Is Reliance GSM providing better services than its competitors? (i) Yes

(ii) No

(iii) Can't say Q10. Kindly rate the following statements on Likert’s scale from 1-5 where 1 corresponds to 'strongly agree' & 5 corresponds to 'strongly disagree'? Statements

Strongly agree

10.1 Services offered by Reliance GSM are unique. 10.2 Reliance GSM will grab the highest market share in future. 10.3 Promotional schemes will affect the sales of Reliance GSM. 10.4 Reliance GSM is offering services at cheaper rate.

66

Agree

Neutral

Disagree

Strongly disagree

10.5 Reliance has strong position in the national economy as a leader 10.6 One out of every four investors in India is a Reliance shareholder. Q11. What do you think about the performance of Reliance GSM in Indian economy? a) Reliance would enjoy a strong position in India's economy with group revenues of more than 3.5 per cent of India's GDP. b) With globally competitive capital and operating cost positions, Reliance Group dominates the rapidly growing Indian market deriving over 80% of its revenues from the domestic market. c) Reliance group contributes10 per cent of the Government of India's indirect tax revenues. d) The acquisition of more GSM spectrum allocation could have also helped Reliance march past Bharti to garner a dominant market share. Thanks for your co-operation.

67