Answered step by step
Verified Expert Solution
Link Copied!

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

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Rockin Your Business Finances

Authors: Chrstine Odle

1st Edition

0999135104, 9780999135105

More Books

Students also viewed these Finance questions

Question

=+ Do you think it is a wise investment of the firm?

Answered: 1 week ago