To Art. There's an intermediary and a court case in between the school district and person I am working with. My understanding is that the recode was done by the district and the person does not think we can go back to the district to
get the unrecoded counts. Who knows, maybe the recode was a carefully calculated maneuver to obscure things.
Andy. Thank you for the additional names for this and the links.
All. The data were provided by school, which is identified, and in addition to the EMS call count, we have school level counts of student demographic categories. Perhaps it's obvious but the call counts are the sum of calls made for each student. Overall, the
number of calls to a school is low, no more than 20 in a semester and 70% to 80% of schools have no calls. But, perhaps very conveniently, about 95% of schools who have at least one call are in that 1 to 5=3 category.
Before realizing that the data had been recoded, I had thought to analyze the data as a zero inflated poisson (ZIP) or negative binominal (ZINB).
I had kind of thought of multiple imputation but I thought the imputation would have to be done against either a ZIP or ZINB model rather than a linear regression model and the values have to be between 1 and 5. I've used imputation before but always for continuous
data. I'm not sure but I'd guess that because such a large percentage of schools that made calls are in the 3 category, there is really no way to compute (guess) what the rate parameter would be.
Gene Maguin
-----Original Message-----
From: SPSSX(r) Discussion <
[hidden email]> On Behalf Of David Marso
Sent: Tuesday, August 14, 2018 12:23 PM
To:
[hidden email]
Subject: Re: partially grouped counts
Good to know Bruce! Thanks.
Fishy comment retracted...
----
Bruce Weaver wrote
> Good question, David. Yes, there is (see link below), I just forgot
> to mention it.
>
>
https://www.ibm.com/support/knowledgecenter/en/SSLVMB_25.0.0/statistic
> s_reference_project_ddita/spss/mva/syn_multiple_imputation_constraints
> .html
>
> See MIN = NONE | num and MAX = NONE | num. You can also specify RND=1
> to round imputed values to the nearest integer.
>
> Bruce
>
>
>
> David Marso wrote
>> That sounds a bit fishy. Is there any way to constrain the imputed
>> values to be between 1-5 ? I am not that familiar with MI.
>>
>>
>> Bruce Weaver wrote
>>> Hi Gene. Here's a partially baked suggestion: How about recoding 3 to
>>> -3
>>> (or some other out of range value for counts), treating it as missing,
>>> and
>>> using multiple imputation?
>>>
>>> p.s. - Sorry about the empty post that was sent a few minutes
>>> ago--clicked
>>> the wrong button by mistake!
>>>
>>>
>>>
>>> Maguin, Eugene wrote
>>>> I'd appreciate some suggestions or advice on analyzing the following
>>>> type
>>>> of data. Somebody here has school-level data on the number of EMS calls
>>>> made during a semester for kids. The element that I need help with is
>>>> that
>>>> the school district decided it needed to preserve something and so
>>>> recoded
>>>> the data so that schools with 1 thru 5 calls in a semester were given a
>>>> value of 3, otherwise the true value was recorded. So the distribution
>>>> looks, for example, like 0, 3, 6, 8, 9, 12, etc. I have the enrollment
>>>> at
>>>> each school so I can compute a rate but because of the grouping it is
>>>> not
>>>> accurate. What am asking for is direct advice from anybody who has
>>>> analyzed such data, references to articles about how such data can
>>>> be/has
>>>> been analyzed, how this type of data would be described as for a search
>>>> term (I know that work has been done with completely grouped counts),
>>>> or
>>>> where (other listservs, for instance, to look for advice etc.
>>>>
>>>> Thanks, Gene Magin
>>>>
>>>> =====================
>>>> To manage your subscription to SPSSX-L, send a message to
>>>
>>>> LISTSERV@.UGA
>>>
>>>> (not to SPSSX-L), with no body text except the
>>>> command. To leave the list, send the command
>>>> SIGNOFF SPSSX-L
>>>> For a list of commands to manage subscriptions, send the command
>>>> INFO REFCARD
>>>
>>>
>>>
>>>
>>>
>>> -----
>>> --
>>> Bruce Weaver
>>
>>> bweaver@
>>
>>>
http://sites.google.com/a/lakeheadu.ca/bweaver/
>>>
>>> "When all else fails, RTFM."
>>>
>>> NOTE: My Hotmail account is not monitored regularly.
>>> To send me an e-mail, please use the address shown above.
>>>
>>> --
>>> Sent from:
http://spssx-discussion.1045642.n5.nabble.com/
>>>
>>> =====================
>>> To manage your subscription to SPSSX-L, send a message to
>>
>>> LISTSERV@.UGA
>>
>>> (not to SPSSX-L), with no body text except the
>>> command. To leave the list, send the command
>>> SIGNOFF SPSSX-L
>>> For a list of commands to manage subscriptions, send the command
>>> INFO REFCARD
>>
>> Not
>>
>>
>>
>> -----
>> Please reply to the list and not to my personal email.
>> Those desiring my consulting or training services please feel free to
>> email me.
>> ---
>> "Nolite dare sanctum canibus neque mittatis margaritas vestras ante
>> porcos
>> ne forte conculcent eas pedibus suis."
>> Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff
>> in
>> abyssum?"
>> --
>> Sent from:
http://spssx-discussion.1045642.n5.nabble.com/
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>
>> LISTSERV@.UGA
>
>> (not to SPSSX-L), with no body text except the
>> command. To leave the list, send the command
>> SIGNOFF SPSSX-L
>> For a list of commands to manage subscriptions, send the command
>> INFO REFCARD
>
>
>
>
>
> -----
> --
> Bruce Weaver
> bweaver@
>
http://sites.google.com/a/lakeheadu.ca/bweaver/
>
> "When all else fails, RTFM."
>
> NOTE: My Hotmail account is not monitored regularly.
> To send me an e-mail, please use the address shown above.
>
> --
> Sent from:
http://spssx-discussion.1045642.n5.nabble.com/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> LISTSERV@.UGA
> (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from:
http://spssx-discussion.1045642.n5.nabble.com/
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD