Excel Data Prep & Analysis -- 2
Budget: ₹750 – ₹1,250 INR
I have a set of raw survey responses that must be brought into a single, well-structured Excel workbook ready for descriptive statistical analysis. The job starts with straightforward data entry—copying and pasting figures from several source files—then moves on to tidy formatting, consistent cell styles, and the creation of clear headers so every column can be understood at a glance.
Once the data is clean, I need you to build the formulas that will drive the analysis: means, medians, modes, standard deviations, response counts, and percentage breakdowns across key demographic columns. A summary sheet should pull these measures together automatically, updating whenever new data is added.
Deliverables
• Master worksheet containing the cleaned survey data, free of blanks, duplicates, or misalignments
• Formula-driven analysis sheet with descriptive statistics calculated for each question and demographic slice
• Brief note (or comment layer) explaining any complex formulas used and where to paste additional data in the future
Accuracy is essential; any deviation greater than ±0.1% on computed figures will be considered an error to be corrected before project sign-off. A solid command of Excel functions (VLOOKUP/XLOOKUP, COUNTIF(S), AVERAGEIF(S), pivot tables) will make this quick work. Let me know your turnaround time and any clarifying questions, and I’ll share the files right away.
Once the data is clean, I need you to build the formulas that will drive the analysis: means, medians, modes, standard deviations, response counts, and percentage breakdowns across key demographic columns. A summary sheet should pull these measures together automatically, updating whenever new data is added.
Deliverables
• Master worksheet containing the cleaned survey data, free of blanks, duplicates, or misalignments
• Formula-driven analysis sheet with descriptive statistics calculated for each question and demographic slice
• Brief note (or comment layer) explaining any complex formulas used and where to paste additional data in the future
Accuracy is essential; any deviation greater than ±0.1% on computed figures will be considered an error to be corrected before project sign-off. A solid command of Excel functions (VLOOKUP/XLOOKUP, COUNTIF(S), AVERAGEIF(S), pivot tables) will make this quick work. Let me know your turnaround time and any clarifying questions, and I’ll share the files right away.