10 4.8 You want to analyze the wedding party stays at the resort by determining the total number of wedding parties who spent four days at the resort. On the SalesAnalysis worksheet, in cell B3, enter a formula that counts the number of wedding parties in cells B7:837 if they spent four days at the spa, cell A3. 11 4.8 You want to know the total number of wedding parties if the party spent four days at the resort and are non-spa (Null) members. In cell B4, enter a formula to count the number of parties if they stayed 4 days (cell A3) and are non-spa (Null) members (cell A4) A E 1 B D Spa Sales Analysis Number of Spa Customers Average Spa Sales Spa Sales 2 3 4 5 Guest Criteria 4 Null Whole Days Spent 1 2 4 4 2 4 2 2 3 4 3 3 4 6. Wedding Party Name 7 Arroyo 8 Proctor 9 Minor 10 Pearce 11 Shea 12 Galvan 13 Crowe 14 Meeks 15 Kendrick 16 Mayfield 17 Kendall 18 Archer 19 Holley 20 Boucher 21 Childs 22 Rankin 23 Lozano 24 Odell 25 Bland 26 Rouse 27 Haas 28 Swain 29 Oconnell 30 Dougherty 31 Andersen 32 Wang 33 Cowan 34 Elder 35 Shirley 36 Hartley 37 Felix 38 4 1 4 2 4 2 1 4 Value of Returned Amount Spent at Merchandise Spa $ 37.34 $ 1,215.63 $ 41.12 $ 720.60 12.70 455.78 $ 13.97 | S 1,309.51 $ 18.53 $ 1,345.57 S 11.09 $ 1,046.69 $ 36.64 $ 1,125.53 $ 47.70 $ 1,068.90 $ 10.24 $ 604.95 $ 7.88 $ 299.60 $ 21.78$ 353.74 $ 37.51 $ 923.56 $ 34.36 $ 1,285.26 $ 5.79 $ 1,157.07 $ 2.47 $ 206.77 $ 12.66 $ 781.30 $ 49.74 $ 1,070.70 $ 18.66 $ 867.45 $ 17.86 $ 267 16 $ 24.98$ 1,330.38 $ 23.12$ 899.77 $ 7.23 $ 1,479.14 $ 111 $ 953.20 $ 0.46 IS 556.17 $ 19.03 $ 644 50 $ 3.15$ 606.30 $ 40.74 $ 955.27 $ 16.60 $ 760 12 S 31.05$ 870.85 S 25.91 $ 1,146.79 $ 30.66 $ 807.42 Spa Member 1 1 1 Null 1 1 1 1 Null Null Null 1 Null 1 1 Null Null Null 1 1 Null Null 1 Null Null 1 Null 1 1 1 Null 1 2 3 3 1 1 1 2 3 4