Excel in Excel®!. Issue 6 (1st September 2017)

• Record Type: Journal Article
• Authors: Ayer, Ganesh
• Is Part Of: Energy engineering. Volume 114:Issue 6(2017)
• Page Start: 7
• Page End: 12
• Publication Date: 2017-09-01
• Subjects: Power (Mechanics) -- Periodicals; 621.04205
• DOI: 10.1080/01998595.2017.11907869
• Languages: English
• ISSNs: 0199-8595

Abstract

ABSTRACT: Many times, tabulated data are given only at discrete points; for example, properties of R-134a refrigerant provided at 10°F intervals. Often the value we are interested lies between the tabulated values and we use the process of interpolation to find this value. Interpolation is formally defined as "estimation of intermediate values between precise data points." In this article, we will look at the manual method to first understand the mathematics behind interpolation, followed by functions available in Excel that can be directly used for interpolation. Finally, we will learn a construct using Excel's INDEX and MATCH functions that can be reused in any Excel model.