Excel Frequency Distribution Analysis
Budget: ₹600 – ₹1,500 INR
I have a raw experimental dataset that needs a clear descriptive-statistics treatment focused on frequency distributions. Your task is to open the file in Excel, tidy up the data if necessary, and generate frequency tables and companion charts that refresh automatically when new data are dropped in. Please rely on native Excel features—formulas, Pivot Tables, and standard chart types—so the workbook stays fully editable without add-ins or macros.
Deliverables
• Cleaned-up Excel workbook with the original and processed data kept on separate sheets
• Frequency distribution tables for every variable, driven by dynamic formulas or Pivot Tables
• Histograms or bar charts that visualise each distribution and remain linked to the tables
• A brief notes sheet summarising key observations from the distributions
Acceptance criteria
All formulas must recalculate correctly if I paste in updated experimental data, and every chart should update instantly without errors.
Deliverables
• Cleaned-up Excel workbook with the original and processed data kept on separate sheets
• Frequency distribution tables for every variable, driven by dynamic formulas or Pivot Tables
• Histograms or bar charts that visualise each distribution and remain linked to the tables
• A brief notes sheet summarising key observations from the distributions
Acceptance criteria
All formulas must recalculate correctly if I paste in updated experimental data, and every chart should update instantly without errors.