R Statistical Software Basics - Descriptive Statistics - Minimum, Maximum & Range Functions

The practice sheet titled StatisticMarks Data.csv downloaded from Link. – Download Sheet

About the Data Sheet - The data in this sheet is related to marks scored by 100 Students in a Statistical Test.

Based on the data, we will use R Software Statistical functions to analyze the descriptive statistics.

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data.

I have stored the StatisticMarks.csv file in Working Directory on my Desktop.

setwd("C:/Users/Rajesh Prabhakar/Desktop/R")

For inputting or reading Data from “StatisticMarks.csv” file, R Command would be

StatMarks=read.csv("StatisticMarks.csv")

I have named input variable name as StatMarks so that it will be easy for reading data into the statistical function formulas.

Click Ctrl R or Run or Ctrl plus Enter Tabs

Minimum Function

min( )

This function returns the minimum value in the data. Function name must be small caps

min(StatMarks)

Result is 25

The lowest marks scored is 25

Maximum Function

max(  )

This function returns the maximum value in the data. Function name must be small caps

max(StatMarks)

Result is 100

The Highest marks scored in test is 100.

Result in R Console 

> min(StatMarks)

[1] 25

> max(StatMarks)

[1] 100

Range Function

range(   )


This function gives a vector of the minimum and maximum values.

range(StatMarks)

Result is 25 & 100

These are the lowest and highest numbers in Data Set.

> range(StatMarks)

[1]  25 100

Range or Spread

For getting the range or spread i.e Range = Maximum – Minimum

max(StatMarks)-min(StatMarks) 

Result is 75 

The difference between 100 – 25 = 75 

Result in R Console 

> max(StatMarks)-min(StatMarks)

[1] 75

Minimum, Maximum & Range - Descriptive Statistics using Microsoft Excel Statistical Functions

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet

About the Data Sheet - The data in this sheet is related to marks scored by 100 Students in a Statistical Test. 

Based on the data, we will use Microsoft Excel Statistical functions to analyse the descriptive statistics. 

In the Data Sheet, we have Data from A2:A101, A1 being the header of the Data. 

MINIMUM

=MIN(number1,number2,...)


The MIN function is used to find the smallest or minimum value in a range of data. Text Data Cells are ignored.
In the Data Sheet Data, we have Data from A2:A101, 

=MIN(A2:A101)
Result is 25

One Student has scored the lowest Marks i.e. 25.

If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.

MAXIMUM
The MAX function returnsthe largest value in a set of values. Text Data Cells are ignored.
In the Data Sheet Data, we have Data from A2:A101, 

If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAXA function.
=MAX(number1,number2,...)

=MAX(A2:A101)

Result is 100
Two Students have scored the highest marks i.e. 100.

RANGE
Range is a measure of spread.

The range is a good way to get a very basic understanding of how spread out our data are. 

RANGE = Maximum - Minimum

In the Data Sheet Data, we have Data from A2:A101, 

RANGE =MAX(A2:A101) - MIN(A2:A101)

Result is 75

If Max function result is in Cell B3 & Min function result is in cell B2, then

=B3-B2

It can also be calculated as 100 - 25 = 75

The practice sheet can be downloaded from Link. Statistics Marks Data - Download Sheet