Connectome Analysis Workbook

An Excel analysis workbook for connectome data, covering data cleaning, matrix transformation, connectivity analysis, charts, and a research dashboard.

0000

Loading spreadsheet…

Start with this prompt

An Excel analysis workbook for connectome data, covering data cleaning, matrix transformation, connectivity analysis, charts, and a research dashboard.

Try in Kimi
Build an Excel analysis workbook from my uploaded connectome data. Identify the brain-region dictionary, connectivity matrix, distance matrix, and experiment records; clean and align the data, convert matrices into edge tables, and normalize connection strength. Preserve the raw data and add cleaned, analysis, charts, and dashboard sheets with a connectivity heatmap, strongest-connection ranking, source and target strength summaries, ipsilateral versus contralateral comparisons, and a strength-versus-distance scatter plot.
Prepare results for research-group review

Frame the workbook for a research-group review, surfacing data-quality issues, key findings, and results that need confirmation.

Remix in Kimi
Build an Excel analysis workbook from my uploaded connectome data. Identify the brain-region dictionary, connectivity matrix, distance matrix, and experiment records; clean and align the data, convert matrices into edge tables, and normalize connection strength. Preserve the raw data and add cleaned, analysis, charts, and dashboard sheets with a connectivity heatmap, strongest-connection ranking, source and target strength summaries, ipsilateral versus contralateral comparisons, and a strength-versus-distance scatter plot.
Validate matrices and region mapping first

Check matrix dimensions, region labels, missing or duplicate regions, symmetry, and distance units before analysis.

Remix in Kimi
Build an Excel analysis workbook from my uploaded connectome data. Identify the brain-region dictionary, connectivity matrix, distance matrix, and experiment records; clean and align the data, convert matrices into edge tables, and normalize connection strength. Preserve the raw data and add cleaned, analysis, charts, and dashboard sheets with a connectivity heatmap, strongest-connection ranking, source and target strength summaries, ipsilateral versus contralateral comparisons, and a strength-versus-distance scatter plot.
Layer the workbook from raw to dashboard

Structure the deliverable as raw → cleaned → analysis → charts → dashboard, with each layer serving a distinct purpose.

Remix in Kimi
Build an Excel analysis workbook from my uploaded connectome data. Identify the brain-region dictionary, connectivity matrix, distance matrix, and experiment records; clean and align the data, convert matrices into edge tables, and normalize connection strength. Preserve the raw data and add cleaned, analysis, charts, and dashboard sheets with a connectivity heatmap, strongest-connection ranking, source and target strength summaries, ipsilateral versus contralateral comparisons, and a strength-versus-distance scatter plot.