« previous next »

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

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

Did you know?

Complications of influenza include: bacterial pneumonia, ear and sinus infections, dehydration, and worsening of chronic conditions such as asthma, congestive heart failure, or diabetes.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

A serious new warning has been established for pregnant women against taking ACE inhibitors during pregnancy. In the study, the risk of major birth defects in children whose mothers took ACE inhibitors during the first trimester was nearly three times higher than in children whose mothers didn't take ACE inhibitors. Physicians can prescribe alternative medications for pregnant women who have symptoms of high blood pressure.

Blood glucose measurement. A postprandial test may be self-administered. (a) A lance pierces the ski Blood glucose measurement. A postprandial test may be self-administered. (a) A lance pierces the ski
Major components and functions of the nervous system. Major components and functions of the nervous system.
Basic Marketing Research: Using Microsoft Excel Data Analysis Basic Marketing Research: Using Microsoft Excel Data Analysis
Finding derivatives of Trig Functions - pt 2 Finding derivatives of Trig Functions - pt 2
Calculate the electron affinity for the formation of the hydride ion from the following ... Calculate the electron affinity for the formation of the hydride ion from the following ...
Calculate the accumulated value of monthly payments of $100.00 made at the end of each month ... Calculate the accumulated value of monthly payments of $100.00 made at the end of each month ...
Video: Kidney Stones

For a complete list of videos, visit our video library