« previous next »

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

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's pharmacokinetics are quite varied. Our hair holds onto drugs longer than our urine, blood, or saliva. For example, alcohol can be detected in the hair for up to 90 days after it was consumed. The same is true for marijuana, cocaine, ecstasy, heroin, methamphetamine, and nicotine.

Did you know?

Oliver Wendell Holmes is credited with introducing the words "anesthesia" and "anesthetic" into the English language in 1846.

Did you know?

The first-known contraceptive was crocodile dung, used in Egypt in 2000 BC. Condoms were also reportedly used, made of animal bladders or intestines.

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Multiple-dose drug administration: drug A and drug B are administered every 12 hours; drug B reaches Multiple-dose drug administration: drug A and drug B are administered every 12 hours; drug B reaches
Although Neandertal brain sizes fall well within the modern human range, their EQ is lower than mode Although Neandertal brain sizes fall well within the modern human range, their EQ is lower than mode
One of the many functions of religion is providing emotional support. This photo was taken in ... One of the many functions of religion is providing emotional support. This photo was taken in ...
How to use inverse trigonometric functions to solve a right triangle How to use inverse trigonometric functions to solve a right triangle
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 Exponential functions - pt 2 Finding derivatives of Exponential functions - pt 2
Video: Evolutionary tree of life Animation

For a complete list of videos, visit our video library