In spite of the fact that there are locks on the columns, the worksheet can be rearranged by highlighting the desired column, going to the Menu Bar, selecting Worksheet:Sort Worksheet, and selecting Ascending, Descending, or Custom from there.Ĭalculating Descriptive Statistics on Grouped Dataīasic statistical treatments can be performed on the data in individual columns using the Statistics on Columns tool.

The resultant worksheet DiscretFreq1 displays data and its counts for automobile Year and Make, respectively.To make operation in the source data worksheet Controlling the Categorical Values section working, change the Sort Data By to Categorical Order. From the Menu Bar, select Statistics: Descriptive Statistics: Discrete Frequency. Highlight the first two columns in the automobile worksheet.From the Menu Bar select Data: Import from File: SingleASCII: Statistics|automobile.dat. We will use the Discrete Frequency tool to quickly obtain frequency information for groups of data. Minimum Origin Version Required: Origin 2015 SR0 Finding Frequency Information for Groups Analyze data sets with the Correlation Coefficient Tool.Sort worksheet data by the attribute values in a designated column.Copy statistical results to a new worksheet for further processing.Use the Statistics on Column dialog to calculate descriptive statistics for grouped data.In addition to strong plotting features, Origin's statistical tools help you summarize and analyze your data. Origin provides comprehensive Descriptive Statistics support including basic statistics (mean, median, variance, etc.), frequency counts, and correlation coefficients of your data sets. 6 Analyzing the Relationship Between Different Indicators.5 Using Statistical Results for Further Operations.4 Calculating Descriptive Statistics on Grouped Data.3 Finding Frequency Information for Groups.

Descriptive statistical calculations