SPSS warning from regression
Locked
 
|
Dear list,
I am running multiple regression, but SPSS keeps telling me: Warnings There are no valid cases for models with dependent variable alldays. Statistics cannot be computed. No valid cases found. Equation-building skipped. I checked the data and it seems all right. I also ran descriptives and the results come out right. Anybody also had such problem before? Any suggestions to fix the problem? Thank you! Regards, Yifan Lu |
Re: SPSS warning from regression
|
At 05:50 PM 3/5/2007, Yifan Lu wrote:
>I am running multiple regression, but SPSS keeps telling me: > >>Warnings >>There are no valid cases for models with dependent variable alldays. >>Statistics cannot be computed. >>No valid cases found. Equation-building skipped. > >Anybody also had such problem before? Any suggestions to fix the >problem? Thank you! The default (and recommended) practice for regression is 'listwise deletion': a case is excluded if any of the dependent or independent variables is missing. The problem you describe can arise when you lose all data because each case has some variable missing. >I checked the data and it seems all right. I also ran descriptives and >the results come out right. Descriptives won't tell you enough; they give the statistics on single variables, not on all of them together. Look at your variables, especially for . Any that are missing for a large proportion of the cases . Any that may be mutually exclusive - if one is present, the other will be missing In principle, you could get your problem from plain bad luck: you don't have much missing data, but by chance every case has some missing variable. (In this case, missing value imputation may be warranted.) More commonly, though, there's something in the structure of your data that ensures you don't have complete data for any case. Look for that first. -Good luck, Richard Ristow |
Re: SPSS warning from regression
|
|
In reply to this post by Yifan Lu-3
When you ran descriptive, did you include all the variables used in regression? If so, what is the listwise N shown in the descriptives output? If any variable used in the regression has a missing value, that case is excluded from the analysis.
-----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Yifan Lu Sent: Monday, March 05, 2007 4:50 PM To: [hidden email] Subject: SPSS warning from regression Dear list, I am running multiple regression, but SPSS keeps telling me: Warnings There are no valid cases for models with dependent variable alldays. Statistics cannot be computed. No valid cases found. Equation-building skipped. I checked the data and it seems all right. I also ran descriptives and the results come out right. Anybody also had such problem before? Any suggestions to fix the problem? Thank you! Regards, Yifan Lu |
Re: SPSS warning from regression
|
|
In reply to this post by Yifan Lu-3
One of the dependent variable must be having many missing values so please
check for the missing values in the dependent variable list. -Regards, Nivruti Hinge Senior Member Of Technical Staff Persistent Systems Pvt. Ltd. http://www.persistentsys.com Direct : +91 (20) 30235627 ____________________________________________________________________________ _______________ Persistent Systems - Software Development Partner for Competitive Advantage. Persistent Systems provides custom software product development services. With over 15 years, 140 customers, and 700 release cycles experience, we deliver unmatched value of higher quality, faster time to market and lower total costs. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Yifan Lu Sent: Tuesday, March 06, 2007 4:20 AM To: [hidden email] Subject: SPSS warning from regression Dear list, I am running multiple regression, but SPSS keeps telling me: Warnings There are no valid cases for models with dependent variable alldays. Statistics cannot be computed. No valid cases found. Equation-building skipped. I checked the data and it seems all right. I also ran descriptives and the results come out right. Anybody also had such problem before? Any suggestions to fix the problem? Thank you! Regards, Yifan Lu DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails. |
Re: SPSS warning from regression
|
|
In reply to this post by Yifan Lu-3
This is telling you that for some reason SPSS is not finding the
dependent variable. Therefore it reports it to you as missing and does nothing on the regression equation. I actually find frustrating trying to learn SPSS. Fermin Ornelas, Ph.D. Management Analyst III, AZ DES Tel: (602) 542-5639 E-mail: [hidden email] -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Nivruti Hinge Sent: Monday, March 05, 2007 9:40 PM To: [hidden email] Subject: Re: SPSS warning from regression One of the dependent variable must be having many missing values so please check for the missing values in the dependent variable list. -Regards, Nivruti Hinge Senior Member Of Technical Staff Persistent Systems Pvt. Ltd. http://www.persistentsys.com Direct : +91 (20) 30235627 ________________________________________________________________________ ____ _______________ Persistent Systems - Software Development Partner for Competitive Advantage. Persistent Systems provides custom software product development services. With over 15 years, 140 customers, and 700 release cycles experience, we deliver unmatched value of higher quality, faster time to market and lower total costs. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Yifan Lu Sent: Tuesday, March 06, 2007 4:20 AM To: [hidden email] Subject: SPSS warning from regression Dear list, I am running multiple regression, but SPSS keeps telling me: Warnings There are no valid cases for models with dependent variable alldays. Statistics cannot be computed. No valid cases found. Equation-building skipped. I checked the data and it seems all right. I also ran descriptives and the results come out right. Anybody also had such problem before? Any suggestions to fix the problem? Thank you! Regards, Yifan Lu DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails. NOTICE: This e-mail (and any attachments) may contain PRIVILEGED OR CONFIDENTIAL information and is intended only for the use of the specific individual(s) to whom it is addressed. It may contain information that is privileged and confidential under state and federal law. This information may be used or disclosed only in accordance with law, and you may be subject to penalties under law for improper use or further disclosure of the information in this e-mail and its attachments. If you have received this e-mail in error, please immediately notify the person named above by reply e-mail, and then delete the original e-mail. Thank you. |
Re: SPSS warning from regression
|
|
This is not exactly a case of "not finding the dependent variable"
or "one of the dependent variables having missing values". The problem is that any case for which at least one variable in the equation (dependent or independent) has a missing value is excluded from the analysis. If all the cases have a missing value for at least one of the relevant variables, then all cases were be excluded and there would be no cases left for the analysis; in such a situation SPSS reports there are no valid cases found and no equation can be built. Facing such plight, you should analyze the pattern of missing values. If it is mainly the responsibility of one specific variable, excluding that variable from the analysis may be enough to leave you with enough cases, though perhaps that variable may be essential to your theoretical pursuit. Another approach is imputation of values (e.g. using regression, as in the SPSS Missing Values module) in order to have valid (albeit not really observed) values for all variables and cases, though this approach may be disputable if applied indiscriminately. One should also analyze whether the missing values are distributed randomly or following some pattern. Hector -----Mensaje original----- De: SPSSX(r) Discussion [mailto:[hidden email]] En nombre de Ornelas, Fermin Enviado el: 06 March 2007 16:08 Para: [hidden email] Asunto: Re: SPSS warning from regression This is telling you that for some reason SPSS is not finding the dependent variable. Therefore it reports it to you as missing and does nothing on the regression equation. I actually find frustrating trying to learn SPSS. Fermin Ornelas, Ph.D. Management Analyst III, AZ DES Tel: (602) 542-5639 E-mail: [hidden email] -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Nivruti Hinge Sent: Monday, March 05, 2007 9:40 PM To: [hidden email] Subject: Re: SPSS warning from regression One of the dependent variable must be having many missing values so please check for the missing values in the dependent variable list. -Regards, Nivruti Hinge Senior Member Of Technical Staff Persistent Systems Pvt. Ltd. http://www.persistentsys.com Direct : +91 (20) 30235627 ________________________________________________________________________ ____ _______________ Persistent Systems - Software Development Partner for Competitive Advantage. Persistent Systems provides custom software product development services. With over 15 years, 140 customers, and 700 release cycles experience, we deliver unmatched value of higher quality, faster time to market and lowe total costs. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Yifan Lu Sent: Tuesday, March 06, 2007 4:20 AM To: [hidden email] Subject: SPSS warning from regression Dear list, I am running multiple regression, but SPSS keeps telling me: Warnings There are no valid cases for models with dependent variable alldays. Statistics cannot be computed. No valid cases found. Equation-building skipped. I checked the data and it seems all right. I also ran descriptives and the results come out right. Anybody also had such problem before? Any suggestions to fix the problem? Thank you! Regards, Yifan Lu DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails. NOTICE: This e-mail (and any attachments) may contain PRIVILEGED OR CONFIDENTIAL information and is intended only for the use of the specific individual(s) to whom it is addressed. It may contain information that is privileged and confidential under state and federal law. This information may be used or disclosed only in accordance with law, and you may be subject to penalties under law for improper use or further disclosure of the information in this e-mail and its attachments. If you have received this e-mail in error, please immediately notify the person named above by reply e-mail, and then delete the original e-mail. Thank you. |
Re: SPSS warning from regression
|
|
In reply to this post by Yifan Lu-3
In theory when building a statistical model, prior to undertaking the
actual estimation one must carry out some exploratory analysis to ensure the integrity of the data. That is things like what percentage of values for each variable are missing, what are the range values for the predictors, are the values consistent with a priori considerations derived either from personal experience or past research studies. Some correlation analysis between the response variable and the predictors could give a hint on what to expect from the final estimation. Once one is satisfied and verified some of the exploratory analysis then it is time to do the actual estimation. Doing those preliminary steps will limit the possibility of getting non sense results. Furthermore, once the final model is obtained one must verify that certain model assumptions are met such as normality, constant variance, independence, an outliers. If the model passes those filters then one still has to consider things such as parameter significance, signs expectations for the parameter estimates, R^2, etc. Fermin Ornelas, Ph.D. Management Analyst III, AZ DES Tel: (602) 542-5639 E-mail: [hidden email] -----Original Message----- From: Hector Maletta [mailto:[hidden email]] Sent: Tuesday, March 06, 2007 8:19 AM To: Ornelas, Fermin; [hidden email] Subject: RE: SPSS warning from regression This is not exactly a case of "not finding the dependent variable" or "one of the dependent variables having missing values". The problem is that any case for which at least one variable in the equation (dependent or independent) has a missing value is excluded from the analysis. If all the cases have a missing value for at least one of the relevant variables, then all cases were be excluded and there would be no cases left for the analysis; in such a situation SPSS reports there are no valid cases found and no equation can be built. Facing such plight, you should analyze the pattern of missing values. If it is mainly the responsibility of one specific variable, excluding that variable from the analysis may be enough to leave you with enough cases, though perhaps that variable may be essential to your theoretical pursuit. Another approach is imputation of values (e.g. using regression, as in the SPSS Missing Values module) in order to have valid (albeit not really observed) values for all variables and cases, though this approach may be disputable if applied indiscriminately. One should also analyze whether the missing values are distributed randomly or following some pattern. Hector -----Mensaje original----- De: SPSSX(r) Discussion [mailto:[hidden email]] En nombre de Ornelas, Fermin Enviado el: 06 March 2007 16:08 Para: [hidden email] Asunto: Re: SPSS warning from regression This is telling you that for some reason SPSS is not finding the dependent variable. Therefore it reports it to you as missing and does nothing on the regression equation. I actually find frustrating trying to learn SPSS. Fermin Ornelas, Ph.D. Management Analyst III, AZ DES Tel: (602) 542-5639 E-mail: [hidden email] -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Nivruti Hinge Sent: Monday, March 05, 2007 9:40 PM To: [hidden email] Subject: Re: SPSS warning from regression One of the dependent variable must be having many missing values so please check for the missing values in the dependent variable list. -Regards, Nivruti Hinge Senior Member Of Technical Staff Persistent Systems Pvt. Ltd. http://www.persistentsys.com Direct : +91 (20) 30235627 ________________________________________________________________________ ____ _______________ Persistent Systems - Software Development Partner for Competitive Advantage. Persistent Systems provides custom software product development services. With over 15 years, 140 customers, and 700 release cycles experience, we deliver unmatched value of higher quality, faster time to market and lowe total costs. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Yifan Lu Sent: Tuesday, March 06, 2007 4:20 AM To: [hidden email] Subject: SPSS warning from regression Dear list, I am running multiple regression, but SPSS keeps telling me: Warnings There are no valid cases for models with dependent variable alldays. Statistics cannot be computed. No valid cases found. Equation-building skipped. I checked the data and it seems all right. I also ran descriptives and the results come out right. Anybody also had such problem before? Any suggestions to fix the problem? Thank you! Regards, Yifan Lu DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails. NOTICE: This e-mail (and any attachments) may contain PRIVILEGED OR CONFIDENTIAL information and is intended only for the use of the specific individual(s) to whom it is addressed. It may contain information that is privileged and confidential under state and federal law. This information may be used or disclosed only in accordance with law, and you may be subject to penalties under law for improper use or further disclosure of the information in this e-mail and its attachments. If you have received this e-mail in error, please immediately notify the person named above by reply e-mail, and then delete the original e-mail. Thank you. |
Re: SPSS warning from regression
|
|
In reply to this post by Yifan Lu-3
Dude, the quickest way to figure out what is going on is to load all the
variables you want to look at into a bivariate correlation. Under Analyze --> Correlate --> Bivariate. If you see a box full of periods, your regression won't work, the box full of periods means that one question was answered by only part of the respondents and the other question was answered by a different part of the respondents. This usually happens if there is a skip pattern in your data or if the same questions are not answered by everyone in the survey. Multiple regression needs a certain number of cases that have values in all the variables you load into the equation. These guys are right in that you need to understand how your data is structured before running this analysis, it helps to run prior analysis just to see if there are relationships between all of your independent variables and your dependent variables before doing a regression. Don On 3/5/07, Yifan Lu <[hidden email]> wrote: > > Dear list, > > > > I am running multiple regression, but SPSS keeps telling me: > > > > Warnings > > > > There are no valid cases for models with dependent variable alldays. > Statistics cannot be computed. > > No valid cases found. Equation-building skipped. > > > > I checked the data and it seems all right. I also ran descriptives and > the results come out right. Anybody also had such problem before? Any > suggestions to fix the problem? Thank you! > > > > Regards, > > > > Yifan Lu > > > > > |
|
|
In reply to this post by Yifan Lu-3
Thank you all for responding to my question. I found out that I forgot
to exclude an independent variable that has all missing values. Now the problem has been solved. Regards, Yifan -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Yifan Lu Sent: Tuesday, March 06, 2007 4:20 AM To: [hidden email] Subject: SPSS warning from regression Dear list, I am running multiple regression, but SPSS keeps telling me: Warnings There are no valid cases for models with dependent variable alldays. Statistics cannot be computed. No valid cases found. Equation-building skipped. I checked the data and it seems all right. I also ran descriptives and the results come out right. Anybody also had such problem before? Any suggestions to fix the problem? Thank you! Regards, Yifan Lu |
Re: SPSS warning from regression
|
|
In reply to this post by Björn Türoque
At 12:56 PM 3/8/2007, Don Asay wrote:
>Load all the variables you want to look at into a bivariate >correlation. Under Analyze --> Correlate --> Bivariate. If you see a >box full of periods, your >regression won't work. Actually, if you see ONE period your regression won't work. The period (correlation missing) means that the two variables are valid in two or fewer cases. The correlation is a normalized form of the covariance needed for regression; so the covariance can't be computed either. HOWEVER, you can see no periods at all, and it still won't work. With listwise variable deletion (which you should use), only cases with all variables present are available for the regression. You can see this happen, if you run CORRELATIONS with listwise deletion. Like this (SPSS 15 draft output; WRR-not saved separately): List |-----------------------------|---------------------------| |Output Created |08-MAR-2007 16:45:08 | |-----------------------------|---------------------------| CASENUM DEPEND IND1 IND2 IND3 1 .9 . 9.8 7.9 2 7.9 4.4 . 6.8 3 3.7 5.5 1.4 . 4 5.7 . 5.6 7.4 5 9.0 3.3 . 8.0 6 1.8 8.7 8.2 . 7 9.5 . 2.7 8.9 8 6.3 6.0 . 5.4 9 5.6 5.2 3.8 . Number of cases read: 9 Number of cases listed: 9 CORRELATIONS /VARIABLES=DEPEND IND1 IND2 IND3 /PRINT=TWOTAIL NOSIG /MISSING=PAIRWISE . Correlations |-----------------------------|---------------------------| |Output Created |08-MAR-2007 16:45:08 | |-----------------------------|---------------------------| Correlations |------|---------------|--------|--------|-----|-----| | | |DEPEND |IND1 |IND2 |IND3 | |------|---------------|--------|--------|-----|-----| |DEPEND|Pearson |1 |-.900(*)|-.689|.135 | | |Correlation | | | | | | |---------------|--------|--------|-----|-----| | |Sig. (2-tailed)| |.015 |.130 |.799 | | |N |9 |6 |6 |6 | |------|---------------|--------|--------|-----|-----| |IND1 |Pearson |-.900(*)|1 |.903 |-.993| | |Correlation | | | | | | |---------------|--------|--------|-----|-----| | |Sig. (2-tailed)|.015 | |.283 |.073 | | |N |6 |6 |3 |3 | |------|---------------|--------|--------|-----|-----| |IND2 |Pearson |-.689 |.903 |1 |-.563| | |Correlation | | | | | | |---------------|--------|--------|-----|-----| | |Sig. (2-tailed)|.130 |.283 | |.619 | | |N |6 |3 |6 |3 | |------|---------------|--------|--------|-----|-----| |IND3 |Pearson |.135 |-.993 |-.563|1 | | |Correlation | | | | | | |---------------|--------|--------|-----|-----| | |Sig. (2-tailed)|.799 |.073 |.619 | | | |---------------|--------|--------|-----|-----| | |N |6 |3 |3 |6 | |------|---------------|--------|--------|-----|-----| * Correlation is significant at the 0.05 level (2-tailed). CORRELATIONS /VARIABLES=DEPEND IND1 IND2 IND3 /PRINT=TWOTAIL NOSIG /MISSING=LISTWISE . Correlations |-----------------------------|---------------------------| |Output Created |08-MAR-2007 16:45:08 | |-----------------------------|---------------------------| Correlations(b) |------|---------------|------|----|----|----| | | |DEPEND|IND1|IND2|IND3| |------|---------------|------|----|----|----| |DEPEND|Pearson |.(a) |.(a)|.(a)|.(a)| | |Correlation | | | | | | |---------------|------|----|----|----| | |Sig. (2-tailed)| |. |. |. | |------|---------------|------|----|----|----| |IND1 |Pearson |.(a) |.(a)|.(a)|.(a)| | |Correlation | | | | | | |---------------|------|----|----|----| | |Sig. (2-tailed)|. | |. |. | |------|---------------|------|----|----|----| |IND2 |Pearson |.(a) |.(a)|.(a)|.(a)| | |Correlation | | | | | | |---------------|------|----|----|----| | |Sig. (2-tailed)|. |. | |. | |------|---------------|------|----|----|----| |IND3 |Pearson |.(a) |.(a)|.(a)|.(a)| | |Correlation | | | | | | |---------------|------|----|----|----| | |Sig. (2-tailed)|. |. |. | | |------|---------------|------|----|----|----| a Cannot be computed because at least one of the variables is constant. b Listwise N=0 REGRESSION /MISSING LISTWISE /STATISTICS COEFF OUTS R ANOVA /CRITERIA=PIN(.05) POUT(.10) /NOORIGIN /DEPENDENT DEPEND /METHOD=ENTER IND1 IND2 IND3 . Regression |-----------------------------|---------------------------| |Output Created |08-MAR-2007 16:46:39 | |-----------------------------|---------------------------| Warnings |--------------------------------------------------------| |There are no valid cases for models with dependent | |variable DEPEND. | |Statistics cannot be computed. | |--------------------------------------------------------| |No valid cases found. | |Equation-building skipped. | |--------------------------------------------------------| =================== APPENDIX: Test data =================== NEW FILE. INPUT PROGRAM. . NUMERIC CASENUM (F3). . NUMERIC DEPEND (F5.1). . NUMERIC IND1 TO IND3 (F5.1). . LOOP CASENUM = 1 TO 9. . VECTOR DATA_VAR=DEPEND TO IND3. . LOOP #VNUM = 1 TO 4. . COMPUTE DATA_VAR(#VNUM) = RV.UNIFORM(0,10). . COMPUTE #ZAP = 2 + MOD((CASENUM-1),3). . COMPUTE DATA_VAR(#ZAP) = $SYSMIS. . END LOOP. END CASE. . END LOOP. END FILE. END INPUT PROGRAM. LIST. |
|
|
In reply to this post by Yifan Lu-3
Although this reply is slightly late, it may help others that are also facing
the same issue now. If you are doing a multiple regression, with multiple variables, you may have made a rooky erorr of not first calculating the mean and total for the varibles. You do this by , going to transform, then compute variable, then for the label type meaninsertvariablename then in the box put MEAN (Q___ to Q___) this will then create a coloum for this. to get the total again , transform, compute variable, then label total..... then in the box put (Q___ +Q____... etc) this will create a total. then to calcualte the multiple reggresion , go to analyse, regression, linear. in the dv enter the mean dv variable you are mesuring e.g. meanHappiness in the Iv enter the other variables e.g. meanaggression, meanenvironment etc. you can then tap the stat's box and select the correct measures you want , e.g. part and partial correlantions, estimates, model fit, colineraity. then press continue then ok this will then output your results, i hope this helps anyone who comes across this issue. -- 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 |
|
In reply to this post by Richard Ristow
The purpose of statistics is to make reasoned statements about some
phenomenon. Understanding why data is missing is crucial in the reasoning behind statements the data is used to support. Before any analysis is done you should be sure that no $sysmis values exist in your data. A major advantage of SPSS over other packages is the distinction between system-missing and user missing. System-missing in the data means the user has given instructions that the system cannot obey. This means either (a) that on input a value cannot be read according to instructions OR (b) a transformation cannot be done as instructed, e.g., division by zero, or square root of a negative number. System-missing in the results means that some computations in the procedure cannot be done as iinstructed. These can happen because of user missing values. Any $sysmis value means that a user should check on how well (s)he gave instructions. some examples of user missing values might be 0 'Possibly ambiguous zero' -1 'Missing unknown reason' -2 'Missing all HH this Place & Phase' -3 'Entry or coding error' -4 'no people this HH this phase' -5 'Not a dwelling' -6 'All zero all HH this Place & Phase' -10 'Legit filter skip, does not apply' -11 'Mult Response: missing not first response' -12 ‘Mult Response: no mentions at all’ -13 ‘None’ -14 ’Do not know’ -15 ‘not computable’ - 999 'invalid longitude or Latitude' 99 'misprinted data gathering instrument' 98 'more than 1 answer' 97 'interviwer mistake' -1 'no pregnamcies because male' -2 'no prgnacies over 55' -3 'no pregnacies because under 12' -4 'refused to answer ----- Art Kendall Social Research Consultants -- 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
Art Kendall
Social Research Consultants |
|
|
In reply to this post by Richard Ristow
The purpose of statistics is to make reasoned statements about some
phenomenon. Understanding why data is missing is crucial in the reasoning behind statements the data is used to support. Before any analysis is done you should be sure that no $sysmis values exist in your data. A major advantage of SPSS over other packages is the distinction between system-missing and user missing. System-missing in the data means the user has given instructions that the system cannot obey. This means either (a) that on input a value cannot be read according to instructions OR (b) a transformation cannot be done as instructed, e.g., division by zero, or square root of a negative number. System-missing in the results means that some computations in the procedure cannot be done as iinstructed. These can happen because of user missing values. Any $sysmis value means that a user should check on how well (s)he gave instructions. some examples of user missing values might be 0 'Possibly ambiguous zero' -1 'Missing unknown reason' -2 'Missing all HH this Place & Phase' -3 'Entry or coding error' -4 'no people this HH this phase' -5 'Not a dwelling' -6 'All zero all HH this Place & Phase' -10 'Legit filter skip, does not apply' -11 'Mult Response: missing not first response' -12 ‘Mult Response: no mentions at all’ -13 ‘None’ -14 ’Do not know’ -15 ‘not computable’ - 999 'invalid longitude or Latitude' 99 'misprinted data gathering instrument' 98 'more than 1 answer' 97 'interviewer mistake' -1 'no pregnancies because male' -2 'no pregnancies over 55' -3 'no pregnancies because under 12' -4 'refused to answer ----- Art Kendall Social Research Consultants -- 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
Art Kendall
Social Research Consultants |
|
|
In reply to this post by Avneer
The original post, which did not appear in my email, seems to be this. Warnings There are no valid cases for models with dependent variable alldays. Statistics cannot be computed. No valid cases found. Equation-building skipped. I checked the data and it seems all right. I also ran descriptives and the results come out right. Anybody also had such problem before? Any suggestions to fix the problem? Thank you! ----------- This probably means that there was enough missing data to knock out all the cases. A case would be excluded if any of the variables in the regression has a missing value. This has nothing to do with "calculating the mean and total for the variables" except that that calculation from REGRESION would give you the same error message. On Tue, Nov 3, 2020 at 10:24 PM Avneer <[hidden email]> wrote: Although this reply is slightly late, it may help others that are also facing |
Re: SPSS warning from regression
Administrator
|
Adding to Jon's summary, the OP posted this in March 2007:
> Thank you all for responding to my question. I found out that I forgot to > exclude an independent variable that has all missing values. Now the > problem has been solved. Let me also reiterate some advice ViAnn gave earlier in the thread: If one includes all variables in the model on a DESCRIPTIVES command, the Valid N (listwise) result at the bottom of the table will show how many observations will be included in the regression model. As Jon noted, there is no need to compute a mean across variables. HTH. Jon Peck wrote > The original post, which did not appear in my email, seems to be this. > Warnings > > There are no valid cases for models with dependent variable alldays. > Statistics cannot be computed. > > No valid cases found. Equation-building skipped. > > I checked the data and it seems all right. I also ran descriptives and > the results come out right. Anybody also had such problem before? Any > suggestions to fix the problem? Thank you! > ----------- > This probably means that there was enough missing data to knock out all > the cases. > A case would be excluded if any of the variables in the regression has a > missing value. > > This has nothing to do with "calculating the mean and total for the > variables" except that that calculation > from REGRESION would give you the same error message. > > On Tue, Nov 3, 2020 at 10:24 PM Avneer < > avneers@ > > wrote: > >> Although this reply is slightly late, it may help others that are also >> facing >> the same issue now. >> >> If you are doing a multiple regression, with multiple variables, you may >> have made a rooky erorr of not first calculating the mean and total for >> the >> varibles. >> >> You do this by , >> >> going to transform, then compute variable, then for the label type >> meaninsertvariablename then in the box put MEAN (Q___ to Q___) this will >> then create a coloum for this. >> >> to get the total again , transform, compute variable, then label >> total..... >> then in the box put (Q___ +Q____... etc) this will create a total. >> >> then to calcualte the multiple reggresion , go to analyse, regression, >> linear. >> in the dv enter the mean dv variable you are mesuring e.g. meanHappiness >> in the Iv enter the other variables e.g. meanaggression, meanenvironment >> etc. >> >> you can then tap the stat's box and select the correct measures you want >> , >> e.g. part and partial correlantions, estimates, model fit, colineraity. >> >> then press continue then ok >> >> this will then output your results, i hope this helps anyone who comes >> across this issue. >> >> >> >> >> >> -- >> 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 >> > > > -- > Jon K Peck > jkpeck@ > > ===================== > 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 [hidden email] 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 [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
--
Bruce Weaver bweaver@lakeheadu.ca http://sites.google.com/a/lakeheadu.ca/bweaver/ "When all else fails, RTFM." PLEASE NOTE THE FOLLOWING: 1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above. 2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/). |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |