{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Intro","Correlations","Diff correlations","Proportions","Diff proportions","Means","Paired means","2 ind means same variance","2 ind means general","Known CI limits"],"not_rendered":{"charts":9,"images":1,"macros":0,"external_links":19,"defined_names":1096,"comments":10,"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":"Intro","index":0,"n_rows":741,"n_cols":14,"rows_kept":741,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Exploratory Software for Confidence Intervals"]
[null,null,null,null,null,"ESCI Effect sizes",null,null,null,null,null,"www.thenewstatistics.com"]
[]
[null,null,null,null,null,null,"Geoff Cumming",null,null,null,null,null,null,"Copyright ©  Geoff Cumming 2011"]
[null,null,null,null,null,null,null,"School of Psychological Science",null,null,null,null,null,"ESCI is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License"]
[null,null,null,null,null,null,null,"La Trobe University, Melbourne",null,null,null,null,null,"      as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version."]
[null,null,null,null,null,null,null,"Australia  3086",null,null,null,null,null,"This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of"]
[null,null,null,null,null,null,null,"esci@latrobe.edu.au",null,null,null,null,null,"      MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  Scroll down to see the GNU General Public License for more details."]
[]
[]
[null,"► ESCI Effect sizes accompanies the book Understanding The New Statistics: Effect Sizes, Confidence Intervals, and Meta-analysis (Routledge, 2012)"]
[null,"► For help, see the book's Appendix A."]
[null,"► Use the tabs below to go to your page of choice."]
[null,"► At any page, explore--with guidance from the relevant chapters of the book."]
[]
[]
[]
[null,"Click the tabs at the bottom of the screen to go to these pages:"]
[]
[null,null,"Correlations  See Chapter 14.  Enter values and see a CI figure for Pearson's r correlations."]
[]
[null,null,"Diff correlations  See Chapter 14.  Enter values and see a CI figure for the difference between two independent Pearson's r correlations."]
[]
[null,null,"Proportions  See Chapter 14.  Enter values and see a CI figure for proportions."]
[]
[null,null,"Diff proportions  See Chapter 14.  Enter values and see a CI figure for the difference between two independent proportions."]
[]
[null,null,"Means  See Chapter 14.  Enter values and see a CI figure for means, for any dependent variable with interval scaling."]
[]
[null,null,"Paired means  See Chapter 14.  Enter values and see a CI figure for mean differences, for paired data (i.e. a repeated measure)."]
[]
[null,null,"2 ind means same variance  See Chapter 14.  Enter values and see a CI figure for differences between means, two independent groups design, variances assumed equal."]
[]
[null,null,"2 ind means general  See Chapter 14.  Enter values and see a CI figure for differences between means, two independent groups design, variances not assumed equal."]
[]
[null,null,"Known CI limits  See Chapter 14.  Enter values and see a CI figure when the point estimate and lower and upper CI limits are known."]
[]
[]
[]
[]
[]
[]
[null,"Please scroll down to see the GNU General Public License below"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"                    GNU GENERAL PUBLIC LICENSE"]
[null,"                       Version 3, 29 June 2007"]
[]
[null," Copyright (C) 2007 Free Software Foundation, Inc. <http://fsf.org/>"]
[null," Everyone is permitted to copy and distribute verbatim copies"]
[null," of this license document, but changing it is not allowed."]
[]
[null,"                            Preamble"]
[]
[null,"  The GNU General Public License is a free, copyleft license for"]
[null,"software and other kinds of works."]
[]
[null,"  The licenses for most software and other practical works are designed"]
[null,"to take away your freedom to share and change the works.  By contrast,"]
[null,"the GNU General Public License is intended to guarantee your freedom to"]
[null,"share and change all versions of a program--to make sure it remains free"]
[null,"software for all its users.  We, the Free Software Foundation, use the"]
[null,"GNU General Public License for most of our software; it applies also to"]
[null,"any other work released this way by its authors.  You can apply it to"]
[null,"your programs, too."]
[]
[null,"  When we speak of free software, we are referring to freedom, not"]
[null,"price.  Our General Public Licenses are designed to make sure that you"]
[null,"have the freedom to distribute copies of free software (and charge for"]
[null,"them if you wish), that you receive source code or can get it if you"]
[null,"want it, that you can change the software or use pieces of it in new"]
[null,"free programs, and that you know you can do these things."]
[]
[null,"  To protect your rights, we need to prevent others from denying you"]
[null,"these rights or asking you to surrender the rights.  Therefore, you have"]
[null,"certain responsibilities if you distribute copies of the software, or if"]
[null,"you modify it: responsibilities to respect the freedom of others."]
[]
[null,"  For example, if you distribute copies of such a program, whether"]
[null,"gratis or for a fee, you must pass on to the recipients the same"]
[null,"freedoms that you received.  You must make sure that they, too, receive"]
[null,"or can get the source code.  And you must show them these terms so they"]
[null,"know their rights."]
[]
[null,"  Developers that use the GNU GPL protect your rights with two steps:"]
[null,"(1) assert copyright on the software, and (2) offer you this License"]
[null,"giving you legal permission to copy, distribute and/or modify it."]
[]
[null,"  For the developers' and authors' protection, the GPL clearly explains"]
[null,"that there is no warranty for this free software.  For both users' and"]
[null,"authors' sake, the GPL requires that modified versions be marked as"]
[null,"changed, so that their problems will not be attributed erroneously to"]
[null,"authors of previous versions."]
[]
[null,"  Some devices are designed to deny users access to install or run"]
[null,"modified versions of the software inside them, although the manufacturer"]
[null,"can do so.  This is fundamentally incompatible with the aim of"]
[null,"protecting users' freedom to change the software.  The systematic"]
[null,"pattern of such abuse occurs in the area of products for individuals to"]
[null,"use, which is precisely where it is most unacceptable.  Therefore, we"]
[null,"have designed this version of the GPL to prohibit the practice for those"]
[null,"products.  If such problems arise substantially in other domains, we"]
[null,"stand ready to extend this provision to those domains in future versions"]
[null,"of the GPL, as needed to protect the freedom of users."]
[]
[null,"  Finally, every program is threatened constantly by software patents."]
[null,"States should not allow patents to restrict development and use of"]
[null,"software on general-purpose computers, but in those that do, we wish to"]
[null,"avoid the special danger that patents applied to a free program could"]
[null,"make it effectively proprietary.  To prevent this, the GPL assures that"]
[null,"patents cannot be used to render the program non-free."]
[]
[null,"  The precise terms and conditions for copying, distribution and"]
[null,"modification follow."]
[]
[null,"                       TERMS AND CONDITIONS"]
[]
[null,"  0. Definitions."]
[]
[null,"  \"This License\" refers to version 3 of the GNU General Public License."]
[]
[null,"  \"Copyright\" also means copyright-like laws that apply to other kinds of"]
[null,"works, such as semiconductor masks."]
[]
[null,"  \"The Program\" refers to any copyrightable work licensed under this"]
[null,"License.  Each licensee is addressed as \"you\".  \"Licensees\" and"]
[null,"\"recipients\" may be individuals or organizations."]
[]
[null,"  To \"modify\" a work means to copy from or adapt all or part of the work"]
[null,"in a fashion requiring copyright permission, other than the making of an"]
[null,"exact copy.  The resulting work is called a \"modified version\" of the"]
[null,"earlier work or a work \"based on\" the earlier work."]
[]
[null,"  A \"covered work\" means either the unmodified Program or a work based"]
[null,"on the Program."]
[]
[null,"  To \"propagate\" a work means to do anything with it that, without"]
[null,"permission, would make you directly or secondarily liable for"]
[null,"infringement under applicable copyright law, except executing it on a"]
[null,"computer or modifying a private copy.  Propagation includes copying,"]
[null,"distribution (with or without modification), making available to the"]
[null,"public, and in some countries other activities as well."]
[]
[null,"  To \"convey\" a work means any kind of propagation that enables other"]
[null,"parties to make or receive copies.  Mere interaction with a user through"]
[null,"a computer network, with no transfer of a copy, is not conveying."]
[]
[null,"  An interactive user interface displays \"Appropriate Legal Notices\""]
[null,"to the extent that it includes a convenient and prominently visible"]
[null,"feature that (1) displays an appropriate copyright notice, and (2)"]
[null,"tells the user that there is no warranty for the work (except to the"]
[null,"extent that warranties are provided), that licensees may convey the"]
[null,"work under this License, and how to view a copy of this License.  If"]
[null,"the interface presents a list of user commands or options, such as a"]
[null,"menu, a prominent item in the list meets this criterion."]
[]
[null,"  1. Source Code."]
[]
[null,"  The \"source code\" for a work means the preferred form of the work"]
[null,"for making modifications to it.  \"Object code\" means any non-source"]
[null,"form of a work."]
[]
[null,"  A \"Standard Interface\" means an interface that either is an official"]
[null,"standard defined by a recognized standards body, or, in the case of"]
[null,"interfaces specified for a particular programming language, one that"]
[null,"is widely used among developers working in that language."]
[]
[null,"  The \"System Libraries\" of an executable work include anything, other"]
[null,"than the work as a whole, that (a) is included in the normal form of"]
[null,"packaging a Major Component, but which is not part of that Major"]
[null,"Component, and (b) serves only to enable use of the work with that"]
[null,"Major Component, or to implement a Standard Interface for which an"]
[null,"implementation is available to the public in source code form.  A"]
[null,"\"Major Component\", in this context, means a major essential component"]
[null,"(kernel, window system, and so on) of the specific operating system"]
[null,"(if any) on which the executable work runs, or a compiler used to"]
[null,"produce the work, or an object code interpreter used to run it."]
[]
[null,"  The \"Corresponding Source\" for a work in object code form means all"]
[null,"the source code needed to generate, install, and (for an executable"]
[null,"work) run the object code and to modify the work, including scripts to"]
[null,"control those activities.  However, it does not include the work's"]
[null,"System Libraries, or general-purpose tools or generally available free"]
[null,"programs which are used unmodified in performing those activities but"]
[null,"which are not part of the work.  For example, Corresponding Source"]
[null,"includes interface definition files associated with source files for"]
[null,"the work, and the source code for shared libraries and dynamically"]
[null,"linked subprograms that the work is specifically designed to require,"]
[null,"such as by intimate data communication or control flow between those"]
[null,"subprograms and other parts of the work."]
[]
[null,"  The Corresponding Source need not include anything that users"]
[null,"can regenerate automatically from other parts of the Corresponding"]
[null,"Source."]
[]
[null,"  The Corresponding Source for a work in source code form is that"]
[null,"same work."]
[]
[null,"  2. Basic Permissions."]
[]
[null,"  All rights granted under this License are granted for the term of"]
[null,"copyright on the Program, and are irrevocable provided the stated"]
[null,"conditions are met.  This License explicitly affirms your unlimited"]
[null,"permission to run the unmodified Program.  The output from running a"]
[null,"covered work is covered by this License only if the output, given its"]
[null,"content, constitutes a covered work.  This License acknowledges your"]
[null,"rights of fair use or other equivalent, as provided by copyright law."]
[]
[null,"  You may make, run and propagate covered works that you do not"]
[null,"convey, without conditions so long as your license otherwise remains"]
[null,"in force.  You may convey covered works to others for the sole purpose"]
[null,"of having them make modifications exclusively for you, or provide you"]
[null,"with facilities for running those works, provided that you comply with"]
[null,"the terms of this License in conveying all material for which you do"]
[null,"not control copyright.  Those thus making or running the covered works"]
[null,"for you must do so exclusively on your behalf, under your direction"]
[null,"and control, on terms that prohibit them from making any copies of"]
[null,"your copyrighted material outside their relationship with you."]
[]
[null,"  Conveying under any other circumstances is permitted solely under"]
[null,"the conditions stated below.  Sublicensing is not allowed; section 10"]
[null,"makes it unnecessary."]
[]
[null,"  3. Protecting Users' Legal Rights From Anti-Circumvention Law."]
[]
[null,"  No covered work shall be deemed part of an effective technological"]
[null,"measure under any applicable law fulfilling obligations under article"]
[null,"11 of the WIPO copyright treaty adopted on 20 December 1996, or"]
[null,"similar laws prohibiting or restricting circumvention of such"]
[null,"measures."]
[]
[null,"  When you convey a covered work, you waive any legal power to forbid"]
[null,"circumvention of technological measures to the extent such circumvention"]
[null,"is effected by exercising rights under this License with respect to"]
[null,"the covered work, and you disclaim any intention to limit operation or"]
[null,"modification of the work as a means of enforcing, against the work's"]
[null,"users, your or third parties' legal rights to forbid circumvention of"]
[null,"technological measures."]
[]
[null,"  4. Conveying Verbatim Copies."]
[]
[null,"  You may convey verbatim copies of the Program's source code as you"]
[null,"receive it, in any medium, provided that you conspicuously and"]
[null,"appropriately publish on each copy an appropriate copyright notice;"]
[null,"keep intact all notices stating that this License and any"]
[null,"non-permissive terms added in accord with section 7 apply to the code;"]
[null,"keep intact all notices of the absence of any warranty; and give all"]
[null,"recipients a copy of this License along with the Program."]
[]
[null,"  You may charge any price or no price for each copy that you convey,"]
[null,"and you may offer support or warranty protection for a fee."]
[]
[null,"  5. Conveying Modified Source Versions."]
[]
[null,"  You may convey a work based on the Program, or the modifications to"]
[null,"produce it from the Program, in the form of source code under the"]
[null,"terms of section 4, provided that you also meet all of these conditions:"]
[]
[null,"    a) The work must carry prominent notices stating that you modified"]
[null,"    it, and giving a relevant date."]
[]
[null,"    b) The work must carry prominent notices stating that it is"]
[null,"    released under this License and any conditions added under section"]
[null,"    7.  This requirement modifies the requirement in section 4 to"]
[null,"    \"keep intact all notices\"."]
[]
[null,"    c) You must license the entire work, as a whole, under this"]
[null,"    License to anyone who comes into possession of a copy.  This"]
[null,"    License will therefore apply, along with any applicable section 7"]
[null,"    additional terms, to the whole of the work, and all its parts,"]
[null,"    regardless of how they are packaged.  This License gives no"]
[null,"    permission to license the work in any other way, but it does not"]
[null,"    invalidate such permission if you have separately received it."]
[]
[null,"    d) If the work has interactive user interfaces, each must display"]
[null,"    Appropriate Legal Notices; however, if the Program has interactive"]
[null,"    interfaces that do not display Appropriate Legal Notices, your"]
[null,"    work need not make them do so."]
[]
[null,"  A compilation of a covered work with other separate and independent"]
[null,"works, which are not by their nature extensions of the covered work,"]
[null,"and which are not combined with it such as to form a larger program,"]
[null,"in or on a volume of a storage or distribution medium, is called an"]
[null,"\"aggregate\" if the compilation and its resulting copyright are not"]
[null,"used to limit the access or legal rights of the compilation's users"]
[null,"beyond what the individual works permit.  Inclusion of a covered work"]
[null,"in an aggregate does not cause this License to apply to the other"]
[null,"parts of the aggregate."]
[]
[null,"  6. Conveying Non-Source Forms."]
[]
[null,"  You may convey a covered work in object code form under the terms"]
[null,"of sections 4 and 5, provided that you also convey the"]
[null,"machine-readable Corresponding Source under the terms of this License,"]
[null,"in one of these ways:"]
[]
[null,"    a) Convey the object code in, or embodied in, a physical product"]
[null,"    (including a physical distribution medium), accompanied by the"]
[null,"    Corresponding Source fixed on a durable physical medium"]
[null,"    customarily used for software interchange."]
[]
[null,"    b) Convey the object code in, or embodied in, a physical product"]
[null,"    (including a physical distribution medium), accompanied by a"]
[null,"    written offer, valid for at least three years and valid for as"]
[null,"    long as you offer spare parts or customer support for that product"]
[null,"    model, to give anyone who possesses the object code either (1) a"]
[null,"    copy of the Corresponding Source for all the software in the"]
[null,"    product that is covered by this License, on a durable physical"]
[null,"    medium customarily used for software interchange, for a price no"]
[null,"    more than your reasonable cost of physically performing this"]
[null,"    conveying of source, or (2) access to copy the"]
[null,"    Corresponding Source from a network server at no charge."]
[]
[null,"    c) Convey individual copies of the object code with a copy of the"]
[null,"    written offer to provide the Corresponding Source.  This"]
[null,"    alternative is allowed only occasionally and noncommercially, and"]
[null,"    only if you received the object code with such an offer, in accord"]
[null,"    with subsection 6b."]
[]
[null,"    d) Convey the object code by offering access from a designated"]
[null,"    place (gratis or for a charge), and offer equivalent access to the"]
[null,"    Corresponding Source in the same way through the same place at no"]
[null,"    further charge.  You need not require recipients to copy the"]
[null,"    Corresponding Source along with the object code.  If the place to"]
[null,"    copy the object code is a network server, the Corresponding Source"]
[null,"    may be on a different server (operated by you or a third party)"]
[null,"    that supports equivalent copying facilities, provided you maintain"]
[null,"    clear directions next to the object code saying where to find the"]
[null,"    Corresponding Source.  Regardless of what server hosts the"]
[null,"    Corresponding Source, you remain obligated to ensure that it is"]
[null,"    available for as long as needed to satisfy these requirements."]
[]
[null,"    e) Convey the object code using peer-to-peer transmission, provided"]
[null,"    you inform other peers where the object code and Corresponding"]
[null,"    Source of the work are being offered to the general public at no"]
[null,"    charge under subsection 6d."]
[]
[null,"  A separable portion of the object code, whose source code is excluded"]
[null,"from the Corresponding Source as a System Library, need not be"]
[null,"included in conveying the object code work."]
[]
[null,"  A \"User Product\" is either (1) a \"consumer product\", which means any"]
[null,"tangible personal property which is normally used for personal, family,"]
[null,"or household purposes, or (2) anything designed or sold for incorporation"]
[null,"into a dwelling.  In determining whether a product is a consumer product,"]
[null,"doubtful cases shall be resolved in favor of coverage.  For a particular"]
[null,"product received by a particular user, \"normally used\" refers to a"]
[null,"typical or common use of that class of product, regardless of the status"]
[null,"of the particular user or of the way in which the particular user"]
[null,"actually uses, or expects or is expected to use, the product.  A product"]
[null,"is a consumer product regardless of whether the product has substantial"]
[null,"commercial, industrial or non-consumer uses, unless such uses represent"]
[null,"the only significant mode of use of the product."]
[]
[null,"  \"Installation Information\" for a User Product means any methods,"]
[null,"procedures, authorization keys, or other information required to install"]
[null,"and execute modified versions of a covered work in that User Product from"]
[null,"a modified version of its Corresponding Source.  The information must"]
[null,"suffice to ensure that the continued functioning of the modified object"]
[null,"code is in no case prevented or interfered with solely because"]
[null,"modification has been made."]
[]
[null,"  If you convey an object code work under this section in, or with, or"]
[null,"specifically for use in, a User Product, and the conveying occurs as"]
[null,"part of a transaction in which the right of possession and use of the"]
[null,"User Product is transferred to the recipient in perpetuity or for a"]
[null,"fixed term (regardless of how the transaction is characterized), the"]
[null,"Corresponding Source conveyed under this section must be accompanied"]
[null,"by the Installation Information.  But this requirement does not apply"]
[null,"if neither you nor any third party retains the ability to install"]
[null,"modified object code on the User Product (for example, the work has"]
[null,"been installed in ROM)."]
[]
[null,"  The requirement to provide Installation Information does not include a"]
[null,"requirement to continue to provide support service, warranty, or updates"]
[null,"for a work that has been modified or installed by the recipient, or for"]
[null,"the User Product in which it has been modified or installed.  Access to a"]
[null,"network may be denied when the modification itself materially and"]
[null,"adversely affects the operation of the network or violates the rules and"]
[null,"protocols for communication across the network."]
[]
[null,"  Corresponding Source conveyed, and Installation Information provided,"]
[null,"in accord with this section must be in a format that is publicly"]
[null,"documented (and with an implementation available to the public in"]
[null,"source code form), and must require no special password or key for"]
[null,"unpacking, reading or copying."]
[]
[null,"  7. Additional Terms."]
[]
[null,"  \"Additional permissions\" are terms that supplement the terms of this"]
[null,"License by making exceptions from one or more of its conditions."]
[null,"Additional permissions that are applicable to the entire Program shall"]
[null,"be treated as though they were included in this License, to the extent"]
[null,"that they are valid under applicable law.  If additional permissions"]
[null,"apply only to part of the Program, that part may be used separately"]
[null,"under those permissions, but the entire Program remains governed by"]
[null,"this License without regard to the additional permissions."]
[]
[null,"  When you convey a copy of a covered work, you may at your option"]
[null,"remove any additional permissions from that copy, or from any part of"]
[null,"it.  (Additional permissions may be written to require their own"]
[null,"removal in certain cases when you modify the work.)  You may place"]
[null,"additional permissions on material, added by you to a covered work,"]
[null,"for which you have or can give appropriate copyright permission."]
[]
[null,"  Notwithstanding any other provision of this License, for material you"]
[null,"add to a covered work, you may (if authorized by the copyright holders of"]
[null,"that material) supplement the terms of this License with terms:"]
[]
[null,"    a) Disclaiming warranty or limiting liability differently from the"]
[null,"    terms of sections 15 and 16 of this License; or"]
[]
[null,"    b) Requiring preservation of specified reasonable legal notices or"]
[null,"    author attributions in that material or in the Appropriate Legal"]
[null,"    Notices displayed by works containing it; or"]
[]
[null,"    c) Prohibiting misrepresentation of the origin of that material, or"]
[null,"    requiring that modified versions of such material be marked in"]
[null,"    reasonable ways as different from the original version; or"]
[]
[null,"    d) Limiting the use for publicity purposes of names of licensors or"]
[null,"    authors of the material; or"]
[]
[null,"    e) Declining to grant rights under trademark law for use of some"]
[null,"    trade names, trademarks, or service marks; or"]
[]
[null,"    f) Requiring indemnification of licensors and authors of that"]
[null,"    material by anyone who conveys the material (or modified versions of"]
[null,"    it) with contractual assumptions of liability to the recipient, for"]
[null,"    any liability that these contractual assumptions directly impose on"]
[null,"    those licensors and authors."]
[]
[null,"  All other non-permissive additional terms are considered \"further"]
[null,"restrictions\" within the meaning of section 10.  If the Program as you"]
[null,"received it, or any part of it, contains a notice stating that it is"]
[null,"governed by this License along with a term that is a further"]
[null,"restriction, you may remove that term.  If a license document contains"]
[null,"a further restriction but permits relicensing or conveying under this"]
[null,"License, you may add to a covered work material governed by the terms"]
[null,"of that license document, provided that the further restriction does"]
[null,"not survive such relicensing or conveying."]
[]
[null,"  If you add terms to a covered work in accord with this section, you"]
[null,"must place, in the relevant source files, a statement of the"]
[null,"additional terms that apply to those files, or a notice indicating"]
[null,"where to find the applicable terms."]
[]
[null,"  Additional terms, permissive or non-permissive, may be stated in the"]
[null,"form of a separately written license, or stated as exceptions;"]
[null,"the above requirements apply either way."]
[]
[null,"  8. Termination."]
[]
[null,"  You may not propagate or modify a covered work except as expressly"]
[null,"provided under this License.  Any attempt otherwise to propagate or"]
[null,"modify it is void, and will automatically terminate your rights under"]
[null,"this License (including any patent licenses granted under the third"]
[null,"paragraph of section 11)."]
[]
[null,"  However, if you cease all violation of this License, then your"]
[null,"license from a particular copyright holder is reinstated (a)"]
[null,"provisionally, unless and until the copyright holder explicitly and"]
[null,"finally terminates your license, and (b) permanently, if the copyright"]
[null,"holder fails to notify you of the violation by some reasonable means"]
[null,"prior to 60 days after the cessation."]
[]
[null,"  Moreover, your license from a particular copyright holder is"]
[null,"reinstated permanently if the copyright holder notifies you of the"]
[null,"violation by some reasonable means, this is the first time you have"]
[null,"received notice of violation of this License (for any work) from that"]
[null,"copyright holder, and you cure the violation prior to 30 days after"]
[null,"your receipt of the notice."]
[]
[null,"  Termination of your rights under this section does not terminate the"]
[null,"licenses of parties who have received copies or rights from you under"]
[null,"this License.  If your rights have been terminated and not permanently"]
[null,"reinstated, you do not qualify to receive new licenses for the same"]
[null,"material under section 10."]
[]
[null,"  9. Acceptance Not Required for Having Copies."]
[]
[null,"  You are not required to accept this License in order to receive or"]
[null,"run a copy of the Program.  Ancillary propagation of a covered work"]
[null,"occurring solely as a consequence of using peer-to-peer transmission"]
[null,"to receive a copy likewise does not require acceptance.  However,"]
[null,"nothing other than this License grants you permission to propagate or"]
[null,"modify any covered work.  These actions infringe copyright if you do"]
[null,"not accept this License.  Therefore, by modifying or propagating a"]
[null,"covered work, you indicate your acceptance of this License to do so."]
[]
[null,"  10. Automatic Licensing of Downstream Recipients."]
[]
[null,"  Each time you convey a covered work, the recipient automatically"]
[null,"receives a license from the original licensors, to run, modify and"]
[null,"propagate that work, subject to this License.  You are not responsible"]
[null,"for enforcing compliance by third parties with this License."]
[]
[null,"  An \"entity transaction\" is a transaction transferring control of an"]
[null,"organization, or substantially all assets of one, or subdividing an"]
[null,"organization, or merging organizations.  If propagation of a covered"]
[null,"work results from an entity transaction, each party to that"]
[null,"transaction who receives a copy of the work also receives whatever"]
[null,"licenses to the work the party's predecessor in interest had or could"]
[null,"give under the previous paragraph, plus a right to possession of the"]
[null,"Corresponding Source of the work from the predecessor in interest, if"]
[null,"the predecessor has it or can get it with reasonable efforts."]
[]
[null,"  You may not impose any further restrictions on the exercise of the"]
[null,"rights granted or affirmed under this License.  For example, you may"]
[null,"not impose a license fee, royalty, or other charge for exercise of"]
[null,"rights granted under this License, and you may not initiate litigation"]
[null,"(including a cross-claim or counterclaim in a lawsuit) alleging that"]
[null,"any patent claim is infringed by making, using, selling, offering for"]
[null,"sale, or importing the Program or any portion of it."]
[]
[null,"  11. Patents."]
[]
[null,"  A \"contributor\" is a copyright holder who authorizes use under this"]
[null,"License of the Program or a work on which the Program is based.  The"]
[null,"work thus licensed is called the contributor's \"contributor version\"."]
[]
[null,"  A contributor's \"essential patent claims\" are all patent claims"]
[null,"owned or controlled by the contributor, whether already acquired or"]
[null,"hereafter acquired, that would be infringed by some manner, permitted"]
[null,"by this License, of making, using, or selling its contributor version,"]
[null,"but do not include claims that would be infringed only as a"]
[null,"consequence of further modification of the contributor version.  For"]
[null,"purposes of this definition, \"control\" includes the right to grant"]
[null,"patent sublicenses in a manner consistent with the requirements of"]
[null,"this License."]
[]
[null,"  Each contributor grants you a non-exclusive, worldwide, royalty-free"]
[null,"patent license under the contributor's essential patent claims, to"]
[null,"make, use, sell, offer for sale, import and otherwise run, modify and"]
[null,"propagate the contents of its contributor version."]
[]
[null,"  In the following three paragraphs, a \"patent license\" is any express"]
[null,"agreement or commitment, however denominated, not to enforce a patent"]
[null,"(such as an express permission to practice a patent or covenant not to"]
[null,"sue for patent infringement).  To \"grant\" such a patent license to a"]
[null,"party means to make such an agreement or commitment not to enforce a"]
[null,"patent against the party."]
[]
[null,"  If you convey a covered work, knowingly relying on a patent license,"]
[null,"and the Corresponding Source of the work is not available for anyone"]
[null,"to copy, free of charge and under the terms of this License, through a"]
[null,"publicly available network server or other readily accessible means,"]
[null,"then you must either (1) cause the Corresponding Source to be so"]
[null,"available, or (2) arrange to deprive yourself of the benefit of the"]
[null,"patent license for this particular work, or (3) arrange, in a manner"]
[null,"consistent with the requirements of this License, to extend the patent"]
[null,"license to downstream recipients.  \"Knowingly relying\" means you have"]
[null,"actual knowledge that, but for the patent license, your conveying the"]
[null,"covered work in a country, or your recipient's use of the covered work"]
[null,"in a country, would infringe one or more identifiable patents in that"]
[null,"country that you have reason to believe are valid."]
[]
[null,"  If, pursuant to or in connection with a single transaction or"]
[null,"arrangement, you convey, or propagate by procuring conveyance of, a"]
[null,"covered work, and grant a patent license to some of the parties"]
[null,"receiving the covered work authorizing them to use, propagate, modify"]
[null,"or convey a specific copy of the covered work, then the patent license"]
[null,"you grant is automatically extended to all recipients of the covered"]
[null,"work and works based on it."]
[]
[null,"  A patent license is \"discriminatory\" if it does not include within"]
[null,"the scope of its coverage, prohibits the exercise of, or is"]
[null,"conditioned on the non-exercise of one or more of the rights that are"]
[null,"specifically granted under this License.  You may not convey a covered"]
[null,"work if you are a party to an arrangement with a third party that is"]
[null,"in the business of distributing software, under which you make payment"]
[null,"to the third party based on the extent of your activity of conveying"]
[null,"the work, and under which the third party grants, to any of the"]
[null,"parties who would receive the covered work from you, a discriminatory"]
[null,"patent license (a) in connection with copies of the covered work"]
[null,"conveyed by you (or copies made from those copies), or (b) primarily"]
[null,"for and in connection with specific products or compilations that"]
[null,"contain the covered work, unless you entered into that arrangement,"]
[null,"or that patent license was granted, prior to 28 March 2007."]
[]
[null,"  Nothing in this License shall be construed as excluding or limiting"]
[null,"any implied license or other defenses to infringement that may"]
[null,"otherwise be available to you under applicable patent law."]
[]
[null,"  12. No Surrender of Others' Freedom."]
[]
[null,"  If conditions are imposed on you (whether by court order, agreement or"]
[null,"otherwise) that contradict the conditions of this License, they do not"]
[null,"excuse you from the conditions of this License.  If you cannot convey a"]
[null,"covered work so as to satisfy simultaneously your obligations under this"]
[null,"License and any other pertinent obligations, then as a consequence you may"]
[null,"not convey it at all.  For example, if you agree to terms that obligate you"]
[null,"to collect a royalty for further conveying from those to whom you convey"]
[null,"the Program, the only way you could satisfy both those terms and this"]
[null,"License would be to refrain entirely from conveying the Program."]
[]
[null,"  13. Use with the GNU Affero General Public License."]
[]
[null,"  Notwithstanding any other provision of this License, you have"]
[null,"permission to link or combine any covered work with a work licensed"]
[null,"under version 3 of the GNU Affero General Public License into a single"]
[null,"combined work, and to convey the resulting work.  The terms of this"]
[null,"License will continue to apply to the part which is the covered work,"]
[null,"but the special requirements of the GNU Affero General Public License,"]
[null,"section 13, concerning interaction through a network will apply to the"]
[null,"combination as such."]
[]
[null,"  14. Revised Versions of this License."]
[]
[null,"  The Free Software Foundation may publish revised and/or new versions of"]
[null,"the GNU General Public License from time to time.  Such new versions will"]
[null,"be similar in spirit to the present version, but may differ in detail to"]
[null,"address new problems or concerns."]
[]
[null,"  Each version is given a distinguishing version number.  If the"]
[null,"Program specifies that a certain numbered version of the GNU General"]
[null,"Public License \"or any later version\" applies to it, you have the"]
[null,"option of following the terms and conditions either of that numbered"]
[null,"version or of any later version published by the Free Software"]
[null,"Foundation.  If the Program does not specify a version number of the"]
[null,"GNU General Public License, you may choose any version ever published"]
[null,"by the Free Software Foundation."]
[]
[null,"  If the Program specifies that a proxy can decide which future"]
[null,"versions of the GNU General Public License can be used, that proxy's"]
[null,"public statement of acceptance of a version permanently authorizes you"]
[null,"to choose that version for the Program."]
[]
[null,"  Later license versions may give you additional or different"]
[null,"permissions.  However, no additional obligations are imposed on any"]
[null,"author or copyright holder as a result of your choosing to follow a"]
[null,"later version."]
[]
[null,"  15. Disclaimer of Warranty."]
[]
[null,"  THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY"]
[null,"APPLICABLE LAW.  EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT"]
[null,"HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM \"AS IS\" WITHOUT WARRANTY"]
[null,"OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO,"]
[null,"THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR"]
[null,"PURPOSE.  THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM"]
[null,"IS WITH YOU.  SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF"]
[null,"ALL NECESSARY SERVICING, REPAIR OR CORRECTION."]
[]
[null,"  16. Limitation of Liability."]
[]
[null,"  IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING"]
[null,"WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MODIFIES AND/OR CONVEYS"]
[null,"THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY"]
[null,"GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE"]
[null,"USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF"]
[null,"DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD"]
[null,"PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS),"]
[null,"EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF"]
[null,"SUCH DAMAGES."]
[]
[null,"  17. Interpretation of Sections 15 and 16."]
[]
[null,"  If the disclaimer of warranty and limitation of liability provided"]
[null,"above cannot be given local legal effect according to their terms,"]
[null,"reviewing courts shall apply local law that most closely approximates"]
[null,"an absolute waiver of all civil liability in connection with the"]
[null,"Program, unless a warranty or assumption of liability accompanies a"]
[null,"copy of the Program in return for a fee."]
[]
[null,"                     END OF TERMS AND CONDITIONS"]
[]
[null,"            How to Apply These Terms to Your New Programs"]
[]
[null,"  If you develop a new program, and you want it to be of the greatest"]
[null,"possible use to the public, the best way to achieve this is to make it"]
[null,"free software which everyone can redistribute and change under these terms."]
[]
[null,"  To do so, attach the following notices to the program.  It is safest"]
[null,"to attach them to the start of each source file to most effectively"]
[null,"state the exclusion of warranty; and each file should have at least"]
[null,"the \"copyright\" line and a pointer to where the full notice is found."]
[]
[null,"    <one line to give the program's name and a brief idea of what it does.>"]
[null,"    Copyright (C) <year>  <name of author>"]
[]
[null,"    This program is free software: you can redistribute it and/or modify"]
[null,"    it under the terms of the GNU General Public License as published by"]
[null,"    the Free Software Foundation, either version 3 of the License, or"]
[null,"    (at your option) any later version."]
[]
[null,"    This program is distributed in the hope that it will be useful,"]
[null,"    but WITHOUT ANY WARRANTY; without even the implied warranty of"]
[null,"    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the"]
[null,"    GNU General Public License for more details."]
[]
[null,"    You should have received a copy of the GNU General Public License"]
[null,"    along with this program.  If not, see <http://www.gnu.org/licenses/>."]
[]
[null,"Also add information on how to contact you by electronic and paper mail."]
[]
[null,"  If the program does terminal interaction, make it output a short"]
[null,"notice like this when it starts in an interactive mode:"]
[]
[null,"    <program>  Copyright (C) <year>  <name of author>"]
[null,"    This program comes with ABSOLUTELY NO WARRANTY; for details type `show w'."]
[null,"    This is free software, and you are welcome to redistribute it"]
[null,"    under certain conditions; type `show c' for details."]
[]
[null,"The hypothetical commands `show w' and `show c' should show the appropriate"]
[null,"parts of the General Public License.  Of course, your program's commands"]
[null,"might be different; for a GUI interface, you would use an \"about box\"."]
[]
[null,"  You should also get your employer (if you work as a programmer) or school,"]
[null,"if any, to sign a \"copyright disclaimer\" for the program, if necessary."]
[null,"For more information on this, and how to apply and follow the GNU GPL, see"]
[null,"<http://www.gnu.org/licenses/>."]
[]
[null,"  The GNU General Public License does not permit incorporating your program"]
[null,"into proprietary programs.  If your program is a subroutine library, you"]
[null,"may consider it more useful to permit linking proprietary applications with"]
[null,"the library.  If this is what you want to do, use the GNU Lesser General"]
[null,"Public License instead of this License.  But first, please read"]
[null,"<http://www.gnu.org/philosophy/why-not-lgpl.html>."]

