Water and Wastewater.com Help Forums - Wastewater statistical analysis

osu

YaBB Newbies

Offline

I love Water and
Wastewater.com

Posts: 3

Company or Organization: University of Fort Hare

Wastewater statistical analysis
Apr 19^th, 2012, 12:46pm

• I am about working on the Final effluent of a Waste water treatment plant. I will be collecting samples for a period of 12 months; 1 (one) sample per month. Sample collections will be split between autumn, winter, summer and spring. The physiochemical parameters like Temperature, pH, Electrical conductivity (EC), Turbidity, total dissolved oxygen (TDS) and dissolved oxygen (DO) will be taken along with the microbiological components like bacteria (Feacal coliform , E.coli and Vibrio) and viruses (Enteri virus, Rotavirus, Norovirus and Adenovirus)will also be looked into. The whole data collected is to access the quality of the final effluent wastewater and what interaction exist between the physiochemical components and microbiological components
• I want to know which statistic analysis method best analyse the data collected and why?
• If more than one statistic method can be use, please can all responders be simple and clear about their explanation on their choice of methods. Advices and suggestions will be highly appreciated. Thank you

Back to top

IP Logged

Victor

YaBB Moderator

Offline

Escherichia coli
Happens!

Posts: 1269

Company or Organization: www.santacruzproductions.com

Re: Wastewater statistical analysis
Reply #1 - Apr 19^th, 2012, 6:55pm

OSU:

I think it is best if you can take a basic statistics course to learn about correlations, student's t test, dependent and independent samples/variables. You need to start out first with graphing these variables on a chart to determine if you can at least "see" a trend, that is, if the variables are inverse/directly related. If you see a trend, then you can statistically test to see if there is a correlation. Try the following website to get you started:

http://www.statsoft.com/textbook/basic-statistics/

Back to top

www.santacruzproductions.com
http://santacruzproductions.wordpress.com
http://www.linkedin.com/groupInvitation?groupID=2328156&sharedKey=6D694C2A168C
Disclaimer! Please Read:
There is no warranty or assumption of any legal liability or responsibility for the accuracy, completeness, or usefulness of any information, apparatus, product, or

IP Logged

osu YaBB Newbies Offline I love Water and Wastewater.com Posts: 3 Company or Organization: University of Fort Hare	Re: Wastewater statistical analysis Reply #2 - Apr 20^th, 2012, 9:39am Thank you...But starting a statistical course isn't it..because of time factor. I just need something definite
Back to top	IP Logged

FR

YaBB Newbies

Offline

Posts: 15

Gender: male

Company or Organization: City of Hayward

Re: Wastewater statistical analysis
Reply #3 - Apr 20^th, 2012, 4:57pm

Depending on your expertise with Microsoft Excel, you may enter all your number in the spreadsheet and then use inset function and make a graph to see how the trends of your variables are.

The average, minimum and maximum are the simplest function, for Fecal coliform ,... you may want to go with 5-day geometric mean/median mean, monthly geometric mean for ...

If you need help, you may send me your numbers (my email is faridr1@gmail.com) and I'll put them together on the excel and send them back to you.
Farid

Back to top

IP Logged

osu YaBB Newbies Offline I love Water and Wastewater.com Posts: 3 Company or Organization: University of Fort Hare	Re: Wastewater statistical analysis Reply #4 - Apr 21^st, 2012, 12:21pm Thank everyone Hi Farid, I will contact you once I have my numbers ready
Back to top	IP Logged