MARKET RESEARCH FOR THE VALUE AND FREQUENCY

QUESTION

The questionnaire used for this gift card study is posted on Blackboard which you will need to help you interpret the data. Note: to simplify the exam, several questions from the survey are not included in your data file, including questions Q6, 10, 11, 12, 13, 14, 15, 17, 18, 19, 20, 21, 24, 26, 27, 28, 29, 30.

 

You may use either XL and/or SPSS to answer the following questions (unless otherwise specified).

 

1. What is your data file number (1 point)?

 

 

2. Copy and paste a portion of the raw data, before you have done any formatting changes (make sure to include the column with respondent ID). (1 point)

 

 

3. Put the data into proper format according to class discussion. Please copy and paste a portion of the file after you have put it in the correct format. Be sure to include the column with respondent ID. (2 points)

 

 

4. To meet the needs of the client, any respondent who does not have a respondent ID value (designated as a ‘-1’ in the ID column), will be eliminated from the study and the remainder of the analysis. To do so, please create a pivot table that shows how many participants have, and do not have, an ID number. Please copy and paste this pivot table below. How many respondents are you eliminating? What is your final usable sample size? For the remainder of this Assignemt, please only use the sample size where all participants have an ID number (i.e. the “usable” sample size) (2 points)

 

5. Edit and code the data  (including plug rules) to make it easier to interpret. For example, a ‘1’ on the age question does not mean the respondent is one year old. Rather, the age question needs to be recoded so that the ‘1’ for age reflects an appropriate value based on the response option from the survey. This step will be quite time consuming since many questions need to be recoded, so do not wait until the last minute to start this part of the assignment.

Please copy and paste a portion of your re-coded spreadsheet below. Also, list the questions that you recoded, and the procedure you used for the recoded (i.e. coded 3’s as a ‘1’ and blanks as a ‘0’ for Question Z). If you like, you can copy and paste the XL code you used.

For the remaining question, please be sure to use the data file with your recoded/edited/corrected values. (10 points)

 

 

6a . What are the frequencies for the start value on the gift card (Q16)? Use your re-coded information if appropriate. Copy and paste the table below. (4 points)

 

6b. What are the frequencies for age (Q23)? Use your re-coded information if appropriate. Copy and paste the table below (4 points)

 

 

7a. Create a single table with the mean values for all of the attribute ratings (Q22 from the survey), in rank order from high to low. Use your re-coded information, if appropriate. For this table include, sample size, mean, min, max, and standard deviation. Please copy and paste the table below. (4 points)

 

7b. Create a single table with only the mean values for all of the attribute ratings (Q22 from the survey), in alphabetical order. Use your re-coded information, if appropriate. For this table, include only sample size and mean. Please copy and paste the table below. (4 points)

 

 

8. The client has asked for a summary of the gift card category (i.e. percent of consumers who have received a gift card, average starting value on a gift card, etc.). Based on your data, please write 2  to 4 paragraphs to summarize the category. Be sure to include appropriate tables, including sample size. (10 points).

 

9. The client is particularly interested in the percent of respondents that have USED a gift card at each of the restaurants (Q7 from the survey), as well as those that HAVE a gift card for each of the restaurants (Q8 from the survey). Please write 1 or 2 paragraphs to summarize this specific information. Be sure to include appropriate tables, including sample size. (4 points)

 

10a. Create a perceptual map using any two reasonable variables from the data. The graph should be completed in XL, and please label the graph and axis. Copy and paste the perceptual map below. (4 points)

 

10b. Please write 1 or 2 paragraphs to summarize the information from your perceptual map in Q10a. (4 points)

 

11a. The client needs to know the interaction between respondents who have purchased a gift card for themselves versus those that have purchased a gift card for others. That is, how many respondents have purchased a gift card for BOTH themselves and for others, just for others, just for themselves, or for neither? Please summarize your findings in 1 or 2 paragraphs and include appropriate tables (and sample size). (4 points)

 

