Fwd: help with data entry

21 views
Skip to first unread message

Pedro Valero

unread,
Sep 5, 2011, 5:38:35 AM9/5/11
to visual-s...@googlegroups.com, sailo...@hotmail.com
I am forwarding your message to the list of users.

---------- Forwarded message ----------
From: yuyang cai <sailo...@hotmail.com>
Date: 2011/9/5
Subject: help with data entry
To: Pedro.Va...@uv.es


Dear Professor Pedro M. Valero Mora,
 
I am a starter of the VisTa, having been trying hard to enter my data to VisTa through text or excel files. I spent two days already on it, yet failed! Rather frustrated!
 
Can you kindly provide any steps easier to follow?
 
Sincerely

CAI Yuyang
 
PHD Candidate
 
Faculty of Education
 
The Unviersity of Hong Kong


Frank

unread,
Sep 19, 2011, 12:52:43 PM9/19/11
to Visual Statistics
Hi,

Look at the file structure of the files to import at "C:\Program Files
\ViSta 7\ViSta 7.9.2.5\data\import"

A standard file structure is variables by cases. It can be imported as
an ascii text with a structure like
City Work Price Salary
Labels Numeric Numeric Numeric
Amsterdam 1714 65.6 49
Athens 1792 53.8 30.4
Bogota 2152 37.9 11.5
Bombay 2052 30.3 5.3
Brussels 1708 73.8 50.5
Buenos_Aires 1971 56.1 12.5
Cairo nil 37.1 nil

The specific of Vista is to have a second line which defines the
varable type. Here the types are : labels and numeric.
There are more complicated file structures possible which are
explained in the book.

Missing data have to be coded as nil.

You can also start ViSta from Excel but I don't use Excel so I cannot
dell you how this works.

HTH
Frank Thomas
Reply all
Reply to author
Forward
0 new messages