You are a consultant who works for the Diligent Consulting Group. In this Case, you are engaged
Question:
You are a consultant who works for the Diligent Consulting Group. In this Case, you are engaged on a consulting basis by Loving Organic Foods. In order to get a better idea of what might have motivated customers’ buying habits you are asked to analyze a customer database. You realize the database is still incomplete, so you recontact these customers and collect additional information. The database now includes “Annual Amount Spent on Organic Food,” “Age,” “Annual Income,” “Number of People in the Household,” and “Gender.” Case Assignment: Using Excel, generate descriptive statistics for these new variables: “Annual Income,” “Number of People in the Household,” and “Gender.” You have much more information about the customers than you did in the Module 1 Case.
| Annual Amount Spent on Organic Food | Age | Annual Income | Number of People in Household | Gender (0 = Male; 1 = Female) |
| 7348 | 77 | 109688 | 3 | 1 |
| 11598 | 47 | 109981 | 5 | 1 |
| 9224 | 23 | 112139 | 4 | 1 |
| 12991 | 38 | 113420 | 5 | 1 |
| 16556 | 58 | 114101 | 5 | 0 |
| 11515 | 44 | 115100 | 5 | 0 |
| 10469 | 34 | 116330 | 5 | 0 |
| 17933 | 75 | 116339 | 6 | 0 |
| 18173 | 32 | 117907 | 7 | 0 |
| 12305 | 39 | 119071 | 5 | 1 |
| 9080 | 65 | 58603 | 5 | 1 |
| 9113 | 48 | 58623 | 4 | 1 |
| 6185 | 48 | 61579 | 2 | 1 |
| 6470 | 49 | 62180 | 2 | 0 |
| 6000 | 57 | 62202 | 5 | 1 |
| 6760 | 71 | 68041 | 2 | 0 |
| 8579 | 47 | 68407 | 4 | 1 |
| 7393 | 47 | 69618 | 3 | 1 |
| 8161 | 28 | 73079 | 4 | 0 |
| 10800 | 63 | 75900 | 5 | 1 |
| 6160 | 24 | 77129 | 3 | 1 |
| 10800 | 66 | 79618 | 6 | 0 |
| 8543 | 24 | 81131 | 4 | 0 |
| 17666 | 38 | 86246 | 6 | 1 |
| 12644 | 54 | 89167 | 5 | 1 |
| 14308 | 28 | 89576 | 5 | 1 |
| 9737 | 58 | 92296 | 4 | 0 |
| 13301 | 27 | 93614 | 5 | 1 |
| 18106 | 48 | 93954 | 6 | 1 |
| 11468 | 26 | 95937 | 5 | 1 |
| 9547 | 52 | 100846 | 4 | 0 |
| 7812 | 29 | 103276 | 2 | 1 |
| 15521 | 75 | 104112 | 5 | 1 |
| 7598 | 45 | 105119 | 4 | 0 |
| 7783 | 74 | 105925 | 3 | 1 |
| 17737 | 56 | 106084 | 6 | 0 |
| 7824 | 30 | 108616 | 3 | 1 |
| 6552 | 57 | 109038 | 2 | 0 |
| 11232 | 41 | 109585 | 5 | 1 |
| 6540 | 23 | 37834 | 5 | 0 |
| 4200 | 28 | 38940 | 5 | 0 |
| 7225 | 23 |
Expert Answer:Introduction Market survey is a valuable tool that is used to analyze and interpret buying behaviors and patterns of the target consumers which in return facilitates the formulation of suitable market... View the full answer
Related Book For
Posted Date:
|
