Create a Chart with Ranges and Lines for Statistics

The Stock Prices.jmp sample data table contains data for the dates and values of a stock over time. The variable YearWeek is a computed column representing the year and week in a single variable. Use a range chart to show the high, low, and average close values for each stock. For those weeks where data exists for multiple days, the average of the values is plotted.

Select Help > Sample Data Library and open Stock Prices.jmp.

Select Graph > Legacy > Chart.

Select YearWeek and click Categories, X, Levels.

Select High and click Statistics.

Select Max from the menu of statistics.

Select Low and click Statistics.

Select Min from the menu of statistics.

Select Close and click Statistics.

Select Mean from the menu of statistics.

10.

Click OK.

11.

Select Range Chart from the red triangle menu for Chart.

12.

In the legend, right-click Mean(Close) and select Connect Points.

Figure 14.19 Example of a Combined Range and Line Chart

The range for each date shows the highest and lowest values the stock reached during that week. The line shows the stock’s average closing price for that week.