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
![Station 1
Station 2
Density
Density
Station 1
Station 2
|depth (m)
(kg/m^3)
|(kg/m^3)
Pressure
Pressure
PGF =
dP/dx
0.00000
1023.24251
1023.45160
0.00000
0.00000
0.00000
Density
PGF = dP/dx
1.00000
1023.24277
1023.45170
10027.77915
10029.82666
0.00205
1023.00
1023.50
1024.00
1024.50
1025.00
2.00000
1023.24282
1023.45186
20055.55878
20059.65489
0.00410
PGF (N/m^3)
-0.030
-0.020
-0.010
0.000
0.010)
0.02000
0.03000
3.00000
1023.24290
1023.45207
30083.33920
30089.48517
0.00615
4.00000
1023.24296
1023.45238
40111.12021
40119.31850
0.00820
5.00000
1023.24309
1023.45425
50138.90249
50149.17015
0.01027
6.00000
1023.24276
1023.45663
60166.68154
60179.04512
0.01236
7.00000
1023.24327
1023.46094
70194.46559
70208.96233
0.01450
8.00000
1023.25657
1023.47523
80222.37997
80239.01959
0.01664
9.00000
1023.33958
1023.50767
90251.10786
90269.39475
0.01829
10.00000
1023.47489
1023.55187 100281.16178 100300.20308
0.01904
11.00000
1023.58800
1023.60668 110312.32418 110331.54854
0.01922
10
10
12.00000
1023.66846
1023.66732 120344.27509 120363.48828
0.01921
13.00000
1023.73448
1023.72166 130376.87299 130395.96055
0.01909
14.00000
1023.81407
1023.76350 140410.25088 140428.84285
0.01859
15
15.00000
1023.90749
1023.79988 150444.54428 150462.08167
0.01754
15
16.00000
1024.00355
1023.83408 160479.77907 160495.65566
0.01588
17.00000
1024.07908
1023.86550 170515.75405 170529.53756
0.01378
18.00000
1024.14787
1023.89689 180552.40318 180563.72708
0.01132
20
19.00000
1024.20043
1023.92953 190589.56739 190598.23647
0.00867
20.00000
1024.24529
1023.96646 200627.17123 200633.10778
0.00594
21.00000
1024.28229
1024.00750 210665.13768 210668.38128
0.00324
22.00000
1024.32080
1024.04994 220703.48152 220704.07069
0.00059
25
23.00000
1024.36253
1024.09715 230742.23431 230740.22276
-0.00201
24.00000
1024.39914
1024.15596 240781.34588 240776.95117
-0.00439
25
25.00000
1024.44903
1024.23311 250820.94638 250814.43565
-0.00651
26.00000
1024.51841
1024.31651 260861.22679 260852.73745
-0.00849
30
27.00000
1024.58450
1024.37684 270902.15489 270891.63048
-0.01052
28.00000
1024.64614
1024.42190 280943.68707 280930.96510
-0.01272
30
29.00000
1024.71640
1024.46235 290985.90779 290970.69613
-0.01521
30.00000
1024.76199
1024.46235 301028.57529 301010.42716
-0.01815
Stati on 1 Density (kg/m^3)
Stati on 2 Density (kg/m^3)
35
20
Depth (m)](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe9a0099a-2c87-4293-8b2b-a4b5ecfda6c5%2Fe23cb2ca-2916-44cd-bc6c-8bc54bd718fd%2Fdo3nh9f_processed.png&w=3840&q=75)
![Consider the case of a density profile with many values
(see weekly activity)
Po = po g zo = 0
Zo = 0
h, = z1-Zo
= Z1-Zo
P1
P1 = Po + p1 g hı
h2 = z2-Z1
%3D
P2
P2 = P1 + p2 g h2
Z2
h3 = Z3-22
P3
P3 = P2+ pa g h3
hN = ZN-ZN-1
PN = PN-1 + PN g hN
ZN
Hint:
z (m) Stn 1 Density (kg/m^3)
Stn 1 Pres.
0.000
= dP/dx
Stn 2 Density (kg/m^3)
Stn 2 Pres.
PGF
1023.24251
1023.45160
0.000
1023.24277
1023.45170
10027.78=1023.24277*9.8*1+0
10029.83
.002
2
1023.24282
1023.45186
20055.56=1023.24282*9.8*1+10027.78
20059.56
.004
000
N O H N](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fe9a0099a-2c87-4293-8b2b-a4b5ecfda6c5%2Fe23cb2ca-2916-44cd-bc6c-8bc54bd718fd%2Fwszhkcq_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 6 steps with 3 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Structural Analysis](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781337630931/9781337630931_smallCoverImage.jpg)
![Structural Analysis (10th Edition)](https://www.bartleby.com/isbn_cover_images/9780134610672/9780134610672_smallCoverImage.gif)
![Principles of Foundation Engineering (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337705028/9781337705028_smallCoverImage.gif)
![Structural Analysis](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781337630931/9781337630931_smallCoverImage.jpg)
![Structural Analysis (10th Edition)](https://www.bartleby.com/isbn_cover_images/9780134610672/9780134610672_smallCoverImage.gif)
![Principles of Foundation Engineering (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337705028/9781337705028_smallCoverImage.gif)
![Fundamentals of Structural Analysis](https://www.bartleby.com/isbn_cover_images/9780073398006/9780073398006_smallCoverImage.gif)
![Sustainable Energy](https://www.bartleby.com/isbn_cover_images/9781337551663/9781337551663_smallCoverImage.gif)
![Traffic and Highway Engineering](https://www.bartleby.com/isbn_cover_images/9781305156241/9781305156241_smallCoverImage.jpg)