How can we calculate Second horizontal derivative of Gravity Anomaly with Microsoft Excel?

Answer 1

You can easily do the above scenario. Just take a look below!

Import or enter the gravity manually data into a new excel worksheet.

The data should be in a table format with columns for the latitude, longitude, and gravity anomaly values.

Calculate the first horizontal derivative of gravity anomaly by creating a new column for the first derivative using the following formula:

=(y2-y1)/(x2-x1)

Where "y" is the column containing the gravity anomaly data, and "x" is the column containing the longitude or latitude data.

Copy the formula down for each row in the table to calculate the first derivative at each point.

Calculate the second horizontal derivative of gravity anomaly by creating a new column for the second derivative using the following formula:

=(z2-z1)/(x2-x1)

Where "z" is the column containing the first derivative data, and "x" is the column containing the longitude or latitude data.

Copy the formula down for each row in the table to calculate the second derivative at each point.

Visualize the second derivative data using a contour map or other visualization technique to better understand the spatial variations of the gravity anomaly data.  

AND YOU ARE DONE!