Google Sheets Oncology Workshop Survey Analysis

I have two tabs in a Google Sheets file—67 pre-workshop and 57 post-workshop responses from physicians who attended an oncology session. I need the data cleaned, analysed, and presented in an easy-to-read format right inside the spreadsheet. Here’s what I’m after: • Demographic overview: create basic tables and, where helpful, simple visuals for the demographic fields already captured in the form. • Knowledge change: for the nine self-assessment questions, calculate the change in knowledge rating between pre and post surveys and show the results in clear stacked bar graphs so I can see shifts at a glance. • Four additional questions: provide a concise text summary that highlights the main themes or trends. Please keep all charts and summaries in the same Google Sheets file, add brief captions that explain what each graphic is showing, and make sure formulae remain editable so I can audit your work later.

Projekt-ID: 40064927