$(20$ points$)1)$ Calculate the constants on paper. $2)$ Calculate the constants using

excel and comment on the effect of the filter in removing particles

Extra Credits: Calculate the total carbonate hardness, total non$-$carbonate hardness

and total dissolved solids in problem $1(5$ points$)A$ water quality sample from nearby lake when tested resulted $in$ constituents shown $in$ table below. Calculated the Molarity, molality, number $of$ moles and mole fraction for all the constituents. Calculate the total hardness, alkalinity and exact alkalinity $of$ the solution. The water sample has $apHof6\mathrm{.}7.$ Assume that density $of$ water $(without$ any contaminants$)tobe1K\frac{g}{L}.$

$\begin{array}{cc}\text{C}\text{o}\text{n}\text{s}\text{t}\text{i}\text{t}\text{u}\text{e}\text{n}\text{t}& \text{C}\text{o}\text{n}\text{c}\text{e}\text{n}\text{t}\text{r}\text{a}\text{t}\text{i}\text{o}\text{n}(m\frac{g}{L})\\ \text{C}\text{o}\text{n}\text{s}\text{t}\text{i}\text{t}\text{u}\text{e}\text{n}\text{t}& \text{C}\text{o}\text{n}\text{c}\text{e}\text{n}\text{t}\text{r}\text{a}\text{t}\text{i}\text{o}\text{n}(m\frac{g}{L})\\ C{a}^{2+}& 20\\ HC{O}_3^{-}& 61\\ M{g}^{2+}& 24\\ C{O}_3^{2-}& 30\\ N{a}^{+}& 23\\ S{O}_4^{2-}& 32\\ K^{+}& 13\\ C{l}^{-}& 18\\ Si{O}_3^{2-}& 38\\ N{O}_3^{-}& 31\end{array}$

$(20$ points$)$ Show the calculation for Molarity, molality, # moles and mole fraction $on$ paper for $at$ least one $of$ these constituents $if$ want $to$ use excel. $If$ using excel, please upload the excel sheet with calculations showing $in$ the cells. Calculate the hardness and alkalinity $on$ paper.