Value of a,b and c based on two equation

[abcdabcd]

Value of three variable At 9AM is: 2a+3b+4c=250

Value of same three variable At 10AM is: 4a+2b+6c=350

Can we find value of a,b and c from above equation? Any help would be much appreciated.I am not worried about time as long as I am able to find value of a, b and c. My thanks in advance!

 

[Dr.Peterson]

If you know nothing about how each variable varies with time, then you really just have two equations in six unknowns. Even if the variables were the same in both equations, you couldn't solve for actual values; you need as many equations as you have unknowns.

If you want help, you'll have to give the entire problem of which this is a part, so we might be able to see other facts that could be used to solve it.

 

[abcdabcd]

If you know nothing about how each variable varies with time, then you really just have two equations in six unknowns. Even if the variables were the same in both equations, you couldn't solve for actual values; you need as many equations as you have unknowns.

If you want help, you'll have to give the entire problem of which this is a part, so we might be able to see other facts that could be used to solve it.

I am sorry for providing incomplete question. There are 5stocks in the group, which has different weightage together form 100%. Assume, when the market open, each stock contributes points to the particular Index based on weightage. Assume, weightage is not known, and I know the increased or decreased share price and total index points.
E.g: 5a+6b-2c+3d+6e=250
After 10minutes, points keep fluctuation due to change in share price; however, index weightage remain same. I just want to find out the weightage from share price change in stock and total index points change. Is there any way I can find out the weightage?

 

[Deleted member 4993]

I am sorry for providing incomplete question. There are 5stocks in the group, which has different weightage together form 100%. Assume, when the market open, each stock contributes points to the particular Index based on weightage. Assume, weightage is not known, and I know the increased or decreased share price and total index points.
E.g: 5a+6b-2c+3d+6e=250
After 10minutes, points keep fluctuation due to change in share price; however, index weightage remain same. I just want to find out the weightage from share price change in stock and total index points change. Is there any way I can find out the weightage?

Yes - however you would at least need to take 5 readings for solving 5 unknowns.

Do you use ms-excel?

 

[abcdabcd]

Yes - however you would at least need to take 5 readings for solving 5 unknowns.

Do you use ms-excel?

Yes, Sir, I am good at ms-excel and vba, any help would be appreciated

 

[Deleted member 4993]

Yes, Sir, I am good at ms-excel and vba, any help would be appreciated

Use matrix algebra - and use excel to invert the resulting matrix.

 

[Steven G]

Value of three variable At 9AM is: 2a+3b+4c=250

Value of same three variable At 10AM is: 4a+2b+6c=350

Can we find value of a,b and c from above equation? Any help would be much appreciated.I am not worried about time as long as I am able to find value of a, b and c. My thanks in advance!

Just some notes on your terminology. You say Value of three variable At 9AM is: 2a+3b+4c=250 . The values of 3 variables would be like saying a=2, b=6 and c=6. In the future say something like the relationship between 3 variables is ....

 

[abcdabcd]

Thank you all for your suggestion. I will try matrix algebra and let you know the answer. Once again thank you..

 

[abcdabcd]

Use matrix algebra - and use excel to invert the resulting matrix.

I am unable to find the solution. I attached the original data, for which I did the calculation and in one tab with original data. When you get time will you be able to look into this.My thanks in advance..

I am unable to attach the excel file. I provided below the data.

Index Base Value is: 1000

Index points as of 1st Nove'19 is: 30330.55

Date	Stock 1 $ Change	Stock2 $ Change	Stock3 $ Change	Stock4 $ Change	Stock5 $ Change	Stock6 $ Change	Stock7 $ Change	Stock8 $ Change	Stock9 $ Change	Stock10 $ Change	Stock11 $ Change	Stock12 $ Change	Index Points Incre/Decre
16-Oct-19​	3.35	-0.7	-2.7	-1.95	3.45	0.75	2.25	-10.05	-0.55	-5.6	-2.4	0.45	-16.3
17-Oct-19​	16.9	1.7	2.1	-1.1	5.3	0.75	65.6	-1	1.7	31.75	9.4	6.35	450.65
18-Oct-19​	-0.75	0.8	-0.35	9	-2.8	-0.25	2.55	10.7	1.2	5.05	4.2	4	130.8
22-Oct-19​	3.2	0.35	-0.45	10.3	13.35	0.1	-1.65	13.6	0.5	-8.3	0.85	0.4	290.9
23-Oct-19​	2.1	2.3	-0.25	2.3	3.95	-0.15	-8.4	-15.2	0.55	-27.8	4.95	-0.6	48.45
24-Oct-19​	-7.15	-2.55	-2.3	-5.5	-0.35	-0.8	-49.6	-0.45	-1.55	-7.45	-12.95	-2.9	-351.65
25-Oct-19​	0.9	1.65	-0.75	-7.1	14.35	1.8	-10.95	-24.6	0.95	8.65	19.05	3.85	288
27-Oct-19​	1.5	0.05	0.6	8.7	0.45	1	4.6	4.4	0.25	-1.1	0.25	2.6	120.35
29-Oct-19​	28.35	1.45	1.25	4.8	7.85	0.1	38.65	-17.45	1	17.15	-1.15	3.4	356.75
30-Oct-19​	8.95	2.5	-0.05	5.85	-6.25	0.75	-18.1	3.35	1.75	12.05	9.25	-1.35	114.45
31-Oct-19​	11.05	-1.65	-1.75	18	8.1	-2.15	-16	4.4	-1.65	-21.65	-22.5	-13.6	78.75
01-Nov-19​	11.95	2.8	2.25	9.7	-0.8	-0.75	66.65	5.4	1.8	0.35	1.15	-3.8	264.3

I need weightage percentage of each stock.

Stock	Weightage % ?
Stock1	?
Stock2	?
Stock3	?
Stock4	?
Stock5	?
Stock6	?
Stock7	?
Stock8	?
Stock9	?
Stock10	?
Stock11	?
Stock12	?