Max and min values -- Finding them in a data set

Click For Summary
SUMMARY

The discussion focuses on calculating maximum and minimum values from a data set, denoted as ##\mathcal{D}##. The mathematical definitions provided are ##M := \max\{d\,\vert \, d \in \mathcal{D}\}## for maximum and ##m := \min\{d\,\vert \, d \in \mathcal{D}\}## for minimum. The conversation highlights the importance of understanding the nature of the data set, including its source, structure, and potential uncertainties. Additionally, practical tools like Excel are suggested for users who prefer a software solution for finding these values.

PREREQUISITES
  • Understanding of set notation and mathematical functions
  • Familiarity with data structures and their properties
  • Basic knowledge of Excel functions, specifically MIN and MAX
  • Awareness of algorithmic approaches to data analysis
NEXT STEPS
  • Research algorithms for finding maximum and minimum values in data sets
  • Learn about data structures that facilitate efficient data retrieval
  • Explore advanced Excel functions for statistical analysis
  • Investigate uncertainty quantification methods in experimental data
USEFUL FOR

Data analysts, mathematicians, researchers conducting experiments, and anyone interested in efficiently calculating statistical extremes in data sets.

Amany Gouda
Messages
29
Reaction score
0
I have some data collected from experiment and I want to calculate the max and min values for this data.
Please note that these data not a result of function.
What is the best mathematical way to get the max and min without just picking them by directly observation.
 
Physics news on Phys.org
Amany Gouda said:
I have some data collected from experiment and I want to calculate the max and min values for this data.
Please note that these data not a result of function.
What is the best mathematical way to get the max and min without just picking them by directly observation.
What do you mean by "have" and what by "get"?

You ask specifically of a mathematical way. So here it is, but you might be disappointed:
Let ##\mathcal{D}## denote the set of collected data. (This mathematically means: have.)
Then ##M := \max\{d\,\vert \, d \in \mathcal{D}\}## and ##m := \min\{d\,\vert \, d \in \mathcal{D}\}## denotes the maximum and minimum. (This mathematically means "get").

Maybe you see the difficulties with your question:
  • Where are the data taken from? ##\mathcal{D} \subseteq## ?
  • How is ##\mathcal{D}## described, i.e. is it a list, a graphic or whatever is it?
  • Are there finitely many of them? ##|\mathcal{D}| < \infty## ?
  • What is the ordering on ##\mathcal{D}## ?
  • Are there eventually algorithms to determine ##M## and ##m## ?
  • Can a order be achieved while reading the data?
  • Is it sufficient to calculate upper and lower bounds for ##M,m## ?
  • Are there uncertainties to the data?
All these questions might depend on your experiment or might not. As long we don't know any answers to those, the formal definition of ##\mathcal{D}\; , \;M\; , \;m## above is your answer.
 
Last edited:
Amany Gouda said:
What is the best mathematical way to get the max and min without just picking them by directly observation.

Do you know how to use Excel? It has min and max functions. Or do you want to write a program and are looking for an algorithm to find the min and max?
 

Similar threads

  • · Replies 19 ·
Replies
19
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K
Replies
28
Views
4K
  • · Replies 7 ·
Replies
7
Views
1K
  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 7 ·
Replies
7
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 4 ·
Replies
4
Views
1K
  • · Replies 7 ·
Replies
7
Views
3K
Replies
8
Views
2K