PM01-0115. Funciones estadísticas: Mínimos y Máximos

Funciones estadísticas

Mínimos

[{"selector":"#anim-0c765255-82f0-4d7a-a6ab-438ef9268a63","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8b1ac2a4-9289-42f5-9bb0-c9f435bf9281","keyframes":{"transform":["translate3d(0px, -378.08633%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1b6099b0-f044-42a4-8158-3428a73b2acc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-1b305d83-1683-4982-bcf7-5807c43eaeb6","keyframes":{"transform":["translate3d(-129.5%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-493576f1-4701-4433-a2bf-37bcb6048d29","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-408743b1-1b4b-4fdb-a3c4-d58dad4679a1","keyframes":{"transform":["translate3d(-125.80646%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5348f34c-050c-4c75-96fb-0cbb3977e8e7","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-24bcf00e-d001-414a-83c8-915610f4b8f4","keyframes":{"transform":["translate3d(-129.53737%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Busca y muestra el valor numérico más bajo en el rango especificado. Ejemplo: =MIN(A20:A60) =MIN( rango )

Máximos

[{"selector":"#anim-5c14a231-7524-4896-8d28-3d7fcb9df304","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e70b11e0-e8dc-4e6e-8254-dbc374f23898","keyframes":{"transform":["translate3d(0px, -378.08633%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-185d0ef9-9d8d-47c0-af22-4ad40cb03c21","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-722831ad-22e1-40ce-ac3d-adec1cf81a4b","keyframes":{"transform":["translate3d(-125.80646%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8ce8ad01-846e-4cb7-89f9-efa3fbac3395","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8111b727-0701-4db5-950d-6cd9a3a4b821","keyframes":{"transform":["translate3d(-129.5%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9fdd9a7e-aef8-4a2a-a833-43fe4ab3f229","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-b1cb7627-9511-4b6d-ad6a-2133c067e0c3","keyframes":{"transform":["translate3d(-129.53737%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Busca y muestra el valor numérico más grande en el rango especificado. Ejemplo: – =MAX(C10:C45) =MAX (rango) Cross

Aprende cómo sacar los mínimos y máximos:

[{"selector":"#anim-a44128fd-0749-4ea9-b3da-a01d5a4d08a4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-eaf4a8f0-e05e-4588-9694-a8590826ad37","keyframes":{"transform":["translate3d(-114.8265%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a305e6c6-cac5-49c7-a92b-b432f90aae68","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-41d0dd9c-8641-4e13-8c2b-e793a5cb081a","keyframes":{"transform":["translate3d(-386.51686%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ff93461c-b7cc-4b2a-a7d8-ba126d954431","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-36b13990-1a87-42aa-815a-751aa4c78f37","keyframes":{"transform":["translate3d(0px, 145.14712%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Aplica

[{"selector":"#anim-fa3e2cc0-4083-4b9c-8d3d-d4628dc77046","keyframes":[{"offset":0,"transform":"translate3d(0, -166.2263%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -46.74283556%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -15.89123428%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -5.967524170000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.59313028%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1400,"fill":"both"}]

Funciones estadísticas

Mínimos y Máximos

Mínimos

Fórmula:

Máximos

Fórmula:

Aprende cómo sacar los mínimos y máximos: