0 of 46 lessons complete.
Module 8: Analysis · Lesson 42 of 46
Linear Interpolation
Estimate values between two known points with FORECAST.
Step 1 of 20%
A thermocouple outputs 0 mV at 0°C and 4.096 mV at 100°C. FORECAST draws a straight line through known points: =FORECAST(x, known y's, known x's). In E2, estimate the output at 65°C.
Target: E2
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Temp (°C) | Output (mV) | Temp to find | Output (mV) | ||
| 2 | 0 | 0 | 65 | |||
| 3 | 100 | 4.096 | 82 | |||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $