1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
sp2606 [1]
3 years ago
7

A worksheet contains sales dollars for agents with your company. The values are $1,250, $1,090, $985, $985, $880, $756, $675, $6

50, and $600. What function could be used to return the third largest value
Business
1 answer:
ivolga24 [154]3 years ago
7 0

Answer:We use the Large Function. the general formula is  =LARGE(first cell:last cell,3) .Please refer to the explanation section for details

Explanation:

Let us assume

A 1 = $1,250,  A 2 = $1,090, A 3 = $985, A 4 = $985, A 5 = $880, A 6 = $756, A 7 = $675, A 78= $650, and A 9 =$600

Using the Large function on excel to return the third largest value, on the formula bar we have the following formula;

=LARGE(A1:A2,3)

You might be interested in
While most marketing to Generation Y tries so hard to be hip that it borders on parody, Vans has kept the decades-old brand real
anastassius [24]

Answer:

age

Explanation:

Based on this information it can be said that in this scenario the segmentation plan used by Vans relies heavily on age segmentation. This is when the company focuses on certain age groups to target within the population. Which in this scenario the Vans company is targeting strictly individuals between the ages 24 and 39 which are referred to as Generation Y.

4 0
4 years ago
Read 2 more answers
When it comes to executing plans, what is the role of a manager?
tiny-mole [99]

When it comes to executing plans, the role of a manager is controlling and problem solving.

<h3>Who is a manager?</h3>

Managers supervise the activities of others in order to achieve goals. Managers in the modern workforce may be in charge of systems or specific functions that do not involve humans.

A manager has several responsibilities in an organization. One of them is concerned with carrying out the plan devised to achieve organizational objectives. A manager uses this plan to control and solve problems that may arise while carrying out the plan, as well as to make necessary adjustments.

For example, compare actual results to planned results and make adjustments as needed.

Learn more about managers on:

brainly.com/question/24708179

#SPJ1

8 0
1 year ago
Use the following information a. Beginning cash balance on March 1, $72,000.b. Cash receipts from sales, $300,000.c. Budgeted ca
mrs_skeptik [129]

Answer:

Ending cash                      87,000

Explanation:

beginning                         72,000

receipts                           300,000

disbursement  (140,000)

salaries             (80,000)

other expenses (45,000)

loan payment    (20,000)

Total disbursement         (285,000)

Ending cash                      87,000 (72,000 + 300,000 - 285,000)

3 0
3 years ago
Assume that the money demand function is (M / P)d = 2,200 – 200r, where r is the interest rate in percent. If the price level is
Wittaler [7]

Answer:

The money supply should be set at 800

Explanation:

In this question, we are asked to calculate the value at which Fed should set the money supply at after fixing the interest rate at 7 percent.

We proceed as follows;

Let the new money supply be M.

To fix the interest rate at 7%, r= 7 and P = 2

(M/P)d = 2,200 - 200r

= 2200 - 200(7)

=2200-1400

= 800

M = 800

8 0
3 years ago
Meyer Inc produces lampposts using labor (L) and capital (K). Its production function is given by the following expression: Q =m
kykrilka [37]

Answer:

L = 0

K = 535.36

Q = 99,577 units

Explanation:

Q = 118L + 186K  

Budget line: C = L.PL + K.PK

5,889 = 16L + 11K

This is a linear production function, indicating labor and capital are perfect substitutes. Optimal bundle lies on one of the corner points on isoquant.

From budget line,

When L = 0, K = 5,889/11 = 535.36  

Q = 118*0 + 186*535.36 = 0 + 99,576. 96 = 99,577 units

When K = 0, L = 5,889 / 16 = 368.06

Q = 118*368.06 + 11*0 = 45,555.08 + 0 = 45,555 units

So, output is maximized when L = 0 and K = 535.36, since Q = 99,577 units (optimal labor).

Hope this helps!

8 0
3 years ago
Other questions:
  • Tanyika needs a loan to buy furniture for her house. she can get a loan from all the following except:
    15·1 answer
  • EA8.
    5·1 answer
  • After hearing test results from her doctor, erin realized her weight was really impacting her health. with respect to the proces
    11·1 answer
  • A recent study about online shopping asked respondents to indicate their education level on the following​ scale: "Less than Hig
    11·1 answer
  • What are your greatest professional strengths?
    5·1 answer
  • The primary source of information to be reported about litigation, claims, and assessments is the:_________
    12·1 answer
  • Compare these two sections of resumes. Which is more appropriate? a. - Completed nine-hour training course • Ran simulation soft
    15·1 answer
  • Carter Production, Inc.'s required production for the first six month of the year is as follows. Month Required Production Janua
    5·1 answer
  • Printers today have many features that include improved quality, photo printing capabilities, digital camera connectivity, built
    13·1 answer
  • When a corporation purchases or builds a facility in a foreign country, it is called:_________
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!