Apparatus and method for forecasting qualitative assessments

Information

  • Patent Application
  • 20070282648
  • Publication Number
    20070282648
  • Date Filed
    May 31, 2006
    18 years ago
  • Date Published
    December 06, 2007
    17 years ago
Abstract
A computer-readable medium to direct a computer to function in a specified manner includes executable instructions to: generate a set of qualitative assessments; convert the set of qualitative assessments into a set of quantitative assessments; produce a quantitative forecast from the set of quantitative assessments; and translate the quantitative forecast to a qualitative forecast.
Description

BRIEF DESCRIPTION OF THE DRAWINGS

For a better understanding of the nature and objects of the invention, reference should be made to the following detailed description taken in conjunction with the accompanying drawings, in which:



FIG. 1 illustrates a computer that may be operated in accordance with an embodiment of the invention.



FIG. 2 illustrates processing operations performed in accordance with an embodiment of the invention.



FIG. 3 illustrates an exemplary set of qualitative assessments.



FIG. 4 illustrates an exemplary mapping for the set of qualitative assessments of FIG. 3.



FIG. 5 illustrates the application of the mapping of FIG. 4 to the qualitative assessments of FIG. 3.



FIG. 6 illustrates the results of the forecast made for the set of quantitative assessments of FIG. 5.



FIG. 7 illustrates the results of rounding the quantitative forecast of FIG. 6.



FIG. 8 illustrates the qualitative forecast converted from the quantitative forecast of FIG. 7.





DETAILED DESCRIPTION OF THE INVENTION


FIG. 1 illustrates a computer network 100 that may be operated in accordance with an embodiment of the invention. The computer network 100 includes a computer 102, which, in general, may be a client computer or a server computer. In the present embodiment of the invention, the computer 102 is a server computer including conventional server computer components. As shown in FIG. 1, the computer 102 includes a Central Processing Unit (“CPU”) 108 that is connected to a network connection device 104 and a set of input/output devices 106 (e.g., a keyboard, a mouse, a display, a printer, a speaker, and so forth) via a bus 110. The network connection device 104 is connected to network 126 through a network transport medium 124, which may be any wired or wireless transport medium.


The CPU 108 is also connected to a memory 112 via the bus 110. The memory 112 stores a set of executable programs. One executable program is the qualitative assessment generator 116. The qualitative assessment generator 116 includes executable instructions to access a data source to produce a set of qualitative assessments. A qualitative assessment is a representation of a qualitative business data value. A set of qualitative business records is a collection of qualitative business data values. The business data values may be recorded for one or more given variables at different periods over time. By way of example, the data source may be database 114 resident in memory 112. The data source may be located anywhere in the network 126.


As shown in FIG. 1, the memory 112 also contains a conversion module 118. The conversion module 118 enables bi-directional conversion between qualitative business records and quantitative business records. The conversion module 118 includes executable instructions to access a data source to convert a set of business data values. By way of example, the data source may be database 114 resident in memory 112. FIG. 1 also shows that memory 112 contains a forecast module 120. The forecast module 120 analyzes business data values to produce a forecast of future business records of an enterprise. In one embodiment of the invention, the forecast module 120 produces a qualitative forecast using the business data values generated by the conversion module 118 according to the processing operations illustrated in FIG. 2.


While the various components of memory 112 are shown residing in the single computer 102, it should be recognized that such a configuration is not required in all applications. For instance, the conversion module 118 may reside in a separate computer (not shown in FIG. 1) that is connected to the network 126. Similarly, separate modules of executable code are not required. The invention is directed toward the operations disclosed herein. There are any number of ways and locations to implement those operations, all of which should be considered within the scope of the invention.



