Factorial Design Analysis Template

Requirements basic Excel installation and appropriate macro security. 

Goal perform the analysis of a factorial design experiment in Excel in an easy and straightforward manner. 

Description a screenshot of the plain template is shown in Fig. 8.27. The yellow blocks are where the required data are entered. The green block represents the row in which an array formula needs to be entered. The complete green row should be selected and then the first cell highlighted. Finally, press Ctrl +Shift+Enter to copy the array formula to the entire green row. Adding additional parameters and data points will also require that the formulae be appropriately copied down. 

The spreadsheet automatically creates the normal probability plot for the parameters and residuals as well as plots of the residuals as a function of y and y and a time series plot of the residuals. Additional plots can be created by the user. An example of how to use the template is provided in Sect. 8.7.3 Factorial Design Examples. 

Warning this template requires that the internal macros be enabled. Also, the array formulae need to be properly entered. 

---

This section presents three examples that show how to implement various forms of regression analysis in Excel. The topics considered are linear regression, nonlinear regression, and analysis of factorial design. All examples are based on real data obtained from experiments. The procedures use the appropriate templates for... 

---