Here is data for two profiles of density vs depth. Use excel or similar to plot density vs depth for the two stations on the same plot. Also compute and plot the Pressure Gradient Force as a function of depth resulting from the difference in density between the two stations, assuming that the stations are 1000m apart. Make your plots look nice, label your axes and use a legend. The data is below or you can find it in our class files in density_data.txt Additional instructions. Describe how you made the calculation and provide your excel spreadsheet so that I can see how you computed pressure and pressure gradient force. Hints: 1) See this slide with some hints 2) see also this screenshot of my excel spreadsheet showing what your plot should look like Depth (m) Station 1 Density (kg/m^3) Station 2 Density (kg/m^3) 0 1023.242514 1023.451596 1 1023.242772 1023.451697 2 1023.242816 1023.451864 3 1023.242899 1023.452068 4 1023.242963 1023.452379 5 1023.243086 1023.454251 6 1023.242764 1023.456634 7 1023.243269 1023.460935 8 1023.256574 1023.47523 9 1023.339578 1023.507671 10 1023.474892 1023.551871 11 1023.587997 1023.606676 12 1023.668463 1023.667322 13 1023.734479 1023.721658 14 1023.814074 1023.763501 15 1023.90749 1023.799882 16 1024.003551 1023.834076 17 1024.079083 1023.865495 18 1024.147871 1023.896887 19 1024.200433 1023.92953 20 1024.245287 1023.966464 21 1024.282289 1024.007496 22 1024.320798 1024.04994 23 1024.362532 1024.097151 24 1024.399138 1024.155957 25 1024.449027 1024.233112 26 1024.518405 1024.316514 27 1024.584501 1024.376842 28 1024.646137 1024.421904 29 1024.716397 1024.462347 30 1024.761992 1024.495816
Here is data for two profiles of density vs depth. Use excel or similar to plot density vs depth for the two stations on the same plot. Also compute and plot the Pressure Gradient Force as a function of depth resulting from the difference in density between the two stations, assuming that the stations are 1000m apart. Make your plots look nice, label your axes and use a legend. The data is below or you can find it in our class files in density_data.txt
Additional instructions. Describe how you made the calculation and provide your excel spreadsheet so that I can see how you computed pressure and pressure gradient force.
Hints: 1) See this slide with some hints
2) see also this screenshot of my excel spreadsheet showing what your plot should look like
Depth (m) Station 1 Density (kg/m^3) Station 2 Density (kg/m^3)
0 1023.242514 1023.451596
1 1023.242772 1023.451697
2 1023.242816 1023.451864
3 1023.242899 1023.452068
4 1023.242963 1023.452379
5 1023.243086 1023.454251
6 1023.242764 1023.456634
7 1023.243269 1023.460935
8 1023.256574 1023.47523
9 1023.339578 1023.507671
10 1023.474892 1023.551871
11 1023.587997 1023.606676
12 1023.668463 1023.667322
13 1023.734479 1023.721658
14 1023.814074 1023.763501
15 1023.90749 1023.799882
16 1024.003551 1023.834076
17 1024.079083 1023.865495
18 1024.147871 1023.896887
19 1024.200433 1023.92953
20 1024.245287 1023.966464
21 1024.282289 1024.007496
22 1024.320798 1024.04994
23 1024.362532 1024.097151
24 1024.399138 1024.155957
25 1024.449027 1024.233112
26 1024.518405 1024.316514
27 1024.584501 1024.376842
28 1024.646137 1024.421904
29 1024.716397 1024.462347
30 1024.761992 1024.495816
Step by step
Solved in 6 steps with 3 images