Question

Application of microsoft excel in pharmaceutical analysis

Answer 1

Microsoft (MS) Excel spreadsheet has become the standard platform for data collection, graphing and analysis. Majority of the original data are saved in MS Excel files in pharmaceutical and analytical fields.

Spreadsheets are mainly used to make monitoring of data easier.

Students and researchers use a spreadsheet for statistics, data analysis, equilibrium calculations and other basic arithmetic calculations. They also construct log diagrams, plot the results, to determine error coefficients in spectrophotometry, calculating the titration curves, for filling kinetic data etc.

 

The macros in the spreadsheets replace the repetitive tasks that are done manually in a lab. Effective monitoring of performance becomes easy. Advancements allow interaction of medical devices with spreadsheets and can help in accumulating data like history or medical information about a patient and the treatment.

Answer 2

The MS excel is used to present and analysis the different data. The spreadsheets are used for this purpose . Excel is also used to plot the result and for the determination of error coefficient  in the spectrophotometry.
One of the major application is that it is used for  handling of pharmocokinetics analysis. MS excel is also used for the parameter esstimation.

Also, it helps in storing of data so it can be saved for future analysis .
Moreover  calculation of basic arithmetic is  also one of applications.