# Percentage of X,Y from table

aneesh123
Hello,

Is there any way of getting the percentage value of In and Ga in question marks, using equations.

I've been working this for few hours and really have no idea.

[PLAIN]http://indiansketches.com/img.png [Broken]

Last edited by a moderator:

L2E
I'm guessing this is in excel or something similar.
for Ga:
wouldn't you just do: Ga counts/(Ga counts + In counts + As Counts) for each row

and the same with In as the numerator for the In percentage?

aneesh123

Yes, It's excel file.

From the first two rows it is evident that percentage don't depend on counts.

Is it possible to derive an equation from data in first two rows and find percentage in question mark for the rest of the rows.

L2E
sorry, I should have read the table more clearly. that was my mistake. you might want to work out how much each of the elements (weigh I guess) compared to each other.

so if you make As = 1, then In = 246/60 and Ga = 92/117.
use those values to scale the amount of each element and work out the percentage.

aneesh123
Thanks so much for the reply mate.

Can you explain in detail, how to do that ?

For example : In and Ga percentage in row three.

The numbers are the percentage composition and counts of substrate.

in InAs 60 counts of In is 50% In in InAs or otherwise 50% of In will give 60 counts

similarly in GaAs 50% Ga and 50% As is there, Ga gives 117 counts where as As gives 92 counts

sorry, I should have read the table more clearly. that was my mistake. you might want to work out how much each of the elements (weigh I guess) compared to each other.

so if you make As = 1, then In = 246/60 and Ga = 92/117.
use those values to scale the amount of each element and work out the percentage.

Last edited:
L2E
sure,

what I have done is chosen multipliers to use to give each element a different weighting. and to do this there are a couple of simple steps.

you see that As is common in both of the initial samples. so it makes sense to set As to a value of 1 (you could use anything but 1 is convenient).

now you want to get the amount each of the other two 'weigh' in relation to As
so for Ga:
117Ga = 50% and 92As = 50%
equate the two equations, (50% = 50%)
therefore: 117Ga = 92As
Ga = (92/117)*As (As = 1)
Ga = 92/117

and do the same for In

aneesh123

I am having trouble in finding the percentage of In and Ga in InGaAs still. Would you be able to demonstrate to find the percentage of In and Ga compostion in the 3rd row.

L2E
ok, so you have the multipliers:
As = 1
Ga = 92/117
In = 246/60

so for row three
if you do
As total weight = 1 (As multiplier) x 141 (As count) = 141
Ga total weight = 92/117 x 120 = 94.3589744
In total weight = 246/60 x 32 = 131.2

total of all elements = 141 + 94.36 + 131.2 = 366.56
percentage of As = 141/366.56 = 38.5%
percentage of Ga = 94.36/366.56 = 25.7%
percentage of In = 131.2/366.56 = 35.8%