Analysis
MathJet runs several common analyses directly on chart data without requiring a script context-switch: live statistics in the status bar and in a floating window, customizable graph characteristics tables, curve fitting with trendlines, and dependent graphs derived from one or more source graphs.
Quick statistics
Section titled “Quick statistics”The status bar provides dynamic updates of essential statistical information about your current selection. For worksheets or data tables, it shows the count of selected rows and columns, along with the total and average values of numerical cells. For chart selections, it shows the number of selected graphs and data points and their total and average values.
The Quick Statistics window offers more comprehensive statistics. As a semi-transparent window floating over graphs, it’s effective for on-the-spot statistical analysis of data tables or charts. When there is no valid areal selection in a sheet or chart, the Quick Statistics window displays statistics for the entire table or chart in a lighter gray shade — providing broader context.
Graph characteristics
Section titled “Graph characteristics”The Graph Characteristics feature runs a comprehensive range of analyses and displays the results in a summary table right in the chart.
Select the graph or specific data points, then choose the appropriate range function from Data → Graph Characteristics. For each function you select, a new column appears to the right of the table, displaying the results. Selecting any row in the graph characteristics table highlights the corresponding graph or active data points. The table updates automatically whenever the source data changes (e.g., due to filtering or editing).
You can customize the Graph Characteristics table — add, delete, or modify function entries; reorder them; and define or change the data item ranges where these functions are applied. Open the customize dialog via Data → Graph Characteristics → Customize, or by double-clicking any column header.
Toggle visibility of the Graph Characteristics table via View → Chart Components → Graph Characteristics or the corresponding tool button.
Curve fitting
Section titled “Curve fitting”MathJet’s curve fitting feature creates models for either a section or the entirety of a graph and displays them as trendlines within the same chart.
To add a trendline, first select either specific data points or the entire graph. Then pick a model type from Data → Curve Fitting or the corresponding tool button. Available models include linear, polynomial, exponential, logarithmic, power, and moving average. Parameters are fitted using the original data, and the model is evaluated at the same x-coordinates. A new line graph representing the evaluated model is added to the chart and updates automatically when the source data changes.
After a trendline is added, you can modify its appearance like any regular line graph and adjust trendline-specific properties — number of periods for backward and forward forecasting, whether to display the equation and R² values, and others.
The Graph Companion Window is particularly useful for point-by-point comparison between original data points and values generated by the fitted model.
Dependent graphs
Section titled “Dependent graphs”The Dependent Graph function creates a new graph linked to one or more source graphs using either predefined or custom formulas.
Select the graphs or data points you’re interested in, then pick a function from the menu — or simply drag and drop one graph onto another and select an arithmetic operation from the Merge Graphs pop-up menu.
Most functions require just one source graph; some, like the difference function, need multiple source graphs.