The following Python script counts how often each type of car is in the list:
from networkx import * from operator import * from sets import Set F = read_edgelist("friendsAndCars.csv",delimiter=",",create_using=DiGraph()) a = [item[1] for item in sorted(F.edges(),key=itemgetter(1))] for item in Set(a): print item + "," + str(a.count(item))You can save this as countFreq.py and run it on the command-line using
python countFreq.py > CarsCounted.csv
Measures of central tendency and dispersion are functions in Excel. For example, AVERAGE(B1:B6) calculates the average (arithmetic mean) of the values in cells B1 to B6.
measure | formula |
---|---|
mode | MODE() |
median | MEDIAN() |
mean | AVERAGE() |
variance | VAR() |
standard deviation | STDEV() |
2) How can you interpret the data: what is the central value? Is this a normal distribution?
3) Produce a chart (diagram) of the data. In order to do this, you should highlight the data and then select the chart wizzard. You may want to create a label for each column first.