insurance claims and medical bills analysis

Task 1) quick research based on your knowledge. share with us how you would suggest to categorize medical procedures/treatments, it could be based on your experience in insurance industry or medical services. please comment if the Singapore TOSP way of classifying medical treatment is a good way. [login to view URL] research on other categorizing methods and send us the information. task 2) clean up medical data HK data. [login to view URL] Tab: data -review the field a) Operation (indexed) and b) operation Options(indexed): correct the typo etc and ensure the same medical condition are grouped together with the same fields value. use pivot table to summarize combination and make data correction. HK Data list: produce a final list of a) Operation (indexed) and b) operation Options(indexed), assign a number for each combination. 3) map each procedure in Singapore TOSP excel to the HK data list (1) as in the highlighted column, note some of the Singapore row may not map to HK one, please leave it as NA. [login to view URL] list of conditio1 list of condition (map to Singapore list of procedures we have two set of medical procedures from Hong Kong and from Singapore as follows: Hong Kong: research on how insurance companies