{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Info","Definitions","TermsDef","DefsTerm","MatchTD","defRandom"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Info","index":0,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,3,9,10]]}
[]
[]
[null,"Session 1 - Exercise generator"]
[]
[null,"In session 1 a lot of terms were discussed. To practice these you can use this Excel Exercise Generator."]
[null,"This requires the use of macros, so when asked please enable these in MS Excel."]
[]
[null,"Below are a few different sheet tabs. "]
[]
[null,null,"Definitions","On this sheet you can see the full overview of all definitions discussed during session 1.\nYou can also select the terms you want to include or exclude in the exercises."]
[]
[null,null,"TermsDef","On this sheet you will be given a description and then will have to give the term this matches to"]
[]
[null,null,"DefsTerm","On this sheet you will be given a term and will then have to select the description of this term."]
[]
[null,null,"MatchTD","On this sheet you will have to match each of the descriptions with the corresponding term."]
[]
[null,null,"defRandom","This is only used for generating the different questions, please don't mess around with it."]
[]
[null,"Author:","Peter Stikker"]
[]
[null,"Version:","Date","Comment"]
[null,"0.1","2016-05-02","first concept"]

{"sheet":"Definitions","index":1,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"yes"]
[null,null,null,null,null,null,null,null,null,"no"]
["Include?","Session","Segment","Term","Definition"]
["yes",1,1,"Descriptive statistics","methods for organizing, displaying, and describing data using tables, graphs and summary measures"]
["yes",1,1,"Population","the complete set of objects of interest"]
["yes",1,1,"Sample","a subset of a population usually chosen in such a way that it can be taken to represent the population with respect to some characteristic"]
["yes",1,1,"Inference","a conclusion about a population based on logical reasoning from data gathered about a smaller sample"]
["yes",1,1,"Inferential statistics","tries to say something about a population, based on a sample from that population"]
["yes",1,1,"Sampling","the process of selecting a limited number of units from a larger set for a study"]
["yes",1,1,"Statistics","the science of collecting, displaying and analysing data"]
["yes",1,2,"Cases","who or what you are collecting data about"]
["yes",1,2,"Variables","the things we would like to know from each case"]
["yes",1,2,"Values","the possible variations of a variable"]
["yes",1,2,"Coding","assigning a letter(s) or number(s) to represent the value"]
["yes",1,2,"Codebook","overview of how all variables and values are coded in a survey"]
["yes",1,2,"Score","the value (or assigned code) for a single case on a single variable"]
["yes",1,3,"Nominal variable","variable with no logical order in values (besides alphabetical)"]
["yes",1,4,"ordinal variable","variable for which the values have a logical order, but the difference between each value is not equal (or can be perceived different)"]
["yes",1,5,"Interval variable","variable for which consecutive values have equal differences, but the zero point does not reflect the absence of something"]
["yes",1,5,"Ratio variable","variable for which consecutive values have equal differences, and the zero point reflects the absence of something"]
["yes",1,6,"Scale variable","a variable that is either interval or ratio"]
["yes",1,6,"Dichotomous variable","a variable with only two possible values"]

{"sheet":"TermsDef","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,3,10,6],[6,3,7,11]]}
[]
[null,"progress",1,"out of",{"$f":"defRandom!P1","v":17}]
[]
[null,null,"Select the proper definition for the following description:"]
[]
[null,null,null,"Description:"]
[null,null,null,{"$f":"VLOOKUP(C2,defRandom!U:W,3,0)","v":"overview of how all variables and values are coded in a survey"}]
[]
[]
[null,null,"Corresponding term:"]
[]
[]
[]
[null,null,"Answer"]
[null,null,null,{"$f":"INDEX(Definitions!D:D,MATCH(D7,Definitions!E:E,0))","v":"Codebook"}]

{"sheet":"DefsTerm","index":3,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[6,3,7,11],[10,3,10,11]]}
[]
[null,"progress",2,"out of",{"$f":"defRandom!P1","v":17}]
[]
[null,null,"Select the proper description for the following term:"]
[]
[null,null,null,"Term:"]
[null,null,null,{"$f":"VLOOKUP(C2,defRandom!U:W,2,0)","v":"Variables"}]
[]
[]
[null,null,"Corresponding term:"]
[null,null,null,"variable with no logical order in values (besides alphabetical)"]
[]
[]
[null,null,"Answer"]
[null,null,null,{"$f":"VLOOKUP(D7,Definitions!D:E,2,0)","v":"the things we would like to know from each case"}]

