Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
please use this photo as the directions, instead of thr preceding photo
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

=+to live and work wherever he or she wants?

Answered: 1 week ago