Spreadsheets in Education (eJSiE)

Abstract Even though interpolating bivariate data by Lagrange interpolation is straightforward, its repetitivecalculations are quite boring and complicated if the number of data is large. Hence, there is a need to have asuitable tool in teaching and learning Numerical Methods for this topic. To simplify things, we have developedan Excel spreadsheet calculator to interpolate the bivariate data with 4 rows by 4 columns using Lagrangeinterpolation. The spreadsheet calculator can be used by educators and students who need its full solution. Inaddition, users only need to enter a dataset, two independent variables, and the values of the two independentvariables which are not in the dataset to obtain a bivariate approximation solutions table in the respectivetarget cells automatically. Besides, the excel command given helps in the teaching and learning process of thistopic using Excel spreadsheet. Keywords Excel Spreadsheet, bivariate approximation, Lagrange interpolation Cover Page Footnote

[1]  H. Levy,et al.  Approximating Expected Utility by a Function of Mean and Variance , 1979 .

[2]  Singiresu S Rao,et al.  Applied numerical methods for engineers and scientists , 2001 .

[3]  Eugene F. Brigham,et al.  Corporate Finance: A Focused Approach , 2002 .

[4]  R. Dorfman.  A Formula for the Gini Coefficient , 1979 .

[5]  David R. Shaffer,et al.  Currency Hedging Using the Mean-Gini Framework , 2005 .

[6]  Donald Lien,et al.  Estimating the extended mean-gini coefficient for futures hedging , 1993 .

[7]  John Okunev,et al.  An empirical evaluation of the extended mean‐gini coefficient for futures hedging , 1992 .

[8]  Jack Golten,et al.  Control System Design and Simulation , 1991 .

[9]  A. Atkinson.  On the measurement of inequality , 1970 .

[10]  Ali El-Hajj.  Functional Simulation Using Spreadsheets , 1999, Simul..

[11]  S. Yitzhaki,et al.  The Mean-Gini Efficient Portfolio Frontier , 2005 .

[12]  John Okunev,et al.  Utility maximizing hedge ratios in the extended mean gini framework , 1993 .

[13]  Campbell R. Harvey,et al.  Emerging Equity Market Volatility , 1995 .

[14]  Ali El-Hajj,et al.  Digital control systems simulation using spreadsheets , 2003, Comput. Appl. Eng. Educ..

[15]  W. Fung,et al.  Empirical Characteristics of Dynamic Trading Strategies: The Case of Hedge Funds , 1997 .

[16]  S. Yitzhaki,et al.  A note on the calculation and interpretation of the Gini index , 1984 .

[17]  Stoyan V. Stoyanov,et al.  Different Approaches to Risk Estimation in Portfolio Theory , 2004 .

[18]  Ali El-Hajj,et al.  On using spreadsheets for logic networks simulation , 1998 .

[19]  Donald Lien,et al.  A note on estimating the minimum extended Gini hedge ratio , 1999 .

[20]  Clarence C. Y. Kwan.  Portfolio Analysis Using Spreadsheet Tools , 2001 .

[21]  John Okunev,et al.  The Generation of Mean Gini Efficient Sets , 1991 .

[22]  Clarence C. Y. Kwan,et al.  The hedging effectiveness of options and futures: A mean‐gini approach , 1990 .

[23]  A linear control system simulation toolbox using spreadsheets , 2000 .

[24]  Shlomo Yitzhaki,et al.  Mean-Gini, Portfolio Theory, and the Pricing of Risky Assets , 1984 .

[25]  Haim Shalit,et al.  Mean-Gini hedging in futures markets , 1995 .