11b. Based on the data the above question, please create an appropriate graph and/or diagram to summarize the information. Please copy and paste the graph and/or diagram below.  (4 points)

 

12. Create a new variable, where ‘1’ = respondents that have used any restaurant gift card, and   ‘0’ = have not used any restaurant gift card (based on Q7 from the survey). Using the new variable, create a single, simple table that shows the percent of respondents who use any restaurant gift card. Please be sure to include the sample size in your table. Copy and paste the table below. (4 points)

13a. Create a cross-tab table of gender (Q23) versus start value of the gift card (Q26). Gender should be the column variable. The cross tab table should show vertical percentages, but not horizontal percentages. Copy and paste the table below. (4 points)

 

13b. Write 1 or 2 paragraphs to summarize what you learned from the table you created for 13a. (4 points)

 

14a. The client wants to know if there is a difference in MEAN AGE by used/not used any restaurant gift certificates (i.e. using the new variable you created for Q12 above). Please write up 1 to 2 paragraphs to answer the client’s questions. Be sure to be technically complete in your answer. Please copy and paste all of the appropriate tables below (including the table with the mean values for age). (6 points)

 

14b. The client also wants to know if there is a difference in GENDER by used/not used any restaurant gift certificates (i.e. using the new variable you created for Q12 above). Please write up 1 to 2 paragraphs to answer the client’s questions. Be sure to be technically complete in your answer. Please copy and paste all of the appropriate tables below. (6 points)

 

15a. Finally, the client would like to know if there is a relationship between start value on gift cards (Q16 from the survey) and any of the attribute ratings (Q22 from the survey). You may use any appropriate method to answer this question. Please write 2 to 4 paragraphs to answers the client’s question. Be sure to include tables that are appropriate. (10 points)

 

15b. Can you use the any of the results you reported in Q15a to predict the start value on the gift card if the first attribute (“A gift card is a great way to make sure the receiver gets exactly what they want”) has a value of 4.5? If so, what is your prediction? Is this prediction dependable? Write up 1 to 3 paragraphs to explain your point of view and include any appropriate tables and/or graphs. (4 points)

 

 

 

 

16. Think of a product that has been introduced recently, but is struggling to achieve its sales goals or is suffering some other problem (or at least as much as you can tell from public information).

  • What product/company did you select?
  • What overall research question does this company (or product) face?
  • What are three hypotheses for why sales are lower than desired?
  • Assume you have been retained to conduct a survey on this new product/company. What are the first 8 questions you would ask in a survey to help address the overall research questions and/or hypotheses?
  • Please be VERY specific with your questions and the response options. (5 points)

SOLUTION

2. Copy and paste a portion of the raw data, before you have done any formatting changes (make sure to include the column with respondent ID). (1 point)

 

RespondentID CollectorID StartDate EndDate Have you ever RECEIVED a gift card? By “gift card,” we mean the plastic cards you can purchase at a specific retailer instead of a paper certificate, not a greeting card or a frequent shopper card. Have you ever PURCHASED a gift card, either for yourself or someone else? Again, by “gift card,” we mean the plastic cards you can purchase at a specific retailer instead of a paper certificate, not a greeting card or a frequent shopper card. (Please select all that apply) How likely are you to purchase a gift card during the next 12 months? Would you say you are…
        Response Yes, for myself Yes, for someone else No Don’t Know Response

900000002

11245115

11/13/2009

11/13/2009

1

2

1

907625070

11245115

11/13/2009

11/13/2009

1

2

1

-1

11245115

11/13/2009

11/13/2009

1

2

2

907538898

11245115

11/13/2009

11/13/2009

1

2

2

907489507

11245115

11/13/2009

11/13/2009

1

2

2

907399520

11245115

11/13/2009

11/13/2009

1

2

3

907271500

11245115

11/13/2009

11/13/2009

1

2

1

907205304

11245115

11/13/2009

11/13/2009

1

3

5

 