FIG. 2 illustrates processing operations associated with an embodiment of the invention. The first processing operation shown in FIG. 2 is to generate a set of qualitative assessments 200. In one embodiment of the invention, this is implemented with executable code of the qualitative assessment generator 116. By way of example, the qualitative assessment generator 116 may generate a set of qualitative assessments for different variables recorded over a specified number of periods. For example, FIG. 3 illustrates a set of qualitative assessments 300 for strategic initiatives 302 recorded at various months. FIG. 3 also displays a legend 304 that correlates each qualitative business data value to a respective qualitative assessment (e.g. Very Good 306, Good 308, OK 310, Bad 312 and Very Bad 314) that may be defined by the user. Thus, a set of qualitative assessments characterizes various qualitative business data values over a specified number of periods. Similarly, a set of quantitative assessments characterizes various quantitative business data values over a specified number of periods.


As shown in FIG. 2, the next processing operation is to classify a mapping to the set of qualitative assessments 202. The conversion module 118 may provide a mapping that is to be applied to the set of qualitative assessments generated by the qualitative assessment generator 116. For instance, FIG. 4 illustrates a mapping 400 that is to be applied to the set of qualitative assessments 300 of FIG. 3. A quantitative value is attached to each qualitative assessment identified in the set of qualitative assessments. To illustrate, the qualitative assessment Very Good 306 was mapped to a quantitative value of 5 402. Any type of transformation may be used provided that the same transformation is used to re-transform the quantitative forecast data, subsequently produced, into qualitative assessments.


Returning to FIG. 2, the next processing operation is to convert the set of qualitative assessments into a set of quantitative assessments 204. The conversion module 118 may convert the set of qualitative assessments into quantitative assessments using the mapping provided by the conversion module 118. The mapping of quantitative assessments is applied to the qualitative assessments to produce converted values. For example, FIG. 5 illustrates the results 500 of applying the mapping 400 of FIG. 4 to the set of qualitative assessments 300 of FIG. 3. Each of the qualitative assessments in the set of qualitative assessments is assigned a quantitative assessment based on the defined mapping.


As shown in FIG. 2, the next processing operation is to produce a forecast for the set of quantitative assessments 206. The forecast module 120 produces a forecast for the set of quantitative assessments converted by the conversion module 118. The forecast module 120 may identify any exemplary patterns that are present in the set of quantitative assessments converted by the conversion module 118 to produce a forecast. By way of example, exemplary patterns that may be identified by the forecast module 118 include linear positive patterns, linear negative patterns, non-linear positive patterns, non-linear negative patterns, cyclical patterns, and random behavior patterns. These patterns can be identified using the techniques described in the commonly owned patent application entitled “Apparatus and Method for Identifying Patterns in a Multi-Dimensional Database”, Ser. No. 10/113,917, filed Mar. 28, 2002.


Various statistical tests may also be applied. For example, the invention may be implemented using Runs Test, a Mean Successive Squared Difference Test, an Autocorrelation Test, a Tukey Test, a Variance Test, or a Regression Analysis.



FIG. 6 illustrates the results of the forecast made for the set of quantitative assessments 600 of FIG. 5. The forecast module 120 employed a linear regression to forecast business records for the months of July 602, August 604, and September 606. Nonetheless, those skilled in the art will appreciate that various forecasting algorithms may be used, each of which should be considered within the scope of the invention.


Returning to FIG. 2, the next processing operation is to round the forecasted quantitative assessments to integer values 208, according to the mapping used in the example. In one embodiment of the invention, the conversion module 118 may round the forecasted quantitative business data values produced by the forecast module 118 to the nearest integer value. For instance, FIG. 7 illustrates the results of rounding the forecasted business data values 700 of FIG. 6 for the months of July 602, August, 604, and September 606. In this example, each quantitative business data value is rounded to the nearest integer. The rounding will reflect the mapping chosen for the qualitative to quantitative conversion.


The last processing operation shown in FIG. 2 is to translate the quantitative forecast to a qualitative forecast 210. The conversion module 118 may use the mapping provided earlier to convert the rounded quantitative forecast into a qualitative forecast. For example, FIG. 8 illustrates the forecasted qualitative assessments 800 converted from the rounded forecasted quantitative assessments 700 of FIG. 7, along with the previously recorded set of qualitative assessments 300. The user may now view a forecast made for a set of recorded qualitative assessments. The forecast may be used to predict future business performance. Ultimately, this enables the user to structure business actions or responses in conjunction with the forecasted data.


