How do I do this? Data given at bottom.

African Beer Standard. Years ago The Economist reported the creation of an index, or standard, for the evaluation of African currency values using the local prices of beer. Beer, instead of Big Macs, was chosen as the product for comparison because McDonald's had not penetrated the African continent beyond South Africa, and beer met most of the same product and market characteristics required for the construction of a proper currency index. Investec, a South African investment banking firm, has replicated the process of creating a measure of purchasing power parity (PPP) like that of the Big Mac Index of The Economist, for Africa. The index compares the cost of a 375-milliliter bottle of clear lager beer across Sub-Saharan Africa. As a measure of PPP, the beer needs to be relatively homogeneous in quality across countries, and must possess substantial elements of local manufacturing, inputs, distribution, and service in order to actually provide a measure of relative purchasing power. The beer is first priced in local currency (purchased in the taverns of the locals, and not in the high-priced tourist centers). The price is then converted to South African rand and the rand-price compared to the local currency price as one measure of whether the local currency is undervalued or overvalued versus the South African rand. Use the data at the bottom and complete the calculation of whether the individual currencies are undervalued or overvalued.

\begin{tabular}{|l|l|l|r|r|r|r|} \hline Beer Prices & & & & & & \\ \hline Country & Beer & Local currency & Price in currency & Price in rand & Implied PPP rate & Spot rate \\ \hline South Africa & Castle & Rand & 2.29 & & & \\ \hline Botswana & Castle & Pula & 2.24 & 2.99 & 0.98 & 0.75 \\ \hline Ghana & Star & Cedi & 1199.98 & 3.16 & 524.01 & 379.15 \\ \hline Kenya & Tusker & Shilling & 41.24 & 4.03 & 18.01 & 10.24 \\ \hline Malawi & Carlsberg & Kwacha & 18.48 & 2.66 & 8.07 & 6.94 \\ \hline Mauritius & Phoenix & Rupee & 15.05 & 3.68 & 6.57 & 4.09 \\ \hline Namibia & Windhoek & N\$ & 2.52 & 2.63 & 1.1 & 0.96 \\ \hline Zambia & Castle & Kwacha & 1200.04 & 3.52 & 524.03 & 340.67 \\ \hline Zimbabwe & Castle & Z\$ & 9.01 & 1.47 & 3.93 & 6.13 \end{tabular} \begin{tabular}{|l|l|l|r|r|r|r|} \hline Beer Prices & & & & & & \\ \hline Country & Beer & Local currency & Price in currency & Price in rand & Implied PPP rate & Spot rate \\ \hline South Africa & Castle & Rand & 2.29 & & & \\ \hline Botswana & Castle & Pula & 2.24 & 2.99 & 0.98 & 0.75 \\ \hline Ghana & Star & Cedi & 1199.98 & 3.16 & 524.01 & 379.15 \\ \hline Kenya & Tusker & Shilling & 41.24 & 4.03 & 18.01 & 10.24 \\ \hline Malawi & Carlsberg & Kwacha & 18.48 & 2.66 & 8.07 & 6.94 \\ \hline Mauritius & Phoenix & Rupee & 15.05 & 3.68 & 6.57 & 4.09 \\ \hline Namibia & Windhoek & N\$ & 2.52 & 2.63 & 1.1 & 0.96 \\ \hline Zambia & Castle & Kwacha & 1200.04 & 3.52 & 524.03 & 340.67 \\ \hline Zimbabwe & Castle & Z\$ & 9.01 & 1.47 & 3.93 & 6.13 \end{tabular}