{"sheet":"MatchTD","index":4,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"DRAG the terms in column C next to the corresponding description in column E"]
[null,null,"You can drag in Excel by first clicking on the cell and then click and hold the border of the selected cell."]
[]
[null,null,"DRAG THESE","TO HERE","Do NOT move these","Correct?"]
[null,null,"Interval variable",null,"methods for organizing, displaying, and describing data using tables, graphs and summary measures"]
[null,null,"Score",null,"variable for which the values have a logical order, but the difference between each value is not equal (or can be perceived different)"]
[null,null,"Statistics",null,"a conclusion about a population based on logical reasoning from data gathered about a smaller sample"]
[null,null,"Population",null,"variable for which consecutive values have equal differences, but the zero point does not reflect the absence of something"]
[null,null,"Descriptive statistics",null,"a subset of a population usually chosen in such a way that it can be taken to represent the population with respect to some characteristic"]
[null,null,"Codebook",null,"tries to say something about a population, based on a sample from that population"]
[null,null,"Values",null,"assigning a letter(s) or number(s) to represent the value"]
[null,null,"Sampling",null,"variable with no logical order in values (besides alphabetical)"]
[null,null,"Ratio variable",null,"variable for which consecutive values have equal differences, and the zero point reflects the absence of something"]
[null,null,"Coding",null,"overview of how all variables and values are coded in a survey"]
[null,null,"Variables",null,"the process of selecting a limited number of units from a larger set for a study"]
[null,null,"Inference",null,"who or what you are collecting data about"]
[null,null,"Cases",null,"the complete set of objects of interest"]
[null,null,"ordinal variable",null,"the things we would like to know from each case"]
[null,null,"Inferential statistics",null,"the value (or assigned code) for a single case on a single variable"]
[null,null,"Sample",null,"the possible variations of a variable"]
[null,null,"Nominal variable",null,"the science of collecting, displaying and analysing data"]

