« previous next »

Author Question: Describe how to use Excel and its functions to calculate the range of a set of ... (Read 51 times)

newyorker26

  • Hero Member
  • *****
  • Posts: 536
on: Jun 24, 2018
Describe how to use Excel and its functions to calculate the range of a set of values.

Question 2

Describe the correct method for keying the mean, median, and mode functions in Excel.


milbourne11

  • Sr. Member
  • ****
  • Posts: 322
Reply #1 on: Jun 24, 2018
Answer to Question 1

Use the maximum (MAXA) and minimum (MINA) functions in Excel to determine the highest and lowest values in a data set. Then subtract the highest value from the lowest value to find the range of the set.

Answer to Question 2

Key an equal sign and the name of the function (either AVERAGE, MEDIAN, or MODE). Then inside parentheses key each cell to be included in the data set separated by a comma. Note: cells can also be selected by the pointing method and separated by commas.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Did you know?

Oxytocin is recommended only for pregnancies that have a medical reason for inducing labor (such as eclampsia) and is not recommended for elective procedures or for making the birthing process more convenient.

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

Did you know?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

How to find the limits of trigonometry functions How to find the limits of trigonometry functions
How to find derivatives of reciprocal trigonometric functions How to find derivatives of reciprocal trigonometric functions
Range of Motion at the Wrist. Range of Motion at the Wrist.
How to calculate regular payments or deposits using the annuity formula (Question 1) How to calculate regular payments or deposits using the annuity formula (Question 1)
How to integrate trigonometric functions containing tangent and sine with odd powers How to integrate trigonometric functions containing tangent and sine with odd powers
The Skeletal System and Its Functions The Skeletal System and Its Functions
Video: Hemoglobin's affinity with oxygen - carbon dioxide, temperature and bisphosphoglycerate (BPG)

For a complete list of videos, visit our video library