summary

Linear Regression EXCEL sample - BOD Thomas_Final

and

where y = BOD t (mg/L)

k = BOD rate constant (d -1

)

Lo = ultimate BOD (mg/L)

Problem 4-15. (DC, p. 333)

Using the Thomas Method, calculate the BOD rate constant, k (d -1

)

and ultimate BOD, Lo (mg/L) from the following data:

Given Data Time, t

(day)

BODt, y

(mg/L)

2 86

5 169

10 206

20 273

35 288

Slope = B

Intercept = A

t

1/ 3 1/ 3 ( ) ( ) t t

y BOD t



6 ( ) B

k A

 0 2 1

6 ( ) ( ) L

A B 

1/ 3 ( ) t

A B t y

 

0

Linear Regression line

(Solution)

Given Data Computed Time, t

(day)

BODt, y

(mg/L) (t/y)^(1/3)

2 86 0.285

5 169 0.309

10 206 0.365

20 273 0.418 35 288 0.495

A 0.2844 Intercept B 0.0063 Slope

k 0.13 per day Lo 327 mg/L

EXCEL HW assignment - BOD Thomas method

submitted by:

Chikashi Sato (#123456)

y = 0.0063x + 0.2844 R² = 0.978

0.000

0.100

0.200

0.300

0.400

0.500

0.600

0 10 20 30 40

(t /y

)^ (1

/3 )

Time (day)

k B

A  6( ) L

A B 0 2

1

6 

( ) ( )