{"sheet":"Correlations","index":1,"n_rows":30,"n_cols":36,"rows_kept":30,"cut":false,"hidden":false,"merged":[[13,2,13,3],[13,5,13,6],[13,7,13,8]]}
[null,null,null,"CIs for correlations",null,null,null,null,null,null,null,{"$f":"$F$11/10000","v":9.4999999999999998E-3},9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,"for C",95]
[null,null,null,"Enter up to 10 correlations (r), each",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$11/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,null,null,null,"CI calculations"]
[null,null,null,null,"with sample size (N)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"crit z",{"$f":"NORMSINV(0.5+F11/200)","v":1.9599639845400536}]
[null,null,null,"See a figure displaying correlations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,"OK?","r","trans r","SE z","trans LL","trans UL"]
[null,null,null,null,"and their approximate CIs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(AND(ISNUMBER(C16),ISNUMBER(D16))),FALSE,AND(C16>=-1,C16<=1,D16>3,D16=INT(D16)))","v":true},{"$f":"IF(AE5,IF(1-ABS(C16)<0.0000001,IF(C16>0,0.9999999,-0.9999999),C16),NA())","v":-0.9},{"$f":"0.5*LN((1+AF5)/(1-AF5))","v":-1.4722194895832204},{"$f":"IF(AE5,1/SQRT(D16-3),NA())","v":0.19245008972987526},{"$f":"AG5-AH5*$AH$3","v":-1.8494147342752776},{"$f":"AG5+AH5*$AH$3","v":-1.0950242448911631}]
[null,null,null,"CIs are calculated by using the ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(AND(ISNUMBER(C17),ISNUMBER(D17))),FALSE,AND(C17>=-1,C17<=1,D17>3,D17=INT(D17)))","v":true},0.9,{"$f":"0.5*LN((1+AF6)/(1-AF6))","v":1.4722194895832204},0.19245008972987526,{"$f":"AG6-AH6*$AH$3","v":1.0950242448911631},{"$f":"AG6+AH6*$AH$3","v":1.8494147342752776}]
[null,null,null,null,"Fisher r to z transformation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,true,0.6,0.69314718055994529,0.19245008972987526,0.31595193586788811,1.0703424252520024]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,true,0.3,0.30951960420311181,0.19245008972987526,-6.7675640488945366E-2,0.68671484889516898]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,true,0,0,0.19245008972987526,-0.37719524469205717,0.37719524469205717]
[null,1,"Level of confidence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,true,-0.9,-1.4722194895832204,9.2450032704204849E-2,-1.653418224053012,-1.2910207551134287]
[null,null,null,null,"C",{"$f":"IF(AF1<100,AF1,99+(AF1-99)/10)","v":95},null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,true,0.9,1.4722194895832204,9.2450032704204849E-2,1.2910207551134287,1.653418224053012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,true,0.6,0.69314718055994529,9.2450032704204849E-2,0.51194844609015366,0.87434591502973691]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,true,0.3,0.30951960420311181,9.2450032704204849E-2,0.12832086973332021,0.49071833867290338]
[null,2,"Input",null,null,"3      CI limits",null,"4      CI bars",null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,true,0,0,9.2450032704204849E-2,-0.18119873446979159,0.18119873446979159]
[null,null,"r","N",null,"LL","UL","Left","Right","MOEav",null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,1,-0.9,30,null,{"$f":"IF(AE5,(EXP(2*AI5)-1)/(EXP(2*AI5)+1),\"\")","v":-0.95169080633943559},{"$f":"IF(AE5,(EXP(2*AJ5)-1)/(EXP(2*AJ5)+1),\"\")","v":-0.79870459141317485},{"$f":"IF(AE5,AG18,\"\")","v":5.1690806339435569E-2},{"$f":"IF(AE5,AH18,\"\")","v":0.10129540858682518},{"$f":"IF(AE5,(AG18+AH18)/2,\"\")","v":7.6493107463130372E-2},null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,"For display"]
[null,2,0.9,30,null,0.79870459141317474,0.95169080633943559,0.10129540858682529,5.1690806339435569E-2,{"$f":"IF(AE6,(AG19+AH19)/2,\"\")","v":7.6493107463130428E-2},null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,"r","y","L bars","R bars"]
[null,3,0.6,30,null,0.30584206780820467,0.78959019513363871,0.29415793219179531,0.18959019513363873,0.24187406366271702,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE5,C16,NA())","v":-0.9},1,{"$f":"IF(ISNA(AE18),NA(),C16-F16)","v":5.1690806339435569E-2},{"$f":"IF(ISNA(AE18),NA(),G16-C16)","v":0.10129540858682518}]
[null,4,0.3,30,null,-6.7572511445785133E-2,0.59586741543673793,0.36757251144578512,0.29586741543673795,0.33171996344126153,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,0.9,2,0.10129540858682529,5.1690806339435569E-2]
[null,5,0,30,null,-0.36026922259556438,0.36026922259556432,0.36026922259556438,0.36026922259556432,0.36026922259556438,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,0.6,3,0.29415793219179531,0.18959019513363873]
[null,6,-0.9,120,null,-0.92932519579828821,-0.85939364127205664,2.9325195798288184E-2,4.0606358727943381E-2,3.4965777263115783E-2,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,0.3,4,0.36757251144578512,0.29586741543673795]
[null,7,0.9,120,null,0.85939364127205675,0.92932519579828832,4.060635872794327E-2,2.9325195798288295E-2,3.4965777263115783E-2,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,0,5,0.36026922259556438,0.36026922259556432]
[null,8,0.6,120,null,0.47146194290076626,0.70357545505648966,0.12853805709923372,0.10357545505648968,0.1160567560778617,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,-0.9,6,2.9325195798288184E-2,4.0606358727943381E-2]
[null,9,0.3,120,null,0.12762115704268967,0.45478638299694135,0.17237884295731032,0.15478638299694136,0.16358261297712584,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,0.9,7,4.060635872794327E-2,2.9325195798288295E-2]
[null,10,0,120,null,-0.17924133908238282,0.17924133908238285,0.17924133908238282,0.17924133908238285,0.17924133908238282,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,0.6,8,0.12853805709923372,0.10357545505648968]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,0.3,9,0.17237884295731032,0.15478638299694136]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,0,10,0.17924133908238282,0.17924133908238285]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]

