T O P I C R E V I E W |
avitale |
Posted - 10/04/2012 : 11:47:06 AM Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 8 SRO 8.0724 Operating System: Windows 7
Hello. I am a graduate student, and I'm new to using Origin Pro. I have, like a lot of people, been using Excel for most applications for the majority of my work, but my advisor wants me to get proficient using Origin for our research. I've been working with it for a few day and just have some small simple questions I figured I'd throw in here when they arise. The questions are really simple, but even so I'm finding some difficulty in figuring these out.
First, how do I do a simple Average (mean) a block of cells? I have cells in column C from 2 to 11. In Excel, I'd just click the cell I want the average in and type something like =AVERAGE(C2:C11).
Second, when making a simple scatter plot, do I have to have my data for Axes in succession in a column? Say I have this data:
X1A Y1A X2A Y2A X3A Y3A X1B Y1B X2B Y2B X3B Y3B X1C Y1C X2C Y2C X3C Y3C
I want to plot the points (X1A,Y1A) (X1B,Y1B) (X1C,Y1C), is this possible? Looking at the "Plot Setup" menu, it looks like axis data has to be data in succession.
Graduate Student |
1 L A T E S T R E P L I E S (Newest First) |
greg |
Posted - 10/05/2012 : 4:38:11 PM FIRST With a block of text selected, choose Statistics : Descriptive Statistics : Statistics on Columns. For Input Data, select "Combined as Single dataset" to get stats for all, otherwise you get a column breakdown.
A quicker way that involves some special syntax is to open the command window and type: stats (startcol[startrow]:endcol[endrow]) and press enter. For example: stats (1[5]:4[20]) will report stats for column 1 thru 4, rows 5 thru 20.
SECOND If your column designations are correct (X1A etc is an X column and Y1A is a Y column) then you can use Ctrl+selection to grab just Y1A Y1B Y1C then select your Plot type from the menu |
|
|