Some business are open seven days a week and have their heaviest volumes on weekends. Others are open only Monday through Friday and may have a fairly even volumne of business throughout the week. Unusual patterns can sometimes be obtained by comparing the occurence of transactions on each day of the week between groups or parts of the population and that of the overall population.

An example of the report is available.

To perform such a test and have the results available in electronic work paper format, the following processing information is explained below:

Description Value Select Specify 'OK' to have this row processed, otherwise it will be skipped Data Source Specify the name of the Excel workbook, including directory or the name of the Access database which has the data to be analyzed Command Name patternWD Command Description Obtain an analysis of the entire population using Federal holiday dates and then compare that with an analysis of each group or sub-population Table Must enter either a sheet name followed by $ or else enter an Access table name Where An optional row selection statement may be made to narrow the analysis to just certain rows Column N/A Column String The name of sort key column, followed by the name of the date column to be tested Parm1 The format of the date, e.g. mdy for month day year, dmy for day month year parm2 N/A Theme N/A procedure does not produce a chart Title N/A procedure does not produce a chart   Return to electronic work paper home page