Part 2. MM4XL Tools > 3. Charts and Maps > Benchmark > How to Run Benchmark Analysis

Benchmark Analysis

How to Run Benchmark Analysis

Tip:
It's easy to get up to speed with MM4XL in a matter of seconds:

  1. Select the MM4XL tool you want to work with from the toolbar.
  2. Click the Example button on the form. This opens an example sheet with data for the tool you are using.
  3. With your mouse, select the data sets as explained in the example sheet, then click the OK button to print the report.

In the floating toolbar, click on the Benchmark Analysis button shown here:

Benchmark Business Performance vs Market Share Growth Software

The window below appears. Select with the mouse the ranges in the sheet where the data are stored, click on the OK button and the chart is drawn. That's it.

Benchmark Business Performance vs Market Share Growth Software

Typically, the fields Product growth and Market growth are filled with percentages, but also other scales of measurement can return meaningful maps. It is important that both variables are measured with the same scale, for instance, both in percentage or both in thousands. Growth values can be found, for instance, dividing sales value of this year by the sales value of last year.

The size of the bubbles range tells MM4XL how large each bubble should be, one can use, for instance, a vector of sales values here. Alternatively, select one of the three options in the list box immediately below the field Bubble size.

The Labels range attaches a text label to each bubble and the field Bubble color is used for assigning different colors to bubbles. Alternatively, select one of the three options in the list box immediately below the field Bubble color.

Finally, the Output range address tells MM4XL where to place the map on the sheet.

In the example we make here the selected ranges have a column label in the first cell (see table below), so the option Labels in first row was checked.

The frame Report hosts controls for printing selected sections of the analysis. Read more about Report content later in the section Anatomy of a Report. The frame Confidence interval hosts 2 text boxes used for telling MM4XL where to place the boundaries around the main diagonal that sorts out growing products from stable and declining ones. The confidence region is where product versus market growth is not broad enough to identify a gain or loss of market share. Input a zero in the two boxes if you want to get rid of confidence boundaries and work with the main diagonal only.

The lower left button opens the Help online, while the button Example opens an Excel sheet with data, an example of analysis, and an explanation of how to make field selections. Click on the OK button once you have made your selection and the chart is made for you.

Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: