Please help me solve the following! (I will rate your answer 5 stars

Case Analysis: There are three parts of questions in total, and all the following questions are based on the case. Cory Rogers of CMG Research was working with Jeff Dean, who believed that there was an opportunity to build an upscale restaurant, possibly to be called L'Experience Flicit (for "Delightful Experience") somewhere in the metropolitan area. The proposed restaurant was described as follows: A restaurant with a very elegant decor, offering very personal service in a spacious, semi-private atmosphere, featuring both traditional and unusual menu items prepared by a chef with an international reputation. The atmosphere, food, and service at this restaurant meet the standards of the fi nest restaurants. Menu items are priced separately, known as "d la carte," and the prices are what one would expect for a restaurant meeting the highest restaurant standards. Cory's team had designed an online questionnaire and gathered a representative sample of 400 potential customers. Cory's marketing intern, Christine Yu has conducted some basic descriptive and inference analysis. The code book for the dataset is shown as follows. Based on the provided information, please answer the following questions. Part I (6 points) Which analysis should be used to find the answer to the following questions (you don't need to exactly answer the questions. You only need to identify the appropriate analysis to answer the following research questions). - Is there any difference in preference for waterfront views and drive less than 30 minutes for male customers? - What is the demographical composition for the sample collected to understand likelihood of patronizing L'Experience Felicite Restaurant (e.8. gender, household income, marital status)? - Ir Cory expects that the estimated likelihood of patronizing L'Experience Felicite Restaurant is 3. how do you know whether it is achieved based on the data information? Edit View Insert Part II (4 points) With respect to the question "how likely would it be for you to patronize the L'Experience Flicite Restaurant", Cory wants to understand whether there is a difference between males and females. 1) Write down the null and alternative hypotheses. 2) Based on the results output below, does the survey support or refute Cory's Hypothesis? Why? Part III (5 points) L'Experience Felicite Restaurant wants to select a target market based on consumers' demographic characteristics and restaurant spending behavior. Therefore, their marketing research team ran a multiple regression analysis. The dependent variable is the amount of money consumers want to spend in this restaurant per month (\$). The independent variables are (1) citymag: do you subscribe to City Magazine? (2) onlinereviews: how often do you use online reviews to choose products and services? (3) water: prefer Waterfront view, and (4) elegant: prefer elegant decor. Please based on the information provided and the output table from Excel, answer the following questions: (1) What is the R square of this regression model? What does that mean? (2) Which variables are significant predictors of the amount of money consumers want to spend in this restaurant per month (\$) at 0.05 level? . (3) What is the regression equation for the model? (4) Based on the regression result, which predictor is the most important in predicting the amount of money consumers want to spend in the restaurant per month (\$)? How would you describe the target customers for the restaurant