Financial Transaction Frequency Analysis
Budget: ₹600 – ₹1,500 INR
I have a set of financial transactions that I need explored for their frequency distribution and overall descriptive statistics. The information is already pulled together in a worksheet that was prepared for statistical analysis, so you will be working directly in Excel.
Your job is to design the formulas, pivot tables, and visuals that show how often each transaction amount or category occurs, then report the classic descriptive measures—mean, median, mode, standard deviation, minimum, maximum, and any other insights that help me spot unusual patterns.
Deliverables I expect:
• A clean, well-structured Excel file with the frequency table clearly separated from raw data.
• At least one histogram or other suitable chart that illustrates the distribution.
• A short summary sheet highlighting the key descriptive statistics and any noteworthy observations.
Please keep the workbook transparent and easy for me to update with new data later.
Your job is to design the formulas, pivot tables, and visuals that show how often each transaction amount or category occurs, then report the classic descriptive measures—mean, median, mode, standard deviation, minimum, maximum, and any other insights that help me spot unusual patterns.
Deliverables I expect:
• A clean, well-structured Excel file with the frequency table clearly separated from raw data.
• At least one histogram or other suitable chart that illustrates the distribution.
• A short summary sheet highlighting the key descriptive statistics and any noteworthy observations.
Please keep the workbook transparent and easy for me to update with new data later.