Plz help me

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 staved at least 4 nights and is a non-spa (Null) customer. \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 1 & \multicolumn{7}{|c|}{ Spa Sales Analysis } \\ \hline 2 & Guest Criteria & \begin{tabular}{c} Number of Spa \\ Customers \end{tabular} & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} Average Spa \\ Sales \\ $B$7:$B$37 \end{tabular}}} & \multicolumn{2}{|r|}{ Spa Sales } & \\ \hline 3 & 4 & 10 & & & & & \\ \hline 4 & Null & 7 & & & & & \\ \hline \multicolumn{8}{|l|}{5} \\ \hline 6 & Wedding Party Name & \begin{tabular}{c} Whole Days \\ Spent \end{tabular} & & \begin{tabular}{l} le of \\ Ined \\ tandise \end{tabular} & & \begin{tabular}{l} ount Spent \\ at Spa \end{tabular} & Spa Member \\ \hline 7 & Arroyo & 1 & s. & 37.34 & 5 & 1,215.63 & 1 \\ \hline 8 & Proctor & 2 & s & 4112 & 5 & 720.60 & 1 \\ \hline 9 & Minor & 4 & s & 12.70 & 5 & 455.78 & 1 \\ \hline 10 & Pearce & 4 & s & 13.97 & 5 & 1,309.51 & Nuil \\ \hline 11 & Shea & 2 & 5 & 18.53 & s & 1,345.57 & 1 \\ \hline 12 & Galvan & 4 & s & 11.09 & s & 1,046.69 & 1 \\ \hline 13 & Crowe & 2 & 5 & 36.64 & s & 1,125.53 & 1 \\ \hline 14 & Meeks & 2 & & 4770 & \$ & 1,068.90 & 1 \\ \hline 15 & Kendrick & 3 & 5 & 10.24 & s & 604.95 & Null: \\ \hline 16 & Mayfield & 4 & 5 & 7.88 & s & 299.60 & Null \\ \hline 17 & Kendall. & 3 & s & 21.78 & 5 & 353.74 & Nulf: \\ \hline 18 & Archer & 3 & $ & 37.51 & s & 929.56 & 1 \\ \hline 19 & Holley & 4 & $ & 34.36 & s & 1,285.26 & Nuil: \\ \hline 20 & Boucher & 4 & 5 & 5.79 & 5 & 1,157,07 & 1 \\ \hline \end{tabular} 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 staved at least 4 nights and is a non-spa (Null) customer. \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 1 & \multicolumn{7}{|c|}{ Spa Sales Analysis } \\ \hline 2 & Guest Criteria & \begin{tabular}{c} Number of Spa \\ Customers \end{tabular} & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} Average Spa \\ Sales \\ $B$7:$B$37 \end{tabular}}} & \multicolumn{2}{|r|}{ Spa Sales } & \\ \hline 3 & 4 & 10 & & & & & \\ \hline 4 & Null & 7 & & & & & \\ \hline \multicolumn{8}{|l|}{5} \\ \hline 6 & Wedding Party Name & \begin{tabular}{c} Whole Days \\ Spent \end{tabular} & & \begin{tabular}{l} le of \\ Ined \\ tandise \end{tabular} & & \begin{tabular}{l} ount Spent \\ at Spa \end{tabular} & Spa Member \\ \hline 7 & Arroyo & 1 & s. & 37.34 & 5 & 1,215.63 & 1 \\ \hline 8 & Proctor & 2 & s & 4112 & 5 & 720.60 & 1 \\ \hline 9 & Minor & 4 & s & 12.70 & 5 & 455.78 & 1 \\ \hline 10 & Pearce & 4 & s & 13.97 & 5 & 1,309.51 & Nuil \\ \hline 11 & Shea & 2 & 5 & 18.53 & s & 1,345.57 & 1 \\ \hline 12 & Galvan & 4 & s & 11.09 & s & 1,046.69 & 1 \\ \hline 13 & Crowe & 2 & 5 & 36.64 & s & 1,125.53 & 1 \\ \hline 14 & Meeks & 2 & & 4770 & \$ & 1,068.90 & 1 \\ \hline 15 & Kendrick & 3 & 5 & 10.24 & s & 604.95 & Null: \\ \hline 16 & Mayfield & 4 & 5 & 7.88 & s & 299.60 & Null \\ \hline 17 & Kendall. & 3 & s & 21.78 & 5 & 353.74 & Nulf: \\ \hline 18 & Archer & 3 & $ & 37.51 & s & 929.56 & 1 \\ \hline 19 & Holley & 4 & $ & 34.36 & s & 1,285.26 & Nuil: \\ \hline 20 & Boucher & 4 & 5 & 5.79 & 5 & 1,157,07 & 1 \\ \hline \end{tabular}