An embodiment of the present invention relates to a computer storage product with a computer-readable medium having computer code thereon for performing various computer-implemented operations. The media and computer code may be those specially designed and constructed for the purposes of the present invention, or they may be of the kind well known and available to those having skill in the computer software arts. Examples of computer-readable media include, but are not limited to: magnetic media such as hard disks, floppy disks, and magnetic tape; optical media such as CD-ROMs, DVDs and holographic devices; magneto-optical media; and hardware devices that are specially configured to store and execute program code, such as application-specific integrated circuits (“ASICs”), programmable logic devices (“PLDs”) and ROM and RAM devices. Examples of computer code include machine code, such as produced by a compiler, and files containing higher level code that are executed by a computer using an interpreter. For example, an embodiment of the invention may be implemented using Java, C++, or other object-oriented programming language and development tools. Another embodiment of the invention may be implemented in hardwired circuitry in place of, or in combination with, machine-executable software instructions.


While the present invention has been described with reference to the specific embodiments thereof, it should be understood by those skilled in the art that various changes may be made and equivalents may be substituted without departing from the true spirit and scope of the invention as defined by the appended claims. In addition, many modifications may be made to adapt to a particular situation, material, composition of matter, method, process step or steps, to the objective, spirit and scope of the present invention. All such modifications are intended to be within the scope of the claims appended hereto. In particular, while the methods disclosed herein have been described with reference to particular steps performed in a particular order, it will be understood that these steps may be combined, sub-divided, or re-ordered to form an equivalent method without departing from the teachings of the present invention. Accordingly, unless specifically indicated herein, the order and grouping of the steps is not a limitation of the present invention.

Claims
  • 1. A computer-readable medium to direct a computer to function in a specified manner, comprising executable instructions to: generate a set of qualitative assessments;convert the set of qualitative assessments to a set of quantitative assessments;produce a quantitative forecast from the set of quantitative assessments; andtranslate the quantitative forecast to a qualitative forecast.
  • 2. The computer-readable medium of claim 1, wherein the executable instructions to convert include executable instructions to establish a mapping to the set of qualitative assessments.
  • 3. The computer-readable medium of claim 2, wherein the executable instructions to establish include executable instructions to accept a user defined mapping.
  • 4. The computer-readable medium of claim 2, wherein the executable instructions to produce include executable instructions to identify at least one of a linear pattern, a non-linear pattern, an outlier pattern, a cyclical pattern, and a random pattern.
  • 5. The computer-readable medium of claim 4, wherein the executable instructions to identify include executable instructions to apply a statistical test.
  • 6. The computer-readable medium of claim 5, wherein the statistical test is selected from a Runs Test, a Mean Successive Squared Difference Test, an Autocorrelation Test, a Tukey Test, a Variance Test, and a Regression Analysis.
  • 7. The computer-readable medium of claim 6, wherein the executable instructions to translate include executable instructions to round the quantitative forecast.
  • 8. The computer-readable medium of claim 1, further comprising executable instructions to present forecast results.
  • 9. A computer implemented method of processing data, comprising: generating a set of qualitative assessments;converting the set of qualitative assessments to a set of quantitative assessments;producing a quantitative forecast from the set of quantitative assessments; andtranslating the quantitative forecast to a qualitative forecast.
  • 10. The method of claim 9, wherein converting includes establishing a mapping to the set of qualitative assessments.
  • 11. The method of claim 10, wherein establishing includes accepting a user defined mapping.
  • 12. The method of claim 11, wherein producing includes identifying at least one of a linear pattern, a non-linear pattern, an outlier pattern, a cyclical pattern, and a random pattern.
  • 13. The method of claim 12, wherein identifying includes applying a statistical test.
  • 14. The method of claim 13, wherein the statistical test is selected from a Runs Test, a Mean Successive Squared Difference Test, an Autocorrelation Test, a Tukey Test, a Variance Test, and a Regression Analysis.
  • 15. The method of claim 9, wherein translating includes rounding the quantitative forecast.
  • 16. The method of claim 9, further comprising presenting forecast results.