{"sheet":"defRandom","index":5,"n_rows":34,"n_cols":25,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[{"$f":"RAND()","v":0.76273842295668925},{"$f":"RANK(A1,A:A)","v":3},{"$f":"COUNTIF(B:B,B1)","v":1},{"$f":"RAND()","v":0.98512762010152222},{"$f":"RANK(D1,D:D)","v":1},{"$f":"COUNTIF(E:E,E1)","v":1},null,"Descriptive statistics","methods for organizing, displaying, and describing data using tables, graphs and summary measures",null,1,{"$f":"VLOOKUP(K1,B:I,7,0)","v":"Coding"},{"$f":"VLOOKUP(K1,E:I,5,0)","v":"methods for organizing, displaying, and describing data using tables, graphs and summary measures"}," ","NrDefs:",{"$f":"COUNTA(H:H)","v":17},null,null,null,null,1,"Inference","overview of how all variables and values are coded in a survey","Cases","a conclusion about a population based on logical reasoning from data gathered about a smaller sample"]
[0.66709714118233721,5,1,0.40803142977169171,13,1,null,"Population","the complete set of objects of interest",null,2,"Statistics","variable for which the values have a logical order, but the difference between each value is not equal (or can be perceived different)"," ","Double?",{"$f":"COUNTIF(C:C,\">1\")+COUNTIF(F:F,\">1\")","v":0},null,null,null,null,2,"Variables","assigning a letter(s) or number(s) to represent the value","Codebook","a subset of a population usually chosen in such a way that it can be taken to represent the population with respect to some characteristic"]
[0.43528999930293155,8,1,0.5548079434646026,10,1,null,"Sample","a subset of a population usually chosen in such a way that it can be taken to represent the population with respect to some characteristic",null,3,"Descriptive statistics","variable for which consecutive values have equal differences, and the zero point reflects the absence of something"," ","TermsDef","all terms one by one, select corresponding definition",null,null,null,null,3,"Sampling","the complete set of objects of interest","Coding","assigning a letter(s) or number(s) to represent the value"]
[0.69658206937128753,4,1,0.25616145335083185,14,1,null,"Inference","a conclusion about a population based on logical reasoning from data gathered about a smaller sample",null,4,"Inference","the possible variations of a variable"," ","DefsTerm","all definitions one by one, select corresponding term",null,null,null,null,4,"Coding","the value (or assigned code) for a single case on a single variable","Descriptive statistics","methods for organizing, displaying, and describing data using tables, graphs and summary measures"]
[0.26141722905426923,10,1,0.85753771698863568,6,1,null,"Inferential statistics","tries to say something about a population, based on a sample from that population",null,5,"Population","the process of selecting a limited number of units from a larger set for a study"," ","TermDef","random term, select corresponding definition",null,null,null,null,5,"Descriptive statistics","variable for which consecutive values have equal differences, and the zero point reflects the absence of something","Inference","overview of how all variables and values are coded in a survey"]
[0.21715275628266173,12,1,0.88435227024389984,5,1,null,"Sampling","the process of selecting a limited number of units from a larger set for a study",null,6,"Codebook","tries to say something about a population, based on a sample from that population"," ","DefTerm","random definition, select corresponding term",null,null,null,null,6,"Ratio variable","variable with no logical order in values (besides alphabetical)","Inferential statistics","the complete set of objects of interest"]
[0.80401246244577929,2,1,2.0166659810786358E-3,17,1,null,"Statistics","the science of collecting, displaying and analysing data",null,7,"Values","the value (or assigned code) for a single case on a single variable"," ","MatchTD","Match terms and definitions",null,null,null,null,7,"Nominal variable","the things we would like to know from each case","Interval variable","the possible variations of a variable"]
[0.12528929456753168,15,1,1.982367832224452E-2,16,1,null,"Cases","who or what you are collecting data about",null,8,"Sample","variable with no logical order in values (besides alphabetical)"," ",null,null,null,null,null,null,8,"Inferential statistics","tries to say something about a population, based on a sample from that population","Nominal variable","the process of selecting a limited number of units from a larger set for a study"]
[9.8144369110364171E-2,17,1,0.1260868630974834,15,1,null,"Variables","the things we would like to know from each case",null,9,"Ratio variable","assigning a letter(s) or number(s) to represent the value"," ",null,null,null,null,null,null,9,"Values","variable for which consecutive values have equal differences, but the zero point does not reflect the absence of something","ordinal variable","the science of collecting, displaying and analysing data"]
[0.47479926279612505,7,1,0.90523626898675347,4,1,null,"Values","the possible variations of a variable",null,10,"Inferential statistics","a subset of a population usually chosen in such a way that it can be taken to represent the population with respect to some characteristic"," ",null,null,null,null,null,null,10,"Codebook","a subset of a population usually chosen in such a way that it can be taken to represent the population with respect to some characteristic","Population","the things we would like to know from each case"]
[0.94751693559437344,1,1,0.6083352537802722,9,1,null,"Coding","assigning a letter(s) or number(s) to represent the value",null,11,"ordinal variable","variable for which consecutive values have equal differences, but the zero point does not reflect the absence of something"," ",null,null,null,null,null,null,11,"Sample","variable for which the values have a logical order, but the difference between each value is not equal (or can be perceived different)","Ratio variable","the value (or assigned code) for a single case on a single variable"]
[0.51297438170431597,6,1,0.47011358507303491,12,1,null,"Codebook","overview of how all variables and values are coded in a survey",null,12,"Sampling","overview of how all variables and values are coded in a survey"," ",null,null,null,null,null,null,12,"Statistics","who or what you are collecting data about","Sample","tries to say something about a population, based on a sample from that population"]
[0.10700300224617754,16,1,0.74912212459690863,7,1,null,"Score","the value (or assigned code) for a single case on a single variable",null,13,"Interval variable","the complete set of objects of interest"," ",null,null,null,null,null,null,13,"Score","methods for organizing, displaying, and describing data using tables, graphs and summary measures","Sampling","variable for which consecutive values have equal differences, and the zero point reflects the absence of something"]
[0.19127418811932606,14,1,0.74283336030409652,8,1,null,"Nominal variable","variable with no logical order in values (besides alphabetical)",null,14,"Nominal variable","a conclusion about a population based on logical reasoning from data gathered about a smaller sample"," ",null,null,null,null,null,null,14,"Population","the process of selecting a limited number of units from a larger set for a study","Score","variable for which consecutive values have equal differences, but the zero point does not reflect the absence of something"]
[0.25098093998773541,11,1,0.93001287129224175,2,1,null,"ordinal variable","variable for which the values have a logical order, but the difference between each value is not equal (or can be perceived different)",null,15,"Cases","the things we would like to know from each case"," ",null,null,null,null,null,null,15,"ordinal variable","the possible variations of a variable","Statistics","variable for which the values have a logical order, but the difference between each value is not equal (or can be perceived different)"]
[0.1976484015298885,13,1,0.51904718757632518,11,1,null,"Interval variable","variable for which consecutive values have equal differences, but the zero point does not reflect the absence of something",null,16,"Score","who or what you are collecting data about"," ",null,null,null,null,null,null,16,"Cases","a conclusion about a population based on logical reasoning from data gathered about a smaller sample","Values","variable with no logical order in values (besides alphabetical)"]
[0.33978991514332979,9,1,0.92452539072673823,3,1,null,"Ratio variable","variable for which consecutive values have equal differences, and the zero point reflects the absence of something",null,17,"Variables","the science of collecting, displaying and analysing data"," ",null,null,null,null,null,null,17,"Interval variable","the science of collecting, displaying and analysing data","Variables","who or what you are collecting data about"]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," "]