Converting data to a specified range

  • Context: Undergrad 
  • Thread starter Thread starter Ronni
  • Start date Start date
  • Tags Tags
    Data Range
Click For Summary
SUMMARY

This discussion focuses on converting a dataset ranging from -50000 to 26214400 into a specified range of 0 to 10. The user breaks down the data into four distinct intervals: 50000-1048576 maps to 0-2.5, 1048577-5242880 to 2.6-5, 5242881-15728640 to 5.1-7.5, and 15728641-26214400 to 7.6-10. The proposed method involves first normalizing the data to a range of 0 to 1 by subtracting 50000 and dividing by 26164400, followed by scaling to the desired range by multiplying by 10. The user notes that while the overall conversion is valid, the resulting intervals are irregular.

PREREQUISITES
  • Understanding of data normalization techniques
  • Familiarity with mathematical scaling methods
  • Basic knowledge of interval mapping
  • Experience with numerical data manipulation
NEXT STEPS
  • Research advanced normalization techniques for irregular intervals
  • Learn about piecewise linear functions for data transformation
  • Explore tools for data visualization to analyze transformed data
  • Investigate statistical methods for handling outliers in datasets
USEFUL FOR

Data analysts, statisticians, and anyone involved in data preprocessing or transformation tasks will benefit from this discussion.

Ronni
Messages
9
Reaction score
0
Hi,

I am trying to convert data to a particular range of 0-10.

Actual Data may vary from - 50000 - 26214400. I have broken this down into 4 parts as follows -

Code: 
50000 - 1048576 -----> 0 - 2.5
1048577 - 5242880 -----> 2.6 - 5
5242881 - 15728640 ----->5.1 - 7.5
15728641 - 26214400 ----->7.6 - 10


How can i convert this data ? Is there any formula to do this? I found a way to normalize data to a range of [ 0 - 1 ] but am not able to apply the same to this.
 
Physics news on Phys.org
Your numbers range from 50000 to 26214400? (I'm no certain if that is a dash or a negative in front of the "5000".

First subtract 50000 from each of your numbers to get them between 0 and 26214400- 50000= 26164400.
If you now divide each of your numbers by 26164400 they will be between 0 and 1. Is that what you say you can do? To get them between 0 and 10, now multiply by 10 which is the same as having divided by 2616440 instead of 26164400.
 
That is a dash.
This converting of whole data to a range of 0-10 is ok but the intervals are irregular that's why i divided the data into the mentioned intervals.
 

Similar threads

Undergrad Variable Normalization for different variable ranges....
  • · Replies 3 ·
Replies
3
Views
2K
Graduate Bin Width for Overlay Plots of Data + Estimation
  • · Replies 8 ·
Replies
8
Views
2K
MHB Are These Statistics Practice Answers Correct?
  • · Replies 1 ·
Replies
1
Views
2K
Undergrad Bayes again - how to interpret in vitro genotoxicity data
  • · Replies 8 ·
Replies
8
Views
2K
Undergrad Calculating a standard deviation involving weighted samples
  • · Replies 1 ·
Replies
1
Views
2K
Admissions Comments on my physics PhD applicant profile
  • · Replies 4 ·
Replies
4
Views
3K
Undergrad Progress In Calculating The HLbL Contribution To Muon g-2
  • · Replies 0 ·
Replies
0
Views
3K
How Can I Convert a -0.1V to 1V Output Into a 0V to 4V Range for an ADC Input?
  • · Replies 8 ·
Replies
8
Views
3K
Is the Dart Throwing Data a Gaussian Distribution?
  • · Replies 2 ·
Replies
2
Views
3K
High School What is the probability that the Universe is absolutely flat?
  • · Replies 96 ·
4
Replies
96
Views
12K