{"sheet":"Diff correlations","index":2,"n_rows":30,"n_cols":59,"rows_kept":30,"cut":false,"hidden":false,"merged":[[14,2,14,3],[14,6,14,7],[14,10,14,11],[14,12,14,13]]}
[null,null,null,"CIs for differences between two independent correlations",null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$9/1000000","v":9.5000000000000005E-5},{"$f":"$P$1","v":9.5000000000000005E-5},9.5000000000000005E-5,9.5000000000000005E-5,9.5000000000000005E-5,9.5000000000000005E-5,9.5000000000000005E-5,9.5000000000000005E-5,9.5000000000000005E-5,9.5000000000000005E-5,9.5000000000000005E-5,9.5000000000000005E-5,9.5000000000000005E-5,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,"for C",95]
[null,null,null,"Enter up to 10 pairs of independent correlations (r1 and r2), each",null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$1","v":9.5000000000000005E-5},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$1","v":9.5000000000000005E-5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CI calculations"]
[null,null,null,null,"with sample size (N1 and N2)",null,null,null,null,null,null,null,null,null,null,{"$f":"$P$1","v":9.5000000000000005E-5},null,"Mark zero?",false,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"crit z",{"$f":"NORMSINV(0.5+G9/200)","v":1.9599639845400536}]
[null,null,null,"See a figure displaying differences (r2 - r1) between correlations",null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,"For vertical",{"$f":"IF(S3,0,NA())","v":{"$error":"#N/A"}},1,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,"r1 OK?","r2 OK?","bothOK?","r1","z1","SE z1","LL (z1)","UL (z1)","LL (r1)","UL (r1)","r2","z2","SE z2","LL (z2)","UL (z2)","LL (r2)","UL (r2)","Lldiff","Uldiff"]
[null,null,null,null,"and the approximate CI on the difference.",null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(AND(ISNUMBER(C17),ISNUMBER(D17))),FALSE,AND(C17>=-1,C17<=1,D17>3,D17=INT(D17)))","v":true},{"$f":"IF(NOT(AND(ISNUMBER(G17),ISNUMBER(H17))),FALSE,AND(G17>=-1,G17<=1,H17>3,H17=INT(H17)))","v":true},{"$f":"AND(AO5,AP5)","v":true},{"$f":"IF(AO5,IF(1-ABS(C17)<0.0000001,IF(C17>0,0.9999999,-0.9999999),C17),NA())","v":0.36},{"$f":"0.5*LN((1+AR5)/(1-AR5))","v":0.37688590118818999},{"$f":"IF(AO5,1/SQRT(D17-3),NA())","v":0.10910894511799619},{"$f":"AS5-AT5*$AT$3","v":0.16303629836576014},{"$f":"AS5+AT5*$AT$3","v":0.59073550401061981},{"$f":"(EXP(2*AU5)-1)/(EXP(2*AU5)+1)","v":0.1616069468277449},{"$f":"(EXP(2*AV5)-1)/(EXP(2*AV5)+1)","v":0.53042438366075562},{"$f":"IF(AP5,IF(1-ABS(G17)<0.0000001,IF(G17>0,0.9999999,-0.9999999),G17),NA())","v":0.49},{"$f":"0.5*LN((1+AY5)/(1-AY5))","v":0.53606033661056662},{"$f":"IF(AP5,1/SQRT(H17-3),NA())","v":8.3918135829668908E-2},{"$f":"AZ5-BA5*$AT$3","v":0.37158381273467533},{"$f":"AZ5+BA5*$AT$3","v":0.70053686048645791},{"$f":"(EXP(2*BB5)-1)/(EXP(2*BB5)+1)","v":0.3553762800034711},{"$f":"(EXP(2*BC5)-1)/(EXP(2*BC5)+1)","v":0.60470843315982648},{"$f":"J17-SQRT((AY5-BD5)^2+(AX5-AR5)^2)","v":-8.7181989427881051E-2},{"$f":"J17+SQRT((BE5-AY5)^2+(AR5-AW5)^2)","v":0.3591676857346856}]
[null,null,null,"CIs are calculated by using the method of Zou (2007).",null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,true,true,{"$f":"AND(AO6,AP6)","v":true},0.49,0.53606033661056662,8.3918135829668908E-2,0.37158381273467533,0.70053686048645791,{"$f":"(EXP(2*AU6)-1)/(EXP(2*AU6)+1)","v":0.3553762800034711},{"$f":"(EXP(2*AV6)-1)/(EXP(2*AV6)+1)","v":0.60470843315982648},0.36,0.37688590118818999,0.10910894511799619,{"$f":"AZ6-BA6*$AT$3","v":0.16303629836576014},{"$f":"AZ6+BA6*$AT$3","v":0.59073550401061981},{"$f":"(EXP(2*BB6)-1)/(EXP(2*BB6)+1)","v":0.1616069468277449},{"$f":"(EXP(2*BC6)-1)/(EXP(2*BC6)+1)","v":0.53042438366075562},-0.3591676857346856,8.7181989427881051E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0.2,0.20273255405408211,0.19245008972987526,-0.17446269063797507,0.57992779874613931,-0.17271392488555382,0.52261295032889143,0.6,0.69314718055994529,0.19245008972987526,0.31595193586788811,1.0703424252520024,0.30584206780820467,0.78959019513363871,-3.6586766624075118E-2,0.81816278157483779]
[null,1,"Level of confidence",null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0.2,0.20273255405408211,0.10153461651336192,3.7283625038069534E-3,0.40173674560435724,3.7283452283029652E-3,0.38143400771884722,0.6,0.69314718055994529,0.10153461651336192,0.49414298900967013,0.89215137211022044,0.45749847601920207,0.7124547098558921,0.16929459587219756,0.6262048280554442]
[null,null,null,null,null,"C",{"$f":"IF(AP1<100,AP1,99+(AP1-99)/10)","v":95},null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0.99999990000000005,8.4056213910223097,1,6.4456574064822565,10.365585375562363,0.999994960330998,0.99999999801574746,-0.99999990000000005,-8.4056213910223097,1,-10.365585375562363,-6.4456574064822565,-0.99999999801574757,-0.999994960330998,-2.0000001386151993,-1.9999930142531037]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,true,true,true,-0.3,-0.30951960420311175,0.11043152607484653,-0.52596141806760677,-9.3077790338616712E-2,-0.48228793103474293,-9.2809926182540387E-2,0.3,0.30951960420311181,9.4491118252306799E-2,0.12432041556967519,0.4947187928365484,0.12368386976575171,0.45795364135504224,0.32794282867517577,0.84120166379659267]
[null,2,"Mark zero",null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0,0,0.10153461651336192,-0.19900419155027516,0.19900419155027516,-0.19641811768205933,0.19641811768205936,0,0,0.10153461651336192,-0.19900419155027516,0.19900419155027516,-0.19641811768205933,0.19641811768205936,-0.27777716592176294,0.27777716592176294]
[null,null,null,"Display dotted vertical at zero",null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0,0,0.24253562503633297,-0.47536109003912352,0.47536109003912352,-0.44252078215149926,0.44252078215149931,0,0,0.24253562503633297,-0.47536109003912352,0.47536109003912352,-0.44252078215149926,0.44252078215149931,-0.62581889175060013,0.62581889175060013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0.9,1.4722194895832204,0.10153461651336192,1.2732152980329452,1.6712236811334955,0.85466670526166133,0.93171328499056583,0.7,0.86730052769405319,0.10153461651336192,0.66829633614377804,1.0663047192443282,0.58385809839391167,0.78806495335730942,-0.3203938277220687,-0.10095181161849469]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,false,false,false,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,3,"Input",null,null,null,"Input",null,null,"Diff","4      CI limits",null,"5      CI bars",null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5]
[null,null,"r1","N1",null,null,"r2","N2",null,"r2 - r1","LLdiff","ULdiff","Left","Right","MOEav",9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,"For display"]
[null,1,0.36,87,null,1,0.49,145,null,{"$f":"IF(AQ5,G17-C17,\"\")","v":0.13},{"$f":"IF(AQ5,BF5,\"\")","v":-8.7181989427881051E-2},{"$f":"IF(AQ5,BG5,\"\")","v":0.3591676857346856},{"$f":"IF(AQ5,AQ18,\"\")","v":0.21718198942788106},{"$f":"IF(AQ5,AR18,\"\")","v":0.2291676857346856},{"$f":"IF(AQ5,(AQ18+AR18)/2,\"\")","v":0.22317483758128331},9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$1","v":9.5000000000000005E-5},null,null,null,null,null,null,null,null,null,null,null,"r","y","L bars","R bars"]
[null,2,0.49,145,null,2,0.36,87,null,-0.13,-0.3591676857346856,8.7181989427881051E-2,0.2291676857346856,0.21718198942788106,0.22317483758128331,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AQ5,J17,NA())","v":0.13},1,{"$f":"IF(ISNA(AO18),NA(),J17-K17)","v":0.21718198942788106},{"$f":"IF(ISNA(AO18),NA(),L17-J17)","v":0.2291676857346856}]
[null,3,0.2,30,null,3,0.6,30,null,0.39999999999999997,-3.6586766624075118E-2,0.81816278157483779,0.43658676662407508,0.41816278157483783,0.42737477409945646,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,-0.13,2,0.2291676857346856,0.21718198942788106]
[null,4,0.2,100,null,4,0.6,100,null,0.39999999999999997,0.16929459587219756,0.6262048280554442,0.23070540412780241,0.22620482805544423,0.22845511609162333,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,0.39999999999999997,3,0.43658676662407508,0.41816278157483783]
[null,5,1,4,null,5,-1,4,null,-2,-2.0000001386151993,-1.9999930142531037,1.3861519931879229E-7,6.9857468962819524E-6,3.5621810478003724E-6,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,0.39999999999999997,4,0.23070540412780241,0.22620482805544423]
[null,6,-0.3,85,null,6,0.3,115,null,0.6,0.32794282867517577,0.84120166379659267,0.27205717132482421,0.24120166379659269,0.25662941756070845,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,-2,5,1.3861519931879229E-7,6.9857468962819524E-6]
[null,7,0,100,null,7,0,100,null,0,-0.27777716592176294,0.27777716592176294,0.27777716592176294,0.27777716592176294,0.27777716592176294,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,0.6,6,0.27205717132482421,0.24120166379659269]
[null,8,0,20,null,8,0,20,null,0,-0.62581889175060013,0.62581889175060013,0.62581889175060013,0.62581889175060013,0.62581889175060013,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,0,7,0.27777716592176294,0.27777716592176294]
[null,9,0.9,100,null,9,0.7,100,null,-0.20000000000000007,-0.3203938277220687,-0.10095181161849469,0.12039382772206864,9.9048188381505378E-2,0.109721008051787,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,0,8,0.62581889175060013,0.62581889175060013]
[null,10,null,null,null,10,null,null,null,"","","","","","",9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,-0.20000000000000007,9,0.12039382772206864,9.9048188381505378E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},10,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5,null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$1","v":9.5000000000000005E-5},null,null,null,null,null,null,null,null,null,null,null,null,9.5000000000000005E-5]

{"sheet":"Proportions","index":3,"n_rows":30,"n_cols":38,"rows_kept":30,"cut":false,"hidden":false,"merged":[[13,2,13,3],[13,6,13,7],[13,8,13,9]]}
[null,null,null,"CIs for proportions",null,null,null,null,null,null,null,null,{"$f":"$G$11/10000","v":9.4999999999999998E-3},9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,null,null,null,null,null,null,null,null,"for C",95]
[null,null,null,"Enter up to 10 proportions (P), each",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$11/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,null,null,"CI calculations"]
[null,null,null,null,"being x/N, where x and N are integers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,"crit z",{"$f":"NORMSINV(0.5+G11/200)","v":1.9599639845400536}]
[null,null,null,"See a figure displaying proportions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,"OK?","P","Q","A","B","C","LL","UL"]
[null,null,null,null,"and their approximate CIs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(AND(ISNUMBER(C16),ISNUMBER(D16))),FALSE,AND(C16=INT(C16),C16>-0.5,C16<D16+0.5,D16=INT(D16),D16>C16-0.5,D16>0.5))","v":true},{"$f":"IF(AE5,C16/D16,NA())","v":0},{"$f":"IF(AE5,1-AF5,NA())","v":1},{"$f":"IF(AE5,2*C16+$AH$3^2,NA())","v":3.8414588206941236},{"$f":"IF(AE5,$AH$3*SQRT($AH$3^2+4*C16*AG5),NA())","v":3.8414588206941236},{"$f":"IF(AE5,2*(D16+$AH$3^2),NA())","v":21.682917641388247},{"$f":"(AH5-AI5)/AJ5","v":0},{"$f":"(AH5+AI5)/AJ5","v":0.35433043506668732}]
[null,null,null,"CIs are calculated by using the method recommended ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,true,0,{"$f":"IF(AE6,1-AF6,NA())","v":1},3.8414588206941236,3.8414588206941236,63.682917641388244,{"$f":"(AH6-AI6)/AJ6","v":0},{"$f":"(AH6+AI6)/AJ6","v":0.1206433047658456}]
[null,null,null,null,"by Newcombe and Altman (2000)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,true,1,0,59.841458820694122,3.8414588206941236,63.682917641388244,0.8793566952341545,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,true,0.8571428571428571,0.1428571428571429,15.841458820694124,5.2846496409652604,21.682917641388247,0.48687217072568117,0.97432037565525653]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,true,0.14285714285714285,0.85714285714285721,5.8414588206941236,5.2846496409652604,21.682917641388247,2.5679624344743558E-2,0.51312782927431888]
[null,1,"Level of confidence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,true,0.14285714285714285,0.85714285714285721,11.841458820694124,8.2121659565397813,63.682917641388244,5.6990053197493958E-2,0.31489802163525293]
[null,null,null,null,null,"C",{"$f":"IF(AF1<100,AF1,99+(AF1-99)/10)","v":95},null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,true,0.14285714285714285,0.85714285714285721,35.841458820694122,15.016266552566844,231.68291764138826,8.9886610891018182E-2,0.21951435129965596]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,true,0.42857142857142855,0.5714285714285714,9.8414588206941236,6.4107907300441349,21.682917641388247,0.15821985525146975,0.74954163547234276]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,true,0.42857142857142855,0.5714285714285714,27.841458820694122,10.960042587709832,63.682917641388244,0.26508547124123705,0.60929214372531226]
[null,2,"Input",null,null,"3 Proportion","4      CI limits",null,"5      CI bars",null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,true,0.42857142857142855,0.5714285714285714,99.841458820694129,20.885873610753915,231.68291764138826,0.34079156984785591,0.52108862259027899]
[null,null,"x","N",null,"P","LL","UL","Left","Right","MOEav",null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,1,0,7,null,{"$f":"IF(AE5,C16/D16,\"\")","v":0},{"$f":"IF(AE5,AK5,\"\")","v":0},{"$f":"IF(AE5,AL5,\"\")","v":0.35433043506668732},{"$f":"IF(AE5,AG18,\"\")","v":0},{"$f":"IF(AE5,AH18,\"\")","v":0.35433043506668732},{"$f":"IF(AE5,(AG18+AH18)/2,\"\")","v":0.17716521753334366},null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,"For display"]
[null,2,0,28,null,0,0,0.1206433047658456,0,0.1206433047658456,{"$f":"IF(AE6,(AG19+AH19)/2,\"\")","v":6.0321652382922801E-2},null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,"P","y","L bars","R bars"]
[null,3,28,28,null,1,0.8793566952341545,1,0.1206433047658455,0,6.0321652382922752E-2,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,{"$f":"IF(AE5,AF5,NA())","v":0},1,{"$f":"IF(ISNA(AE18),NA(),AE18-AK5)","v":0},{"$f":"IF(ISNA(AE18),NA(),AL5-AE18)","v":0.35433043506668732}]
[null,4,6,7,null,0.8571428571428571,0.48687217072568117,0.97432037565525653,0.37027068641717592,0.11717751851239944,0.24372410246478768,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,{"$f":"IF(AE6,AF6,NA())","v":0},2,{"$f":"IF(ISNA(AE19),NA(),AE19-AK6)","v":0},{"$f":"IF(ISNA(AE19),NA(),AL6-AE19)","v":0.1206433047658456}]
[null,5,1,7,null,0.14285714285714285,2.5679624344743558E-2,0.51312782927431888,0.1171775185123993,0.37027068641717603,0.24372410246478765,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,1,3,0.1206433047658455,0]
[null,6,4,28,null,0.14285714285714285,5.6990053197493958E-2,0.31489802163525293,8.5867089659648899E-2,0.17204087877811008,0.12895398421887949,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,0.8571428571428571,4,0.37027068641717592,0.11717751851239944]
[null,7,16,112,null,0.14285714285714285,8.9886610891018182E-2,0.21951435129965596,5.2970531966124668E-2,7.6657208442513114E-2,6.4813870204318891E-2,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,0.14285714285714285,5,0.1171775185123993,0.37027068641717603]
[null,8,3,7,null,0.42857142857142855,0.15821985525146975,0.74954163547234276,0.27035157331995879,0.32097020690091421,0.2956608901104365,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,0.14285714285714285,6,8.5867089659648899E-2,0.17204087877811008]
[null,9,12,28,null,0.42857142857142855,0.26508547124123705,0.60929214372531226,0.1634859573301915,0.18072071515388372,0.17210333624203761,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,0.14285714285714285,7,5.2970531966124668E-2,7.6657208442513114E-2]
[null,10,48,112,null,0.42857142857142855,0.34079156984785591,0.52108862259027899,8.7779858723572635E-2,9.2517194018850446E-2,{"$f":"IF(AE14,(AG27+AH27)/2,\"\")","v":9.014852637121154E-2},null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,0.42857142857142855,8,0.27035157331995879,0.32097020690091421]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,0.42857142857142855,9,0.1634859573301915,0.18072071515388372]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,0.42857142857142855,10,8.7779858723572635E-2,9.2517194018850446E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]

{"sheet":"Diff proportions","index":4,"n_rows":35,"n_cols":54,"rows_kept":35,"cut":false,"hidden":false,"merged":[[23,2,23,3],[23,7,23,8],[23,12,23,13],[23,14,23,15]]}
[null,null,null,"CIs for differences between two independent proportions",null,null,null,null,null,null,null,null,null,{"$f":"$H$11/10000","v":9.4999999999999998E-3},9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"for C",95]
[null,null,null,"Enter up to 10 pairs of independent proportions (P1, P2), each",null,null,null,null,null,null,null,null,null,{"$f":"$H$11/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,{"$f":"$H$11/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,"CI calculations"]
[null,null,null,null,"being x/N, where x and N are integers",null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,"Mark zero?",true,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,"crit z",{"$f":"NORMSINV(0.5+H11/200)","v":1.9599639845400536}]
[null,null,null,"See a figure displaying differences (P2 - P1) between ",null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,"For vertical",{"$f":"IF(Q3,0,NA())","v":0},1,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"p1 OK?","p2 OK?","all OK?","p1","q1","A1","B1","C1","LL1","UL1","p2","q2","A2","B2","C2","LL2","UL2","D","LLD","ULD"]
[null,null,null,null,"proportions and the approximate CIs on differences",null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(AND(ISNUMBER(C26),ISNUMBER(D26))),FALSE,AND(C26=INT(C26),C26>-0.5,C26<D26+0.5,D26=INT(D26),D26>C26-0.5,D26>0.5))","v":true},{"$f":"IF(NOT(AND(ISNUMBER(H26),ISNUMBER(I26))),FALSE,AND(H26=INT(H26),H26>-0.5,H26<I26+0.5,I26=INT(I26),I26>H26-0.5,I26>0.5))","v":true},{"$f":"AND(AI5,AJ5)","v":true},{"$f":"IF(AK5,C26/D26,NA())","v":0.14285714285714285},{"$f":"IF(AK5,1-AL5,NA())","v":0.85714285714285721},{"$f":"IF(AK5,2*C26+$AL$3^2,NA())","v":11.841458820694124},{"$f":"IF(AK5,$AL$3*SQRT($AL$3^2+4*C26*AM5),NA())","v":8.2121659565397813},{"$f":"IF(AK5,2*(D26+$AL$3^2),NA())","v":63.682917641388244},{"$f":"(AN5-AO5)/AP5","v":5.6990053197493958E-2},{"$f":"(AN5+AO5)/AP5","v":0.31489802163525293},{"$f":"IF(AK5,H26/I26,NA())","v":0.42857142857142855},{"$f":"IF(AK5,1-AS5,NA())","v":0.5714285714285714},{"$f":"IF(AK5,2*H26+$AL$3^2,NA())","v":27.841458820694122},{"$f":"IF(AK5,$AL$3*SQRT($AL$3^2+4*H26*AT5),NA())","v":10.960042587709832},{"$f":"IF(AK5,2*(I26+$AL$3^2),NA())","v":63.682917641388244},{"$f":"(AU5-AV5)/AW5","v":0.26508547124123705},{"$f":"(AU5+AV5)/AW5","v":0.60929214372531226},{"$f":"IF(AK5,AS5-AL5,NA())","v":0.2857142857142857},{"$f":"IF(AK5,AZ5-SQRT((AS5-AX5)^2+(AR5-AL5)^2),NA())","v":4.8383878444349965E-2},{"$f":"IF(AK5,AZ5+SQRT((AL5-AQ5)^2+(AY5-AS5)^2),NA())","v":0.48579710349819577}]
[null,null,null,"CIs are calculated by using the method recommended ",null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(AND(ISNUMBER(C27),ISNUMBER(D27))),FALSE,AND(C27=INT(C27),C27>-0.5,C27<D27+0.5,D27=INT(D27),D27>C27-0.5,D27>0.5))","v":true},{"$f":"IF(NOT(AND(ISNUMBER(H27),ISNUMBER(I27))),FALSE,AND(H27=INT(H27),H27>-0.5,H27<I27+0.5,I27=INT(I27),I27>H27-0.5,I27>0.5))","v":true},{"$f":"AND(AI6,AJ6)","v":true},0.55000000000000004,0.44999999999999996,25.841458820694122,9.5298316103083529,47.682917641388244,0.34208534245034239,0.74180214174437575,0.85,{"$f":"IF(AK6,1-AS6,NA())","v":0.15000000000000002},37.841458820694122,7.3443642231420379,47.682917641388244,{"$f":"(AU6-AV6)/AW6","v":0.63958113525924309},{"$f":"(AU6+AV6)/AW6","v":0.94763125410378335},{"$f":"IF(AK6,AS6-AL6,NA())","v":0.29999999999999993},{"$f":"IF(AK6,AZ6-SQRT((AS6-AX6)^2+(AR6-AL6)^2),NA())","v":1.5282314886274462E-2},{"$f":"IF(AK6,AZ6+SQRT((AL6-AQ6)^2+(AY6-AS6)^2),NA())","v":0.52969624855854502}]
[null,null,null,null,"by Newcombe and Altman (2000)",null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,true,true,true,1,0,17.841458820694122,3.8414588206941236,21.682917641388247,0.64566956493331262,0.99999999999999989,0,1,3.8414588206941236,3.8414588206941236,21.682917641388247,0,0.35433043506668732,-1,-1,-0.49890109316713149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,true,true,true,1,0,143.84145882069413,3.8414588206941236,147.68291764138826,0.947976937589733,1,0,1,3.8414588206941236,3.8414588206941236,147.68291764138826,0,5.2023062410266892E-2,-1,-1,-0.92642827958321849]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0.5,0.5,7.8414588206941236,5.4884097108238175,15.682917641388247,0.15003898915214955,0.84996101084785047,0.75,0.25,9.8414588206941236,5.1265175639191032,15.682917641388247,0.30064184258240201,0.95441273919029945,0.25,-0.31955725151330316,0.65528666034910488]
[null,1,"Level of confidence",null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0.1,0.9,23.841458820694122,12.371310497116994,207.68291764138826,5.5229137060675088E-2,0.17436566150491342,0.09,0.91,21.841458820694122,11.857613454529041,207.68291764138826,4.8072540002565153E-2,0.16226212852716304,-1.0000000000000009E-2,-9.5370741550603044E-2,7.5007325493795227E-2]
[null,null,null,null,null,null,"C",{"$f":"IF(AJ1<100,AJ1,99+(AJ1-99)/10)","v":95},null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0.3,0.7,63.841458820694122,18.36952222594249,207.68291764138826,0.21894885294932759,0.39584854633346667,0.33,0.66999999999999993,69.841458820694129,18.828048862621877,207.68291764138826,0.2456312273412804,0.4269465620490947,3.0000000000000027E-2,-9.7691165059206109E-2,0.15636425258501194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0.5,0.5,103.84145882069413,19.972548358697271,207.68291764138826,0.40383153036599567,0.59616846963400427,0.99,1.0000000000000009E-2,201.84145882069413,5.4743933728804528,207.68291764138826,0.94551380382129468,0.99823256793585935,0.49,0.38404059172401606,0.58652020372214797]
[null,2,"Mark zero",null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,true,true,true,0.7,0.30000000000000004,143.84145882069413,18.36952222594249,207.68291764138826,0.60415145366653333,0.78105114705067236,0.01,0.99,5.8414588206941236,5.4743933728804519,207.68291764138826,1.7674320641406511E-3,5.4486196178705294E-2,-0.69,-0.77146817546163815,-0.58433086787197996]
[null,null,null,"Display dotted vertical at zero",null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,false,false,false,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"For display"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H$11/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"D","y","L bars","R bars"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK5,AZ5,NA())","v":0.2857142857142857},1,{"$f":"IF(ISNA(AI18),NA(),AI18-BA5)","v":0.23733040726993573},{"$f":"IF(ISNA(AI18),NA(),BB5-AI18)","v":0.20008281778391007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,0.29999999999999993,2,{"$f":"IF(ISNA(AI19),NA(),AI19-BA6)","v":0.28471768511372547},0.22969624855854509]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,-1,3,0,0.50109890683286851]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,-1,4,0,7.3571720416781505E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,0.25,5,0.56955725151330316,0.40528666034910488]
[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,-1.0000000000000009E-2,6,8.5370741550603035E-2,8.5007325493795236E-2]
[null,3,"Input",null,null,"Prop'n",null,"Input",null,null,"Prop'n","Diff","4      CI limits",null,"5      CI bars",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.0000000000000027E-2,7,0.12769116505920614,0.12636425258501191]
[null,null,"x1","N1",null,"P1",null,"x2","N2",null,"P2","P2 - P1","LLdiff","ULdiff","Left","Right","MOEav",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49,8,0.10595940827598394,9.6520203722147979E-2]
[null,1,4,28,null,{"$f":"IF(AK5,C26/D26,\"\")","v":0.14285714285714285},null,12,28,null,{"$f":"IF(AK5,H26/I26,\"\")","v":0.42857142857142855},{"$f":"IF(AK5,K26-F26,\"\")","v":0.2857142857142857},{"$f":"IF(AK5,BA5,\"\")","v":4.8383878444349965E-2},{"$f":"IF(AK5,BB5,\"\")","v":0.48579710349819577},{"$f":"IF(AK5,AK18,\"\")","v":0.23733040726993573},{"$f":"IF(AK5,AL18,\"\")","v":0.20008281778391007},{"$f":"IF(AK5,(AK18+AL18)/2,\"\")","v":0.21870661252692292},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.69,9,8.1468175461638204E-2,0.10566913212801998]
[null,2,11,20,null,0.55000000000000004,null,17,20,null,0.85,{"$f":"IF(AK6,K27-F27,\"\")","v":0.29999999999999993},1.5282314886274462E-2,0.52969624855854502,0.28471768511372547,0.22969624855854509,{"$f":"IF(AK6,(AK19+AL19)/2,\"\")","v":0.25720696683613531},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},10,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,3,7,7,null,1,null,0,7,null,0,-1,-1,-0.49890109316713149,0,0.50109890683286851,0.25054945341643425]
[null,4,70,70,null,1,null,0,70,null,0,-1,-1,-0.92642827958321849,0,7.3571720416781505E-2,3.6785860208390753E-2]
[null,5,2,4,null,0.5,null,3,4,null,0.75,0.25,-0.31955725151330316,0.65528666034910488,0.56955725151330316,0.40528666034910488,0.48742195593120402]
[null,6,10,100,null,0.1,null,9,100,null,0.09,-1.0000000000000009E-2,-9.5370741550603044E-2,7.5007325493795227E-2,8.5370741550603035E-2,8.5007325493795236E-2,8.5189033522199142E-2]
[null,7,30,100,null,0.3,null,33,100,null,0.33,3.0000000000000027E-2,-9.7691165059206109E-2,0.15636425258501194,0.12769116505920614,0.12636425258501191,0.12702770882210901]
[null,8,50,100,null,0.5,null,99,100,null,0.99,0.49,0.38404059172401606,0.58652020372214797,0.10595940827598394,9.6520203722147979E-2,0.10123980599906596]
[null,9,70,100,null,0.7,null,1,100,null,0.01,-0.69,-0.77146817546163815,-0.58433086787197996,8.1468175461638204E-2,0.10566913212801998,9.3568653794829093E-2]
[null,10,null,null,null,"",null,null,null,null,"","","","","","",""]

