« previous next »

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

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

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?

The human body produces and destroys 15 million blood cells every second.

Range of Motion of the Knee Joint: Flexion, Extension, and Hyperextension Range of Motion of the Knee Joint: Flexion, Extension, and Hyperextension
How to find the derivatives of inverse trigonometric functions (Part 1) How to find the derivatives of inverse trigonometric functions (Part 1)
Sketch the graph of each function using transformations. State the domain and range. Sketch the graph of each function using transformations. State the domain and range.
Finding derivatives of Trig Functions - pt 6 Finding derivatives of Trig Functions - pt 6
Stomach functions Stomach functions
Functions of Fat Functions of Fat
Video: Proteins Defined, Hierarchy & Composition of Cells

For a complete list of videos, visit our video library