https://docs.google.com/spreadsheets/d/1DcXS96HY0qXiM4ntanyRb1fmCywtbxag58dFzNd6Tsc/edit?usp=sharing

Sales Management:A large wholesaler of groceries, other food stuffs, and consumer products in Portugal has recently identified that the majority of its customers fall into one of two categories: Either Hotel/Restaurant/Cafe or Retail. The company wishes to better understand the differences between these two types of customers. The available variables are contained in the worksheet "Wholesale" and defined as follows.

Channel:(Customer Type) Coded as 1 for Hotel/Restaurant/Cafe or 2 for Retail.

Grocery:Annual spending on grocery products (inthousandsof monetary units (m.u.)).

Frozen:Annual spending on frozen products (inthousandsof m.u.).

Fit the proper regression model to predict whether or not a customer is Retail or Hotel/Restaurant/Cafe. Fit the model so that the event being modeled is "Retail". Furthermore, an interaction is hypothesized to exist between Grocery and Frozen products - in other words, the effect of Grocery spending on the likelihood of being a Retail customer is hypothesized to be moderated by the amount of spending on Frozen products and vice versa. Create the appropriate variable(s) and fit the interaction model to test this hypothesis and others.

(a) Complete the following statement (Enter your first answer as a whole number and thepercentrounded to two decimal places).

Out of a total ofn=( )customers in the sample,( )%wereRetailcustomers.

Regardless of your conclusions above, use the full model for the remainder of these questions.

(e) What is the predicted probability that a new customer is in Retail when the customer spends1,000m.u. on groceries and2,000m.u. on frozen products wholesale? (Enter your answer rounded to four decimal places)?

P(The Customer is in Retail) =

What is the predicted probability that a new customer is in Hotel/Restaurant/Cafe when the customer spends1,000m.u. on groceries and2,000m.u. on frozen products wholesale? (Enter your answer rounded to four decimal places)?

P(The Customer is in Hotel/Restaurant/Cafe) =

What is the predicted probability that a new customer is in Retail when the customer spends1,000m.u. on groceries and1,000m.u. on frozen products wholesale? (Enter your answer rounded to four decimal places)?

P(The Customer is in Retail) =

What is the predicted probability that a new customer is in Hotel/Restaurant/Cafe when the customer spends1,000m.u. on groceries and1,000m.u. on frozen products wholesale? (Enter your answer rounded to four decimal places)?

P(The Customer is in Hotel/Restaurant/Cafe) =