Home » Posts tagged 'Data'
Tag Archives: Data
R & R Commander basics
To load data from .rda file: Data –> Load data set…
To load data from other files: Data –> Import data… –> select the proper file type
To view a quick summary of the data:
- Statistics –> Summaries –> Active Data Set
- Statistics –> Summaries –> Numerical Summaries
Here you see the same descriptions as above, but you can change the variables you see. - Statistics –> Summaries –> Count Missing Observations
- Graphs –> Histogram (aka a bar graph)
- Graphs –> Boxplot
- Graphs –> Scatterplot (select only the Least Squares Line)
- Chi-square:
- Statistics –> Contingency Tables –> Two Way Tables
- T-tests
- Statistics –> Means –> Single Sample T-test
- Statistics –> Means –> Independent Samples T-test
- Statistics –> Means –> Paired T-test
- ANOVA
- Statistics –> Means –> One-way ANOVA
- Statistics –> Means –> Mutli-way ANOVA
To view your data in a graph:
Now you can use several tests to analyze and interpret your data:
For more information on Data Analysis tools, please visit The Commons Blog.
What to do if your data is an absolute mess… in Excel
Use the “Text to Columns” function! Let’s say this is your data:
Select the data you want to use…
For more information on Data Analysis tools, please visit The Commons Blog.
How to make calculations in Excel
- Average, Count, and Sum appear on the bottom of your window when you select 2 or more cells.
*Note: On a PC, all three show up in a row; on a Mac, you can choose which one to see with the down arrow for the drop-down menu. - To get the sum of a set of numbers: in a cell type:
=SUM(whatever cells or range of cells you need)
and press Enter - To get the mean or average of a set of numbers: in a cell type:
=AVERAGE(whatever cells or range of cells you need)
and press Enter - To raise a number to a degree (such as square it, cube it, etc): in a cell type:
=(the number or the cell you select)^(2)
and press Enter - To take a square root of a number: in a cell type:
=SQRT(the number or the cell you select)
and press Enter - To find the standard deviation of a dataset: in a cell type:
=STDEV(whatever cells or range of cells you need)
and press Enter
*Another note: if you need to make calculations on different cells, you can select one at a time using Ctrl click (Command click on Macs).
For more information on Data Analysis tools, please visit The Commons Blog.
How to sort and/or filter your data in Excel
If your data is a mess, you can easily sort in is ascending and descending order. You can also Filter it to show you only certain values. These two functions work both with numbers and text.
For more information on Data Analysis tools, please visit The Commons Blog.
