Excel data file

Excel datasets, with their data correctly formatted, can be specified directly to Facets.

Data= Exceldata.xls

Dvalues= is useful for constant values in the data

 

Excel-format data files.

Excel worksheets, with their data correctly formatted, can be specified directly to Facets.

Data = Excel filename.xls

Data = Creativity.xls

or, if the data worksheet is not the first worksheet, usually Sheet,

Data = Excel filename.xls(sheet number)

Data = Creativity.xls(2)

 

Dvalues= is useful for constant values in the data

 

Facets analyzes integer data in the range 0-255. Excel is a good means of reformatting your data, if necessary.

 

(a) Set up the Excel spreadsheet as follows:

 

Imagine a three-facet situation: judges, examinees and items.

 

In Row 1, put ;judge - the semi-colon is so that Facets will treat this as a comment. Then examinees and items

 

If you see:

First active data line is

judge examinee items ratings   

             Processed as judge, examinee, items, ratings, ,,

>Check (2)? Invalid datum location R0,0,0,0, in line 1. Datum "" is too big or not a positive integer, treated as missing.

Then change "judge" to ";judge" to make the heading row a comment for Facets.

 

In column A, put the judge number

 

In column B, put the examinee number

 

Either:

In column C, put the item number range as a character constant, e.g., 1-5

to enter this as text, type: '1-5 , i.e., apostrophe 1-5

If this doesn't work,
type 1-5a the "a" will be ignored by Facets

or
type 1_5 an underline can be used instead of a minus sign.

 

In columns D-H put the judges' ratings of the examinee on items 1,2,3,4,5
Entries beyond column H will be ignored.

 

Or:

Alternatively, put the judge number in columns A, the examinee number in column B, include in the specifications:

Dvalues = 3, 1-5  ; place 1-5 in data facet 3

and in columns C-G put the judges' ratings of the examinee on items 1,2,3,4,5

 

Here is what this looks like for the Creativity data. It is in a file called Creativity.xls.

 

 

Columns to the right of the data are usually ignored by Facets.

 

(b) Specify this Excel worksheet directly with the Data=

Data = Creativity.xls

 

or, particularly if Windows reports "Low memory" or "Out of memory",

 

Use "save as" CSV (Comma-delimited) (*.csv) to obtain a file in the Data= format, e.g, creativity.csv

 

;examinee,;judge,items,ratings,,,,

1,1,1-5,5,5,3,5,3

2,1,1-5,9,7,5,8,5

3,1,1-5,3,3,3,7,1

4,1,1-5,7,3,1,3,3

5,1,1-5,9,7,7,8,5

6,1,1-5,3,5,3,5,1

7,1,1-5,7,7,5,5,5

1,2,1-5,6,5,4,6,3

2,2,1-5,8,7,5,7,2

3,2,1-5,4,5,3,6,6

4,2,1-5,5,6,4,5,5

5,2,1-5,2,4,3,2,3

6,2,1-5,4,4,6,4,2

7,2,1-5,3,3,5,5,4

1,3,1-5,5,5,5,7,3

2,3,1-5,7,7,5,7,5

3,3,1-5,3,5,5,5,5

4,3,1-5,5,3,3,3,1

5,3,1-5,9,7,7,7,7

6,3,1-5,3,3,3,5,3

7,3,1-5,7,7,7,5,7

 

c) For the specifications, set up an outline skeleton of the specification file:

 

Title="Creativity using Excel"

Facets=3

Positive=1,2,3

Noncenter=1

Model=?,?,?,R9

Labels=Build  ; this will tell Facets to build a list of elements

1,Judges

*

2,Examinees

*

3,Items

1=Attack

2=Basis

3=Clarity

4=Daring

5=Enthusiasm

*

Data=creativity.xls

 

d)  Save your specification file as Cspec.txt and analyze it with Facets.

 

The output reports:

 

Table 2. Data Summary Report.

....

This list is generated by Labels=Build. Please copy and paste into your specification file, where needed

Labels=

 1, Judges,   ; facet 1

 1 =

 2 =

 3 =

 *

 2, Examinees,   ; facet 2

 1 =

 2 =

 3 =

 4 =

 5 =

 6 =

 7 =

 *

 

e) Open Cspec.txt and paste the extra element numbers into the Labels=list

 

Labels=

 1, Judges,   ; facet 1

 1 =

 2 =

 3 =

 *

 2, Examinees,   ; facet 2

 1 =

 2 =

 3 =

 4 =

 5 =

 6 =

 7 =

 *

3,Items

1=Attack

2=Basis

3=Clarity

4=Daring

5=Enthusiasm

*

 

f) Save your revised Cspec.txt specification file, and analyze it with Facets.

The analysis should report correctly.

 

g) If the data appear to be incorrect, verify that Facets has imported your Excel datasheet correctly, look at the temporary "Data =" file in the Edit pull-down menu.

 


