« previous next »

Author Question: Describe how to use Excel and its functions to calculate the range of a set of ... (Read 48 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?

Medication errors are three times higher among children and infants than with adults.

Did you know?

The types of cancer that alpha interferons are used to treat include hairy cell leukemia, melanoma, follicular non-Hodgkin's lymphoma, and AIDS-related Kaposi's sarcoma.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Did you know?

The ratio of hydrogen atoms to oxygen in water (H2O) is 2:1.

Did you know?

The horizontal fraction bar was introduced by the Arabs.

Regions of the Human Visual Cortex and Their Functions Regions of the Human Visual Cortex and Their Functions
Passive movement of the hip through its full range. With one hand just above the knee and the other ... Passive movement of the hip through its full range. With one hand just above the knee and the other ...
How to calculate annuity when compounded semi-annually (Part 1) How to calculate annuity when compounded semi-annually (Part 1)
How to calculate mean, median, and mode How to calculate mean, median, and mode
Cell parts and their functions Cell parts and their functions
Calculate the molar solubility of CaF2 in a solution containing 0.250 M Ca(NO3)2. Calculate the molar solubility of CaF2 in a solution containing 0.250 M Ca(NO3)2.
Video: Neural regulation of mechanical digestion- CNS voluntary, ANS & ENS controlled involuntary movements

For a complete list of videos, visit our video library