Assignment 1 Excel Pt. 2 PDF

Preview

Summary

Some assignments came with excel requirements: Here is the PDFs of the excel part of the assignment....

Description

Standard Deviation (Accn Values) accn Standard Deviation (Dr Values) 53 0.219 5.656854249 0.07651258 64 0.219 2.121320344 0.07651258 53 0.146 5.656854249 0.128131375 64 0.146 2.121320344 0.128131375 65 0.684 2.828427125 0.252292073 55 0.611 4.242640687 0.200673278 75 0.591 9.899494937 0.186531143 72 0.522 7.778174593 0.137740775 40 0.258 14.8492424 0.048935415 58 0.25 2.121320344 0.05459227 43 0.283 12.72792206 0.031257746 32 0.419 20.50609665 0.064908776 40 0.123 14.8492424 0.144394831 30 0.138 21.92031022 0.133788229 72 0.422 7.778174593 0.067030097 90 0.556 20.50609665 0.161782405 40 0.447 14.8492424 0.084707766 50 0.547 7.778174593 0.155418444 55 0.204 4.242640687 0.087119182 50 0.17 7.778174593 0.111160812 55 0.17 4.242640687 0.111160812 75 0.192 9.899494937 0.095604463 53 0.292 5.656854249 0.024893785 70 0.299 6.363961031 0.019944037 64 0.292 2.121320344 0.024893785 53 0.225 5.656854249 0.072269939 50 0.313 7.778174593 0.010044542 44 0.224 12.02081528 0.072977046 100 0.231 27.57716447 0.068027299 65 0.334 2.828427125 0.0048047 68 0.419 4.949747468 0.064908776 78 0.352 12.02081528 0.017532622 58 0.363 2.121320344 0.025310797 80 0.291 13.43502884 0.025600892 55 0.314 4.242640687 0.009337436 100 0.377 27.57716447 0.035210292 100 0.434 27.57716447 0.075515378 52 0.35 6.363961031 0.016118408 58 0.334 2.121320344 0.0048047 61 0.327205 Average 17.16138 0.140521 Population

Dr

Skew (Dr Values) 0.624638655

0.70435107

EARTHQUAKE REC0RDS Ground Acceleration (Accn) (in m/s^2)

0.8 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0 0

20

40

60

80

100

Relative Density (Dr) (in %)

Correlation Coefficient: r = 0.28068 General Trends in Scatterplot: Since the density of the sand goes up when the relative denisty percentage goes up, you can see that the looser the density of the sand, the higher the acceleration seemed to be.

120...