Answered step by step
Verified Expert Solution
Question
1 Approved Answer
FALL e ules toru Question 13 The nearby figure is a snapshot of an Excel spreadsheet showing the prices of 4 types of coffees sold
FALL e ules toru Question 13 The nearby figure is a snapshot of an Excel spreadsheet showing the prices of 4 types of coffees sold in 3 stores. What is the correct formula to compute the average price of the coffee named "Ethiopia Sidamo" sold in the 3 stores? A 1 The Coffee Merchant 2 Coffee Price per Pound Comparison 3 45 5 Ethiopia Sidamo 6 Kenya AA 7 Kona 8 Zimbabwe 9 O AVERAGE(B5+C5+D5) O AVG(B5+C5+D5) O 1/(3 (B5+C5+D5)) O (B5+C5+D5)/E5 O (B5+C5+D5)/3 O SUM(B5+C5+D5)/3 sssss $ $ $ $ B Store 1 9.99 $ 13.55 $ 24.99 $ 10.99 $ C Store 2 10.99 $ 14.91 $ 27.49 $ 12.09 $ D Store 3 9.49 S 12.87 $ 23.74 $ 10.44 $ 0.5 pts E Average Price 10.16 13.78 25.41 11.17
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started