« previous next »

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

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Protein, Ligand and their Functions Protein, Ligand and their Functions
Long-range forecasts Long-range forecasts
Water is vital for many body functions, but it isn’t stored in the body Water is vital for many body functions, but it isn’t stored in the body
Functions and Properties of Blood Functions and Properties of Blood
Range for Functions Range for Functions
Calculate the molar solubility of CaF2 in a solution containing 0.250 M Ca(NO3)2. Calculate the molar solubility of CaF2 in a solution containing 0.250 M Ca(NO3)2.
Video: Cellular slime mold life cycle Animation

For a complete list of videos, visit our video library