Nutritional Response Models: A Workbook to Fit Data From Nutritional Experiments to Several Models

RB 440

This Excel workbook will allow you to fit data from nutritional experiments to several models. It includes a PowerPoint presentation that shows you how to use the Excel workbook to fit several regression models to experimental data. The models may be used to estimate nutritional requirements or the most economical feeding levels of critical nutrients. All you need is Microsoft Excel (with macros enabled), the downloadable Excel file, and some input/output data.

Originally prepared by Dmitry Vedenov, Department of Agricultural and Applied Economics, Texas A&M
Gene Pesti, Department of Poultry Science, University of Georgia

The NRM.xlsm program is an Excel workbook that you can use to fit data from nutritional experiments to several models. The models may be used to estimate nutritional requirements or the most economical feeding levels of critical nutrients. It requires Microsoft Excel (with enabled macros) and some data in the form of ordered pairs.

Instructions are included in the PDF below (made from a PowerPoint presentation) and on each spreadsheet of the Excel workbook.

References are included on the Instructions and References page of the workbook.

Download NRM 1.4.xlsm — the Excel Workbook

Download instructions for using NRM 1.0. [PDF]

Examples of fit lines and tests for data: observed points, multiple range test, quadratic polynomial, broken line - linear ascending, broken line - quadratic ascending, and saturation kinetics.

Published by University of Georgia Cooperative Extension. For more information or guidance, contact your local Extension office.

The University of Georgia College of Agricultural and Environmental Sciences (working cooperatively with Fort Valley State University, the U.S. Department of Agriculture, and the counties of Georgia) offers its educational programs, assistance, and materials to all people without regard to age, color, disability, genetic information, national origin, race, religion, sex, or veteran status, and is an Equal Opportunity Institution.