Final Exam Project (Group Project 3) Your client, Ms. Jane Garland, needs your help and guidance on the following issues and questions. Your job is to submit a professionally prepared management report that addresses all of the questions and issues raised below. The report should contain results of appropriate analyses, proper interpretations and recommendations. Remember: you are using sample data and your job is to make inferences and generalizations about the population (Caution: it is okay teams helping other teams for learning purposes, but make sure the work is your team's own and it is not plagiarized from another source or team. Honesty is vitally important): 1) Is preference for simple dcor or elegant dcor related to age? Explain and provide useful insights on this matter. 2) Is preference for waterview related to preferences for menu, dcor, and atmosphere related factors? If so, what is the nature of the relationship? What are the implications for your client? 3) Is there a significant difference between males and females regarding what they would expect an average evening meal entree item to be priced ? Explain. 4) With respect to the restaurant's dcor, is a elegant dcor preferred over simple dcor? What are the implications? Explain. 5) It has been speculated that the potential customers living in different geographic areas identified by zip codes would have different reactions to the prospect of patronizing (as measured by variable 'likely') a new upscale restaurant. Are these anticipated differences substantiated by the survey? Perform the proper analysis, interpret your findings, and make proper recommendations regarding zip code areas to target for promoting the new restaurant. Which zip code area has the most promising potential customers? Why? 6) Theorize/formulate predictive models with the variable 'likely' as the dependent variable to address the following questions and issues. Test the models using multiple regression analysis and interpret your findings. a) What is the demographic target market definition for the new restaurant? b) What is the restaurant spending behavior target market definition for the new restaurant? c) Now use restaurant feature preferences for target market definition for the new restaurant. Provide a ranking of the features from the best predictor to the least. In other words, tell Jane which feature is most important, second most important etc. (Caution: some of these independent variables may not be appropriate or suitable for regression analysis!). 1 7) You will notice that in the data file there is a new variable called \"VLpatron\". This categorical scale variable was created by recoding the metric scale variable \"likely\" to distinguish \"Probable patrons\" for the restaurant (likely to patronize the prospective new restaurant =4 or =5) from \"Not probable patrons\" (likely to patronize the prospective new restaurant =1, =2, or =3). If the \"Probable patrons\Prospective New Restaurant Survey This research is being conducted by XYZ research and is a survey about your attitudes, habits, and preferences for restaurants. There are different types of restaurants such as fast food restaurants or cafeterias or snack bars. But this survey is not about these types of restaurants. When you answer the questions which follow, we want you to think in terms of a particular type of restaurant defined as: A restaurant in which you are normally seated by a hostess; there is a menu with several choices for appetizers, entrees, desserts, and beverages; and food is served by a waiter or waitress assigned to your table. 1) Do you eat at this type of restaurant at least once every two weeks? 1 2 1. Yes.....Continue 2. No.....(Terminate) 2) How many total dollars do you spend/ per month in restaurants (for your meals only)? 3) Now please read the description of another type of restaurant below and answer the following questions. A restaurant with a very elegant decor, offering very personal service in a spacious, semi-private atmosphere, featuring menu items, traditional and unusual, prepared by chefs with international reputations. The atmosphere, food, and service at this restaurant meet a standard equal to that of the finest restaurants in the world. Menu items are priced separately, known as \"a la carte,\" and the prices are what one would expect for a restaurant meeting or surpassing the highest restaurant standards in the world. How likely would it be for you to patronize this restaurant? 5 4 3 2 1 1. Very Likely 2. Somewhat Likely 3. Neither Likely Nor Unlikely 4. Somewhat Unlikely 5. Very Unlikely 4) Thinking again of the restaurant just described and remembering that drinks, appetizers, entrees, and desserts are priced separately (a la carte), what would you expect an average evening meal entree item alone to be priced? 5) Would you describe yourself as one who listens to the radio? 1 2 1. Yes 2. No, Go to question 7 6) To which type of radio programming do you most often listen? 1 2 3 4 5 1. Country & Western 2. Easy Listening 3. Rock 4. Talk/News 5. No Preference 7) Would you describe yourself as a viewer of TV local news? 1 2 1. Yes 2. No, Go to question 9 8) Which newscast do you watch most frequently? 1 2 3 4 1. 7:00 am News 2. Noon News 3. 6:00 pm News 4. 10:00 pm News 9) Do you read the newspaper? 1 2 1. Yes 2. No 10) Which section of the local newspaper would you say you read most frequently? 1 2 1. Editorial 2. Business 3 4 5 6 3. Local 4. Classifieds 5. Life, Health & Entertainment 6. No Preference 11) Do you subscribe to City Magazine? 1 2 1. Yes 2. No We are going to describe some characteristics of restaurants and we want you to tell us how strongly you would prefer each characteristic in a restaurant of your choice. 12) Waterfront view 5 4 3 2 1 1. Very Strongly Prefer 2. Somewhat Prefer 3. Neither Prefer Nor Not Prefer 4. Somewhat Not Prefer 5. Very Strongly Not Prefer 13) Located less than a 30-minute drive from your home 5 4 3 2 1 1. Very Strongly Prefer 2. Somewhat Prefer 3. Neither Prefer Nor Not Prefer 4. Somewhat Not Prefer 5. Very Strongly Not Prefer 14) A formal wait staff wearing tuxedos 5 4 3 2 1 1. Very Strongly Prefer 2. Somewhat Prefer 3. Neither Prefer Nor Prefer 4. Somewhat Not Prefer 5. Very Strongly Not Prefer 15) Unusual desserts such as \"Baked Alaska\" and \"Flaming Bananas Foster\" 5 4 3 2 1 1. Very Strongly Prefer 2. Somewhat Prefer 3. Neither Prefer Nor Not Prefer 4. Somewhat Not Prefer 5. Very Strongly Not Prefer 16) A large variety of entrees 5 4 3 2 1 1. Very Strongly Prefer 2. Somewhat Prefer 3. Neither Prefer Nor Not Prefer 4. Somewhat Not Prefer 5. Very Strongly Not Prefer 17) Unusual entrees such as moose, bison, venison, and pheasant 5 4 3 2 1 1. Very Strongly Prefer 2. Somewhat Prefer 3. Neither Prefer Nor Not Prefer 4. Somewhat Not Prefer 5. Very Strongly Not Prefer 18) Simple decor: tables, chairs, and a few wall decorations 5 4 3 2 1 1. Very Strongly Prefer 2. Somewhat Prefer 3. Neither Prefer Nor Not Prefer 4. Somewhat Not Prefer 5. Very Strongly Not Prefer 19) Elegant decor: curtains, original paintings, fine furniture 5 1. Very Strongly Prefer 4 3 2 1 2. Somewhat Prefer 3. Neither Prefer Nor Not Prefer 4. Somewhat Not Prefer 5. Very Strongly Not Prefer 20) A string quartet for background music 5 4 3 2 1 1. Very Strongly Prefer 2. Somewhat Prefer 3. Neither Prefer Nor Not Prefer 4. Somewhat Not Prefer 5. Very Strongly Not Prefer 21) A jazz combo for background music 5 4 3 2 1 1. Very Strongly Prefer 2. Somewhat Prefer 3. Neither Prefer Nor Not Prefer 4. Somewhat Not Prefer 5. Very Strongly Not Prefer Demographic questions to classify your answers. 22) The following questions are asked for classification purposes only. In which year were you born? 23) What is your highest level of education? 1 2 3 4 5 6 1. Less Than High School 2. Some High School 3. High School Graduate 4. Some College (No Degree) 5. Associate Degree 6. Bachelor's Degree 7 8 7. Master's Degree 8. Doctorate Degree 24) What is your marital status? 1 2 3 1. Single 2. Married 3. Other 25) Including children under 18 years of age living with you, what is your family size? 26) Please check the letter that includes the zip code in which you live. 1 2 3 4 A. (1 & 2) B. (3, 4, & 5) C. (6, 7, 8, & 9) D. (10, 11, & 12) 27) Which of the following categories best describes your before tax household income? 1 2 3 4 5 6 7 1. Household Earning< $15,000 2. Household Earning $15,000-$24,999 3. Household Earning $25,000-$49,999 4. Household Earning $50,000-$74,999 5. Household Earning $75,000-$99,999 6. Household Earning $100,000-$149,999 7. Household Earning $150,000+ 28) What is your gender? 1 2 1. Male 2. Female When you have completed all relevant questions, please click the \"submit\" button