Financial Data Variance Analysis

Job ID: 40034397

Budget: ₹600 – ₹1,500 INR

I have an Excel workbook containing a little over a thousand rows of raw financial figures. Your job is to calculate the standard deviation and variance for every numeric column so I can quickly assess volatility across the dataset. Nothing else is required—no means, medians, or percentile work—just those two descriptive statistics delivered cleanly and accurately.

The file is already structured, but I need clear, self-contained formulas (not hard-coded values) and a concise summary sheet that highlights each column’s results. Please double-check that the math references the entire dataset, handle any blank or non-numeric cells safely, and label the outputs so they’re obvious at a glance.

Deliverables:
• Updated workbook with working STDEV and VAR functions for each metric column
• A “Summary” tab that lists the final figures side-by-side and notes any assumptions or data cleaning steps

If everything tallies correctly and the summary sheet is logical, I’ll mark the project complete right away.