{"sheet":"Means","index":5,"n_rows":35,"n_cols":40,"rows_kept":35,"cut":false,"hidden":false,"merged":[[23,2,23,3],[23,8,23,9],[23,12,23,13]]}
[null,null,null,"CIs for single means",null,null,null,null,null,null,null,null,{"$f":"$F$8/10000","v":9.4999999999999998E-3},9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,"for C",95]
[null,null,null,"Enter up to 10 means (M), each with its ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$8/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,null,null,null,null,"CI calculations"]
[null,null,null,null,"sample size N, AND either SD OR SE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,"Blank if:",null,"Block entry if:",null,"mean","SD &","all"]
[null,null,null,"See a figure displaying the means ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,"SD grey","SE grey","SD grey","SE grey","& n OK?","SE OK?","OK?","SE"]
[null,null,null,null,"and their CIs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J26),\"\",-1)","v":-1},{"$f":"IF(ISNUMBER(I26),\"\",-1)","v":""},{"$f":"IF(AG5=\"\",9.99999999999999E+29,0)","v":0},{"$f":"IF(AH5=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(NOT(AND(ISNUMBER(C26),ISNUMBER(D26))),FALSE,AND(D26=INT(D26),D26>1.5))","v":true},{"$f":"IF(NOT(OR(AND(ISNUMBER(I26),J26=\"\"),AND(ISNUMBER(J26),I26=\"\"))),FALSE,OR(I26>0,J26>0))","v":true},{"$f":"AND(AK5,AL5)","v":true},{"$f":"IF(AM5,IF(ISNUMBER(J26),J26,I26/SQRT(D26)),NA())","v":8.4852813742385695}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(J27),\"\",-1)","v":-1},{"$f":"IF(ISNUMBER(I27),\"\",-1)","v":""},{"$f":"IF(AG6=\"\",9.99999999999999E+29,0)","v":0},{"$f":"IF(AH6=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(NOT(AND(ISNUMBER(C27),ISNUMBER(D27))),FALSE,AND(D27=INT(D27),D27>1.5))","v":true},{"$f":"IF(NOT(OR(AND(ISNUMBER(I27),J27=\"\"),AND(ISNUMBER(J27),I27=\"\"))),FALSE,OR(I27>0,J27>0))","v":true},{"$f":"AND(AK6,AL6)","v":true},3.1980107453341562]
[null,1,"Level of confidence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,"",-1,9.9999999999999903E+29,0,true,true,true,22]
[null,null,null,null,"C",{"$f":"IF(AH1<100,AH1,99+(AH1-99)/10)","v":95},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,"",-1,9.9999999999999903E+29,0,true,true,true,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,"",-1,9.9999999999999903E+29,0,true,true,true,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,-1,-1,0,0,true,false,false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,"",-1,9.9999999999999903E+29,0,true,true,true,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,-1,"",0,9.9999999999999903E+29,true,true,true,9.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,-1,-1,0,0,false,false,false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,-1,"",0,9.9999999999999903E+29,true,true,true,2.9755097944025266]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,"For display"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$8/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,null,null,"D","y","L bars","R bars"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AM5,C26,NA())","v":32},1,{"$f":"IF(AM5,L26,NA())","v":107.81572238512503},{"$f":"IF(AM5,L26,NA())","v":107.81572238512503}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,55,2,6.6506274215847982,6.6506274215847982]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,22,3,45.751504584008956,45.751504584008956]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,33,4,34.283767386873023,34.283767386873023]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,102,5,35.006909358120787,35.006909358120787]
[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,{"$error":"#N/A"},6,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2,"Input",null,null,null,null,null,"3        Input",null,null,"Bars","4      CI limits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,7,13.889518661104916,13.889518661104916]
[null,null,"M","N",null,"df","tcrit",null,"SD","SE",null,"MOE","LL","UL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,8,19.643747820705524,19.643747820705524]
[null,1,32,2,null,{"$f":"IF(ISNUMBER(D26),D26-1,\"\")","v":1},{"$f":"IF(ISNUMBER(D26),TINV(1-$F$8/100,F26),\"\")","v":12.706204736174694},null,12,null,null,{"$f":"IF(AM5,G26*AN5,\"\")","v":107.81572238512503},{"$f":"IF(AM5,C26-L26,\"\")","v":-75.815722385125028},{"$f":"IF(AM5,C26+L26,\"\")","v":139.81572238512501},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},9,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2,55,22,null,{"$f":"IF(ISNUMBER(D27),D27-1,\"\")","v":21},{"$f":"IF(ISNUMBER(D27),TINV(1-$F$8/100,F27),\"\")","v":2.07961384472768},null,15,null,null,6.6506274215847982,48.349372578415199,61.650627421584801,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,10,5.8903188274350491,5.8903188274350491]
[null,3,22,22,null,21,2.07961384472768,null,null,22,null,45.751504584008956,-23.751504584008956,67.751504584008956]
[null,4,33,44,null,43,2.0166921992278248,null,null,17,null,34.283767386873023,-1.2837673868730235,67.283767386873023]
[null,5,102,4,null,3,3.1824463052837078,null,null,11,null,35.006909358120787,66.993090641879206,137.00690935812079]
[null,6,10,100,null,99,1.9842169515864165,null,null,null,null,"","",""]
[null,7,30,100,null,99,1.9842169515864165,null,null,7,null,13.889518661104916,16.110481338895084,43.889518661104916]
[null,8,50,100,null,99,1.9842169515864165,null,99,null,null,19.643747820705524,30.356252179294476,69.643747820705528]
[null,9,null,null,null,"","",null,null,null,null,"","",""]
[null,10,45,123,null,122,1.9795998784866402,null,33,null,null,5.8903188274350491,39.109681172564947,50.890318827435053]

{"sheet":"Paired means","index":6,"n_rows":35,"n_cols":51,"rows_kept":35,"cut":false,"hidden":false,"merged":[[23,13,23,16],[23,19,23,20],[23,2,23,4],[23,7,23,9]]}
[null,null,null,"CIs for mean differences",null,null,null,null,null,null,null,null,null,null,{"$f":"$G$13/10000","v":9.4999999999999998E-3},9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,"CI calculations"]
[null,null,null,"Enter data for up to 10 paired experiments.  (In each experiment,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$13/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,"Blank if:",null,"Block entry if:",null,null,null,"Blank if:",null,null,null,"Block entry if:",null,null,null,null,"All 4 at"]
[null,null,null,null,"there is a single repeated measure.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,"Md grey","1&2grey","Md grey","1&2grey","Md OK?","n OK?","SDdgrey","SEdgrey","t grey","p grey","SDdgrey","SEdgrey","t grey","p greyL","p greyU","4 OK?","All OK?","SEd"]
[null,null,null,"For each experiment, enter:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(E26),ISNUMBER(D26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(ISNUMBER(C26),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(AH4=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":9.9999999999999903E+29},{"$f":"IF(AI4=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":-9.9999999999999903E+29},{"$f":"OR(ISNUMBER(C26),AND(ISNUMBER(D26),ISNUMBER(E26)))","v":true},{"$f":"IF(NOT(ISNUMBER(I26)),FALSE,AND(I26=INT(I26),I26>1.5))","v":true},{"$f":"IF(OR(ISNUMBER(O26),ISNUMBER(P26),ISNUMBER(Q26)),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(OR(ISNUMBER(N26),ISNUMBER(P26),ISNUMBER(Q26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O26),ISNUMBER(N26),ISNUMBER(Q26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O26),ISNUMBER(P26),ISNUMBER(N26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(AN4=\"\",9.99999999999999E+29,0)","v":0},{"$f":"IF(AO4=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(AP4=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":9.9999999999999903E+29},{"$f":"IF(AQ4=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(AQ4=\"\",9.99999999999999E+29,1)","v":9.9999999999999903E+29},{"$f":"IF(NOT(COUNT(N26:Q26)=1),FALSE,OR(AND(ISNUMBER(N26),N26>0),AND(ISNUMBER(O26),O26>0),ISNUMBER(P26),AND(ISNUMBER(Q26),Q26>=0,Q26<=1)))","v":true},{"$f":"AND(AL4,AM4,AW4)","v":true},{"$f":"IF(AX4,IF(ISNUMBER(N26),N26/SQRT(I26),IF(ISNUMBER(O26),O26,IF(ISNUMBER(P26),ABS(G26/P26),ABS(G26)/TINV(Q26,K26)))),NA())","v":6.9282032302755097}]
[null,null,null,null,"* the mean difference, OR the two sample means, AND  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(E27),ISNUMBER(D27)),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(ISNUMBER(C27),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(AH5=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":-9.9999999999999903E+29},{"$f":"IF(AI5=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":9.9999999999999903E+29},true,{"$f":"IF(NOT(ISNUMBER(I27)),FALSE,AND(I27=INT(I27),I27>1.5))","v":true},{"$f":"IF(OR(ISNUMBER(O27),ISNUMBER(P27),ISNUMBER(Q27)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(N27),ISNUMBER(P27),ISNUMBER(Q27)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O27),ISNUMBER(N27),ISNUMBER(Q27)),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(OR(ISNUMBER(O27),ISNUMBER(P27),ISNUMBER(N27)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(AN5=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(AO5=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(AP5=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":-9.9999999999999903E+29},{"$f":"IF(AQ5=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(AQ5=\"\",9.99999999999999E+29,1)","v":9.9999999999999903E+29},{"$f":"IF(NOT(COUNT(N27:Q27)=1),FALSE,OR(AND(ISNUMBER(N27),N27>0),AND(ISNUMBER(O27),O27>0),ISNUMBER(P27),AND(ISNUMBER(Q27),Q27>=0,Q27<=1)))","v":true},{"$f":"AND(AL5,AM5,AW5)","v":true},{"$f":"IF(AX5,IF(ISNUMBER(N27),N27/SQRT(I27),IF(ISNUMBER(O27),O27,IF(ISNUMBER(P27),ABS(G27/P27),ABS(G27)/TINV(Q27,K27)))),NA())","v":28.061224489795919}]
[null,null,null,null,"* N, the number of data pairs, AND ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,"",9.9999999999999903E+28,9.9999999999999903E+29,-9.9999999999999903E+29,true,true,"","","",9.9999999999999903E+28,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,true,true,7.5322303561104942]
[null,null,null,null,"* the SD OR SE of the differences, OR t OR p for testing ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.9999999999999903E+28,"",-9.9999999999999903E+29,9.9999999999999903E+29,true,false,"","","",9.9999999999999903E+28,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,true,false,{"$error":"#N/A"}]
[null,null,null,null,null,"a null hypothesis of zero difference.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.9999999999999903E+28,"",-9.9999999999999903E+29,9.9999999999999903E+29,true,true,9.9999999999999903E+28,"","","",0,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,true,true,4.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,"",9.9999999999999903E+28,9.9999999999999903E+29,-9.9999999999999903E+29,true,false,9.9999999999999903E+28,"","","",0,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,true,false,{"$error":"#N/A"}]
[null,null,null,"See a figure displaying the mean differences and their CIs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.9999999999999903E+28,"",-9.9999999999999903E+29,9.9999999999999903E+29,true,true,"","","",9.9999999999999903E+28,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,true,true,19.648970650004692]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,9.9999999999999903E+28,9.9999999999999903E+28,-9.9999999999999903E+29,-9.9999999999999903E+29,false,true,"",9.9999999999999903E+28,"","",9.9999999999999903E+29,0,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,true,false,{"$error":"#N/A"}]
[null,1,"Level of confidence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,"",9.9999999999999903E+28,9.9999999999999903E+29,-9.9999999999999903E+29,true,false,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,0,0,-9.9999999999999903E+29,0,1,false,false,{"$error":"#N/A"}]
[null,null,null,null,null,"C",{"$f":"IF(AI14<100,AI14,99+(AI14-99)/10)","v":95},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(E35),ISNUMBER(D35)),\"\",9.99999999999999E+28)","v":""},9.9999999999999903E+28,9.9999999999999903E+29,-9.9999999999999903E+29,true,false,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,0,0,-9.9999999999999903E+29,0,1,false,false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,"for C",95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,"For display"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$13/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,"Md","y","L bars","R bars"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,{"$f":"IF(AX4,G26,NA())","v":-11},1,{"$f":"IF(AX4,S26,NA())","v":29.80965254100396},{"$f":"IF(AX4,S26,NA())","v":29.80965254100396}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,55,2,58.356510948991023,58.356510948991023]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,-22,3,15.967615046873837,15.967615046873837]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,{"$error":"#N/A"},4,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,-92,5,14.321008373776685,14.321008373776685]
[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,{"$error":"#N/A"},6,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2,"Input",null,null,null,null,"3    Input",null,null,null,null,null,"4                        Input",null,null,null,null,"Bars","CI limits",null,null,null,null,null,null,null,null,null,null,null,null,null,30,7,38.987820644963278,38.987820644963278]
[null,null,"Md","M1","M2",null,"Md",null,"N",null,"df","tcrit",null,"SDd","SEd","t","p",null,"MOE","LL","UL","t","p",null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1,null,55,44,null,{"$f":"IF(AL4,IF(ISNUMBER(C26),C26,E26-D26),\"\")","v":-11},null,3,null,{"$f":"IF(ISNUMBER(I26),I26-1,\"\")","v":2},{"$f":"IF(ISNUMBER(I26),TINV(1-$G$13/100,K26),\"\")","v":4.3026527297494619},null,12,null,null,null,null,{"$f":"IF(AX4,AY4*L26,\"\")","v":29.80965254100396},{"$f":"IF(AX4,G26-S26,\"\")","v":-40.809652541003956},{"$f":"IF(AX4,G26+S26,\"\")","v":18.80965254100396},{"$f":"IF(AX4,IF(AY4>0,G26/AY4,\"\"),\"\")","v":-1.5877132402714706},{"$f":"IF(AX4,IF(AY4>0,TDIST(ABS(V26),K26,2),\"\"),\"\")","v":0.25327134336765633},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},9,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2,55,null,null,null,{"$f":"IF(AL5,IF(ISNUMBER(C27),C27,E27-D27),\"\")","v":55},null,22,null,21,2.07961384472768,null,null,null,1.96,null,null,58.356510948991023,-3.3565109489910228,113.35651094899103,{"$f":"IF(AX5,IF(AY5>0,G27/AY5,\"\"),\"\")","v":1.96},{"$f":"IF(AX5,IF(AY5>0,TDIST(ABS(V27),K27,2),\"\"),\"\")","v":6.3399665814220338E-2},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},10,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,3,null,22,0,null,-22,null,17,null,16,2.119905299221255,null,null,null,null,0.01,null,15.967615046873837,-37.967615046873838,-6.0323849531261633,-2.9207816224251002,9.9999999999999898E-3]
[null,4,33,null,null,null,33,null,null,null,"","",null,null,null,null,0.05,null,"","","","",""]
[null,5,-92,null,null,null,-92,null,4,null,3,3.1824463052837078,null,9,null,null,null,null,14.321008373776685,-106.32100837377669,-77.678991626223308,-20.444444444444443,2.5586851423793584E-4]
[null,6,null,-222,-220,null,2,null,null,null,"","",null,22,null,null,null,null,"","","","",""]
[null,7,30,null,null,null,30,null,100,null,99,1.9842169515864165,null,null,null,null,0.13,null,38.987820644963278,-8.9878206449632785,68.987820644963278,1.5267975373556191,0.12999999999999887]
[null,8,null,null,null,null,"",null,100,null,99,1.9842169515864165,null,null,7.7,null,null,null,"","","","",""]
[null,9,null,55,44,null,-11,null,null,null,"","",null,null,null,null,null,null,"","","","",""]
[null,10,null,33,22,null,-11,null,null,null,"","",null,null,null,null,null,null,"","","","",""]

{"sheet":"2 ind means same variance","index":7,"n_rows":35,"n_cols":61,"rows_kept":35,"cut":false,"hidden":false,"merged":[[23,14,23,19],[23,22,23,23],[23,2,23,4],[23,8,23,9]]}
[null,null,null,"CIs for two means, same variance",null,null,null,null,null,null,null,null,null,null,{"$f":"$G$14/10000","v":9.4999999999999998E-3},9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,null,"CI calculations"]
[null,null,null,"Enter data for up to 10 experiments, each comparing two independent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$14/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,null,null,null,"Blank if:",null,"Block entry if:",null,null,"n1 n2","Blank if:",null,null,null,"Block entry if:",null,null,null,null,"SD1 2","SE1 2",null,null,null,"If SD1 2","If SE1 2","If t","If p"]
[null,null,null,null,"groups, assuming population variances are equal.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"diff grey","1&2grey","diff grey","1&2grey","diff OK?","OK?","SD grey","SE grey","t grey","p grey","SDdgrey","SEdgrey","t grey","p greyL","p greyU","OK?","OK?","t OK?","p OK?","All OK?","SEdiff","SEdiff","SEdiff","SEdiff","SEdiff"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(E26),ISNUMBER(D26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(ISNUMBER(C26),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(AK4=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":9.9999999999999903E+29},{"$f":"IF(AL4=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":-9.9999999999999903E+29},{"$f":"OR(ISNUMBER(C26),AND(ISNUMBER(D26),ISNUMBER(E26)))","v":true},{"$f":"IF(NOT(AND(ISNUMBER(I26),ISNUMBER(J26))),FALSE,AND(I26=INT(I26),I26>1.5,J26=INT(J26),J26>1.5))","v":true},{"$f":"IF(OR(ISNUMBER(Q26),ISNUMBER(R26),ISNUMBER(S26),ISNUMBER(T26)),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(OR(ISNUMBER(O26),ISNUMBER(P26),ISNUMBER(S26),ISNUMBER(T26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O26),ISNUMBER(P26),ISNUMBER(R26),ISNUMBER(Q26),ISNUMBER(T26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O26),ISNUMBER(P26),ISNUMBER(R26),ISNUMBER(S26),ISNUMBER(Q26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(AQ4=\"\",9.99999999999999E+29,0)","v":0},{"$f":"IF(AR4=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(AS4=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":9.9999999999999903E+29},{"$f":"IF(AT4=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(AT4=\"\",9.99999999999999E+29,1)","v":9.9999999999999903E+29},{"$f":"IF(NOT(AND(ISNUMBER(O26),ISNUMBER(P26))),0,IF(AND(O26>0,P26>0),1,0))","v":1},{"$f":"IF(NOT(AND(ISNUMBER(Q26),ISNUMBER(R26))),0,IF(AND(Q26>0,R26>0),1,0))","v":0},{"$f":"IF(ISNUMBER(S26),1,0)","v":0},{"$f":"IF(NOT(ISNUMBER(T26)),0,IF(AND(T26>=0,T26<=1),1,0))","v":0},{"$f":"AND(AO4,AP4,SUM(AZ4:BC4)=1)","v":true},{"$f":"IF(BD4,IF(ISNUMBER(O26),SQRT(((I26-1)*O26^2+(J26-1)*P26^2)/L26)*SQRT(1/I26+1/J26),\"\"),\"\")","v":3.317981313991988},{"$f":"IF(BD4,IF(ISNUMBER(Q26),SQRT(((I26-1)*I26*Q26^2+(J26-1)*J26*R26^2)/L26)*SQRT(1/I26+1/J26),\"\"),\"\")","v":""},{"$f":"IF(BD4,IF(ISNUMBER(S26),ABS(G26/S26),\"\"),\"\")","v":""},{"$f":"IF(BD4,IF(ISNUMBER(T26),ABS(G26)/TINV(T26,L26),\"\"),\"\")","v":""},{"$f":"IF(BD4,IF(ISNUMBER(BE4),BE4,IF(ISNUMBER(BF4),BF4,IF(ISNUMBER(BG4),BG4,BH4))),NA())","v":3.317981313991988}]
[null,null,null,"For each experiment, enter:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(E27),ISNUMBER(D27)),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(ISNUMBER(C27),\"\",9.99999999999999E+28)","v":""},-9.9999999999999903E+29,9.9999999999999903E+29,true,{"$f":"IF(NOT(AND(ISNUMBER(I27),ISNUMBER(J27))),FALSE,AND(I27=INT(I27),I27>1.5,J27=INT(J27),J27>1.5))","v":true},{"$f":"IF(OR(ISNUMBER(Q27),ISNUMBER(R27),ISNUMBER(S27),ISNUMBER(T27)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O27),ISNUMBER(P27),ISNUMBER(S27),ISNUMBER(T27)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O27),ISNUMBER(P27),ISNUMBER(R27),ISNUMBER(Q27),ISNUMBER(T27)),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(OR(ISNUMBER(O27),ISNUMBER(P27),ISNUMBER(R27),ISNUMBER(S27),ISNUMBER(Q27)),\"\",9.99999999999999E+28)","v":""},9.9999999999999903E+29,9.9999999999999903E+29,{"$f":"IF(AS5=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":-9.9999999999999903E+29},9.9999999999999903E+29,9.9999999999999903E+29,{"$f":"IF(NOT(AND(ISNUMBER(O27),ISNUMBER(P27))),0,IF(AND(O27>0,P27>0),1,0))","v":0},{"$f":"IF(NOT(AND(ISNUMBER(Q27),ISNUMBER(R27))),0,IF(AND(Q27>0,R27>0),1,0))","v":0},{"$f":"IF(ISNUMBER(S27),1,0)","v":1},{"$f":"IF(NOT(ISNUMBER(T27)),0,IF(AND(T27>=0,T27<=1),1,0))","v":0},{"$f":"AND(AO5,AP5,SUM(AZ5:BC5)=1)","v":true},{"$f":"IF(BD5,IF(ISNUMBER(O27),SQRT(((I27-1)*O27^2+(J27-1)*P27^2)/L27)*SQRT(1/I27+1/J27),\"\"),\"\")","v":""},{"$f":"IF(BD5,IF(ISNUMBER(Q27),SQRT(((I27-1)*I27*Q27^2+(J27-1)*J27*R27^2)/L27)*SQRT(1/I27+1/J27),\"\"),\"\")","v":""},{"$f":"IF(BD5,IF(ISNUMBER(S27),ABS(G27/S27),\"\"),\"\")","v":5.9071729957805905},{"$f":"IF(BD5,IF(ISNUMBER(T27),ABS(G27)/TINV(T27,L27),\"\"),\"\")","v":""},{"$f":"IF(BD5,IF(ISNUMBER(BE5),BE5,IF(ISNUMBER(BF5),BF5,IF(ISNUMBER(BG5),BG5,BH5))),NA())","v":5.9071729957805905}]
[null,null,null,null,"* Difference between the means, OR the two means, AND  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"",9.9999999999999903E+28,9.9999999999999903E+29,-9.9999999999999903E+29,true,true,"","","",9.9999999999999903E+28,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,0,0,0,1,true,"","","",5.5738634135829992,5.5738634135829992]
[null,null,null,null,"* N1 and N2, the two sample sizes, AND ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999903E+28,"",-9.9999999999999903E+29,9.9999999999999903E+29,true,false,"","","",9.9999999999999903E+28,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,0,0,0,1,false,"","","","",{"$error":"#N/A"}]
[null,null,null,null,"* the SD for each group, OR the SE for each group, OR t OR p  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999903E+28,"",-9.9999999999999903E+29,9.9999999999999903E+29,true,true,"",9.9999999999999903E+28,"","",9.9999999999999903E+29,0,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,0,0,true,"",7.1400280111495364,"","",7.1400280111495364]
[null,null,null,null,null,"for testing a null hypothesis of zero difference.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"",9.9999999999999903E+28,9.9999999999999903E+29,-9.9999999999999903E+29,true,true,9.9999999999999903E+28,"","","",0,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,1,0,0,0,true,6.2721977899520249,"","","",6.2721977899520249]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999903E+28,"",-9.9999999999999903E+29,9.9999999999999903E+29,true,true,"","","",9.9999999999999903E+28,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,0,0,0,1,true,"","","",6.0509479323099971,6.0509479323099971]
[null,null,null,"See a figure displaying the differences between means, and their CIs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999903E+28,9.9999999999999903E+28,-9.9999999999999903E+29,-9.9999999999999903E+29,false,true,"",9.9999999999999903E+28,"","",9.9999999999999903E+29,0,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,0,0,false,"","","","",{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"",9.9999999999999903E+28,9.9999999999999903E+29,-9.9999999999999903E+29,true,false,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,0,0,-9.9999999999999903E+29,0,1,0,0,0,0,false,"","","","",{"$error":"#N/A"}]
[null,1,"Level of confidence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999903E+28,9.9999999999999903E+28,-9.9999999999999903E+29,-9.9999999999999903E+29,false,false,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,0,0,-9.9999999999999903E+29,0,1,0,0,0,0,false,"","","","",{"$error":"#N/A"}]
[null,null,null,null,null,"C",{"$f":"IF(AL14<100,AL14,99+(AL14-99)/10)","v":95},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"for C",95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"For display"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$14/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,null,null,null,"M1 - M2","y","L bars","R bars"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BD4,G26,NA())","v":-15.600000000000001},1,{"$f":"IF(BD4,V26,NA())","v":6.9708200716736872},{"$f":"IF(BD4,V26,NA())","v":6.9708200716736872}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,14,2,12.018233824595244,12.018233824595244]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,10,3,11.248511768961004,11.248511768961004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},4,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,19,5,17.471019157988842,17.471019157988842]
[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,-29,6,12.649092355010252,12.649092355010252]
[null,2,"Input",null,null,null,null,null,"3        Input",null,null,null,null,null,"4                                       Input",null,null,null,null,null,null,"Bars","CI limits",null,null,null,null,null,null,null,null,null,null,null,null,null,9.1999999999999993,7,11.932575079992779,11.932575079992779]
[null,null,"M2 - M1","M1","M2",null,"M2 - M1",null,"N1","N2",null,"df","tcrit",null,"SD1","SD2","SE1","SE2","t","p",null,"MOE","LL","UL","t","p",null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1,null,43.2,27.6,null,{"$f":"IF(AO4,IF(ISNUMBER(C26),C26,E26-D26),\"\")","v":-15.600000000000001},null,10,10,null,{"$f":"IF(AND(ISNUMBER(I26),ISNUMBER(J26)),I26+J26-2,\"\")","v":18},{"$f":"IF(ISNUMBER(L26),TINV(1-$G$14/100,L26),\"\")","v":2.1009220402410378},null,9.6999999999999993,4,null,null,null,null,null,{"$f":"IF(BD4,BI4*M26,\"\")","v":6.9708200716736872},{"$f":"IF(BD4,G26-V26,\"\")","v":-22.570820071673687},{"$f":"IF(BD4,G26+V26,\"\")","v":-8.6291799283263142},{"$f":"IF(BD4,IF(BI4>0,G26/BI4,\"\"),\"\")","v":-4.70165396478109},{"$f":"IF(BD4,IF(BI4>0,TDIST(ABS(Y26),L26,2),\"\"),\"\")","v":1.7780488116370737E-4},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},9,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2,14,null,null,null,{"$f":"IF(AO5,IF(ISNUMBER(C27),C27,E27-D27),\"\")","v":14},null,13,22,null,{"$f":"IF(AND(ISNUMBER(I27),ISNUMBER(J27)),I27+J27-2,\"\")","v":33},{"$f":"IF(ISNUMBER(L27),TINV(1-$G$14/100,L27),\"\")","v":2.0345152974493379},null,null,null,null,null,2.37,null,null,12.018233824595244,1.981766175404756,26.018233824595242,{"$f":"IF(BD5,IF(BI5>0,G27/BI5,\"\"),\"\")","v":2.37},{"$f":"IF(BD5,IF(BI5>0,TDIST(ABS(Y27),L27,2),\"\"),\"\")","v":2.3787468361012719E-2},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},10,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,3,null,40,50,null,10,null,22,22,null,42,2.0180817028184439,null,null,null,null,null,null,0.08,null,11.248511768961004,-1.2485117689610039,21.248511768961002,1.7940877373548314,8.0000000000000196E-2]
[null,4,23.65,null,null,null,23.65,null,null,null,null,"","",null,null,null,null,null,null,0.14000000000000001,null,"","","","",""]
[null,5,19,null,null,null,19,null,4,4,null,6,2.4469118511449688,null,null,null,4.3,5.7,null,null,null,17.471019157988842,1.5289808420111584,36.471019157988842,2.6610539861090854,3.7471263970397239E-2]
[null,6,null,-15,-44,null,-29,null,20,25,null,43,2.0166921992278248,null,22,20,null,null,null,null,null,12.649092355010252,-41.649092355010254,-16.350907644989746,-4.6235786834493009,3.4370105166272857E-5]
[null,7,9.1999999999999993,null,null,null,9.1999999999999993,null,100,100,null,198,1.9720174778363073,null,null,null,null,null,null,0.13,null,11.932575079992779,-2.7325750799927793,21.132575079992776,1.5204229325582423,0.13000000000000023]
[null,8,null,null,null,null,"",null,100,100,null,198,1.9720174778363073,null,null,null,3,7.7,null,null,null,"","","","",""]
[null,9,null,55,66,null,11,null,null,null,null,"","",null,null,null,null,null,null,null,null,"","","","",""]
[null,10,null,null,null,null,"",null,null,null,null,"","",null,null,null,null,null,null,null,null,"","","","",""]

{"sheet":"2 ind means general","index":8,"n_rows":35,"n_cols":65,"rows_kept":35,"cut":false,"hidden":false,"merged":[[23,14,23,19],[23,22,23,23],[23,2,23,4],[23,8,23,9]]}
[null,null,null,"CIs for two means, without assuming same variance",null,null,null,null,null,null,null,null,null,null,{"$f":"$G$14/10000","v":9.4999999999999998E-3},9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,null,"CI calculations"]
[null,null,null,"Enter data for up to 10 experiments, each comparing two independent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$G$14/10000","v":9.4999999999999998E-3},null,null,null,null,null,null,null,null,null,null,null,"Blank if:",null,"Block entry if:",null,null,"n1 n2","Blank if:",null,null,null,"Block entry if:",null,null,null,null,"SD1 2","SE1 2",null,null,null,"If SD1 2","If SE1 2","If t","If p"]
[null,null,null,null,"groups.  Do not assume population variances are equal.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"diff grey","1&2grey","diff grey","1&2grey","diff OK?","OK?","SD grey","SE grey","t grey","p grey","SDdgrey","SEdgrey","t grey","p greyL","p greyU","OK?","OK?","t OK?","p OK?","All OK?","SEdiff","SEdiff","SEdiff","SEdiff","SEdiff","q SD SE","m","t crit","Approx df"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(E26),ISNUMBER(D26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(ISNUMBER(C26),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(AK4=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":9.9999999999999903E+29},{"$f":"IF(AL4=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":-9.9999999999999903E+29},{"$f":"OR(ISNUMBER(C26),AND(ISNUMBER(D26),ISNUMBER(E26)))","v":true},{"$f":"IF(NOT(AND(ISNUMBER(I26),ISNUMBER(J26))),FALSE,AND(I26=INT(I26),I26>1.5,J26=INT(J26),J26>1.5))","v":true},{"$f":"IF(OR(ISNUMBER(Q26),ISNUMBER(R26),ISNUMBER(S26),ISNUMBER(T26)),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(OR(ISNUMBER(O26),ISNUMBER(P26),ISNUMBER(S26),ISNUMBER(T26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O26),ISNUMBER(P26),ISNUMBER(R26),ISNUMBER(Q26),ISNUMBER(T26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O26),ISNUMBER(P26),ISNUMBER(R26),ISNUMBER(S26),ISNUMBER(Q26)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(AQ4=\"\",9.99999999999999E+29,0)","v":0},{"$f":"IF(AR4=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(AS4=\"\",9.99999999999999E+29,-9.99999999999999E+29)","v":9.9999999999999903E+29},{"$f":"IF(AT4=\"\",9.99999999999999E+29,0)","v":9.9999999999999903E+29},{"$f":"IF(AT4=\"\",9.99999999999999E+29,1)","v":9.9999999999999903E+29},{"$f":"IF(NOT(AND(ISNUMBER(O26),ISNUMBER(P26))),0,IF(AND(O26>0,P26>0),1,0))","v":1},{"$f":"IF(NOT(AND(ISNUMBER(Q26),ISNUMBER(R26))),0,IF(AND(Q26>0,R26>0),1,0))","v":0},{"$f":"IF(ISNUMBER(S26),1,0)","v":0},{"$f":"IF(NOT(ISNUMBER(T26)),0,IF(AND(T26>=0,T26<=1),1,0))","v":0},{"$f":"AND(AO4,AP4,SUM(AZ4:BC4)=1)","v":true},{"$f":"IF(BD4,IF(ISNUMBER(O26),SQRT(O26^2/I26+P26^2/J26),\"\"),\"\")","v":3.317981313991988},{"$f":"IF(BD4,IF(ISNUMBER(Q26),SQRT(Q26^2+R26^2),\"\"),\"\")","v":""},{"$f":"IF(BD4,IF(ISNUMBER(S26),ABS(G26/S26),\"\"),\"\")","v":""},{"$f":"IF(BD4,IF(ISNUMBER(T26),ABS(G26/TINV(T26,L26)),\"\"),\"\")","v":""},{"$f":"IF(BD4,IF(ISNUMBER(BE4),BE4,IF(ISNUMBER(BF4),BF4,IF(ISNUMBER(BG4),BG4,BH4))),NA())","v":3.317981313991988},{"$f":"IF(BD4,IF(ISNUMBER(O26),P26^2/O26^2,IF(ISNUMBER(Q26),(J26*R26^2)/(I26*Q26^2),\"\")),\"\")","v":0.17004995217345098},{"$f":"IF(ISNUMBER(BJ4),(1/I26+BJ4/J26)^2/(1/(I26^2*(I26-1))+BJ4^2/(J26^2*(J26-1))),\"\")","v":11.974874727576344},{"$f":"IF(BD4,IF(ISNUMBER(BJ4),(INT(BK4)+1-BK4)*TINV(1-$G$14/100,INT(BK4))+(BK4-INT(BK4))*TINV(1-$G$14/100,INT(BK4)+1),TINV(1-$G$14/100,L26)),\"\")","v":2.1793699155094086},{"$f":"IF(SUM(BB4:BC4)=1,-9.99999999999999E+29,9.99999999999999E+29)","v":9.9999999999999903E+29}]
[null,null,null,"For each experiment, enter:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(E27),ISNUMBER(D27)),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(ISNUMBER(C27),\"\",9.99999999999999E+28)","v":""},-9.9999999999999903E+29,9.9999999999999903E+29,true,true,{"$f":"IF(OR(ISNUMBER(Q27),ISNUMBER(R27),ISNUMBER(S27),ISNUMBER(T27)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O27),ISNUMBER(P27),ISNUMBER(S27),ISNUMBER(T27)),\"\",9.99999999999999E+28)","v":""},{"$f":"IF(OR(ISNUMBER(O27),ISNUMBER(P27),ISNUMBER(R27),ISNUMBER(Q27),ISNUMBER(T27)),\"\",9.99999999999999E+28)","v":9.9999999999999903E+28},{"$f":"IF(OR(ISNUMBER(O27),ISNUMBER(P27),ISNUMBER(R27),ISNUMBER(S27),ISNUMBER(Q27)),\"\",9.99999999999999E+28)","v":""},9.9999999999999903E+29,9.9999999999999903E+29,-9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,0,1,0,true,{"$f":"IF(BD5,IF(ISNUMBER(O27),SQRT(O27^2/I27+P27^2/J27),\"\"),\"\")","v":""},{"$f":"IF(BD5,IF(ISNUMBER(Q27),SQRT(Q27^2+R27^2),\"\"),\"\")","v":""},5.9071729957805905,{"$f":"IF(BD5,IF(ISNUMBER(T27),ABS(G27/TINV(T27,L27)),\"\"),\"\")","v":""},{"$f":"IF(BD5,IF(ISNUMBER(BE5),BE5,IF(ISNUMBER(BF5),BF5,IF(ISNUMBER(BG5),BG5,BH5))),NA())","v":5.9071729957805905},{"$f":"IF(BD5,IF(ISNUMBER(O27),P27^2/O27^2,IF(ISNUMBER(Q27),(J27*R27^2)/(I27*Q27^2),\"\")),\"\")","v":""},{"$f":"IF(ISNUMBER(BJ5),(1/I27+BJ5/J27)^2/(1/(I27^2*(I27-1))+BJ5^2/(J27^2*(J27-1))),\"\")","v":""},{"$f":"IF(BD5,IF(ISNUMBER(BJ5),(INT(BK5)+1-BK5)*TINV(1-$G$14/100,INT(BK5))+(BK5-INT(BK5))*TINV(1-$G$14/100,INT(BK5)+1),TINV(1-$G$14/100,L27)),\"\")","v":2.178812829667228},{"$f":"IF(SUM(BB5:BC5)=1,-9.99999999999999E+29,9.99999999999999E+29)","v":-9.9999999999999903E+29}]
[null,null,null,null,"* Difference between the means, OR the two means, AND  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"",9.9999999999999903E+28,9.9999999999999903E+29,-9.9999999999999903E+29,true,true,"","","",9.9999999999999903E+28,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,0,0,0,1,true,"","","",5.4358132226138984,5.4358132226138984,"","",2.07961384472768,-9.9999999999999903E+29]
[null,null,null,null,"* N1 and N2, the two sample sizes, AND ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999903E+28,"",-9.9999999999999903E+29,9.9999999999999903E+29,true,false,"","","",9.9999999999999903E+28,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,0,0,0,1,false,"","","","",{"$error":"#N/A"},"","","",-9.9999999999999903E+29]
[null,null,null,null,"* the SD for each group, OR the SE for each group, OR t OR p  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999903E+28,"",-9.9999999999999903E+29,9.9999999999999903E+29,true,true,"",9.9999999999999903E+28,"","",9.9999999999999903E+29,0,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,0,0,true,"",7.1400280111495364,"","",7.1400280111495364,1.7571660356949705,5.5792426969627185,2.4989469002862101,9.9999999999999903E+29]
[null,null,null,null,null,"for testing a null hypothesis of zero difference.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"",9.9999999999999903E+28,9.9999999999999903E+29,-9.9999999999999903E+29,true,true,9.9999999999999903E+28,"","","",0,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,1,0,0,0,true,6.3403469936589438,"","","",6.3403469936589438,0.82644628099173556,38.950273159345777,2.0227756169735374,9.9999999999999903E+29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999903E+28,"",-9.9999999999999903E+29,9.9999999999999903E+29,true,true,"","","",9.9999999999999903E+28,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,0,0,0,1,true,"","","",6.0256843326681047,6.0256843326681047,"","",1.9842169515864165,-9.9999999999999903E+29]
[null,null,null,"See a figure displaying the differences between means, and their CIs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999903E+28,9.9999999999999903E+28,-9.9999999999999903E+29,-9.9999999999999903E+29,false,true,"",9.9999999999999903E+28,"","",9.9999999999999903E+29,0,9.9999999999999903E+29,9.9999999999999903E+29,9.9999999999999903E+29,0,1,0,0,false,"","","","",{"$error":"#N/A"},"","","",9.9999999999999903E+29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"",9.9999999999999903E+28,9.9999999999999903E+29,-9.9999999999999903E+29,true,false,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,0,0,-9.9999999999999903E+29,0,1,0,0,0,0,false,"","","","",{"$error":"#N/A"},"","","",9.9999999999999903E+29]
[null,1,"Level of confidence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,9.9999999999999903E+28,9.9999999999999903E+28,-9.9999999999999903E+29,-9.9999999999999903E+29,false,false,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,9.9999999999999903E+28,0,0,-9.9999999999999903E+29,0,1,0,0,0,0,false,"","","","",{"$error":"#N/A"},"","","",9.9999999999999903E+29]
[null,null,null,null,null,"C",{"$f":"IF(AL14<100,AL14,99+(AL14-99)/10)","v":95},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"for C",95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"For display"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,"M1 - M2","y","L bars","R bars"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BD4,G26,NA())","v":-15.600000000000001},1,{"$f":"IF(BD4,V26,NA())","v":7.2311086559365156},{"$f":"IF(BD4,V26,NA())","v":7.2311086559365156}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,14,2,12.870624310270545,12.870624310270545]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,10,3,11.304392435101649,11.304392435101649]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},4,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,19,5,17.842550866418847,17.842550866418847]
[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,-29,6,12.825099301924784,12.825099301924784]
[null,2,"Input",null,null,null,null,null,"3        Input",null,null,null,null,null,"4                                        Input",null,null,null,null,null,null,"Bars","CI limits",null,null,null,null,null,null,null,null,null,null,null,null,null,9.1999999999999993,7,11.956264997788738,11.956264997788738]
[null,null,"M2 - M1","M1","M2",null,"M2 - M1",null,"N1","N2",null,"df","tcrit",null,"SD1","SD2","SE1","SE2","t","p",null,"MOE","LL","UL","t","p",null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1,null,43.2,27.6,null,{"$f":"IF(AO4,IF(ISNUMBER(C26),C26,E26-D26),\"\")","v":-15.600000000000001},null,10,10,null,{"$f":"IF(BD4,IF(SUM(AZ4:BA4)=1,BK4,MIN(I26:J26)-1),\"\")","v":11.974874727576344},{"$f":"IF(ISNUMBER(BL4),BL4,\"\")","v":2.1793699155094086},null,9.6999999999999993,4,null,null,null,null,null,{"$f":"IF(BD4,BI4*M26,\"\")","v":7.2311086559365156},{"$f":"IF(BD4,G26-V26,\"\")","v":-22.831108655936518},{"$f":"IF(BD4,G26+V26,\"\")","v":-8.3688913440634849},{"$f":"IF(BD4,IF(BI4>0,G26/BI4,\"\"),\"\")","v":-4.70165396478109},{"$f":"IF(BD4,IF(BI4>0,TDIST(ABS(Y26),L26,2),\"\"),\"\")","v":6.4840389927023638E-4},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},9,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,2,14,null,null,null,{"$f":"IF(AO5,IF(ISNUMBER(C27),C27,E27-D27),\"\")","v":14},null,13,22,null,{"$f":"IF(BD5,IF(SUM(AZ5:BA5)=1,BK5,MIN(I27:J27)-1),\"\")","v":12},{"$f":"IF(ISNUMBER(BL5),BL5,\"\")","v":2.178812829667228},null,null,null,null,null,2.37,null,null,12.870624310270545,1.1293756897294553,26.870624310270543,{"$f":"IF(BD5,IF(BI5>0,G27/BI5,\"\"),\"\")","v":2.37},{"$f":"IF(BD5,IF(BI5>0,TDIST(ABS(Y27),L27,2),\"\"),\"\")","v":3.5401432441053676E-2},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},10,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,3,null,40,50,null,10,null,22,22,null,21,2.07961384472768,null,null,null,null,null,null,0.08,null,11.304392435101649,-1.3043924351016489,21.304392435101647,1.8396511415069075,8.0000000000000029E-2]
[null,4,23.65,null,null,null,23.65,null,null,null,null,"","",null,null,null,null,null,null,0.14000000000000001,null,"","","","",""]
[null,5,19,null,null,null,19,null,4,4,null,5.5792426969627185,2.4989469002862101,null,null,null,4.3,5.7,null,null,null,17.842550866418847,1.157449133581153,36.842550866418847,2.6610539861090854,4.4827148379367812E-2]
[null,6,null,-15,-44,null,-29,null,20,25,null,38.950273159345777,2.0227756169735374,null,22,20,null,null,null,null,null,12.825099301924784,-41.82509930192478,-16.174900698075216,-4.5738821596047101,4.9766067075683086E-5]
[null,7,9.1999999999999993,null,null,null,9.1999999999999993,null,100,100,null,99,1.9842169515864165,null,null,null,null,null,null,0.13,null,11.956264997788738,-2.7562649977887386,21.156264997788739,1.5267975373556191,0.12999999999999887]
[null,8,null,null,null,null,"",null,100,100,null,"","",null,null,null,3,7.7,null,null,null,"","","","",""]
[null,9,null,55,66,null,11,null,null,null,null,"","",null,null,null,null,null,null,null,null,"","","","",""]
[null,10,null,null,null,null,"",null,null,null,null,"","",null,null,null,null,null,null,null,null,"","","","",""]

{"sheet":"Known CI limits","index":9,"n_rows":30,"n_cols":37,"rows_kept":30,"cut":false,"hidden":false,"merged":[[12,5,12,6],[12,8,12,9]]}
[null,null,null,"CIs when lower and upper limits are known",null,null,null,null,null,null,null,null,{"$f":"$F$10/10000","v":9.4999999999999998E-3},9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3,9.4999999999999998E-3]
[null,null,null,"Enter up to 10 point estimates, each",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$F$10/10000","v":9.4999999999999998E-3}]
[null,null,null,null,"with the LL and UL of the CI.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,"Point","Point","Point","Point","OK","OK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,"est & L","est & U","est. L","est. R","for L?","for R?"]
[null,null,null,"See a figure displaying these point estimates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F15),-9.99999999999999E+29,F15)","v":12},{"$f":"IF(ISBLANK(G15),9.99999999999999E+29,G15)","v":27.3},{"$f":"IF(ISNUMBER(C15),C15,-9.99999999999999E+29)","v":18.5},{"$f":"IF(ISNUMBER(C15),C15,9.99999999999999E+29)","v":18.5},{"$f":"IF(NOT(AND(ISNUMBER(C15),ISNUMBER(F15))),FALSE,C15>=F15)","v":true},{"$f":"IF(NOT(AND(ISNUMBER(C15),ISNUMBER(G15))),FALSE,C15<=G15)","v":true}]
[null,null,null,null,"and their CIs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(F16),-9.99999999999999E+29,F16)","v":10},{"$f":"IF(ISBLANK(G16),9.99999999999999E+29,G16)","v":15.4},12.55,12.55,true,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,16.8,25.9,21,21,true,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,15,33.1,23.4,23.4,true,true]
[null,1,"Level of confidence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,8.1999999999999993,21,14.75,14.75,true,true]
[null,null,null,null,"C",95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,8.6,28.4,19,19,true,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,-9.9999999999999903E+29,9.9999999999999903E+29,-9.9999999999999903E+29,9.9999999999999903E+29,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,-9.9999999999999903E+29,9.9999999999999903E+29,-9.9999999999999903E+29,9.9999999999999903E+29,false,false]
[null,2,"Point",null,null,"3      CI limits",null,null,"4       CI bars",null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,-9.9999999999999903E+29,9.9999999999999903E+29,-9.9999999999999903E+29,9.9999999999999903E+29,false,false]
[null,null,"estimate",null,null,"LL","UL",null,"Left","Right","MOEav",null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,-9.9999999999999903E+29,9.9999999999999903E+29,-9.9999999999999903E+29,9.9999999999999903E+29,false,false]
[null,1,18.5,null,null,12,27.3,null,{"$f":"IF(AJ5,AH18,\"\")","v":6.5},{"$f":"IF(AK5,AI18,\"\")","v":8.8000000000000007},{"$f":"IF(AND(AJ5,AK5),(AH18+AI18)/2,\"\")","v":7.65},null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,2,12.55,null,null,10,15.4,null,2.5500000000000007,2.8499999999999996,{"$f":"IF(AND(AJ6,AK6),(AH19+AI19)/2,\"\")","v":2.7},null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,"For display"]
[null,3,21,null,null,16.8,25.9,null,4.1999999999999993,4.8999999999999986,4.5499999999999989,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,"r","y","L bars","R bars"]
[null,4,23.4,null,null,15,33.1,null,8.3999999999999986,9.7000000000000028,9.0500000000000007,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(C15),C15,NA())","v":18.5},1,{"$f":"IF(AJ5,C15-F15,NA())","v":6.5},{"$f":"IF(AK5,G15-C15,NA())","v":8.8000000000000007}]
[null,5,14.75,null,null,8.1999999999999993,21,null,6.5500000000000007,6.25,6.4,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(C16),C16,NA())","v":12.55},2,2.5500000000000007,2.8499999999999996]
[null,6,19,null,null,8.6,28.4,null,10.4,9.3999999999999986,9.8999999999999986,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,21,3,4.1999999999999993,4.8999999999999986]
[null,7,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,23.4,4,8.3999999999999986,9.7000000000000028]
[null,8,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,14.75,5,6.5500000000000007,6.25]
[null,9,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,19,6,10.4,9.3999999999999986]
[null,10,null,null,null,null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},7,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},8,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},9,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},10,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.4999999999999998E-3]