Help for Facets Rasch Measurement Software: www.winsteps.com Author: John Michael Linacre.
 

For more information, contact info@winsteps.com or use the Contact Form
 

Facets Rasch measurement software. Buy for $149. & site licenses. Freeware student/evaluation download
Winsteps Rasch measurement software. Buy for $149. & site licenses. Freeware student/evaluation download

State-of-the-art : single-user and site licenses : free student/evaluation versions : download immediately : instructional PDFs : user forum : assistance by email : bugs fixed fast : free update eligibility : backwards compatible : money back if not satisfied
 
Rasch, Winsteps, Facets online Tutorials

 

Forum Rasch Measurement Forum to discuss any Rasch-related topic

Click here to add your email address to the Winsteps and Facets email list for notifications.

Click here to ask a question or make a suggestion about Winsteps and Facets software.

Rasch Publications
Rasch Measurement Transactions (free, online) Rasch Measurement research papers (free, online) Probabilistic Models for Some Intelligence and Attainment Tests, Georg Rasch Applying the Rasch Model 3rd. Ed., Bond & Fox Best Test Design, Wright & Stone
Rating Scale Analysis, Wright & Masters Introduction to Rasch Measurement, E. Smith & R. Smith Introduction to Many-Facet Rasch Measurement, Thomas Eckes Invariant Measurement with Raters and Rating Scales: Rasch Models for Rater-Mediated Assessments, George Engelhard, Jr. & Stefanie Wind Statistical Analyses for Language Testers, Rita Green
Rasch Models: Foundations, Recent Developments, and Applications, Fischer & Molenaar Journal of Applied Measurement Rasch models for measurement, David Andrich Constructing Measures, Mark Wilson Rasch Analysis in the Human Sciences, Boone, Stave, Yale
in Spanish: Análisis de Rasch para todos, Agustín Tristán Mediciones, Posicionamientos y Diagnósticos Competitivos, Juan Ramón Oreja Rodríguez
Winsteps Tutorials Facets Tutorials Rasch Discussion Groups

 

Coming Rasch-related Events
Jan. 5 - Feb. 2, 2018, Fri.-Fri. On-line workshop: Practical Rasch Measurement - Core Topics (E. Smith, Winsteps), www.statistics.com
Jan. 10-16, 2018, Wed.-Tues. In-person workshop: Advanced Course in Rasch Measurement Theory and the application of RUMM2030, Perth, Australia (D. Andrich), Announcement
Jan. 17-19, 2018, Wed.-Fri. Rasch Conference: Seventh International Conference on Probabilistic Models for Measurement, Matilda Bay Club, Perth, Australia, Website
Jan. 22-24, 2018, Mon-Wed. In-person workshop: Rasch Measurement for Everybody en español (A. Tristan, Winsteps), San Luis Potosi, Mexico. www.ieia.com.mx
April 10-12, 2018, Tues.-Thurs. Rasch Conference: IOMW, New York, NY, www.iomw.org
April 13-17, 2018, Fri.-Tues. AERA, New York, NY, www.aera.net
May 22 - 24, 2018, Tues.-Thur. EALTA 2018 pre-conference workshop (Introduction to Rasch measurement using WINSTEPS and FACETS, Thomas Eckes & Frank Weiss-Motz), https://ealta2018.testdaf.de
May 25 - June 22, 2018, Fri.-Fri. On-line workshop: Practical Rasch Measurement - Core Topics (E. Smith, Winsteps), www.statistics.com
June 27 - 29, 2018, Wed.-Fri. Measurement at the Crossroads: History, philosophy and sociology of measurement, Paris, France., https://measurement2018.sciencesconf.org
June 29 - July 27, 2018, Fri.-Fri. On-line workshop: Practical Rasch Measurement - Further Topics (E. Smith, Winsteps), www.statistics.com
July 25 - July 27, 2018, Wed.-Fri. Pacific-Rim Objective Measurement Symposium (PROMS), (Preconference workshops July 23-24, 2018) Fudan University, Shanghai, China "Applying Rasch Measurement in Language Assessment and across the Human Sciences" www.promsociety.org
Aug. 10 - Sept. 7, 2018, Fri.-Fri. On-line workshop: Many-Facet Rasch Measurement (E. Smith, Facets), www.statistics.com
Sept. 3 - 6, 2018, Mon.-Thurs. IMEKO World Congress, Belfast, Northern Ireland www.imeko2018.org
Oct. 12 - Nov. 9, 2018, Fri.-Fri. On-line workshop: Practical Rasch Measurement - Core Topics (E. Smith, Winsteps), www.statistics.com

 

Our current URL is www.winsteps.com

Winsteps® is a registered trademark
 

Concerned about aches, pains, youthfulness? Mike and Jenny suggest Liquid Biocell