« previous next »

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

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

Did you know?

Autoimmune diseases occur when the immune system destroys its own healthy tissues. When this occurs, white blood cells cannot distinguish between pathogens and normal cells.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

Synthesis and major functions of the chief steroid hormones in animals. Synthesis and major functions of the chief steroid hormones in animals.
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
Individual Tubule Functions Individual Tubule Functions
How to find the derivatives of hyperbolic functions How to find the derivatives of hyperbolic functions
Passive movement of the hip through its full range. With one hand just above the knee and the other ... Passive movement of the hip through its full range. With one hand just above the knee and the other ...
How to find the domain and range of a function (Part 1) How to find the domain and range of a function (Part 1)
Video: Plant Defense Mechanisms from Pathogens

For a complete list of videos, visit our video library