VTools worksheet menu

<< Click on a menu item to jump to that topic.

VTools --> Plot

When you click Plot, Chart Setup dialog box appears.

Plot --> Input

Here you see the Input tab of the Chart Setup dialog.

Default date range is the currently selected range on the active worksheet.

VTools supports four different data layouts:

Data Columns:
Each column contains a separate data set.

Example: Defects by shift are logged as shown here.

Data and Code Column:

Only two columns are selected and one of them is a code/category column.

Example: Defects by shift are logged as shown here.

1st code and 2..n data columns:

Same as above except there are multiple data columns.

Example: Various defects by shift are logged as shown here.

1..(n-1) code columns and nth data column:

In this case, there are multiple code columns and a single data column.

Example:

Plot --> Output

Following shows output tab of the Chart Setup dialog.

Most of the potions here are self-explanatory, except may be Box and Whisker.

The Box of the Box-Plot represents 25th, 50th, and 75th percentiles.

• Upper Whisker: = Min (Max(data), 1.5 * IQR)
• Lower Whisker: = Max (Min(data), 1.5 * IQR)

IQR := InterQuartile Range (75% - 25%)

On the Box & Whisker Graph (Box Plot) asterisk indicates Average

Plot --> Options

Following shows Options tab of the Chart Setup dialog.

StatBox adds a textbox on the chart and displays selected statistics.

• n: Total number of data points
• xx%: xxth percentile value
• IQR: 75th percentile – 25th percentile
• P (Anova/t-Test): result of Anova or t-test (two tailed assuming equal variance)
• P (Levene/F-Test): result of Levene’s Test or F-test (two tailed)
• Note: VTools uses modified Levene’s test (using medians)
• P (Kruskal-Wallis): result of the Kruskal-Wallis test
  

Outlier elimination: The drop down list lists two methods for outlier elimination. The outlier eliminated data is used ONLY for P-Value calculation.

• 3 Sigma: Data outside of Average ± 3 Sigma is eliminated.
• 1.5 IQR: Data greater than 75th % + 1.5 (75th % - 25th %) and less than 25th % - 1.5 (75th % - 25th %) is eliminated.

Save as Default: Current Input, Output, and Options setting are saved as default and will be loaded every time chart dialog is displayed.

VTools --> Options

Following dialog appears when you select Options from the VTools menu.

Options --> General

First three checkboxes in the General tab are self-explanatory.

Number Format: Here you specify number format used in the StatBox. Note: P-values use fixed number format of ‘0.000’

Options --> Chart

Following shows the Chart tab.

Left three text boxes specify default chart title for the respective charts. (This can be over-ridden by the value from Chart Setup dialog’s Options tab. )

Right three text boxes allow you to customize each chart using your own macro.

VTools --> Cleanup

VTools --> Reset UI

Use this option to reset User Interface after VTools crash (which hardly ever happens ;-) )

VTools Chart menu

Click on a menu item to jump to that topic.

VTools --> Stat Box

Selecting StatBox, brings up the following dialog box.

Please see the ‘Chart Setup’ dialog explanation above for StatBox parameter help. Other buttons let you format indicated properties.

VTools --> My Style

Fill and line properties: StatBox & Plot Area
Font properties: Chart Title, Axis Titles, Tickmark Labels, and Legend
Gridlines: Gridlines on/off and line color, weight and type are saved for the given chart type.

These properties can be applied to all new graphs by checking the "user My Style" option in the chart setup dialog box.

VTools --> My Style -->Apply: Clicking this will apply saved 'My Style' properties to the active chart.

VTools --> Data Labels

Check needed checkboxes and those values will be displayed on the graph.

VTools --> Toggle Outliers

This will toggle outlier display on the box plot. (available only while on graph sheet with VTools Box Plot)

VTools --> Fix It

For Box Plot

- Fixes labels' position after changing Y axis min/max

- Matches color of the outliers with that of the associated box

For Normal Probability Plot

- Fixes labels' position & grid after changing X axis min/max

Tips:

• Remember: You can select data before opening 'Plot' dialog box of VTools.


• Use 'Fix it' from VTools chart menu to correct various label alignment issues on charts created by VTools.


• In excel, Dates are stored internally as Numbers; it is the cell formatting that makes it look like Date/Time.
  For this reason, using date/time in VTools produces undesirable results. You should convert your date/time column to text before using it in VTools.
  Following example shows how to convert date/time data to string in excel.

  =TEXT(B2,"mm/dd/yyyy hh:mm AM/PM")

• VTools creates a hidden sheet for each VTools graph. After you delete one of these graphs, its associated sheet becomes useless. Use 'Cleanup' from VTools menu to delete these orphaned sheets.


• After selecting your data range, clicking the 'VTools' chart menu while holding down the shift key will bypass the chart setup dialog box and create chart(s) using your default settings.


• Clicking "Reset UI" fixes user interface after VTools crash.

Notes:

ANOVA/t-Test:

• H0 : µ1 = µ2 = … = µn
• Assumptions: (1) Approximately normally distributed data. (2)Equal variance.
• Note: t-Test (two tailed) assuming equal variance will be done if n = 2.
  

Levene/F-Test:

• H0: s1^2 = s2^2 = … = sn^2
• Note: VTools uses modified Levene's test.
• Note: F-Test (two tailed) will be done if n = 2

K-W (Kruskal-Wallis):

• Ho: all n distribution functions are equal
• Note: This is a nonparametric test since the data is rank transformed.