Excel Financial Data Analysis
Budget: ₹600 – ₹1,500 INR
I have a set of financial figures that needs a clear-cut descriptive statistics pass in Excel. I’m looking for median, mode, full quartiles, and key percentiles laid out in a tidy worksheet, with formulas left live so I can refresh the results whenever the data grows.
Alongside the numbers, I want histograms that instantly reflect any change in the dataset—properly labelled axes, sensible bin sizes, and clean formatting. Whether you rely on built-in functions or the Analysis ToolPak is up to you, as long as the file stays self-contained and works in Office 365.
Deliverables
• Workbook containing:
– Raw data sheet untouched
– Statistics sheet showing median, mode, quartiles (Q1, Q2, Q3), and selected percentiles (e.g., 5th, 25th, 50th, 75th, 95th)
– Dynamic histograms linked to the data
• A brief note or comments inside the workbook that outline the formulas or steps used so I can replicate the workflow.
Accuracy, neat formatting, and the ability to update effortlessly are essential. If this is straightforward for you, I’m ready to move ahead right away.
Alongside the numbers, I want histograms that instantly reflect any change in the dataset—properly labelled axes, sensible bin sizes, and clean formatting. Whether you rely on built-in functions or the Analysis ToolPak is up to you, as long as the file stays self-contained and works in Office 365.
Deliverables
• Workbook containing:
– Raw data sheet untouched
– Statistics sheet showing median, mode, quartiles (Q1, Q2, Q3), and selected percentiles (e.g., 5th, 25th, 50th, 75th, 95th)
– Dynamic histograms linked to the data
• A brief note or comments inside the workbook that outline the formulas or steps used so I can replicate the workflow.
Accuracy, neat formatting, and the ability to update effortlessly are essential. If this is straightforward for you, I’m ready to move ahead right away.