« previous next »

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

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.

Did you know?

About 3% of all pregnant women will give birth to twins, which is an increase in rate of nearly 60% since the early 1980s.

Did you know?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

Did you know?

Medications that are definitely not safe to take when breastfeeding include radioactive drugs, antimetabolites, some cancer (chemotherapy) agents, bromocriptine, ergotamine, methotrexate, and cyclosporine.

Cheetah at the Werribee Open Range Zoo Cheetah at the Werribee Open Range Zoo
The Broad Range of Human Emotions. The Broad Range of Human Emotions.
How to integrate trigonometric functions containing even powers (Question 1) How to integrate trigonometric functions containing even powers (Question 1)
Functions and Properties of Blood Functions and Properties of Blood
Summary of Functions of Principal Parts of the Brain Summary of Functions of Principal Parts of the Brain
A crowd in Iceland reflects its narrow range of genetic diversity A crowd in Iceland reflects its narrow range of genetic diversity
Video: Normal and abnormal blood pH

For a complete list of videos, visit our video library