Table 1 shows Apple's online orders for the last week. When shoppers place an online order, several
Question:
Table 1 shows Apple's online orders for the last week.
•When shoppers place an online order, several "recommended products" (upsells) are shown as at checkout an attempt to upsell
•See table 2 in cell N2 for a list of products that Apple upsells at checkout.
•Upsells, however, will not be shown if the shopper has added either the iPad Mini , iPad Pro, Special Offer or iPhone7, Special Offer into the their shopping cart. For the purpose of this analysis, any orders containing these products are considered ineligible transactions. All other orders are considered eligible transactions.
•You are tasked with providing a report to management about last week's eligible transactions.
•Construct formulas to answer the five questions to the right of the data table (N14:N22).