3. Put the data into proper format according to class discussion. Please copy and paste a portion of the file after you have put it in the correct format. Be sure to include the column with respondent ID. (2 points)

RespondentID

CollectorID

StartDate

EndDate

Q1

Q2

Q3

        Response Yes, for myself Yes, for someone else No Don’t Know Response

900000002

11245115

11/13/2009

11/13/2009

1

2

1

907625070

11245115

11/13/2009

11/13/2009

1

2

1

-1

11245115

11/13/2009

11/13/2009

1

2

2

907538898

11245115

11/13/2009

11/13/2009

1

2

2

907489507

11245115

11/13/2009

11/13/2009

1

2

2

907399520

11245115

11/13/2009

11/13/2009

1

2

3

907271500

11245115

11/13/2009

11/13/2009

1

2

1

907205304

11245115

11/13/2009

11/13/2009

1

3

5

 

4. To meet the needs of the client, any respondent who does not have a respondent ID value (designated as a ‘-1’ in the ID column), will be eliminated from the study and the remainder of the analysis. To do so, please create a pivot table that shows how many participants have, and do not have, an ID number. Please copy and paste this pivot table below. How many respondents are you eliminating? What is your final usable sample size? For the remainder of this Assignemt, please only use the sample size where all participants have an ID number (i.e. the “usable” sample size) (2 points)

Ans: In total, 51 data points were eliminated reducing the sample size to 89.

 

 

Count of Slno

RespondentID Total RespondentID Total RespondentID Total RespondentID Total RespondentID Total

-1

51

905205076

1

906194308

1

906686032

1

907205304

1

900000002

1

905207751

1

906204362

1

906690769

1

907271500

1

905024922

1

905237499

1

906216478

1

906708567

1

907399520

1

905027026

1

905439352

1

906242037

1

906726291

1

907489507

1

905038690

1

905449186

1

906249078

1

906755912

1

907538898

1

905038941

1

905466267

1

906282498

1

906795674

1

907625070

1

905053435

1

905472536

1

906333275

1

906801428

1

Grand Total

140

905054971

1

905485562

1

906511363

1

906855414

1

905062268

1

905571947

1

906547892

1

906871923

1

905074199

1

905638295

1

906548597

1

906886354

1

905089113

1

905678358

1

906551355

1

906891507

1

905101421

1

905731604

1

906560033

1

906904616

1

905103388

1

905742297

1

906588794

1

907007899

1

905115289

1

905832643

1

906595438

1

907103848

1

905128314

1

905993782

1

906597148

1

907105281

1

905129451

1

906030898

1

906598863

1

907107993

1

905146741

1

906035395

1

906609298

1

907110339

1

905168290

1

906132156

1

906620274

1

907120531

1

905173576

1

906133135

1

906638076

1

907155645

1

905185250

1

906178940

1

906672041

1

907168859

1

905187262

1

906179058

1

906684156

1

907193189

1

 

5. Edit and code the data (including plug rules) to make it easier to interpret. For example, a ‘1’ on the age question does not mean the respondent is one year old. Rather, the age question needs to be recoded so that the ‘1’ for age reflects an appropriate value based on the response option from the survey. This step will be quite time consuming since many questions need to be recoded, so do not wait until the last minute to start this part of the assignment.

Please copy and paste a portion of your re-coded spreadsheet below. Also, list the questions that you recoded, and the procedure you used for the recoded (i.e. coded 3’s as a ‘1’ and blanks as a ‘0’ for Question Z). If you like, you can copy and paste the XL code you used.

For the remaining question, please be sure to use the data file with your recoded/edited/corrected values. (10 points)

Ans: The recoding was done for Q2, Q7 and Q8.

SL No

Respondent

ID

Collector

ID

Start

Date

End

Date

Received Gift Card

Purchased for myself

Purchased for someone else

Not Purchased

Don’t Know

1

900000002

11245115

13-Nov-09

13-Nov-09

1

2

1

2

2

2

907625070

11245115

13-Nov-09

13-Nov-09

1

2

