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
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
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
 

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.

For a complete list of videos, visit our video library