« previous next »

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

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

A good example of polar molecules can be understood when trying to make a cake. If water and oil are required, they will not mix together. If you put them into a measuring cup, the oil will rise to the top while the water remains on the bottom.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Range of Motion of the Spine, Lateral Bending Range of Motion of the Spine, Lateral Bending
How to find the derivatives of inverse hyperbolic functions How to find the derivatives of inverse hyperbolic functions
How to find the domain and range of a function (Part 1) How to find the domain and range of a function (Part 1)
How to calculate annuity when compounded quarterly (Part 2) How to calculate annuity when compounded quarterly (Part 2)
Calculate the velocity of the red rock after collision Angle measured counterclockwise from the ... Calculate the velocity of the red rock after collision Angle measured counterclockwise from the ...
Finding derivatives of Trig Functions - pt 2 Finding derivatives of Trig Functions - pt 2
Video: Gas exchange - partial pressure, locations, external and internal respiration

For a complete list of videos, visit our video library