1

2

2

3

907538898

11245115

13-Nov-09

13-Nov-09

1

2

1

2

2

4

907489507

11245115

13-Nov-09

13-Nov-09

1

2

1

2

2

5

907399520

11245115

13-Nov-09

13-Nov-09

1

2

1

2

2

6

907271500

11245115

13-Nov-09

13-Nov-09

1

2

1

2

2

7

907205304

11245115

13-Nov-09

13-Nov-09

1

2

2

1

2

8

907193189

11245115

13-Nov-09

13-Nov-09

1

1

1

2

2

 

6a . What are the frequencies for the start value on the gift card (Q16)? Use your re-coded information if appropriate. Copy and paste the table below. (4 points)

Count of SL No  
Avg_Starting_Value Total

0

2

1

1

2

3

3

13

4

31

5

1

6

6

7

1

9

31

Grand Total

89

 

 

6b. What are the frequencies for age (Q23)? Use your re-coded information if appropriate. Copy and paste the table below (4 points)

Count of SL No  
Age Total

0

2

2

47

3

32

4

7

7

1

Grand Total

89

 

7a. Create a single table with the mean values for all of the attribute ratings (Q22 from the survey), in rank order from high to low. Use your re-coded information, if appropriate. For this table include, sample size, mean, min, max, and standard deviation. Please copy and paste the table below. (4 points)

 

Descriptive Statistics

 

N

Minimum

Maximum

Mean

Std. Deviation

A gift card is a great idea to give someone who is hard to shop for

89

0

5

4.09

1.184

I’m usually very happy to receive a gift card as a gift

89

0

5

3.85

1.144

It doesn’t take much thought or effort to buy a gift card

89

0

5

3.83

1.290

With a gift card, I can buy what I want and know that it is the right thing

89

0

5

3.75

1.218

I like gift cards because it is like free money that you have to spend

89

0

5

3.71

1.333

With a gift card, I can pick out exactly what I want

89

0

5

3.69

1.276

I prefer to receive gift cards from people who do not know me well

89

0

5

3.65

1.226

I have a better time picking out gifts for myself than others picking them out for me

89

0

5

3.57

1.242

From close friends, I prefer to receive personal items as gifts

89

0

5

3.54

1.178

You don’t have to stress about giving the “perfect gift” when you give a gift card

89

0

5

3.53

1.358

A gift card gives me freedom of choice

89

0

5

3.46

1.340

I give a gift card when I’m too lazy to go look for anything

89

0

5

3.43

1.269

I prefer to receive personal items as gifts from family members

89

0

5

3.40

1.312

A gift card is a great way to make sure the receiver gets exactly what they want

89

0

5

3.39

1.328

A gift card keeps me in control

89

0

5

3.04

1.205

I don’t care about the money on a gift card, I care about the thought

89

0

5

3.00

1.331

Gift cards are the same as getting money

89

0

5

2.82

1.419

Gift cards are more convenient than money

89

0

5

2.33

1.372

Valid N (listwise)

89

       

 

 

7b. Create a single table with only the mean values for all of the attribute ratings (Q22 from the survey), in alphabetical order. Use your re-coded information, if appropriate. For this table, include only sample size and mean. Please copy and paste the table below. (4 points)

 

Descriptive Statistics

 

N

Mean

A gift card gives me freedom of choice

89

3.46

A gift card is a great idea to give someone who is hard to shop for

89

4.09

A gift card is a great way to make sure the receiver gets exactly what they want

89

3.39

A gift card keeps me in control

89

3.04

From close friends, I prefer to receive personal items as gifts

89

3.54

Gift cards are more convenient than money

89

2.33

Gift cards are the same as getting money

89

2.82

I don’t care about the money on a gift card, I care about the thought

89

3.00

I give a gift card when I’m too lazy to go look for anything

89

3.43

I have a better time picking out gifts for myself than others picking them out for me

89

3.57

I like gift cards because it is like free money that you have to spend

89

3.71

