|Labeling graphics in Ms Word - the Nile Delta|
|Extracting data from Flexidata .. taken from Year 10 Shopping Journeys advice|
data from the computer
up Flexidata 2
choose Load a datafile
this point on you will have to choose the data you need, by
asking the computer questions.
most useful outputs:
get averages of any one field .. for us this will be
on the top menu .. insert,
then choose statistics.
Click on the field you want the statistics for, say local
shop distance .. a green box of data is shown with a red
surround (you can get rid of this box by right-clicking it
and then selecting delete)
really good feature can be found by choosing insert
from the top menu , then select graph
and then scattergram
from the drop-down-menu.
should select the first field you want .. which should be home
village as the villagesí names have been cut
down to make them fit on a page! The other field, such as supermarket
should then be selected.
l What you get is a matrix of the numbers going from each home location to each supermarket, in an easily understood format. From here you can obtain the data to draw the graphs you need!
select the statistics for any one place, either a village,
town or supermarket.:
to format, then select query
and then Start a new query
.. such as this one-
l Select home location and select one, say, Capel in the value box by typing in its name; then choose another field, say Tesco Copdock Mill. This will give you all the records from people who live in Capel and shop at Tesco Copdock Mill.
Just select Capel, as an example, then say OK. You will now have all the records for people from Capel. You can now go to insert, then choose statistics. Select one of the four distances on offer and then click OK. The resulting box will have the average distance to all supermarkets by all people in Capel. This figure could be compared with other villages.