« previous next »

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

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

Fatal fungal infections may be able to resist newer antifungal drugs. Globally, fungal infections are often fatal due to the lack of access to multiple antifungals, which may be required to be utilized in combination. Single antifungals may not be enough to stop a fungal infection from causing the death of a patient.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

Approximately 500,000 babies are born each year in the United States to teenage mothers.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Protobionts and their lifelike functions Protobionts and their lifelike functions
Range of Motion of the Spine, Flexion and Hyperextension Range of Motion of the Spine, Flexion and Hyperextension
A goniometer is used to measure range of motion of the patient’s arm. A goniometer is used to measure range of motion of the patient’s arm.
How to integrate trigonometric functions containing sine and cosine with odd powers (Part 2) How to integrate trigonometric functions containing sine and cosine with odd powers (Part 2)
Functions Functions
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: Action potentials - electrical characteristics and generation

For a complete list of videos, visit our video library