I’m usually very happy to receive a gift card as a gift

89

3.85

I prefer to receive gift cards from people who do not know me well

89

3.65

I prefer to receive personal items as gifts from family members

89

3.40

It doesn’t take much thought or effort to buy a gift card

89

3.83

With a gift card, I can buy what I want and know that it is the right thing

89

3.75

With a gift card, I can pick out exactly what I want

89

3.69

You don’t have to stress about giving the “perfect gift” when you give a gift card

89

3.53

Valid N (listwise)

89

 

 

 

8. The client has asked for a summary of the gift card category (i.e. percent of consumers who have received a gift card, average starting value on a gift card, etc.). Based on your data, please write 2 to 4 paragraphs to summarize the category. Be sure to include appropriate tables, including sample size. (10 points)

Count of SL No  
Frequency of Purchase for yourself Total

0

1

1

72

2

4

3

5

4

2

5

4

8

1

Grand Total

89

Count of SL No  
Received Gift Card Total % of receptance

1

87

97.75%

2

1

1.12%

3

1

1.12%

Grand Total

89

 

 

Ans: The survey respondents for the gift card category are across different age groups (for table check Q6b). The data shows that the respondents are mostly young comprising of more than 84% of the sample.

The frequency of purchase for themselves and for others show a unique distribution as around 81% of the sample purchase once in a year for themselves. However, multiple purchases are made by almost 80% of the sample. This shows that one buys less frequently for oneself and gifts others more frequently within a year.

Moreover, out of the total sample around 98% of them have received a gift card from someone or the other. We can, therefore, conclude that most of the respondents have received a gift and also buy gifts for themselves as well as others at least once a year.

 

Count of SL No  
Frequency of Purchase for others Total

0

1

1

9

2

12

3

26

4

14

5

11

6

11

7

3

11

2

Grand Total

89

 

 

 

 

 

 

9. The client is particularly interested in the percent of respondents that have USED a gift card at each of the restaurants (Q7 from the survey), as well as those that HAVE a gift card for each of the restaurants (Q8 from the survey). Please write 1 or 2 paragraphs to summarize this specific information. Be sure to include appropriate tables, including sample size. (4 points)

Ans: There is no such respondent who has either used a gift card at each of the restaurants or has a gift for each of the restaurants. There are very few respondents with multiple entries for both Q7 and Q8 from the survey.

10a. Create a perceptual map using any two reasonable variables from the data. The graph should be completed in XL, and please label the graph and axis. Copy and paste the perceptual map below. (4 points)

10b. Please write 1 or 2 paragraphs to summarize the information from your perceptual map in Q10a. (4 points)

Ans: The above graph shows that the distribution of the average Starting value is similar for the most likely and somewhat likely buyers of gift cards within 12 months. Those who are neutral about their buying decision would like to spend very less amount for buying the gift cards if at all they do. The distribution for somewhat unlikely buyers is slightly random and for most unlikely buyers the starting value is more towards the costlier side.

11a. The client needs to know the interaction between respondents who have purchased a gift card for themselves versus those that have purchased a gift card for others. That is, how many respondents have purchased a gift card for BOTH themselves and for others, just for others, just for themselves, or for neither? Please summarize your findings in 1 or 2 paragraphs and include appropriate tables (and sample size). (4 points)

Count of SL No        
Purchased for myself Purchased for someone else Not Purchased Don’t Know Total

1

1

2

2

24

    2 Total  

24

  1 Total    

24

 

2

2

2

4

    2 Total  

4

  2 Total    

4

1 Total      

28

2

1

2

2

59

    2 Total  

59

  1 Total    

59

 

2

1

2

1

    1 Total  

1

   

2

2

1

    2 Total  

1

  2 Total    

2

2 Total      

61

Sample Size      

89

 

11b. Based on the data the above question, please create an appropriate graph and/or diagram to summarize the information. Please copy and paste the graph and/or diagram below.  (4 points)

