I How to find the location of red cells?

  • I
  • Thread starter Thread starter MarkSS
  • Start date Start date
  • Tags Tags
    Cells
MarkSS
Messages
1
Reaction score
0
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
 

Attachments

  • TAB1 and TAB2.jpg
    TAB1 and TAB2.jpg
    99 KB · Views: 132
  • TAB3.jpg
    TAB3.jpg
    52.6 KB · Views: 132
  • TAB_COLOR1.jpg
    TAB_COLOR1.jpg
    88.1 KB · Views: 122
Physics news on Phys.org
MarkSS said:
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.

MarkSS said:
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.
 
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/
 
Hi all, I've been a roulette player for more than 10 years (although I took time off here and there) and it's only now that I'm trying to understand the physics of the game. Basically my strategy in roulette is to divide the wheel roughly into two halves (let's call them A and B). My theory is that in roulette there will invariably be variance. In other words, if A comes up 5 times in a row, B will be due to come up soon. However I have been proven wrong many times, and I have seen some...
Thread 'Detail of Diagonalization Lemma'
The following is more or less taken from page 6 of C. Smorynski's "Self-Reference and Modal Logic". (Springer, 1985) (I couldn't get raised brackets to indicate codification (Gödel numbering), so I use a box. The overline is assigning a name. The detail I would like clarification on is in the second step in the last line, where we have an m-overlined, and we substitute the expression for m. Are we saying that the name of a coded term is the same as the coded term? Thanks in advance.
Back
Top