Calculating statistical significant change in ordinal data

Davidliu

New Member
Joined
Mar 2, 2022
Messages
1
Office Version
  1. 365
Platform
  1. MacOS
Hi!

I would appreciate help with calculating whether there has been a significant change in physical activity levels between two assessment periods.

Question I'm trying to answer: Has the sample become more or less physically active (subjectively assessed) between two tests and is the change statistically significant?
Data collection: A question regarding their physical activity level, possible choices are: 1. Sedentary, 2. Somewhat active, 3. Regularly active, 4. Hard exercise.

Basically I have a lot of data on which ''physical activity level group'' each person in the sample belongs to and then a second assessment 6 months later where the same person either jumped up or down in the possible physical activity groups.

How do I go about calculating change and statistical significance?

Very thanks!
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top