britt40478ox78h3 britt40478ox78h3
  • 17-01-2018
  • Computers and Technology
contestada

Column A contains numbers from rows 1-20. You can use the formula ----?---- to find the value of the largest number divided by the total number of values.

Respuesta :

calculista
calculista calculista
  • 22-01-2018

Using Excel formulas
 =LARGE(A1:A20, 1)/COUNT (A1:A20)

 Count (Ai:An) Function that allows to count the total number of values in a cells range between Ai and An that contain only numbers.

  Large (Ai:An, k) Function that allows to find the value of the largest number in a cells range between Ai and An, the number k determine the k-th largest value

 

Answer Link
everandeli2011 everandeli2011
  • 19-01-2021

Answer:

=MAX(A1:A20)/COUNT(A1:A20)

Explanation:

Got it right on plato

Answer Link

Otras preguntas

Harley begins solve this problem by combining like terms 3x + 5x =10
After a bill had been introduced, what happens next in the lawmaking process
y=f(x)=-3x find f(x) when x is 3
Vector's map has the scale missing. He knows that the distance from the lake to the youth center is 8 miles. On the map, they are 2 inches apart. What is the s
Write out (5x facts).
A grass starts with 30,000 MJ of energy. How much energy would a cheetah acquire after it ate a zebra that consumed the grass
what did the Europeans want from Aran traders ?
If t varies as v, and t = 2 4/7 when v =13/14 , find v when t = 2 1/4 a) 2106/392 b) 13/16 c) 324/52
Please help I need a 100
what is y-value when x equals -12? y =-200 - 6(x)