-
Directions
Click on the calculator and use it to compute the average for the data in the first column of each table. Type your data in the highlighted cell of the table. Use the Enter or Return key to input the data. The average for data in the succeeding columns of each table will automatically be calculated for you.
Complete Table 2 - Calculate the following concentration values and type in your data in the highlighted cell of the table. Press the Enter key to input.
- Calculate the average glucose concentration at 1 hr post meal state. Other averaged glucose concentration values will be entered automatically.
- Calculate the average value of the ketone (betahydroxybutyrate) concentration at 1 hr post meal state. Other averaged ketone concentration values will be entered automatically.
When you have completed your calculations for Table 2, click on the tab for Table 3 to continue.
Complete Table 3 - Calculate the following concentration values and type in your data in the highlighted cell of the table. Press the Enter key to input.
- Calculate the insulin concentration at 1 hr post meal state. Other averaged values will be entered automatically.
- Calculate the glucagon concentration at 1 hr post meal state. Other averaged values will be entered automatically.
- Using averaged values of insulin and glucagon concentrations at 1 hr post meal, calculate the insulin to glucagon ratio. Values of the insulin to glucagon ratio for the other states will be entered automatically.
To see your calculations reflected in a graph, click on the See Graphs tab.
Your data tables will be transferred to your Laboratory Report.
-
Glucose and Ketone Concentration in Blood Plasma 
Glucose (mmol/l) Ketones (μmol/l) Sub. 1 Sub. 2 Sub. 3 Average Sub. 1 Sub. 2 Sub. 3 Average Fasting Immediately post meal
[0 hour]1 hr post meal Minimum 3 characters, two numbers, one digital full stop. The Average value is valid, thank you. Sorry. Your value is wrong. Please try again. The valid Average value is correct, thank you.
Minimum 2 characters, two numbers. The Average value is valid, thank you. Sorry. Your value is wrong. Please try again. The valid Average value is correct, thank you.
2 hr post meal 3 hr post meal Equations (fx)
Use these formulas for making your calculations. Round your answer to the nearest tenth.
Averages
Add the values from the three subjects; divide by three.
Your data will not be saved until the table is completely filled in.
Insulin and Glucagon Concentration in Blood Plasma Insulin (pmol/l) Glucagon (pmol/l) Insulin/Glucagon
RatioSub. 1 Sub. 2 Sub. 3 Average Sub. 1 Sub. 2 Sub. 3 Average Fasting Immediately post meal
[0 hour]1 hr post meal Minimum 3 characters, two numbers, one digital full stop. The Average value is valid, thank you. Sorry. Your value is wrong. Please try again. The valid Average value is correct, thank you.
Minimum 2 characters, two numbers. The Average value is valid, thank you. Sorry. Your value is wrong. Please try again. The valid Average value is correct, thank you.
Minimum 3 characters, two numbers, one digital full stop. The Average value is valid, thank you. Sorry. Your value is wrong. Please try again. The valid Average value is correct, thank you.
2 hr post meal 3 hr post meal Equations (fx)
Use these formulas for making your calculations. Round your answer to the nearest tenth.
Averages
Add the values from the three subjects; divide by three.
Ratio
Divide the insulin average by the glucagon average from 1 hr post meal.
Your data will not be saved until the table is completely filled in.
×Congratulations on completing Data Analysis.
Select Laboratory Report to report on your findings.
-
Glucose Concentration in Blood Plasma
Ketones Concentration in the Blood Plasma
Insulin and Glucagon Concentration in Blood Plasma
Insulin to Glucagon Concentration Ratio