How to find the location of red cells?

[MarkSS]

TL;DR Summary

HOW TO FIND THE LOCATION OF RED CELLS??

Hi ALL!
I’m Mark. I’m new on this forum. Thank you very much to possibility of registration. This is my first post over here. I am student and I am writing my final work. I have a big and serious technical problem. Maybe some of you will be able to help me.
I show results of my measurements in tables.

TABLE LEGEND:

X - The X marks are measured values. The results of my measurements (KNOWN VALUES)

GREEN (KNOWN VALUES) - In green cells with numbers from 1 to 6 there are results of analytical calculations from previous series of measurements.

RED (VALUES TO PREDICT) - In red cells with letters from A to F are results of current calculations.
I noticed that results of analytical calculations agreed with measured values:
values of green from 1 to 6 and values of red cells from A to F. High correlation of the results of analytical calculations and measurements

MY PROBLEMS:
How to predict values in red cells?
How to find variants of value in red cells when I have position green cells in sheet ??.
OR
How to find variants of positions of red cells when we have position green cells in sheet from previous calculations??

Regards
Mark

 

[Dale]

How to predict values in red cells?

You need some statistical model of how the values of the red cells depend on the values of the green cells. Then you do a statistical fit to that model, usually a least-squares fit.

How to find variants of positions of red cells when we have position green cells in sheet from previous calculations??

Similarly you would need a statistical model of how the position of the red cell depends on the position of the green cells. Again, you would do a fit to that model.

 

[.Scott]

I am guessing that:
S1, S2, S3 ... refer to test samples.
M1, M2,M3, ... refer to types of measurements of the samples (for example pH, height, mass, viscosity, ...)
1, 2, 3, 4: refer to four separate opportunities to apply the same measurement to the same sample.

I am not clear of the phrase "position green cell".
Do you mean "the positions of green cells"? Or simply "some green cells"?

Also, is this a duplicate of:
https://www.physicsforums.com/threads/prediction-problem.1049901/