12. Create a new variable, where ‘1’ = respondents that have used any restaurant gift card, and   ‘0’ = have not used any restaurant gift card (based on Q7 from the survey). Using the new variable, create a single, simple table that shows the percent of respondents who use any restaurant gift card. Please be sure to include the sample size in your table. Copy and paste the table below. (4 points)

Count of SL No  
Usage Total

0

51

1

38

Sample Size

89

 

13a. Create a cross-tab table of gender (Q23) versus start value of the gift card (Q26). Gender should be the column variable. The cross tab table should show vertical percentages, but not horizontal percentages. Copy and paste the table below. (4 points)

 

Avg_Starting_Value * Age Crosstabulation

     

Age

Total

     

0

2

3

4

7

Avg_Starting_Value 0 Count

2

0

0

0

0

2

% within Age

100.0%

.0%

.0%

.0%

.0%

2.2%

1 Count

0

1

0

0

0

1

% within Age

.0%

2.1%

.0%

.0%

.0%

1.1%

2 Count

0

3

0

0

0

3

% within Age

.0%

6.4%

.0%

.0%

.0%

3.4%

3 Count

0

8

5

0

0

13

% within Age

.0%

17.0%

15.6%

.0%

.0%

14.6%

4 Count

0

15

12

3

1

31

% within Age

.0%

31.9%

37.5%

42.9%

100.0%

34.8%

5 Count

0

0

1

0

0

1

% within Age

.0%

.0%

3.1%

.0%

.0%

1.1%

6 Count

0

3

3

0

0

6

% within Age

.0%

6.4%

9.4%

.0%

.0%

6.7%

7 Count

0

1

0

0

0

1

% within Age

.0%

2.1%

.0%

.0%

.0%

1.1%

9 Count

0

16

11

4

0

31

% within Age

.0%

34.0%

34.4%

57.1%

.0%

34.8%

Total Count

2

47

32

7

1

89

% within Age

100.0%

100.0%

100.0%

100.0%

100.0%

100.0%

 

 

 

13b. Write 1 or 2 paragraphs to summarize what you learned from the table you created for 13a. (4 points)

Ans: The above table is a cross tabulation between age of the respondents and their preference of starting value. It is clear that the sample size only consists of people belonging to only few age brackets (under 18, 22-34, and 45-49). Under 18 respondents (2) are interested in buying only gift cards with the lowest prices, whereas, the only respondent in the bracket 45-49 prefers to buy cards with medium price around $21-$30. Similarly, the age bracket prefer either medium range or do not have any gift cards. The majority of the respondents (more than half) belong to the age group (22-24) and the buying behavior is not restricted to a single price level. Similarly, for the age group 25-29, there is no specific price level that the respondents stick to.

 

14a. The client wants to know if there is a difference in MEAN AGE by used/not used any restaurant gift certificates (i.e. using the new variable you created for Q12 above). Please write up 1 to 2 paragraphs to answer the client’s questions. Be sure to be technically complete in your answer. Please copy and paste all of the appropriate tables below (including the table with the mean values for age). (6 points)

  Usage      
 

0

 

1

  Total Count of SL No
  Count of SL No Average of Age Count of SL No Average of Age  
Total

51

2.47

38

2.61

89

 

The table above shows the mean age for the people who use cards at the restaurants and for those who do not. The value 0 represents non usage of the cards and 1 represents usage. As it can be seen the mean age for the non users is less than that of the users of the cards.

14b. The client also wants to know if there is a difference in GENDER by used/not used any restaurant gift certificates (i.e. using the new variable you created for Q12 above). Please write up 1 to 2 paragraphs to answer the client’s questions. Be sure to be technically complete in your answer. Please copy and paste all of the appropriate tables below. (6 points)

Count of SL No Usage Gender            
 

0

  0 Total

1

    1 Total Grand Total
 

1

2

 

0

1

2

   
Total

26

25

51

2

22

14

38

89

 

Out of the total respondents who do not use cards, the distribution of male and female is almost equal. Male respondents dominate the sample of users of the gift certificates.

