Linear interpolation problem : From Table 1, find the freezing point temperature

Question

Linear interpolation problem:

From Table 1, find the freezing point temperature for a salinity value of 33 using linear interpolation. Also plot the salinity value vs freezing point temperature. Use Excel to plot.

Table 1: Salinity as a function of Freezing temperature

     Salinity

     Freezing Temperature (F)

       0

(fresh water)

           32.0

        10

         31.1

        20

         30.1

        24.7

         29.6

        30

         29.1

        35

         28.6

     Salinity

     Freezing Temperature (F)

       0

(fresh water)

           32.0

        10

         31.1

        20

         30.1

        24.7

         29.6

        30

         29.1

        35

         28.6

Explanation / Answer

=FORECAST(33,<y value cell range>,<x value cell range>)

= 28.80687 ( Freezing temperature at 33 degrees).

Similarly (x,y) pairs can be computed for other x values to generate a graph plot

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.