OriginLab Corporation - Scientific Graphing and Data Analysis Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis

Quick Start


To use the Set Values dialog to generate data for a column, simply input expressions in the Column Formula and/or Before Formula Scripts and then click the Apply button( or the OK button) to set the column values.

Image:SetValuesPanelNew.png

The following short tutorial will show you how to use this dialog to generate data for a simulated gaussian curve.

  1. Create a new workbook by clicking the New Workbook button Image:New Workbook.png on the Standard toolbar.
  2. Highlight column A and right-click on it to select Set Column Values from the short-cut menu to open the Set Values dialog.
  3. Enter {-1:0.03:5} in the Column Formula edit box and then click the Apply button. Column A should be filled with a series of numbers.
  4. Then we will use the one of the navigation buttons to let you input an expression for the second column without closing the dialog. Click the Next button Image:Next Button.png. You will see that column B is highlighted in the worksheet.
  5. Now enter 1 + (5/(1.5*sqrt(PI/2)))*exp(-2*((col(a)-2)/1.5)^2) in the Column Formula edit box and click the OK button. The Set Values dialog is closed. You will see the results in the following worksheet. (If you create a line graph of column B, you will get a graph similar to the one next to the workbook.)
Image:Quick_Start_SetColumnValues_1.png