15a. Finally, the client would like to know if there is a relationship between start value on gift cards (Q16 from the survey) and any of the attribute ratings (Q22 from the survey). You may use any appropriate method to answer this question. Please write 2 to 4 paragraphs to answers the client’s question. Be sure to include tables that are appropriate. (10 points)

Ans: In order to check whether any relationship exists between the start values on gift cards and the attribute ratings linear regression was performed. The regression was done by taking the start value as dependent variables and the attribute ratings as independent variables. The coefficient matrix is as shown below:

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

t

Sig.

Correlations

B

Std. Error

Beta

Zero-order

Partial

Part

1 (Constant)

1.965

1.500

 

1.310

.194

     
I like gift cards because it is like free money that you have to spend

.012

.318

.006

.037

.971

.220

.004

.004

Gift cards are the same as getting money

-.154

.269

-.080

-.571

.570

.151

-.068

-.060

Gift cards are more convenient than money

-.176

.249

-.089

-.709

.481

.079

-.084

-.075

I don’t care about the money on a gift card, I care about the thought

.318

.284

.155

1.117

.268

.201

.132

.117

I give a gift card when I’m too lazy to go look for anything

.202

.271

.094

.747

.458

.128

.089

.078

I prefer to receive gift cards from people who do not know me well

.021

.329

.009

.064

.949

.150

.008

.007

From close friends, I prefer to receive personal items as gifts

-.832

.402

-.360

-2.070

.042

-.064

-.240

-.218

I prefer to receive personal items as gifts from family members

.345

.343

.166

1.005

.318

.111

.119

.106

It doesn’t take much thought or effort to buy a gift card

.594

.295

.282

2.011

.048

.236

.234

.211

I’m usually very happy to receive a gift card as a gift

.566

.454

.238

1.248

.216

.265

.148

.131

With a gift card, I can pick out exactly what I want

.108

.339

.050

.317

.752

.148

.038

.033

A gift card is a great way to make sure the receiver gets exactly what they want

.116

.355

.057

.328

.744

.225

.039

.034

With a gift card, I can buy what I want and know that it is the right thing

-.358

.374

-.160

-.959

.341

.137

-.114

-.101

You don’t have to stress about giving the “perfect gift” when you give a gift card

.106

.318

.053

.334

.740

.269

.040

.035

A gift card is a great idea to give someone who is hard to shop for

.073

.440

.032

.166

.869

.287

.020

.017

A gift card keeps me in control

.228

.342

.101

.665

.508

.172

.079

.070

A gift card gives me freedom of choice

.062

.327

.031

.190

.850

.150

.023

.020

I have a better time picking out gifts for myself than others picking them out for me

-.285

.328

-.130

-.867

.389

.112

-.103

-.091

a. Dependent Variable: Avg_Starting_Value              

 

Model Summary

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

1

.476a

.227

.028

2.683

a. Predictors: (Constant), I have a better time picking out gifts for myself than others picking them out for me, I prefer to receive personal items as gifts from family members, Gift cards are more convenient than money, I give a gift card when I’m too lazy to go look for anything, I don’t care about the money on a gift card, I care about the thought, A gift card gives me freedom of choice, It doesn’t take much thought or effort to buy a gift card, With a gift card, I can pick out exactly what I want, Gift cards are the same as getting money, I prefer to receive gift cards from people who do not know me well, A gift card keeps me in control, You don’t have to stress about giving the “perfect gift” when you give a gift card, I like gift cards because it is like free money that you have to spend, With a gift card, I can buy what I want and know that it is the right thing, A gift card is a great idea to give someone who is hard to shop for, A gift card is a great way to make sure the receiver gets exactly what they want, From close friends, I prefer to receive personal items as gifts, I’m usually very happy to receive a gift card as a gift

 

The model summary shows that the value of R square as well as adjusted R square is very less and, therefore, we can conclude that no relationship exists. Linear regression helps us in deciding whether the dependent variables are explained by the independent variables or not. In order to accept our results the R square value need to be closer to 1 or any value above .7 is also acceptable.

