QC 1:
Check the number of cases within each group (i.e. treatment and control group).
Q2:
Check if the number of treatment school and control school is balanced within block.
SQL: where x like "Ohio"
How to find a row based on a string variable:
where x like "Ohio"
http://stackoverflow.com/questions/515039/use-or-like-to-compare-strings-in-sql
The ASA's statement on p-values: context, process, and purpose
Counting how many times does a string occur in a variable
COUNTING=count(award_info,"SP");
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002260230.htm
Creating Sequence Values per ID
How to filter Excel data
Put the whole data into TABLE:
How to convert a Rasch score (or any score) into a 1 to 10 scale
Excel function that produces "True" or "False"
https://exceljet.net/excel-functions/excel-true-function
I tried this myself and it worked. If column C2 and D2 contain the identical values, this will return "TRUE."
=IF(C2=D2,TRUE())
WWC effect size
What works Clearinghouse considers an effect size of .25 as “substantively important” and interpreted as “qualified positive” even when the effect size is not statistically significant.
See page 23.
https://ies.ed.gov/ncee/wwc/Docs/referenceresources/wwc_procedures_v3_0_standards_handbook.pdf