how to plot a graph in excel ph vs cumulative concentration

However, the exact pattern of this relation continues to be debated. There is conclusive evidence from clinical trials that reduction of mortality by fibrinolytic therapy in acute myocardial infarction is related to the time elapsing between onset of symptoms and commencement of treatment. after the last dose of diazepam on Day 15. Desmethyldiazepam blood levels are within the range of the diazepam blood levels and exhibit an apparent half-life range from 50 to 99 hr. Diazepam blood levels plateau at approximately Day 7 of treatment at twice the blood levels observed on Day 1. diazepam every 24 hr., the minimum and maximum steady-state (plateau) levels of diazepam can be successfully predicted or calculated utilizing the pharmacokinetic parameters obtained following intravenous administration. Following chronic administration of 10 mg. Orally administered diazepam was rapidly and completely absorbed. The rate at which diazepam returns to the central compartment from the deep peripheral compartment, k31, was shown to be the rate-controlling factor in the elimination of diazepam and in the formation of desmethyldiazepam. The “apparent” half-life of elimination of diazepam following intravenous administration ranged from 21 to 37 hr., and the calculated volume of distribution ranged from 160 to 205% of body weight. The intravenous blood level data were fitted with a three-compartment open-model system containing both a “shallow” and a “deep” peripheral compartment. (Key words: nonlinear concepts, upper asymptote, Alpha Beta (αβ) Math, Excel spreadsheet screen, coefficient of determination, regression equation, proportionality constant, position constant) Symbols: θ = 10 q = Log (nonlinear logarithmic) αβ (extension of XY) ϕ = (0) (nonlinear zero)įour subjects each received single intravenous and oral 10-mg. All examples include systematic demonstration of Excel data manipulation and extensive graphing. It demonstrates a straightforward methodology for solving the key upper asymptotes for the proportionality equation using the Microsoft Excel via determining the 'coefficient of determination'. The article emphasizes the building of a straight-line proportionality relationship for the dose-response data in a log-linear and log-log graphs. Their difference is XY =, where Yu, Yb, Xu, and Xb are the upper and bottom asymptotes of Y and X variables. The Alpha Beta (αβ) math is an extension of the XY math it emphasizes the association between the XY continuous nonlinear numbers and its associated asymptotes while the XY math is helpless in addressing the asymptotes relating to the nonlinear numbers. It introduces a new extended XY math (named Alpha Beta (αβ) math) concept for graphical expression of the experimental data, along with the presentation of simple mathematical equation having meaningful equation parameters. This article first reviews the fundamentals of nonlinear math followed by the analyses with examples. The data of pharmacokinetics and dose-response relationships in life science are nonlinear phenomena thus need to analyze from the viewpoint of nonlinear mathematics.

How to plot a graph in excel ph vs cumulative concentration