{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INSTRUCTIONS","ANALYSIS","DATA"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":36,"comments":1,"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":"INSTRUCTIONS","index":0,"n_rows":95,"n_cols":3,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[null,"An Excel Worksheet for \nProportion-Judgment Analyses of Number-Line Data"]
[]
[null,"Please read all of the following notes and instructions before beginning."]
[]
[null,"NOTE 1: System and Excel Version Compatibility\nThis tool was written under MS Excel 2007 for PC (Windows) and saved under the .XLSM extension. Unfortunately, it will most likely NOT work on a Mac. For PC users, all the tools in this workbook should function correctly under MS Excel 2007 & 2010 for Windows. This workbook may not function correctly under versions of MS Excel prior to the 2007 version (such as 2003) unless the MS Office Compatibility Pack is installed. The necessary downloads and instructions may be found at the following link: http://support.microsoft.com/kb/923505"]
[]
[null,"NOTE 2: Solver & Macros Set-Up\nThis workbook will not function unless the Sovler is installed and Macros are enabled. The Set-Up instructions below for the solver add-in are only necessary the very first time this workbook is utilized. Unless all macros are enabled in the MS Trust Center, it may be necessary to enable this workbook's macro each time this workbook is opened."]
[]
[null,"NOTE 3: Instructions\nAll instructions below are with respect to MS Excel 2007 for Windows. In some cases these instructions may need to be adapted for other versions of Excel. Links for support for other versions of MS Excel for Windows are provided below."]
[]
[null,"MENU"]
[null,"Set-Up"]
[null,"setting up solver add-in"]
[null,"step 1 - installing the solver add-in",{"$f":"MATCH(B15,B$34:B$104,0)+ROW(B$33)","v":38}]
[null,"step 2 - opening the visual basic editor",{"$f":"MATCH(B16,B$34:B$104,0)+ROW(B$33)","v":44}]
[null,"step 3 - referencing solver in macros",50]
[null,"enabling macros in workbook"]
[null,"upon initial opening of workbook",{"$f":"MATCH(B19,B$34:B$104,0)+ROW(B$33)","v":55}]
[null,"if macro warning dialog/bar does not appear",58]
[null,"further help on enabling macros in Excel",61]
[null,"Utilization"]
[null,"inputting data"]
[null,"step 1 - importing data into DATA worksheet",{"$f":"MATCH(B24,B$34:B$104,0)+ROW(B$33)","v":72}]
[null,"reseting DATA worksheet",76]
[null,"running analysis"]
[null,"step 2 - setting up ANALYSIS worksheet",{"$f":"MATCH(B27,B$34:B$104,0)+ROW(B$33)","v":81}]
[null,"step 3 - specifying model",84]
[null,"step 4 - setting model parameters",87]
[null,"step 5 - launching regression analysis",91]
[null,"reseting ANALYSIS worksheet",94]
[]
[]
[null,"Set-Up"]
[]
[null,"Set-Up | setting up solver add-in"]
[]
[null,"step 1 - installing the solver add-in"]
[null,"Follow the link below for help with your version of Excel:"]
[null,{"$f":"HYPERLINK(\"http://office.microsoft.com/en-us/excel-help/load-the-solver-add-in-HP001127725.aspx\",\"for Excel 2003\")","v":"for Excel 2003"}]
[null,{"$f":"HYPERLINK(\"http://office.microsoft.com/en-us/excel-help/load-the-solver-add-in-HP010021570.aspx\",\"for Excel 2007\")","v":"for Excel 2007"}]
[null,{"$f":"HYPERLINK(\"http://office.microsoft.com/en-us/excel-help/load-the-solver-add-in-HP010342660.aspx\",\"for Excel 2010\")","v":"for Excel 2010"}]
[]
[null,"step 2 - opening the visual basic editor"]
[null,"To open the Visual Basic Editor from with Excel, press [ALT] + [F11]. If the Visual Basic Editor does not open, please see the links below for help with your version of Excel:"]
[null,{"$f":"HYPERLINK(\"http://office.microsoft.com/en-us/excel-help/introduction-to-custom-macros-in-excel-HA001118958.aspx\",\"for Excel 2003\")","v":"for Excel 2003"}]
[null,{"$f":"HYPERLINK(\"http://office.microsoft.com/en-us/excel-help/create-or-delete-a-macro-HP010014111.aspx#BMrecordmacro\",\"for Excel 2007\")","v":"for Excel 2007"}]
[null,{"$f":"HYPERLINK(\"http://office.microsoft.com/en-us/excel-help/create-or-delete-a-macro-HP010342374.aspx\",\"for Excel 2010\")","v":"for Excel 2010"}]
[]
[null,"step 3 - referencing solver in macros"]
[null,"Within the Visual Basic Editor window complete the following instructions:\n(1) Under the Tools drop-down menu, select References.\n(2) Scroll down menu to locate SOLVER option and make sure checkbox is checked.\n(3) Click OK in dialog menu and close Visual Basic Editor."]
[]
[null,"Set-Up | enabling macros in workbook"]
[]
[null,"upon initial opening of workbook"]
[null,"Upon opening this workbook either a warning dialog or a warning bar (depending on your version of Excel) will appear. If the dialog appears, select the option to enable macros. If the warning bar appears (located above this worksheet), click on the options button and   select the option to enable macros. "]
[]
[null,"if macro warning dialog/bar does not appear"]
[null,"If either the macro warning dialog or warning bar does not appear, then close this workbook and reopen it. The warning dialog or bar should upon reopening the workbook."]
[]
[null,"further help on enabling macros in Excel"]
[null,"For further help on enabling macros in versions of Excel, please see the following help pages:"]
[null,{"$f":"HYPERLINK(\"http://office.microsoft.com/en-us/excel-help/enable-macros-to-run-HP001119579.aspx\",\"for Excel 2003\")","v":"for Excel 2003"}]
[null,{"$f":"HYPERLINK(\"http://office.microsoft.com/en-us/excel-help/enable-or-disable-macros-in-office-documents-HA010031071.aspx#BM12\",\"for Excel 2007\")","v":"for Excel 2007"}]
[null,{"$f":"HYPERLINK(\"http://office.microsoft.com/en-us/word-help/enable-or-disable-macros-in-office-files-HA010354316.aspx\",\"for Excel 2010\")","v":"for Excel 2010"}]
[]
[]
[null,"Utilization"]
[]
[null,"Utilization | inputting data"]
[]
[null,"step 1 - importing data into DATA worksheet"]
[null,"The data is brought into the regression analysis through the DATA worksheet. This is to help ensure that the data is correctly structured for the analysis. To import data, paste your data values into the appropriate columns in the DATA worksheet. "]
[null,"The data column headings in the DATA worksheet can be changed and those changes will carry over to the ANALYSIS worksheet functions."]
[]
[null,"reseting DATA worksheet"]
[null,"To ensure that all old data and empty cells are removed before importing new data into the DATA worksheet, click on the [reset 'DATA'] button - then copy new data into DATA worksheet."]
[]
[null,"Utilization | running analysis"]
[]
[null,"step 2 - setting up ANALYSIS worksheet"]
[null,"The initial set-up for the ANALYSIS worksheet contains no data or equations. To set up the ANALYSIS worksheet with data from the DATA worksheet and to populate the equations, click on the [reset 'ANALYSIS'] button. (The 'reset ANALYSIS' button will return an error if the DATA worksheet contains no data.)"]
[]
[null,"step 3 - specifying model"]
[null,"The initial setting \"[models]\" appears in the model drop-down menu cell. Click on this cell and to make the drop-down menu appear and then scroll down this menu until the desired model is highlighted."]
[]
[null,"step 4 - setting model parameters"]
[null,"There are two classes of model parameters that need to be specified: free parameters and fixed parameters. The free parameters require an initial (starting) search value which needs to be specified. The free parameters will be searched for utilizing the least-squares regression solver while the fixed parameters will remain constant."]
[null,"To set these parameters the values can be manually set or they can be automatically set from the model defaults by clicking on the [reset parameters] button. (The [reset parameters] button will return and error if no model is selected.)"]
[]
[null,"step 5 - launching regression analysis"]
[null,"Simply click on the [regress model] button to initiate the parameter search using Excel's solver (least-squares based regression). Once clicked Excel may take several moments while it performs a series of calculations behind the scenes. Excel's status can be observed in the bottom-left corner of the application window which will show the word 'READY' when the analysis is completed. Once completed the free parameter cells will be updated with the results of the analysis. For more or technical information on how Excel's solver goes about estimating the parameter values, see the help sections above on 'installing the solver add-in'."]
[]
[null,"reseting ANALYSIS worksheet"]
[null,"If new data is brought into the DATA worksheet or if the analysis needs to be reinitiated, click on the [reset 'ANALYSIS'] button. As indicated above [step 2], this will restore the ANALYSIS worksheet to its default state."]

{"sheet":"ANALYSIS","index":1,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,"X","Y",{"$f":"C2&\"'\"","v":"Y'"},"e2",null,"model","[models]","<< drop menu"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(H2,K12:N19,2)","v":"parameter(1)"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(H2,K12:N19,3)","v":"parameter(2)"}]
[null,null,null,null,null,null,"K"]
[null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,"SSE"]
[null,null,null,null,null,null,"MSE"]
[null,null,null,null,null,null,"R2"]
[null,null,null,null,null,null,"AICc"]
[]
[null,null,null,null,null,null,"xs","model","Y = X","[models]","[models]","parameter(1)","parameter(2)",0]
[null,null,null,null,null,null,{"$f":"MIN(B:B)","v":0},{"$f":"modelx(G13,H$3,H$4,H$2)","v":{"$error":"#NAME?"}},{"$f":"MIN(B:B)","v":0},"LIN_UNC","1_CYCLE","beta","range(fixed)",1]
[null,null,null,null,null,null,{"$f":"G13+(G$52-G$13)/39","v":0},{"$error":"#NAME?"},{"$f":"MAX(B:B)","v":0},"LIN_CON","2_CYCLE","beta","range(fixed)",1]
[null,null,null,null,null,null,0,{"$error":"#NAME?"},{"$f":"I13-MOD(I13,10)","v":0},"LOG_UNC","LIN_CON","slope","intercept",2]
[null,null,null,null,null,null,0,{"$error":"#NAME?"},{"$f":"CEILING(I14 / 10, 1) * 10","v":0},"LOG_CON","LIN_UNC","slope","intercept",2]
[null,null,null,null,null,null,0,{"$error":"#NAME?"},{"$f":"10^LEN(I14)","v":10},"POWER","LOG_CON","slope","intercept",2]
[null,null,null,null,null,null,0,{"$error":"#NAME?"},{"$f":"ROUND(H3*10^3,0)/10^3","v":0},"1_CYCLE","LOG_UNC","slope","intercept",2]
[null,null,null,null,null,null,0,{"$error":"#NAME?"},{"$f":"ROUND(H4*10^3,0)/10^3","v":0},"2_CYCLE","POWER","beta","range",2]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,0,{"$error":"#NAME?"}]
[null,null,null,null,null,null,{"$f":"MAX(B:B)","v":0},{"$error":"#NAME?"}]

{"sheet":"DATA","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"X","Y"]
[null,null,null,null," ¬ Copy and paste data values into variable columns under variable names 'X' (column A) and 'Y' (column B)"]
[null,null,null,null,"Changes to the variable names (column headings) will carry through to the ANALYSIS worksheet."]
[]
[]
[null,null,null,null,"      If you would like to make sure all old data and cell formatting are completely cleared out, click 'RESET' ®"]