My Math Forum  

Go Back   My Math Forum > High School Math Forum > Probability and Statistics

Probability and Statistics Basic Probability and Statistics Math Forum


Reply
 
LinkBack Thread Tools Display Modes
April 20th, 2017, 01:31 AM   #1
Newbie
 
Joined: Apr 2017
From: Spain

Posts: 4
Thanks: 0

Integer harmonized data in other scale

I have n data and harmonize them to be between 1 and 100.

These data I have to integrate into another data scale, some of which correspond to some of mine.

For example, I have already normalized these data:
Foo = 0
Bar = 23
Baz = 47
Qux = 88
Quxx = 100
And I want to put it on another list in which not all my elements but only some
L1 = 321
Bar = 427
L3 = 430
Qux = 432
L5 = 552
What I need to get is the values of foo, baz and quux on that new scale (of course it's just an example, the lists would have many more records and could be repeated in both of them.
ulises2010 is offline  
 
April 20th, 2017, 01:45 AM   #2
Senior Member
 
romsek's Avatar
 
Joined: Sep 2015
From: CA

Posts: 1,206
Thanks: 614

can't you just divide these new values by the same normalization factor you used in the first batch?
romsek is offline  
April 20th, 2017, 01:52 AM   #3
Newbie
 
Joined: Apr 2017
From: Spain

Posts: 4
Thanks: 0

Thanks romsek... but I don't understand.

I normalize the data with this excel formula:

=((E2-min(E2:E28))/(MAX(E2:E28)-min(E2:E28)))*100

What do you propose?

Last edited by skipjack; April 20th, 2017 at 03:25 AM.
ulises2010 is offline  
April 20th, 2017, 01:56 AM   #4
Senior Member
 
romsek's Avatar
 
Joined: Sep 2015
From: CA

Posts: 1,206
Thanks: 614

Quote:
Originally Posted by ulises2010 View Post
Thanks romsek... but I don't understand.

I normalize the data with this excel formula:

=((E2-min(E2:E28))/(MAX(E2:E28)-min(E2:E28)))*100

What do you propose?
Are you saying that bar was 427 before you rescaled it?

And that Qux was 432?

But after rescaling you end up with

bar=23
Qux=88 ?

Last edited by skipjack; April 20th, 2017 at 03:26 AM.
romsek is offline  
April 20th, 2017, 02:58 AM   #5
Newbie
 
Joined: Apr 2017
From: Spain

Posts: 4
Thanks: 0

No, I don't know exactly the number before normalize, it's only an example... ok, I do it with real data:

I have this numbers:
A 14114.95924
B 10533.13138
C 6577.410098
D 1485.161134
E 4783.793628
F 605.5022578
G 3075.351796
H 5297.838888
I 3665.250456
J 8078.53943
K 9568.715523
L 24241.96974
M 4018.821608
N 19765.286
O 6272.29431
P 5900.627335
Q 4186.309794
R 12744.83994
S 10051.84912
T 12032.2509
U 11787.90014
V 4855.601458
W 6773.989664
X 8946.267047
Y 5304.473946
Z 5641.43848
A1 4368.112301
I normalize
A 57.1551438
B 42.00132329
C 25.26565293
D 3.721617357
E 17.6773089
F 0
G 10.44931752
H 19.85210621
I 12.94503166
J 31.61655682
K 37.92112028
L 100
M 14.44090304
N 81.06026737
O 23.97478412
P 22.40235383
Q 15.14950378
R 51.35851068
S 39.96513808
T 48.34372416
U 47.30993703
V 17.98110992
W 26.09733206
X 35.28769599
Y 19.88017749
Z 21.30579041
A1 15.91866486
And now have to put in other scale we only have this data
A
B
C
D 56.88
E
F 48.18
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
A1 50.38

Last edited by skipjack; April 20th, 2017 at 03:27 AM.
ulises2010 is offline  
April 20th, 2017, 03:12 AM   #6
Newbie
 
Joined: Apr 2017
From: Spain

Posts: 4
Thanks: 0

No, I rescale bar and qux and obtain 23 and 88... but in the new scale I have to put all the number I know bar and qux value is 427 and 432 but not the value of others.

I try to explain better but is revision the post
ulises2010 is offline  
Reply

  My Math Forum > High School Math Forum > Probability and Statistics

Tags
data, harmonized, integer, scale



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
centigrade scale, Celsius scale and thermodynamic scale taylor_1989_2012 Physics 2 June 6th, 2016 03:52 AM
Compacting data into a 16-bit integer Dev Dorian Computer Science 6 September 1st, 2013 11:25 PM
Rolling 3 months YOY data to Monthly YOY data lumpa Real Analysis 0 October 19th, 2012 08:07 AM
Scale on Map haftakhan Algebra 3 June 17th, 2011 09:44 AM
How to regress actual data towards projected data. BigLRIP Advanced Statistics 1 May 18th, 2009 10:01 AM





Copyright © 2017 My Math Forum. All rights reserved.