How to aggregate data in SPSS (Data Aggregation)

In this video, I show how data aggregation is done in SPSS. Data aggregation is used when there is a need to change the unit of analysis from, let's say, individual level to firm level. Or, in science research, one phenomenon may require multiple observations per subject and thus aggregation may be needed. However, before aggregating the data, we might first want to check inter-rater reliability and inter-rater agreement. For more on this please refer to James (1984) and James (1993).
PS: Sorry about a few squeaks!

[@aishascott2363]

This video was excellent! I'm writing a research proposal and needed to explain in the data analysis section how I plan to disaggregate the data by race, gender and language spoken at home. This video was clear and concise, thank you!

[@myregentuniversityexperien6468]

This is exactly what I was looking for. Thank you so much for an extremely clear and concise explanation and presentation.

[@milehigh899]

Glad it helped. Have identified the glitch and fixed it for future videos. Thanks for watching and commenting:)

[@zhao011]

thank you! it's exactly what I'm looking for

[@mentalsynergy8363]

Thank you, yes it was helpful. Didn´t find further information in Andy Field´s Book. So I watched your simple and clear explained video! :)

[@carloserodrod]

Thanks for you video!. It has been the only one that clarifies my question about this function.

[@rebin_daho22]

You are a very good teacher thank you ♥️♥️

[@WarwickYT]

Just wanted to give you a quick 'thank you'. This has helped me greatly. Thanks, and liked!

[@milehigh899]

Hi, glad the video helped. As I understand, you are left with only 20 cases now (which could be 20 organizations you collected data from). In most situations significance issues will occur, however it must be noted that your unit of analysis now is "organization". Unless you have some strong support from literature suggesting that surveying as small a number as 20 organizations is acceptable, I suggest you collect data from more firms.

[@zachburton2347]

Thank you sir for the video. It helped a lot with teaching me about aggregator variable in SPSS. If you have more videos, I plan to watch them. :)

[@milehigh899]

Glad the video helped. Thanks for visiting.

[@ZMQ7028]

Dear Muzamil, thanks for your response. I mean the multilevel linear models using data with two or three levels, e.g., regional, organizational and individual levels. Hope I make it clear. Thank you.

[@milehigh899]

That will also make the results more generalisable. I hope this gives you some idea. PS: my video uses hypothetical data.

[@ranikirana2627]

Thanks! It's very useful for me. And btw what the use of inter-rater reability and inter-rater agreement? And how to check that? I found that in your note below.

[@lifefree0122]

Thank you for this video!!!! It indeed helps a lot! ^^

[@LaxmanGanapati]

Thank you very much, Muzamil. I was grappling with that. Should the data be first sorted by the break variable?

[@danielyanV]

Thank you, Muzamil

[@milehigh899]

You're Welcome.

[@ZMQ7028]

Dear Muzamil, thank you so much. This is very helpful.
Are you interested in preparing a video regarding how to conduct multilevel analysis with SPSS? Thank you. Mike

[@Lammy2k]

Nooo, I accidentlz pressed Dislike :(

[@pplo]

don't know if you're trolling but you know that you can unclick it, don't you?

[@Lammy2k]

Actually I did not know that :)

[@pplo]

Lammy2k ;)