- StudyBlue
- Virginia
- George Mason University
- Engineering
- Engineering 107
- Hassan
- Prob_4_EX_Prb_8.7_Fig_8.19.xls
Prob_4_EX_Prb_8.7_Fig_8.19.xls
Engineering 107 with Hassan at George Mason University
About this note
By: Sree Ram Mohanan
Created: 2009-12-06
File Size: 9 page(s)
Views: 0
Created: 2009-12-06
File Size: 9 page(s)
Views: 0
About StudyBlue
STUDYBLUE makes things that make you better at school.
Things like online flashcards with photos and audio.
Things like personalized quizzes and friendly reminders about when (and what) to study next.
Think of it as a digital backpack™: access to all of your study materials online and on your phone.
STUDYBLUE exists to make studying efficient and effective for every student, for free. Join us.
“Simply amazing. The flash cards are smooth, there are many different types of studying tools, and there is a great search engine. I praise you on the awesomeness.”
Dennis
Dennis
Sign up (free) to study this.
Chart1 4330 4470 4600 4620 5110 5320 5360 5600 5950 6300 7300 7530 8900 9000 9150 10700 12000 14000 15300 22400 Chart3 4330 4470 4600 4620 5110 5320 5360 5600 5950 6300 7300 7530 8900 9000 9150 10700 12000 14000 15300 22400 Chart4 4330 4470 4600 4620 5110 5320 5360 5600 5950 6300 7300 7530 8900 9000 9150 10700 12000 14000 15300 22400 Sheet1 Problem 8.7_Table 8.19 Xi' Yi' Xi Yi Xi*Yi Xi^2 Yi^2 P Q Log P Log Q (Log P)(log Q) (log P)^2 (log Q)^2 Q' Q'-Q % Diff 1.85 4330 0.2672 3.6365 0.9716 0.0714 13.2240 4642 312 7.2 1.95 4470 0.2900 3.6503 1.0587 0.0841 13.3247 4771 301 6.7 2.06 4600 0.3139 3.6628 1.1496 0.0985 13.4158 4909 309 6.7 2.18 4620 0.3385 3.6646 1.2403 0.1146 13.4296 5055 435 9.4 2.32 5110 0.3655 3.7084 1.3554 0.1336 13.7524 5222 112 2.2 2.48 5320 0.3945 3.7259 1.4697 0.1556 13.8824 5406 86 1.6 2.66 5360 0.4249 3.7292 1.5845 0.1805 13.9067 5607 247 4.6 2.87 5600 0.4579 3.7482 1.7162 0.2097 14.0489 5833 233 4.2 3.11 5950 0.4928 3.7745 1.8599 0.2428 14.2470 6081 131 2.2 3.40 6300 0.5315 3.7993 2.0193 0.2825 14.4350 6370 70 1.1 3.75 7300 0.5740 3.8633 2.2177 0.3295 14.9253 6703 -597 -8.2 4.18 7530 0.6212 3.8768 2.4082 0.3859 15.0295 7092 -438 -5.8 4.73 8900 0.6749 3.9494 2.6653 0.4554 15.5977 7563 -1337 -15.0 5.43 9000 0.7348 3.9542 2.9056 0.5399 15.6360 8126 -874 -9.7 6.39 9150 0.8055 3.9614 3.1909 0.6488 15.6929 8843 -307 -3.4 7.75 10700 0.8893 4.0294 3.5833 0.7909 16.2359 9777 -923 -8.6 9.84 12000 0.9930 4.0792 4.0506 0.9860 16.6397 11069 -931 -7.8 13.48 14000 1.1297 4.1461 4.6838 1.2762 17.1904 13038 -962 -6.9 21.41 15300 1.3306 4.1847 5.5682 1.7705 17.5116 16584 1284 8.4 52.00 22400 1.7160 4.3502 7.4650 2.9447 18.9247 26308 3908 17.4 153.84 167940 13.3454 77.4945 53.1639 11.7011 301.0502 168996 1056 0.6% Sum P Sum Q Sum log P Sum log Q Sum (log P)(log Q) Sum (log P)^2 Sum (log Q)^2 sum xi sum yi sum xi*yi sum xi^2 sumyi^2 n= 20 Form: log Q = m log P + log b y = bx^m m = 0.520 Q' = 3371P^.520 log b = 3.5277 b = 10^3.5277 b = 3371 Using Excel r = 0.984 Correlation coefficient = 0.984 29.0778099439 7.4780061738 3.949790961 r^2 97% of variation in discharge can be accounted for by variation in the return period. Sheet2 Problem 8.7_Table 8.19 Xi' Yi' Xi Yi Xi*Yi Xi^2 Yi^2 P Q Log P Log Q (Log P)(log Q) (log P)^2 (log Q)^2 Q' Q'-Q % Diff 1.85 4330 0.2672 3.6365 0.9716 0.0714 13.2240 #REF! #REF! #REF! 1.95 4470 0.2900 3.6503 1.0587 0.0841 13.3247 #REF! #REF! #REF! 2.06 4600 0.3139 3.6628 1.1496 0.0985 13.4158 #REF! #REF! #REF! 2.18 4620 0.3385 3.6646 1.2403 0.1146 13.4296 #REF! #REF! #REF! 2.32 5110 0.3655 3.7084 1.3554 0.1336 13.7524 #REF! #REF! #REF! 2.48 5320 0.3945 3.7259 1.4697 0.1556 13.8824 #REF! #REF! #REF! 2.66 5360 0.4249 3.7292 1.5845 0.1805 13.9067 #REF! #REF! #REF! 2.87 5600 0.4579 3.7482 1.7162 0.2097 14.0489 #REF! #REF! #REF! 3.11 5950 0.4928 3.7745 1.8599 0.2428 14.2470 #REF! #REF! #REF! 3.40 6300 0.5315 3.7993 2.0193 0.2825 14.4350 #REF! #REF! #REF! 3.75 7300 0.5740 3.8633 2.2177 0.3295 14.9253 #REF! #REF! #REF! 4.18 7530 0.6212 3.8768 2.4082 0.3859 15.0295 #REF! #REF! #REF! 4.73 8900 0.6749 3.9494 2.6653 0.4554 15.5977 #REF! #REF! #REF! 5.43 9000 0.7348 3.9542 2.9056 0.5399 15.6360 #REF! #REF! #REF! 6.39 9150 0.8055 3.9614 3.1909 0.6488 15.6929 #REF! #REF! #REF! 7.75 10700 0.8893 4.0294 3.5833 0.7909 16.2359 #REF! #REF! #REF! 9.84 12000 0.9930 4.0792 4.0506 0.9860 16.6397 #REF! #REF! #REF! 13.48 14000 1.1297 4.1461 4.6838 1.2762 17.1904 #REF! #REF! #REF! 21.41 15300 1.3306 4.1847 5.5682 1.7705 17.5116 #REF! #REF! #REF! 52.00 22400 1.7160 4.3502 7.4650 2.9447 18.9247 #REF! #REF! #REF! 153.84 167940 13.3454 77.4945 53.1639 11.7011 301.0502 Sum P Sum Q Sum log P Sum log Q Sum (log P)(log Q) Sum (log P)^2 Sum (log Q)^2 sum xi sum yi sum xi*yi sum xi^2 sumyi^2 n= 20 Form: log Q = m log P + log b y = bx^m m = 0.520 Q' = 3371P^.520 log b = 3.5277 b = 10^3.5277 b = 3371 Using Excel r = 0.984 Correlation coefficient = 0.984 29.0778099439 7.4780061738 3.949790961 r^2 97% of variation in discharge can be accounted for by variation in the return period. Sheet3 P Q Log P Log Q (Log P)(log Q) (log P)^2 (log Q)^2 Q' Q'-Q % Diff 1.85 4330 0.2672 3.6365 0.9716 0.0714 13.2240 0 -4330 -100.0 1.95 4470 0.2900 3.6503 1.0587 0.0841 13.3247 0 -4470 -100.0 2.06 4600 0.3139 3.6628 1.1496 0.0985 13.4158 0 -4600 -100.0 2.18 4620 0.3385 3.6646 1.2403 0.1146 13.4296 0 -4620 -100.0 2.32 5110 0.3655 3.7084 1.3554 0.1336 13.7524 0 -5110 -100.0 2.48 5320 0.3945 3.7259 1.4697 0.1556 13.8824 0 -5320 -100.0 2.66 5360 0.4249 3.7292 1.5845 0.1805 13.9067 0 -5360 -100.0 2.87 5600 0.4579 3.7482 1.7162 0.2097 14.0489 0 -5600 -100.0 3.11 5950 0.4928 3.7745 1.8599 0.2428 14.2470 0 -5950 -100.0 3.40 6300 0.5315 3.7993 2.0193 0.2825 14.4350 0 -6300 -100.0 3.75 7300 0.5740 3.8633 2.2177 0.3295 14.9253 0 -7300 -100.0 4.18 7530 0.6212 3.8768 2.4082 0.3859 15.0295 0 -7530 -100.0 4.73 8900 0.6749 3.9494 2.6653 0.4554 15.5977 0 -8900 -100.0 5.43 9000 0.7348 3.9542 2.9056 0.5399 15.6360 0 -9000 -100.0 6.39 9150 0.8055 3.9614 3.1909 0.6488 15.6929 0 -9150 -100.0 7.75 10700 0.8893 4.0294 3.5833 0.7909 16.2359 0 -10700 -100.0 9.84 12000 0.9930 4.0792 4.0506 0.9860 16.6397 0 -12000 -100.0 13.48 14000 1.1297 4.1461 4.6838 1.2762 17.1904 0 -14000 -100.0 21.41 15300 1.3306 4.1847 5.5682 1.7705 17.5116 0 -15300 -100.0 52.00 22400 1.7160 4.3502 7.4650 2.9447 18.9247 0 -22400 -100.0 153.84 167940 13.3454 77.4945 53.1639 11.7011 301.0502 P Q Log P Log Q (Log P)(log Q) (log P)^2 (log Q)^2 153.84 167940 13.35 77.49 53.16 11.70 301.05
Back
Next
About this note
By: Sree Ram Mohanan
Created: 2009-12-06
File Size: 9 page(s)
Views: 0
Created: 2009-12-06
File Size: 9 page(s)
Views: 0
About StudyBlue
STUDYBLUE makes things that make you better at school.
Things like online flashcards with photos and audio.
Things like personalized quizzes and friendly reminders about when (and what) to study next.
Think of it as a digital backpack™: access to all of your study materials online and on your phone.
STUDYBLUE exists to make studying efficient and effective for every student, for free. Join us.
“Simply amazing. The flash cards are smooth, there are many different types of studying tools, and there is a great search engine. I praise you on the awesomeness.”
Dennis
Dennis