BrainyBlast!

📊 How to Use the IB Data Suite: Data Table with Precision Analytics

Welcome to the data-processing tool for your IB Biology Internal Assessment! This tool formats your raw data, calculates your means and uncertainties, helps you choose a suitable statistical test, and runs university-grade statistics, all while keeping your tables consistent with IB presentation expectations.

Here is a quick guide to getting the most out of the app:

Step 1: Input Your Data

You don’t have to type everything from scratch!

• The Paste Box: If you already have your data in Excel or Google Sheets, copy the whole block (including your headers) and paste it into the dashed Paste Box at the top. The app builds your table for you. If a header contains the word “Trial”, the app will also orient the table the right way round automatically. Columns labelled Mean, SD or SEM at the end of your pasted data are skipped, because the app calculates those itself.
• Layout Switcher: Prefer your trials going down instead of across? Use the Horiz ▤ / Vert ▥ buttons to change how the table is laid out. If your pasted data came in the wrong way round, click Transpose ⇄ to flip the rows and columns.
• Manual Entry: Use the + Add Group (IV) and + Add Trial buttons to build your table by hand. Click on any header to rename it, and use the title box to give your table a full title (include the IV, the DV and the uncertainty, for example “Table 1: Mould growth (±1 mm) on different cheeses”).
• Start Again: Click Reset All to clear the table. Your work is saved automatically in the web browser on the computer you are using, so it will still be there if you refresh the page, but it will not follow you to another device. Use Excel (.xlsx) to keep a copy.

Step 2: Fix Your Precision (Matching Decimal Places)

The IB teacher support material says the uncertainty in raw data must be given to the same number of decimal places as the measurement, and your processed data (means and uncertainties) should not be more precise than the instrument that produced the raw data. This app helps by making every number in the table use the same number of decimal places.

• If you see red warning boxes, the decimal places in your raw data, means and uncertainties do not match.
• The Fix: Use the +.00 and -.00 buttons at the top until the warnings disappear. This syncs the precision of every cell in your table. Your statistical tests always use your original, unrounded values, so changing the display will not change your p-values.
• Choose a precision that makes sense for your equipment. For example, a ruler marked in millimetres (±1 mm) does not justify means with three decimal places.

Step 3: Choose Your Uncertainty

Next to the decimal buttons, toggle your error calculation between SD (Standard Deviation, the spread of your data) and SEM (Standard Error of the Mean, how precisely your mean is estimated). The uncertainty row in your table updates instantly. Whichever you choose, always state it in your table title or figure caption.

Step 4: Run Your Stats

Click the Calculate Advanced Stats ✨ button. The Stats Wizard will open and guide you:

1. Choose your goal: click Compare Groups (Difference) if you want to know whether the means of your groups differ, or Find a Trend (Correlation) if you want to know whether two numeric variables are related. (There is also a link to skip the wizard and calculate everything.)
2. Read the data health check: the app checks that each group has at least 5 trials (the IB expects at least five replicates for standard deviation and for a t-test) and looks for extreme outliers. The outlier check is the app’s own rule of thumb. If it flags an outlier, don’t simply delete it. IB expects you to identify and justify removing or keeping any outlier.
3. Pick a test family: one button will be highlighted as the app’s suggestion. For comparing groups the choices are Parametric (T-Test / ANOVA) or Non-Parametric (Mann-Whitney / Kruskal). For trends the choices are Pearson’s r (straight-line relationships) or Spearman’s rank (outliers or curves that keep rising or falling).

Your results appear in tabs below the table:

• Parametric (p-values): Levene’s test runs automatically to check whether your groups have equal variances. If they do, the Student’s t-test (2 groups) or Fisher’s ANOVA (3 or more groups) is marked RECOMMENDED. If not, the Welch version is recommended instead. Each result is labelled Significant or Not Significant at α = 0.05.
• Where is the difference? With 3 or more groups, the Run Post-Hoc button appears. It becomes available only if the recommended ANOVA is significant (p < 0.05). Click it to run a t-test on every pair of groups with a Bonferroni correction, so you can see exactly which groups differ.
• Non-Parametric (Box Plot): a five-number summary (min, Q1, median, Q3, max, IQR) plus a Mann-Whitney U test (2 groups) or Kruskal-Wallis H test (3 or more groups). These tests compare the ranks of your data rather than the means, so they are not distorted by outliers or small samples.
• Correlation (Trend): available when your group names are numbers (for example 10, 20, 30 °C). It shows Pearson’s r, Spearman’s ρ, and a table of trend-line models (linear, exponential, logarithmic and quadratic) with the equation and R² of each. The IB teacher support material recommends showing R² only for linear and logarithmic trendlines, because a polynomial’s R² always rises as terms are added and spreadsheets calculate exponential R² on log-transformed data. Other models are fine when the biology predicts that shape, but never choose one only for a higher R². Choose Raw Data (uses every trial, recommended) or Group Means (matches the R² of a spreadsheet trendline drawn through your averages, but makes the correlation look stronger than it is).
• Distribution (Histogram): groups your raw data into bins so you can see its shape. Change the bin width and click Update.
• IA Writing Guide: a glossary of key statistics terms and the “Golden Rules of IB Science Writing”. Read it before you write your analysis!

Remember: a statistical test tells you whether a difference or relationship is unlikely to be due to chance alone. It never proves your hypothesis, and a significant correlation does not show that one variable causes the other.

Step 5: Export Your Work

Ready to put this into your IA draft? You have several options:

1. ⬇️ PNG: downloads a high-resolution image of your table, perfect for inserting into Word or Google Docs.
2. 📋 Copy Table: copies the table image to your clipboard so you can paste it straight into your document.
3. Excel (.xlsx): downloads a formatted spreadsheet with your numbers set up for further calculations.
4. EXPORT for GRAPHING: use Processed Data to copy your group names, means and errors for a bar graph or line graph. Use Scatterplot Copy to copy every raw X,Y pair for a scatter plot with a trendline. In the Non-Parametric tab, use Copy for Graphing (Box Plot) for a box-and-whisker plot. Then paste into the BrainyBlast Graphing Tool to build your error-bar graph.

---

---

Technical Credits & Open Source Licensing

The IB Data Suite: Precision Analytics is built using high-performance open-source libraries to ensure mathematical accuracy and reliable data processing. We gratefully acknowledge the following contributors:

• • jStat: Professional-grade statistical calculations and distribution modeling. (MIT License)
• • html2canvas: High-resolution table rendering and image generation. (MIT License)
• • SheetJS/XLSX-Style: Advanced Excel formatting and spreadsheet export engine. (SheetJS/MIT)
• • iFrame Resizer: Seamless responsive integration and layout management. (MIT License)