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
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.”