« previous next »

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

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Did you know?

Thyroid conditions may make getting pregnant impossible.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

Range of Motion of the Elbow Joint, Supination, Pronation Range of Motion of the Elbow Joint, Supination, Pronation
Range of Motion of the Hip Joint, Internal and External Rotation Range of Motion of the Hip Joint, Internal and External Rotation
Selected Vitamins: Food Sources, Functions, and Deficiency and Toxicity Symptoms (continued) Selected Vitamins: Food Sources, Functions, and Deficiency and Toxicity Symptoms (continued)
The heat range of a spark plug is determined by the distance the heat has to flow from the tip to ... The heat range of a spark plug is determined by the distance the heat has to flow from the tip to ...
Range for Functions Range for Functions
Increasing/decreasing Functions Increasing/decreasing Functions
Video: Humerus Adduction Animation

For a complete list of videos, visit our video library