Connectome Analysis Workbook
An Excel analysis workbook for connectome data, covering data cleaning, matrix transformation, connectivity analysis, charts, and a research dashboard.
Loading spreadsheet…
10761 views
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 KimiBuild 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 KimiBuild 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 KimiBuild 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 KimiBuild 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.
