How can I use excel to accurately predict A4, & A5 ?

[Elijah]

As shown below, I measured the gross flow of five wells (P, Q, R, S, T) with
the aid of three different measuring instruments (A, B & C). How can I use
excel to accurately predict A4, & A5 (The missing gross flow when I used
instrument A)?

A sample calculation / programming on how excel spreadsheet can be used will
be appreciated. I have tried trend.
Measuring Instruments
"Well #" A B C
P 44.9 46.4 67.3
Q 50.9 52 49.5
R 570 507 574.9
S A4 91.4 72.5
T A5 493.4 369.1

Thanks in advance.

Best regards,
Elijah.

 

[Tim Williams]

I don't think you can "accurately" predict the values.

In order to do this you'd have to have some idea of how readings from A
correlate with those from B and C. Since you only have 3 pairs of points
for each comparison (two very close togther and one much higher) you don't
really have any sound basis for this. Did you take multiple readings or
just one reading for each condition (well+instrument)?

Tim

 

[Elijah]

Hi Tim:

Thanks for attempting my question. I took multiple readings.

 

[Tim Williams]

I'm still not sure you can get anything really accurate. I would just take
a best guess, since your existing numbers don't support a reliable
calculated approach.

For example, for well R reading B<C, but for well T C<B: this does not
appear consistent.

Tim