Linear Interpolation in Matlab

I have an excel file spreadsheet with four columns containing the velocity pressure exposure coefficients, Kz, for different values of height above ground level,z. The first column A is height above ground, the other three columns (B, C, D) are the values of Kz.

Create a MATLAB script that will estimate the value of Kz given a particular exposure type and for any value of z up to 500 ft. Your MATLAB script must do the following tasks:

1. Import the data file into MATLAB
2. Prompt the user to specify exposure type
3. Prompt the user to specify height above ground level
4. Identify the correct lower and upper bounds given the height specified in step #3 and the exposure type specified in step #2
5. Perform the linear interpolation to estimate Kz for the specified height from step #3

I can't hard code it or use the built in linear interpolation function so I keep on getting various errors. I need help with indexing the arrays and putting them into the linear int. equation.

[John D'Errico]

Break a problem that is too large for you into SMALL problems that you CAN focus on and solve. Solve each one, then put them all together. This is how all large problems are solved.

Answer 1

[Image Analyst]

Try this: http://www.mathworks.com/matlabcentral/answers/8626-how-do-i-get-help-on-homework-questions-on-matlab-answers

One question I have is if you're supposed to average columns B, C, and D together to get a single value of Kz for that particular height in column A.

Other hints: xlsread(), inputdlg(), min() and max(), and interp1().