« previous next »

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

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Water is vital for many body functions, but it isn’t stored in the body Water is vital for many body functions, but it isn’t stored in the body
Summary of Functions of Principal Parts of the Brain Summary of Functions of Principal Parts of the Brain
Functions Functions
Finding derivatives of Trig Functions - pt 6 Finding derivatives of Trig Functions - pt 6
Stomach functions Stomach functions
Excel hardware is introducing a new product on a new product line of capacity 800 units per ... Excel hardware is introducing a new product on a new product line of capacity 800 units per ...
Video: Hormonal regulation of blood pressure - RAA system

For a complete list of videos, visit our video library