Calculation of Water Quality Index
Вставка
- Опубліковано 15 сер 2020
- The main motive of this video is to help Students or Researchers (who work with Water Quality Monitoring and Assessment) in how to carry out the steps by step procedure for calculating Weighted Arithmetic Index Method developed by Brown et al., 1972 using MS-Excel
#waterqualityindex #wqi(brownetal.,1972) #JustLikeAStream
Water Quality Index: • Water Quality Index
![How to Enter Water Quality Data in SPSS [Step by Step Tutorial]](http://i.ytimg.com/vi/_qeCqEQ6l9o/mqdefault.jpg)
![ОРБАН приехал к ПУТИНУ и "отчитался" о поездке в Киев 😁 [Пародия]](http://i.ytimg.com/vi/_0ukDovOWq8/mqdefault.jpg)
It's like I found diamond here.
Thanks a ton.
Appreciate the way of presenting these complex calculations.
Your honest compliment means the world to me. Thank You so much, Sir.
It just amazing way to provide a detailed information on WQI..... Thanks
Your kind words means a world to me
Thank you so so much @Pramod
You are too good at explaining the subject matter sir. Thanks and lot 🙏
I am elated to know from your kind words of admiration and encouragement. Thank you so much. Appreciate it very much 🙏
Hello Dr. Eugene, thank you very much for the slow and clear explanation on how to calculate the Water Quality Index with that specific popular method. I want to complement the presentation by saying that the ideal value for dissolved oxygen in water could be 14.6 mg/L for 0 salinity and 0 C temperature. I read this figure in a journal publication and in a table presented in the appendix of the book "Water Supply and Pollution Control" 6th Ed. by Viessmann and Hammer. Again thank you for educating us in a potentially summingly very useful water quality index. God bless and cordial regards.
Thank you so much @Ifmegv
Your compliment made me feel very very HAPPY.
I appreciate your appreciation so much. Thank a lot.
Yes, I agree with you with DO ideal value.
Thanks a Million time for the support.
God bless
Such a
adequate explanation. It is helping many people. Thank you, Keep doing.
Appreciate it so much Mr. Ravi. Thank You
Thank you so much for this wonderful explanation
Thank you so much for this video sir🙏🙏. With this I got clear clarity on how to calculate the WQI index.
I'm am so so happy to know my friend. I thank you 😊 too for your kind words. Appreciate it very much 🙏
Really Appreciate Dr.👍👌👌Its much helpful for WQI researcher.
Thank You so much GEO@AKASH@GANGA. It means a lot
That's a great explanation. Thank you so much.
The purpose of this video is served to hear that from you....Thank You so much @Errol Pereira.
Thank you very much Dr. Eugene
Welcome @ouhamdouchs5753
Thank you so much. This was very helpful. Much appreciated
I am happy to know that. Thank you @Babalwa
Thanks for sharing. It helped me a lot.It is very practical video
I'm so so happy to know that Sir. So grateful to you. Thanks a lot 🙏
Thank you so much for this. It really helped me .
Your kind words made me really happy. Thank you so much
For Sn either we use drinking standard or inland surface water standard for calculating WQI for river water sample?And can we use any parameter that have standard value using this method? Please reply @
great...very easily explained...thanx
Thank you so much and So grateful to you @Artificial intelligence Foundation
Thank you sir it was a great explanation it helps a lot for our research
I'm so grateful and happy to know this
Thank to you too ☺
Appreciate it very much 🙏
Can we get the excel sheet that was used as a template or for reference purposes?
Very nice explanation sir, really it helped me a lot for my research
Knowing that it's purpose is served.
Thank you so much. Wishing you the best.
Kindly Continue supporting my channel🙏
A loooooot of thanks sir
Love from kashmir
Appreciate it very much Mr. Adil
Thank you so much
Please can you provide a link to the WHO standard of some of these parameters? Because the standard I saw has a range for pH. How are we suppose to use the value when given in range.
Hi@arwoogun
The WHO standards slightly differs from BIS Standards. However, researches sometime use the former or the latter and sometime combined. This totally depends on the researchers aND parameters studied. The pH range is 7 to 8.5 and 8.5 is taken s the limit. This you can find in all WQI papers. Ok Thank you Friend
Can you please mention me the research paper used to select the water quality parameters in that video. or It is your choice?
Yes, they are researchers choice. However, if you are interested you can Google water qualit monitoing using water quality index, there are 100s of paper published related to this. Thank you 😊
Such wonderful explanation.......thank you...and please keep making water research related vedio like what kind of statistics we can use in water quality parameters with interpretation as well.....
Thank you so so much
It mean a lot
Thank you for motivating me.
Yes, I will surely do so
Thanks a lot.
Can this calculation be done by taking the average mean concentration values of monsoon post monsoon and pre monsoon seasons or do we need to calculate it separately for different seasons.
Hi Anjaly
Yes, the values to be used for wqi calculation are mean values.
For different seasons calculation of WQI should be also different
Example Station X will have 3 Different WQI values for Monsoon promonson and post monsoon seasons respectively
Thank you 😊
Hello Dr. Eugene, is there a maximum number of water quality paramters used for this method?
Hi @Liketso.
There is no maximum numver of water parameters
The resaerchers can incorporate as much parameters as he can, as long as the parameters incorporate have standard limits
Thank you
Hello would like to check why the DO ideal value is 14 ?
very good explaintion course. thank you very much. I have question please, can I use this method in raw water ?as most of standred are for drinking water
Thank you so much @Ahmed Abou Halima..... Yes, you can. The only thing is will change is the standards limit between drinling water and industrial waste water. Thanks again Ahmed
Please provide a video on Irrigation Water Quality Index
That,s very easy method you have explained sir.Can i get this excel sheet.This will be very kind of you sir
Thankyou so much for the clear explanation.. it will be more easy if u kindly provide the excel also
Hello sir, I just want to know if the ideal values are still applicable even if my research is about water quality that enables aquatic species to persist and not for drinking consumption?
Hi I believe there limits will be different but ideal will be the same
Thank you 😊
this is a very good video, however could you use the sample value instead of the mean value for the different sites. and also is this index only used exclusively for drinking water or can be it used for samples form river water?
Thank you @Faten Bazine. Your sample value will be a one-time analysis value but your mean value will be an average of three-time analysis value. So it's better to use mean value. Next answer is yes you can use it for determining the river water quality as well. Thanks @Faten and all the best
I like every single one of your content, but I'm not getting notifications on your recent publications. Thank you again for this insightful session on WQI calculation. Please keep sharing your knowledge as said by Abert Einstein, . May God bless and keep you fit for everyone. Thank you and Namaste 🙏🙏🙏
thankyou so much! Dr, do you know how to calculate HPI ? heavy metal pollution index?
@Nur Thank you so much. I will try to upload some in the near future. Much appreciation
Hello! Hope you are well. Is it possible to make some videos on Multivariate Statistical Analysis (PCA, CCA, DA, FA) and machine learning algorithms (SVR, ANN, BRT, MLR) using the river and lakes water quality parameters? I would be really grateful to you.
Thank You @Md Mamun for the message. I am happy and grateful you appreciate my work. With respect to your request, I will love to do so but it will take time my friend. Some Multivariate Statistical Analysis, will be given try in the near future. thank You My friend
Thank you for the video,. I have a question what happens if the mean conc values are negative??? Do you consider them or you just consider the positive values only !! Kindly help
Thank you for saying it. Appreciate it. Yes it's included.
Remember the modules sign in the formula l-8.3l . This modulus ignore the negative sign and hence value become 8.3. I hope you get it thanks again continue supporting 🙏 thanks 😊
Hi. First thanks for the video.
Secondly, the values of parameters are having quiet a large range, so is this okay to use these water quality parameters without standardization? If yes, what is the difference if someone use temperature in degrees Celsius and another use in Kelvin?
Thank you and appreciate it very much.
Using od WQI is mainly to make the data easy to understand to anyone
Parameters must be carried out adoption standard protocol. For temp, use the standard unit use for data.
Thank you and all the best 👍
Sir can we use other parameters like Temp, EC, DO , BOD and COD for water quality index calculation.
Yes @ Amina Shahzadi. Any water parameters having prescribe limit can be used for WQI calculation
Thanks for quite nice information
Thank You so much, My friend. It means a lots
Sir thank you very much for your video, it is excellent. I would like to know if this same methodology could be used to calculate the WQI of seawater and if so, what parameters could be considered ideal?
Hello there, in the cases where I do not have temperature and turbidity, would I just use 0? I have other parameters such as Nitrate, Nitrite, E.Coli levels and electrical conductivity. Much appreciated.
Hi there too. The parameters include here are just examples. It not necessary you have to have or include these parameters only. You can incorporate any parameters of interest subjected to they have the standard parameters
Thank you 😊
@@JustLikeASteam I am doing an analysis for water quality in Nepal. I have pH, EC, TDS, TH, Ecoli, Mg, FE, DO, NH3. Would I just substitute these values and use the exact same method you did? Thank you for your help.
And just use the standards provided in the measured levels table?
@@AnugrahaUdas yes, procedure is the same. Thank you 😊.
Thank you very much
You are welcome my friend
Thank you so much
The video is very useful but what will be the formula to calculate the value of DO in the column vn/sn as the ideal value of DO is 14?
VDo -14.6/5-14.6×100.
You can get this from any WQI reseaech paper. Thank you 😊
I need an Excel program that calculates the water quality index, please
Thank you for a great explanation. Can i get this excel sheet ?
Well explained!
Thank you so much.
Thank you very much sir. It is a very good explanation and helpful for me.
I am so happy to know that. appreciate it so very much @Gayomi Kannangara
@@JustLikeASteam Sir,
Could you tell me please,
How can I choose the ideal WQI method for rivers in tropical countries and what is the suitable WQI method, CWQI or Weighted Arithmetic Index Method.?
@@gayomikannangara7899 The Purpose of WQI method is to simplify the analytical data. The method to use totally depends on the researchers because it depends on him/her how he wants his study will express his/her finding.
Example. whether he wants to express his data seasonally(WAI) or one time (CCME WQI). Thank You
Thank you sir
@@gayomikannangara7899 Appreciate it
Great work. 👍👍
Thank You so so very much
thank you for the wonderful video. i have a doubt. what would be the ideal value of chemical oxygen demand ?
Amazingly grateful 🙏. It means a lot. In terms of COD, I am not aware there is standards limit, in that case there will be no sn value, meaning it can't be incorporated in wqi calculation. However, if therebis a prescribed limit then that will be the sn value. Thank you 😊
Where did you draw the analytical data one more time? The very last slide you showed for calculated WQI
Apologies I'm getting your questions.
Please sir, can I use more than one reference to know the standards at one time, for example BIS and WHO ?
Hi sir, can I use metals such as Pb, Cd, and Mn with pH and TDS included to calculate WQI?
Some research papers do, I did too.
However, if the study focus only on Heavy Metals.. I will suggest you use Heavy Metal Index. Thank You Sir.
Sir could you give us a heavy metal index formula
sir for classification of water quality there are 2 table : 1) form 0-100 2) and 0-300 what is the difference between them?
Great presentation
All the best for more lectures &videos sir.:-)
Appreciate it so much. Thanks for the motivation
Why the procedure to calculate Vn/Sn value for pH is different?
@YU_GN sir while calculating QPh some times we get negative sign and if u say neglect and reason behind neglecting the - ve sign in Qph
Sir reply plz
it becasue of the modulus [()] sign. Thank you
@@JustLikeASteam sir whether formula it self as modulus sign
are you ready to share the excel sheet you are using?
Could you kindly tell me where you read that the ideal DO value is 14?
Yes kindly see relevant papers where Brown et al WQI was used, you will find it mention there ok. All the best. Thank you 😊
Thank you so much sir
You are welcome my friend 😊 Thank you
Thank you for the video.
I am actually confused about what should I do if the Sn value is zero. Can you please help me about it?
In such case omit the parameters. No point of including it in the calculations right. Thank you 😊
Can i take Sn values from two different standards like a few from IS other from WHO or EPA or some other standards
Generally in most research papers you will see thatb if you (say) incorporate 10 paramters , say 7 you can obtained form BIS and 3 you can incorporate from other standards. Sometimes it's not possible to avail all parameters standards from 1 standards. Thank you
Sir I have 20 surface water quality parameters when im calculating NSF method exceeding 1000. In these I observed turbidity is playing major role it’s around 700
Then I try arthmatic method its les than 100 if I take turbudity limit 5
I sent an email also regarding this help
This helped me a lot in my research,Thank you very much .
I have a small doubt how to calculate the Qn value for DO since the ideal value for Disolved Oxygen is not Zero
I'm happy to know that this vidoe has help you
Thank you so much
Ideal value for DO is 14
Thabk you so much again
What is the formula for calculation of vn/sn value for DO, like pH?
It's 14. Ok Thank 😊 🙏
Thanks for this informative vedio. Could you please tell how to calculate hpi index.
Great Explanation...
But in some case their is confusion in the permisble limit for Turbidity. Weather it is 1 or 5 ,lly in case of BOD 3 or 2 or 5. Could you please help me to download the complete water quality standard by bis and who. All the parameters are not available in single pdf or .... So that we can cite that paper or site...
Thank you so much, it means a lot. First, please refer to BIS,2012 or any recent update if any. The confusion you get if
For each parameter, there is admissible limit and the prescribed limit example. Turbidity 1 is former and 4.is later ...similarly for other parameters. You can.refer any standard WQI research paper for reference ok. Thank you and all the best 👍
Sir, Can I calculate salinity in this WQI? If yes, may I know the ideal value of salinity please?
Hi Alice
Kindly check the standard limit for salinity first. If there is, then you can try.
However for WQI, IV is for pH and DO only. But I belive for salinity parts you can try SAR and others too. Have a look into these ok. Thank you 😊
Sir can u tell me in step 2 after diving you didnt multipy with hundred ?
The one you ask for is in the next steps. Hope this helps thanks again 🙏
This is a great video. It has really been helpful. I would like to know if the standard value is given as a range, which value should be used. For example, pH is given as 6.5 - 8.0
Most of the time you will find 1 no as the standard value
However for ph it the range
But the ph value you will use is 7 for calculations purposes
Thank you 😊
Please continue supporting this channel
Appreciate it very much 🙏
Kindly share the calculation part of the DO parameter too. it will be helpfull
Hello, this a good tutorial, what do I do with the negative signs during calculation of QpH
Thank you. It is mentioned in the video. Kindly check te video again.. [ value ]. Thank you 😊 al the best
The ideal value of DO is 14 or 14.6? In many publications, authors took it as 14.6.… Please give a clarification. And if you have the publication of Brown et al.,1972 then kindly share it because it is hard to get the full article.
The ideal value for DO is 14.6. Thank you 😊 and forgive me I am not sure I have the later you requested for.
Sir, in which SI units are we taking values for each parameters? is it in mg/L or microsiemens per litre?
It's mg/l for all paramters except for conducting mS/cm OK thank you 😊 🙏
@@JustLikeASteam Thankyou so much for your response, the video is of much helpful.
thank you sir
sir, which website take from this parametric data
Hi @Komal Malik. Thank you for writing and there is no website as such.
Thank You
Nice video Thank you, sir. how to calculate the Seawater mixing index and SAR, please provide these videos
Thank You so much Mr RXSekhar. I will surely try.Appreciate it so much
Congrats 80 subscribe 😊😊
in case of pH, Qn may become negative, if its less than 7, what to do? kindly suggest
Still works the same. Ignore the negative sign. Eg 4.6 pH.
Qph 1.5. Thank you 😊
Wonderful explanation 👏 👌 👍, so in case we include DO into the calculation, we have to consider 14 as ideal value, am I right sir?
First of all, I'm grateful 🙏 Thank you so much Sir. It means a lot to me.
And yes, you are right
Thank you 😊
can anyone please help me with this question, if we have extensive number of samples, how can we do it at once for all. thanks in advance
I believe CCME WQI is best. It's there in my channel. Thank you and I hope you will find it useful. Continue supporting this channel. Thanks a lot 🙏
May I get the link for the results taken ?
Sorry there is no link.
Thank you 😊
can you please list out main parameters which we have to select to determine WQI
Hi @Disha
For determining WQI, it totally depends on the researcher and also the study, any water pramters of interest in both cases can be included, keeping in mind the selected parameters do have standards limits ok
Thank you
@@JustLikeASteam thank you Sir
VERY USEFUL SIR
Appreciate it very much 🙏Devaki
Are all parameters must be within the permissible range (WHO) for example
Or in other words, do you mean that I cannot use a specific site that has parameters that exceed the permissible limit.?
Hi @ Azzeddine REGHAIS. No, it is, not that way, What it meant is
1. Any parameters selected for incorporation in any water quality index method calculation should have a standard limit (Example WHO standard limit).
2. Without a standard limit of water parameters WQI calculation is impossible
3. Only with the presence of the standard limit you will be able to determine the water limit of any site is within or exceeding the prescribed standard limit
Thank you and I hope I made it clear
@@JustLikeASteam Now it's ok , A lot thanks for you
@@azzeddinereghais7494 It is my pleasure to help.All the best my friend
Thank you sir for your great explanation. I have one question. I got a larger number as WQI ( above 5000).. can it be possible? I use E coli as a parameter and its permissible level i selected was 3. Sir can you pls lemme know the reason for this?
Hi @ Sandani. To my knowledge on using WQI assessment, I have not come across where WQI's overall value is beyond the range of the selected WQI method adopted.
I request you to kindly redo the calculation part.
I don't think because of any particular parameters the reading shoot up, because in the same case, we have combine say 8 to 9 water physico chemical parameters and 1 or 2 heavy metals where permissible limit (say, 0.01 or 0.3 ppm), the final value is still within the Selected WQI method.
Kindly cross-check again. One reminder, you have to be very meticulous with the calculation part
all the best ok
Thank you very much sir
1. As per standard TH is to be 200 but you are using 300. please clarify that. 2. For sodium as per WHO recommendation as 20 mg/L. is it correct to use this value?
Hi @ snowlin. The difference in TH acceptable limit is because 1991 drinking water specification (First Revision, 1991) is 300mg/l and second Revisoin i.e. 2012 is 300mg/l.
EPA guidance level for sodium in drinking water is 20 mg/L
Thank You
I compare my water sample result WHO standard should i write sn value ?
Yes you can
How good is he? Wonderfull Wonderfull Wonderfull!
Hi I believe you kind enough. Thank you so much. It means a lot Appreciate it 🙏
Thank you 😊
Thank you for the video sir much appreciated. I have a question, you mentiond that if we got negative value in QpH, does that mean we change negative sign into positive? Please clarify
Appreciate it very much. Thank you for kind words. Yes, did you remember the modulus in formula l×l. It it this, that ignore or eliminate the negative sign. Thank you 😊
Thanks for your.its very interesting
Thank you ☺☺
Appreciate it very much 🙏
Hi, Thank you. Great explanation. I'm wondering, may i have this excel format? Thank You again.
Thank you for the compliment and I appreciate it so much
Plz mail this excel sheet on astk1927@gmail.com this mail
Wonderful 👍😊
I thank you so much
Sir plz tell me if we calculate BOD for any water bodies Whether we will get 2 day Bod value high or 5day Bod value high, and also as time passes Bod values increase or decrease
BOD is for 5 days incubation. So with time DO content decreases.Thank you
@@JustLikeASteam sir if we use dilution factor the 5day BoD greater than example 2 day BOD is it right or wrong
@@PavanKumar-sq9xj
Get it clear
BOD values of water samples is obtained by finding it DO concentration
Direct or Dilution method
Level of DO is expected to decrease after incubation Thank you
Where could we get Sn value for electric conductivity, DO, phosphate ( as I have gone through the standards of BIS as well as WHO, I didn't fine any standard value for those parameters). Please also tell which standard value we put in Sn( permissible or acceptable). Also can you please tell which value should be used as Sn for pH ( 6.5 or 8.5) and why....... please reply ASAP
It depends on what standards you adopted eg. WHO/EPA/BIS etc.
However, some parameters doesn't have standard limits. In that case, you cannot incorporate it in WQI. PH is 8.5. Thabk you
@@JustLikeASteam What is the standard limit of e.coli? can we incorporate e.coli in WQI?
@@mdbayezidislam4678 Hi
If there is standard limit set our respective country recommend agency, yes we can.
Thank you 😊
@@JustLikeASteam For E.coli, the standard limit is zero according to WHO, in that case, 1/Sn calculation is impossible.
@@mdbayezidislam4678 if that the case then no point of adding it to WQI calculations. Thank you 😊
hello sir i am calclating water quality index for e. coli and Sn is zero cfu/100 ml and because of which 1/sn is showing error because 1/0 is undefined plz help in this regard
Hi, due to sn is 0, paramters as such are not incorporated in wqi calculations. So don't incorporate it ok . Thank you 😊
can you please tell me how to calculate Qn for dissolved oxygen. Is BIS standards of oxygen 15?
Is it 15?
@@nemboihaokip9575 14.62
Is this method can be used for biological parameters like E -coli?, when I was used this method according to your great explanation, the final WQI value is very large, because of maximum permissible level of E-coli is 0.1. is this method can be used only physicochemical parameters only??
We have use parameters like Iron with 0.3 permissible limit. It works. So you can use any paramters and all the best
@@JustLikeASteam but Dr Eugene, if ecoli permisiable level is zero. We cannot use this weighted arithmatic method. It gives 1/si =infinity. What I can do for that Dr? Also I cannot use CCME method because of one time sampling.
Express your water quality data graphically as mean plus-minus standard deviation value. All the best. Thank You
@@JustLikeASteam can you suggest the refferance video for that.
Sir, i have the value of ( Total hardness, magnesium, calcium, residual free chlorine, E-colli, total coliform Know for samples), is there any way to calculate WQI on the basis of above given parameters ??? SIR, E-colli should not be present in upto 100 ml of water sample, & the desirable limit of E-colli as per BIS is zero, It is not acceptable in the water ( Sir i have to consider E-colli & total colliform) how can i proceed ???
If possible kindly reply Asap.
Some of the paramter you have doesn't have standards limits like E Coli etc so in that case these parameters cannot ne included and calculation of wqi is possible only if there are standard limit to the paramters selected. Alright, thank you 😊 🙏
Sir I want to ask you more doubt regarding it, can I have your contact number, please.
Sir when i see the Central Board of population control's report of wqi I see the lower values of wqi to be poor & unfit for drinking & higher values to be excellent , but as per your video it is visible that wqi developed by brown et al (1972) lower values are excellent & higher are unfit,
Sir CPCB also calculate wqi on the basic of sub indexing,
My question is what values & there status should I use for my work.
@@_Pinnacle_here different wqi method differ from one another and therefore their values differ and range also differ consequently category also differ. You have to select the best and most fit and suitable to your study. Thank you
Thank sir for your detailed explanation ! please if you can send me excel sheet format Please
How to calculate the same of one site but different season...
Hi @ Pushpanathan. The water samples collected from the same sampling site will display different readings during different seasons.
IF you merge it, then you won't get water quality variation but only the average value of any specific parameters. thank you
Qph = 0.6 when it coming out to you was not multiplaying 100 why, I hope you will answer me as soon as possible, thanks.
It was multiplied in the Vn/sn*100 cell.
Thank you 😊
can you give me the excel file?
Sir Please tell the ideal value for alkalnity, hardness
It all 0
Only ph and Do have ideal value in this wqi method
Thank you and keep supporting my channel my friend
Thank you 😊