marketing homework
Microsoft Word - Short_Credit Card Survey.doc Credit Card Survey [variable names in brackets] page 1 Thank you for your willingness to participate in this survey. Your responses are important to us and your answers will remain anonymous. Thank you again for your assistance. Part One – Credit Cards Q: In the following questions, if evaluating a credit card offer with a charitable donation option that lets you decide who receives your money, which one of these five organizations would you choose to support? (pick one) [pikcause] o American Cancer Society o World Health Organization o Habitat for Humanity o SchoolWise (for local schools) o National Wildlife Federation Q: Which of these options do you prefer most? [binary1] 1% of your monthly charges donated to the charity you selected 1% of your monthly charges credited back to you Q: Which of these options do you prefer most? [binary2] 5% of your monthly charges donated to the World Health Organization 1% of your monthly charges credited back to you Q: Which of these options do you prefer most? [binary3] 5% of your monthly charges donated to the World Health Organization 1% of your monthly charges donated to the charity you selected Q: Which of these options do you prefer most? [binary4] 5% of your monthly charges donated to the charity you selected 5% of your monthly charges credited back to you Q: On a scale from 1 (extremely unappealing) to 7 (extremely appealing) rate the following credit card payback options [ryou; rwho; rboth; rchoose] Extremely Unappealing Extremely Appealing 1 2 3 4 5 6 7 Percentage of your monthly charges credited back to you • • • • • • • Percentage of your monthly charges donated to the World Health Organization • • • • • • • Percentage of your monthly charges donated to the World Health Organization and Habitat for Humanity • • • • • • • Percentage of your monthly charges donated to the charity you selected • • • • • • • Q: Ranging from 1(never) to 7 (several times a day) approximately how often do you use credit cards?[freqcc] Never Almost Never Monthly Weekly Several Times a Week Daily Several Times a Day 1 2 3 4 5 6 7 • • • • • • • Credit Card Survey [variable names in brackets] page 2 Q: Do you currently have a credit card that earns “points” or “rewards”? [rewdcard] Yes ____ No ______ Q: Do you currently have a credit card that earns “hotel rewards”? [hotcard] Yes ____ No ______ Q: Do you currently have a credit card that earns “airline rewards”? [aircard] Yes ____ No ______ Q: Do you currently have a credit card that pays you cash back? [cashcard] Yes ____ No ______ Q: Do you currently have a Capital One credit card? [capcard] Yes ____ No ______ Part Two – Consumer Profile Q: On a scale from 1 (very bad) to 7 (very good), what is your overall attitude toward the following organizations? [acs; who; habitat; school; nwf; red; init] Very Bad Very Good 1 2 3 4 5 6 7 American Cancer Society • • • • • • • World Health Organization • • • • • • • Habitat for Humanity • • • • • • • SchoolWise • • • • • • • National Wildlife Federation • • • • • • • American Red Cross • • • • • • • Initiative for Health • • • • • • • Q: Please answer the following questions about you. Gender (circle one) [gender] Female Male State of Residence (select one) _____ [state] Age (circle one) [age] a) 19-24 years old b) 25-34 years old c) 35-44 years old d) 45-54 years old e) 55-64 years old f) 65+ years old Q: Are your married? [married] Yes _____ No ______ Q: Do you have children? [children] Yes _____ No ______ Level of educational attainment (circle one) [educatio] a) High School b) Some college c) Bachelor’s Degree d) Graduate degree Credit Card Survey [variable names in brackets] page 3 Annual household income (circle one) [income] a) Under $35,000 b) $35,000 to under $50,000 c) $50,000 to under $75,000 d) $75,000 to under $100,000 e) $100,000 and over Political Affiliation (select one) [politics] a) Republican b) Democrat c) Independent d) Other Q: On a scale from 1 (strongly disagree) to 7 (strongly agree), what is your perspective on each of the following statements? [help; charity; compassi; liberal] Strongly Disagree Strongly Agree 1 2 3 4 5 6 7 People should be willing to help others who are less fortunate. • • • • • • • Money given to charities goes for good causes. • • • • • • • I consider myself to be a compassionate person. • • • • • • • I would characterize my political views as liberal. • • • • • • • Q: What is the average monthly amount you charge to credit cards? [charge] _____________________ 4202-LAB 3 Part 1: 1) a) Given the correlation coefficient, what is the direction of this relationship? Type Answer here a) What is your statistical conclusion for this hypothesis test?Type Answer here 2)a) What is the value of the intercept? Type Answer here b) What is the value of the slope?Type Answer here c) What is the Null hypothesis of the slope? Type Answer here d) What is the P-value of the slope parameter? Type Answer here e) What is your interpretation of this result from the slope? Type Answer here f) How much of the variation in the DV are explained by the model? Type Answer here 3) a) What is the value of the slope from price?Type Answer here b) How to interpret the slope of price? Type Answer here c) What is the P-value of the slope parameter from price? Type Answer here d) What is the value of the slope from feature?Type Answer here e) How to interpret the slope of feature? Type Answer here f) What is the P-value of the slope parameter from feature? Type Answer here g) How much of the variation in the DV are explained by the model? Type Answer here Regarding the comparison of the two regressions h) Consider the adjusted R-square. How would you interpret the increase in explanatory power of the feature and display variables in the second regression compared to the first regression?Type Answer here i) As a manager, which regression model would you use to predict sales? Explain Type Answer here j) By M2, What is the predicted sales if we having display promotion and price $8, but not feature promotion? Type Answer here k) By M2, what is the changes on sales if we decreased price by 1 dollar but got rid of feature? (keeping display constant) Type Answer here 4) a) Which competitors’ price is significant? What is the intuition of the correlation between own sales and competitor’s price? Which competitor’s price estimation is counter intuitive?Type Answer here b) Is there any multicolinearity problem? Type Answer here. 5) I. Please answer the following question by using SPSS a) How many respondents have a card that earns airline miles? Please also Use a pie chart to illustrate this answer. Type Answer here b) How many women have a credit card that earn airline miles? Please also display this response using a cross tab? Type Answer here c) Comment on the central tendency and spread of the two variables rating cash back, rating charity of choice. Please also display it by a boxplot Type Answer here d) If I want to know whether there is a gender difference in political affiliation, which crosstab should I use (which group should sum up to 1 for this question? Each gender group or each political party group)? Please also display the cross tab Type Answer here 5) II) Please answer the following question and use SPSS to show Hypothesis testing tables (attaching corresponding tables) For each of the following questions, indicate 1) what is H0, 2) what is Ha, 3) which statistical test you would do, and 4) perform the test in SPSS, provide the p-value and write down your conclusion. · Want to know if there is any dependence between gender and annual income Ho: Ha: Test: Result: Conclusion: · Want to know if there is a monthly charge to credit card difference between male and female Ho: Ha: Test: Result: Conclusion: · Is there any difference in perspective on charity (charity) between different age groups? Ho: Ha: Test: Result: Conclusion: 1 CONTENTS A. CORRELATIONS SPSS LAB 3 DESCRIPTIVE STATISTICS, HYPOTHESIS TESTING, Regression Part 1: A closer look at the Pizza dataset ................................................................................................................................................... 1 A. Correlations ....................................................................................................................................................................................... 1 B. Simple regression............................................................................................................................................................................... 2 C. Multiple regression ..............................................................................................................................................