Welcome to the JMP User Community!

Latest Discussions

• How do I Import data from a large number (>100) of excel files, each containing a number of worksheets/tabs, into one JMP file.

  I need to import (into JMP) specific Excel worksheets from a number of excel files and the data in the JMP file must be stacked with a ID column specifying the file origin.The Excel import wizard makes it relatively easy to import and stack two or more selected worksheets from a single file (see script below). The data is structured similarly in the different worksheets.If possible I need to impor...

  hhi

  Discussions |

  Aug 4, 2023 3:04 AM

  2622 views | 5 replies

• Rolling and Expanding window forecast in 17

  Is there a function in J17 to automate multiple rolling window forecasts for time series and include forecast errors MSE,MAE,etc.

  ParametricSteer

  Discussions |

  Aug 4, 2023 1:05 AM

  712 views | 0 replies

• Using Graph Builder is it possible to manually move reported Means and St Devs?

  Using Graph builder I'm struggling to make graphs that list the mean and standard deviations of box plots. I discovered I could use the boxplot & Line of Fit to report the means and stardard devs next to each factor, but the reported numbers are oddly positioned. I was hoping there would be a way to simply manually move these values on the graph so that the overall graph looks better. Is there a w...

  ndowidar

  Discussions |

  Aug 3, 2023 5:31 PM

  1052 views | 1 replies

• Associative Array - splitting keys

  Hi, I've a data table, looks something like this. I want to split each test and assign % values.  I am trying to create an Associative Array and allocate values to each tests but the results are incorrect. I am not sure what I missed The final associative array should contain the following.new_aa = [" Currents_A" => 0.003 " Currents_B" => 0.003, " Currents_C" => 0.003, "Volts_A" => 0.003, "Votls_B...

  Jackie_

  Discussions |

  Aug 3, 2023 2:57 PM

  1262 views | 2 replies

• How to Center Data over a Character Based Column on the X-Axis

  Hey there! I've got an issue with visualizing data in Graph Builder (JMP16). Graph builder automatically orders my Box Plot data by entry rather than wanting to center it over the corresponding label. Similarly, if I plot by Point, the points are stretched out in X instead aligning on a single vertical line above the corresponding label. Any idea how I'd encourage JMP to center that data? Box Plot...

  BatteryTamer359

  Discussions |

  Aug 3, 2023 10:10 AM

  1837 views | 3 replies