Hello,
I'm trying to run control charts with weighted data, and received an error message stating that cases with non-integer weights will be excluded from the procedure. I've done a Google search, and haven't found recent information about this (the latest was from 2007). Does anybody know of good reference for this? I'm running SPSS 22, release 22.0.0.0, 32-bit, on Windows 7. Thanks, Barry DeCicco ===================== 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 |
I don't know that there is a direct solution, even in GPL. I am unfamiliar with control charts but from source of all things, Wikipedia, it seems that two lines are plotted against time. One is the time unit value, e.g., mean, SD, median, and the other is the time period value. The former is a curve and the latter is a straight line.
I think there is a complicated workaround. The mean of a weighted variable is the sum of the products of values (yi's) times their corresponding weights (wi's), that sum divided by the sum of the weights. (Descriptives accepts non-integer weights so you can check the computation.) Therefore, the aggregate command can be used to compute sum(yi*wi) and sum(wi) by time unit. Post aggregate, divide sum(yi*wi) by sum(wi). That will give you the time unit value. Save these records in a file, call it "tuv". Reopen the raw data file and compute the same quantities but for the entire file, which gives a one record file, and do the post-aggregate division. This is the time period mean. Then do a match files with the time period mean as the table and "tuv" as the file. This is now the input file to the graph command. If you have a lot of these to do, a macro, I'll bet, would be ideal. If you are plotting SDs, you can work out the formulas. I'm not sure if or how weights work for medians. Probably others will know. Gene Maguin -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Barry DeCicco Sent: Friday, April 03, 2015 3:21 PM To: [hidden email] Subject: Question on non-integer weights Hello, I'm trying to run control charts with weighted data, and received an error message stating that cases with non-integer weights will be excluded from the procedure. I've done a Google search, and haven't found recent information about this (the latest was from 2007). Does anybody know of good reference for this? I'm running SPSS 22, release 22.0.0.0, 32-bit, on Windows 7. Thanks, Barry DeCicco ===================== 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 |
Free forum by Nabble | Edit this page |