1
$\begingroup$

I had an intervention with control group and experimental group. Both groups had pre- and post-tests. So I was using 4 graphs to explain in a presentation. (pre-test control, pre-test experiment & post-test control and post-test experiment) Each graph showed responses to a likert scale question with 5 options.

One of the listeners asked me if I could show the shift of 'how many' students had moved from one option in pre-test to some other option in post-test. I can use pivot tables in Excel however, I am not very good in stats.

Can someone kindly guide me through this?

$\endgroup$
2
$\begingroup$

If you're familiar with Excel then "Conditional Formatting" (YouTube Intro) is a good candidate.

First, tabulate the pre- and post-scores, and highlight the data:

enter image description here

Then, under Home > Conditional Formatting, choose the scheme that fits your emphasis:

enter image description here

The result would be a labelled heat map that shows both numbers and their relative magnitude on a color scale.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.