Mean, Median, Variance and Standard Deviation
Plotly has built in statistical tools to help you analyze data with only a few clicks.
We’re set up for both descriptive and inferential statistics, so whether you’re looking to plot a graph with error bars (see our awesome tutorial here or do a simple statistical analysis of the ages of Nobel Prize winners, you’ve come to the right place.
Our statistics tool computes the minimum and maximum values, mean, median, quartiles, standard deviation, variance and standard error. The data in this tutorial comes from http://www.nber.org/nobel/, which was used by Jones and Weinberg in their paper “Age dynamics in scientific creativity”.
Step 1 : Set up the grid
You can load data into Plotly by typing directly, cutting & pasting or importing data from an external source. If you need help, our tutorial Add Data to Plotly’s Grid is the perfect place to start.
|In this example, we’ve loaded all the Nobel Prize winners in medicine, physics and chemistry, their birth years, and computed their age when they won their award. Copy the data here: https://plot.ly/~mariahh/8/|
Step 2: Running basic statistics
Plotly has both descriptive and inferential statistical tools. For our example we’re interested in quantitative features to describe our data set. This is exactly what descriptive statistics does. On the other hand, if you want to use a sample data set to make predictions about a larger population, inferential statistics is the tool you’ll want to use.
|Select “Basic statistics” from the ANALYSIS menu.|
|Two things happen. First, a STATISTICS box opens on the left of the browser window. We have two choices: “Inferential (N-1)” or “Descriptive”. “Inferential (N-1)” is the default, so we’ve had to change our choice to “Descriptive”.|
|Second, notice that the grid lets you choose which columns you want to use for statistics. We’ve only selected Column 5, containing the age data, but Plotly can also run statistics on multiple columns.|
|Finally, click the blue STATISTICS button in the sidebar.|
|The statistics now shows in the grid, just to the right of your last column.Some insights: the average (mean) age of a Nobel Prize winner is almost 56 years old. Half of all Nobel Prize winners were between the ages of 47 and 64 when they received the prize (Q1 and Q3). The youngest winner (min) — Lawrence Bragg — was 25 years old.|