Please organize on excel and find the answers please and to see what the picture would look like go down to organize and please answer this for me right. A retail store has recently started paying attention to customer analytics. The store collected data from a sample of 131 walk-in customers about registration in the store's points program, purchase level, and payment method.CustomerRegistrationPurchase LevelPayment Method1UnregisteredMediumDebit2RegisteredMediumDebit3RegisteredLargeCash4RegisteredSmallOther5UnregisteredSmallMobile6UnregisteredLargeCash7UnregisteredSmallOther8RegisteredMediumDebit9RegisteredMediumMobile10UnregisteredSmallOther11RegisteredSmallMobile12RegisteredLargeCash13UnregisteredSmallOther14UnregisteredMediumDebit15UnregisteredSmallMobile16UnregisteredSmallOther17RegisteredMediumDebit18UnregisteredMediumMobile19UnregisteredSmallOther20UnregisteredSmallMobile21UnregisteredMediumDebit22UnregisteredSmallOther23UnregisteredLargeCash24RegisteredSmallMobile25RegisteredMediumDebit26RegisteredMediumCredit27UnregisteredLargeCredit28UnregisteredMediumMobile29RegisteredLargeCash30UnregisteredLargeCredit31UnregisteredSmallOther32RegisteredSmallMobile33RegisteredMediumDebit34UnregisteredSmallMobile35RegisteredSmallMobile36UnregisteredSmallOther37RegisteredLargeCredit38RegisteredMediumDebit39UnregisteredSmallMobile40RegisteredLargeCredit41UnregisteredMediumMobile42UnregisteredLargeCredit43UnregisteredMediumDebit44UnregisteredSmallOther45UnregisteredSmallMobile46RegisteredSmallOther47UnregisteredSmallOther48UnregisteredMediumDebit49UnregisteredMediumCredit50RegisteredSmallMobile51UnregisteredMediumDebit52UnregisteredLargeCash53RegisteredMediumMobile54UnregisteredLargeCredit55RegisteredMediumMobile56UnregisteredLargeCash57UnregisteredLargeCredit58UnregisteredLargeCash59UnregisteredSmallOther60RegisteredSmallOther61RegisteredMediumMobile62UnregisteredSmallMobile63UnregisteredLargeCredit64UnregisteredLargeCash65RegisteredMediumMobile66UnregisteredMediumDebit67UnregisteredSmallOther68UnregisteredSmallOther69RegisteredSmallOther70UnregisteredLargeCredit71UnregisteredMediumDebit72RegisteredSmallOther73UnregisteredLargeCredit74UnregisteredLargeCredit75UnregisteredSmallMobile76UnregisteredSmallMobile77RegisteredSmallOther78UnregisteredLargeCredit79RegisteredLargeCash80UnregisteredLargeCash81RegisteredLargeCash82UnregisteredMediumMobile83UnregisteredMediumDebit84RegisteredLargeCredit85UnregisteredSmallOther86RegisteredMediumDebit87RegisteredLargeCredit88UnregisteredSmallMobile89UnregisteredSmallMobile90UnregisteredMediumDebit91UnregisteredLargeCash92RegisteredSmallMobile93RegisteredSmallOther94UnregisteredLargeCredit95RegisteredLargeCash96RegisteredMediumMobile97UnregisteredLargeCash98UnregisteredLargeCash99RegisteredSmallOther100UnregisteredLargeCredit101UnregisteredSmallOther102UnregisteredLargeCredit103UnregisteredMediumDebit104UnregisteredMediumMobile105UnregisteredMediumMobile106RegisteredMediumCredit107UnregisteredMediumMobile108UnregisteredSmallOther109UnregisteredSmallOther110UnregisteredLargeCash111UnregisteredLargeCash112RegisteredLargeCash113UnregisteredLargeCash114UnregisteredMediumMobile115UnregisteredSmallOther116UnregisteredLargeCredit117UnregisteredMediumMobile118UnregisteredSmallOther119UnregisteredMediumDebit120RegisteredSmallOther121UnregisteredMediumDebit122RegisteredLargeCash123UnregisteredLargeCredit124UnregisteredSmallOther125UnregisteredLargeCredit126UnregisteredMediumMobile127UnregisteredMediumDebit128UnregisteredLargeCredit129UnregisteredSmallOther130UnregisteredSmallMobile131UnregisteredLargeCash1. How many purchases in the sample are small?2. How many customers paid with mobile?3. How many registered customers' purchases are small? 4. How many unregistered customers paid with mobile? Round to two decimal places5. What percent of all customers are unregistered and paid with mobile? %6. What percent of all customers are registered and made a small purchase? %7. What percent of registered customers' purchases are small? %8. What percent of unregistered customers paid with mobile? %

Customer Registration Purchase Level Payment Method Unregistered Medium Debit 2 Registered Medium Debit Registered Large Cash 4 Registered Small Other 5 Unregistered Small Mobile Unregistered Large Cash Unregistered Small Other 8 Registered Medium Debit Registered Medium Mobile 10 Unregistered Small Other 11 Registered Small Mobile 12 Registered Large Cash 13 Unregistered Small Other 14 Unregistered Medium Debit