Frequency Distribution Analysis in Excel
Budget: ₹600 – ₹1,500 INR
I have a medical-research dataset already sitting in an Excel workbook and I need a clear, well-structured descriptive analysis that focuses on frequency distributions. Your task is to work inside the file, clean anything that might interfere with the counts, and then create the tables, charts, or pivot views that best illustrate how often each value or category appears across the variables I flag for you.
Please organise the end result so the workbook contains:
• a tidy “Data_Clean” sheet (original structure preserved, just scrubbed for blanks, obvious entry errors, and duplicate rows)
• one or more frequency tables built with native Excel functions or PivotTables, clearly labelled
• visual snapshots (histogram, bar, or column charts as appropriate) linked to those tables
• a brief “Summary” tab that highlights the main takeaways in plain language—no more than a few paragraphs and bullet points where it helps
Everything must remain in Excel—no external BI tools this round. Power Query is fine if it simplifies the cleaning steps, but keep the queries saved so I can refresh them later. Data confidentiality is crucial, so please handle the file locally and return only the finished workbook.
Once I review and confirm that the counts, charts, and summary match what I expect, the job is complete.
Please organise the end result so the workbook contains:
• a tidy “Data_Clean” sheet (original structure preserved, just scrubbed for blanks, obvious entry errors, and duplicate rows)
• one or more frequency tables built with native Excel functions or PivotTables, clearly labelled
• visual snapshots (histogram, bar, or column charts as appropriate) linked to those tables
• a brief “Summary” tab that highlights the main takeaways in plain language—no more than a few paragraphs and bullet points where it helps
Everything must remain in Excel—no external BI tools this round. Power Query is fine if it simplifies the cleaning steps, but keep the queries saved so I can refresh them later. Data confidentiality is crucial, so please handle the file locally and return only the finished workbook.
Once I review and confirm that the counts, charts, and summary match what I expect, the job is complete.