Chapter 7 OR analysis Excel output

7.1 TBA How much finished

90%

7.2 Introduction

This chapter illustrates significance testing using the OR method. But, instead of the perhaps unwieldy output in Chapter 6, it generates an Excel output file containing the following worksheets:

  • Summary
  • FOMs
  • ANOVA
  • RRRC
  • FRRC
  • RRFC

7.3 Generating the Excel output file

This illustrates the UtilOutputReport() function. The arguments are the embedded dataset, dataset03, the same dataset as in the previous two chapters, the report file base name ReportFileBaseName is set to R/quick-start/MyResults, the report file extension ReportFileExt is set to xlsx, the FOM is set to “Wilcoxon”, the method of analysis is set to “OR”, and the flag overWrite = TRUE overwrites any existing file with the same name, as otherwise the program will pause for user input.

ret <- UtilOutputReport(get("dataset03"), 
                        ReportFileBaseName = "R/quick-start/MyResults", 
                        ReportFileExt = "xlsx",  
                        FOM = "Wilcoxon", 
                        method = "OR", 
                        overWrite = TRUE)

The following screen shots display the contents of the created file "R/quick-start/MyResults.xlsx".

`Summary` and `FOMs` worksheets of Excel file `R/quick-start/MyResults.xlsx``Summary` and `FOMs` worksheets of Excel file `R/quick-start/MyResults.xlsx`

FIGURE 7.1: Summary and FOMs worksheets of Excel file R/quick-start/MyResults.xlsx

`ANOVA` worksheet of Excel file `R/quick-start/MyResults.xlsx``ANOVA` worksheet of Excel file `R/quick-start/MyResults.xlsx`

FIGURE 7.2: ANOVA worksheet of Excel file R/quick-start/MyResults.xlsx

`RRRC`, `FRRC` and `RRFC` worksheets of Excel file `R/quick-start/MyResults.xlsx``RRRC`, `FRRC` and `RRFC` worksheets of Excel file `R/quick-start/MyResults.xlsx``RRRC`, `FRRC` and `RRFC` worksheets of Excel file `R/quick-start/MyResults.xlsx`

FIGURE 7.3: RRRC, FRRC and RRFC worksheets of Excel file R/quick-start/MyResults.xlsx

7.4 References