15b. Can you use the any of the results you reported in Q15a to predict the start value on the gift card if the first attribute (“A gift card is a great way to make sure the receiver gets exactly what they want”) has a value of 4.5? If so, what is your prediction? Is this prediction dependable? Write up 1 to 3 paragraphs to explain your point of view and include any appropriate tables and/or graphs. (4 points)

Ans: In order to predict the value of the start value using only the first attribute we need to perform another regression analysis and, thus, the results of 15a cannot be used as there will be a significant change in the distribution of the coefficients in the linear equation y=mx+c.

The equation derived from the coefficient table (shown below) is Start_value= 2.886+.660*attribute1

So for a value of 4.5, the start value is predicted to be $ 5.856

Coefficientsa

Model

Unstandardized Coefficients

Standardized Coefficients

T

Sig.

Correlations

B

Std. Error

Beta

Zero-order

Partial

Part

1 (Constant)

2.886

1.005

 

2.872

.005

     
A gift card is a great idea to give someone who is hard to shop for

.660

.236

.287

2.794

.006

.287

.287

.287

a. Dependent Variable: Avg_Starting_Value              

Model Summary

Model

R

R Square

Adjusted R Square

Std. Error of the Estimate

1

.287a

.082

.072

2.622

a. Predictors: (Constant), A gift card is a great idea to give someone who is hard to shop for

 

However, the prediction is not correct as shown below in the model summary; the R square value is very low to accept the model.

 

 

 

16. Think of a product that has been introduced recently, but is struggling to achieve its sales goals or is suffering some other problem (or at least as much as you can tell from public information).

  • What product/company did you select?
  • What overall research question does this company (or product) face?
  • What are three hypotheses for why sales are lower than desired?
  • Assume you have been retained to conduct a survey on this new product/company. What are the first 8 questions you would ask in a survey to help address the overall research questions and/or hypotheses?
  • Please be VERY specific with your questions and the response options. (5 points)

Ans: The product selected is a hybrid drink C2, a product of Coca-Cola (Schneider J, Hall J, 2011). The main research question that the company faced is who are the target customers for this product? The product was targeted for young to middle aged men in order to provide a unique drink which is a hybrid of both Coca cola and the diet Coke.

The hypothesis for the failure was that the target customers were dissatisfied with the hybrid nature of the drink.

The questions to be asked for the survey are:

  • What is your age?

A. Below 20    B. 20-40   C. 40-60     D. Above 60

  • Gender

A. Male           B. Female

  • Do you Consume Soft drinks?

A. Yes             B. No

  • Which soft drinks are you aware of?

(list out 3-5 drinks you know)

  • How many times do you consume Soft drinks daily?

A. once or twice B. 4-5 times C. Every hour D. Never

  • Why do you consume Soft Drinks?

A. I like to drink while I eat B. I drink when I am thirsty C. I drink because I like the taste     D. I don’t drink at all

  • What do you like most in a soft drink?

A. Taste           B. Low calories          C. Both

  • Which soft drink do you prefer to drink?

A. Coca Cola B. Diet Coke   C. None

References

Schneider J, Hall J, 2011, Why Most Product Launches Fail, Harvard Business Review, The Magazine April 2011, viewed 24 April 2011 <http://hbr.org/2011/04/why-most-product-launches-fail/ar/2>

 KC30

“The presented piece of writing is a good example how the academic paper should be written. However, the text can’t be used as a part of your own and submitted to your professor – it will be considered as plagiarism.

But you can order it from our service and receive complete high-quality custom paper.  Our service offers Marketing  essay sample that was written by professional writer. If you like one, you have an opportunity to buy a similar paper. Any of the academic papers will be written from scratch, according to all customers’ specifications, expectations and highest standards.”

Please  Click on the  below links to Chat Now  or fill the Order Form !
order-now-new                        chat-new (1)