« previous next »

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

When taking monoamine oxidase inhibitors, people should avoid a variety of foods, which include alcoholic beverages, bean curd, broad (fava) bean pods, cheese, fish, ginseng, protein extracts, meat, sauerkraut, shrimp paste, soups, and yeast.

Did you know?

All patients with hyperparathyroidism will develop osteoporosis. The parathyroid glands maintain blood calcium within the normal range. All patients with this disease will continue to lose calcium from their bones every day, and there is no way to prevent the development of osteoporosis as a result.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

People about to have surgery must tell their health care providers about all supplements they take.

Did you know?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

The Locations and Functions of the Cerebral Lobes, Diencephalon, Cerebellum, and Brain Stem The Locations and Functions of the Cerebral Lobes, Diencephalon, Cerebellum, and Brain Stem
Regions of the Human Visual Cortex and Their Functions Regions of the Human Visual Cortex and Their Functions
How to calculate monthly payments at varying amortization periods (Question 3) How to calculate monthly payments at varying amortization periods (Question 3)
Stomach functions Stomach functions
Sketch the graph of the following functions using local maximum/minimums, interc Sketch the graph of the following functions using local maximum/minimums, interc
How to calculate the DRT to determine which is more effective against the pathogen How to calculate the DRT to determine which is more effective against the pathogen
Video: Lower Limb Arteries Animation

For a complete list of videos, visit our video library