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.

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" <(E-Mail Removed)> wrote in message
news:28440F1A-CACD-448D-BFA8-(E-Mail Removed)...
> 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.
>

Hi Tim:

Thanks for attempting my question. I took multiple readings.

"Tim Williams" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:28440F1A-CACD-448D-BFA8-(E-Mail Removed)...
> > 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.
> >
>
>
>

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

"Elijah" <(E-Mail Removed)> wrote in message
news0875A61-7A2D-4934-B9AC-(E-Mail Removed)...
> Hi Tim:
>
> Thanks for attempting my question. I took multiple readings.
>
> "Tim Williams" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:28440F1A-CACD-448D-BFA8-(E-Mail Removed)...
>> > 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.
>> >
>>
>>
>>