1"use strict";(globalThis.webpackChunkwebsite=globalThis.webpackChunkwebsite||[]).push([[5390],{28453(e,n,s){s.d(n,{R:()=>l,x:()=>o});var t=s(96540);const i={},a=t.createContext(i);function l(e){const n=t.useContext(a);return t.useMemo(function(){return"function"==typeof e?e(n):{...n,...e}},[n,e])}function o(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(i):e.components||i:l(e.components),t.createElement(a.Provider,{value:n},e.children)}},40843(e,n,s){s.r(n),s.d(n,{assets:()=>c,contentTitle:()=>r,default:()=>u,frontMatter:()=>o,metadata:()=>t,toc:()=>d});const t=JSON.parse('{"id":"analyzing/overview","title":"Data analysis overview","description":"Beyond spreadsheet formulas, Figlinq offers a powerful, UI-driven statistical analysis engine. You don\'t need to memorize complex formulas\u2014simply select your data and choose the test you want to run.","source":"@site/docs/analyzing/overview.mdx","sourceDirName":"analyzing","slug":"/analyzing/overview","permalink":"/docs/analyzing/overview","draft":false,"unlisted":false,"tags":[],"version":"current","frontMatter":{"id":"overview","title":"Data analysis overview","sidebar_label":"Overview"},"sidebar":"docs","previous":{"title":"Collections","permalink":"/docs/collections"},"next":{"title":"Statistical formulas","permalink":"/docs/analyzing/statistical-formulas"}}');var i=s(74848),a=s(28453),l=s(86025);const o={id:"overview",title:"Data analysis overview",sidebar_label:"Overview"},r=void 0,c={},d=[{value:"Creating an Analysis",id:"creating-an-analysis",level:2},{value:"Using the Analyze Tab",id:"using-the-analyze-tab",level:3},{value:"Analysis Nodes",id:"analysis-nodes",level:2},{value:"Automatic Plot Annotation",id:"automatic-plot-annotation",level:2},{value:"General Formula Support",id:"general-formula-support",level:2}];function h(e){const n={a:"a",code:"code",h2:"h2",h3:"h3",li:"li",ol:"ol",p:"p",strong:"strong",ul:"ul",...(0,a.R)(),...e.components};return(0,i.jsxs)(i.Fragment,{children:[(0,i.jsx)(n.p,{children:"Beyond spreadsheet formulas, Figlinq offers a powerful, UI-driven statistical analysis engine. You don't need to memorize complex formulas\u2014simply select your data and choose the test you want to run."}),"\n",(0,i.jsx)(n.h2,{id:"creating-an-analysis",children:"Creating an Analysis"}),"\n",(0,i.jsx)(n.p,{children:"You can create statistical analyses in three ways:"}),"\n",(0,i.jsxs)(n.ol,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:(0,i.jsx)(n.a,{href:"/docs/ai-assistant",children:"Flow Assistant"})}),': Simply ask the assistant to "Run a t-test on columns A and B" or "Analyze the effect of Treatment on Outcome". The assistant will select the appropriate test and configure it for you.']}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Data Grid Editor"}),": Open the ",(0,i.jsx)(n.strong,{children:"Analyze"})," tab in the grid editor sidebar to manually configure tests."]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Plot Editor"}),": When editing a plot, you can add analysis from the sidebar to automatically check for significance in your visualized data."]}),"\n"]}),"\n",(0,i.jsx)(n.h3,{id:"using-the-analyze-tab",children:"Using the Analyze Tab"}),"\n",(0,i.jsxs)(n.p,{children:["When working in the ",(0,i.jsx)(n.a,{href:"/docs/flows#integrated-editors",children:"Data Grid Editor"}),", switch to the ",(0,i.jsx)(n.strong,{children:"Analyze"})," tab in the sidebar. Here you can:"]}),"\n",(0,i.jsxs)(n.ol,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Select a Test"}),": Choose from a comprehensive library of statistical tests (T-tests, ANOVA, Regression, Non-parametric tests, etc.)."]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Assign Columns"}),': Drag and drop your grid columns into the required fields (e.g., "Dependent Variable", "Grouping Factor").']}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Run Analysis"}),': Click "Run" to execute the test.']}),"\n"]}),"\n",(0,i.jsx)(n.h2,{id:"analysis-nodes",children:"Analysis Nodes"}),"\n",(0,i.jsxs)(n.p,{children:["Running a test creates a new ",(0,i.jsx)(n.strong,{children:"Analysis Node"})," on your Flow canvas, linked to your data grid. This node displays:"]}),"\n",(0,i.jsx)("img",{className:"screengrab",alt:"Statistical Analysis",src:(0,l.Ay)("img/flow/features/04.jpg")}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Test Results"}),": Full statistical reports including test statistics, degrees of freedom, and p-values."]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Interpretation"}),': Human-readable conclusions (e.g., "Reject Null Hypothesis").']}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Post-hoc Tests"}),": Detailed pairwise comparisons if applicable (e.g., Tukey's HSD for ANOVA)."]}),"\n"]}),"\n",(0,i.jsx)(n.h2,{id:"automatic-plot-annotation",children:"Automatic Plot Annotation"}),"\n",(0,i.jsx)(n.p,{children:"One of Figlinq's most powerful features is the automatic integration between analysis and visualization."}),"\n",(0,i.jsx)(n.p,{children:(0,i.jsx)(n.strong,{children:"If you plot data that has an active analysis linked to it, Figlinq will automatically add significance annotations (asterisks, p-values) to your plot."})}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Smart Detection"}),": The system detects if the plotted data matches the groups used in your analysis."]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Live Updates"}),": If you change your data or your analysis parameters, the plot annotations update instantly."]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Customizable"}),": You can toggle these annotations on/off in the Plot Editor."]}),"\n"]}),"\n",(0,i.jsx)(n.h2,{id:"general-formula-support",children:"General Formula Support"}),"\n",(0,i.jsx)(n.p,{children:"For traditional data manipulation, we still support a full range of spreadsheet formulas (similar to Excel or Google Sheets)."}),"\n",(0,i.jsxs)(n.ul,{children:["\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Math & Trig"}),": ",(0,i.jsx)(n.code,{children:"SUM"}),", ",(0,i.jsx)(n.code,{children:"AVERAGE"}),", ",(0,i.jsx)(n.code,{children:"SIN"}),", ",(0,i.jsx)(n.code,{children:"COS"}),", etc."]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Logic"}),": ",(0,i.jsx)(n.code,{children:"IF"}),", ",(0,i.jsx)(n.code,{children:"AND"}),", ",(0,i.jsx)(n.code,{children:"OR"}),"."]}),"\n",(0,i.jsxs)(n.li,{children:[(0,i.jsx)(n.strong,{children:"Text"}),": ",(0,i.jsx)(n.code,{children:"CONCATENATE"}),", ",(0,i.jsx)(n.code,{children:"LEFT"}),", ",(0,i.jsx)(n.code,{children:"RIGHT"}),"."]}),"\n"]}),"\n",(0,i.jsxs)(n.p,{children:["For a full list of available formulas, check the ",(0,i.jsx)(n.a,{href:"https://jspreadsheet.com/products/formulas",children:"JSpreadsheet documentation"}),"."]})]})}function u(e={}){const{wrapper:n}={...(0,a.R)(),...e.components};return n?(0,i.jsx)(n,{...e,children:(0,i.jsx)(h,{...e})}):h(e)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.