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 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.
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.