Excel Summary Stats Analysis

I have an .xlsx dataset that needs a clear, well-documented set of summary statistics—mean, median, and mode for each relevant field. You are free to use native Excel tools (formulas, PivotTables, Data Analysis ToolPak) as long as the final workbook remains fully transparent: every number must trace back to an auditable cell or formula without hidden macros.

Scope
• Import the supplied Excel file exactly as provided.
• Check the data’s basic integrity; if you spot duplicates or obvious missing values, note them and let me know before running the calculations.
• Produce a tidy “Summary” sheet that lists the descriptive measures for every numeric column.
• Add a brief note (one worksheet or a short comment block) explaining any assumptions and the steps you took so I can replicate or update the stats later.

Deliverables
1. Updated .xlsx workbook containing:
– Original data (untouched)
– Clean copy if issues were found
– Summary sheet with mean, median, and mode formulas
2. One-paragraph methodology note

Completion is accepted once I can open the workbook, verify the formulas, and see all requested statistics without errors.