please use this photo as the directions, instead of thr preceding photo

Next, you will determine if there is a significant difference between the average amount spent at the spa and the average amount spent at the spa for non-spa (Null) members. To gather this information, you will need to create a formula based on two sets of criteria. In cell C4, enter a function to calculate the average if the guest stayed at least 4 nights and is a non-spa (Null) customer. Now you want to determine the total amount spent at the spa if the guest stayed for four days. In cell D3, enter a formula to calculate the total amount spent at the spa if the guest stayed for four days (cell A3). Formulas Review View Home Insert Data Help File Page Layout D3 A B E 2 Guest Criteria Number of Spa Customers 10 C Average Spa Sales $890.991 $892.90 Spa Sales 3 4 4 Null 7 5 Spa Member Whole Days Spent 1 2 4 4 2 NA 6 Wedding Party Name 7 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 2 2 Value of Returned Amount Spent at Merchandise Spa $ 37.34 $ 1,215.63 $ 41.12 $ 720.60 $ 12.70$ 455.78 $ 13.97$ 1,309.51 $ 18.53S 1,345.57 $ 11.09S 1,046.69 $ 36.64 $ 1,125.53 S 47.70 $ 1,068.90 $ 10.24 | $ 604.95 S 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 1 1 Null 1 1 1 1 Null Null Null 4 3 3 1 4 Null 4 1 1 4 Uuuuu 2 1 Null Null Null 4 2 Now you want to determine the total amount spent at the spa if the guest stayed for four days. In cell D3, enter a formula to calculate the total amount spent at the spa if the guest stayed for four days (cell A3). To finish the analysis of the spa usage, you want to determine the total spa sales if four whole days were spent at the spa and the guests were non-spa (Null) members. In cell D4, enter a function that sums the total sales if the customer stayed for 4 days and was a non-spa (Null) member. . Fuit Creol Submit the file as directed