« previous next »

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

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

Did you know?

Sildenafil (Viagra®) has two actions that may be of consequence in patients with heart disease. It can lower the blood pressure, and it can interact with nitrates. It should never be used in patients who are taking nitrates.

Range of Motion of the Hip Joint, Flexion with Knee Flexed Range of Motion of the Hip Joint, Flexion with Knee Flexed
How to find the domain and range of the trigonometric function, sine, cosine, and tangent How to find the domain and range of the trigonometric function, sine, cosine, and tangent
The carotenoid lycopene, found in tomatoes and tomato products, functions as an antioxidant The carotenoid lycopene, found in tomatoes and tomato products, functions as an antioxidant
As a result of a hole in the graph, which of the following functions does not have an average ... As a result of a hole in the graph, which of the following functions does not have an average ...
Alpine tundra. Low-growing, hardy plants at a high altitude in Washington’s Cascade range. Alpine tundra. Low-growing, hardy plants at a high altitude in Washington’s Cascade range.
Video: Glycolysis - Introduction to ATP and the burning of sugar

For a complete list of videos, visit our video library