Purchase Solution

SPSS Logistic Regression

Not what you're looking for?

Ask Custom Question

I have a set of data and I'm running logistic regression using s.p.s.s.
I'm getting great results but when i try to run the formula ((e^(b0+b1*x1...bi*xi))/(1+e^(bo+b1*x1....bi*xi)) on excel I'm getting bad result.

Can you help me to figure out whats going on here and why I don't get the right result on the excel? Can you show me how to do it right?

the variables are : tempaug, per, and tempaug*per. and im trying to get a binary response (safe=0 not safe=1)
now, the spss plot shows that it should look like that:

P(y) = 1/ (1+ e^-(61.599-2.249*tempaug-0.137*per+0.005*per_by_tempaug))
(its the same as the formula above)

that should give me accuracy of 81.8% with cut value of 0.5

4 files attached:

1. the set of data on spss
2. the spps logistic regression plot
3. the excel file, with the formula and the results (yellow- real results; red-calculated results)
4. the spss logistic regression plot in PDF format

Attachments
Purchase this Solution
Solution Summary

The expert examines SPSS logistic regression.

Solution Preview

You said that you wanted to use the formula :(e^(b0+b1*x1...bi*xi))/(1+e^(bo+b1*x1....bi*xi). The formula you used is mathematically equivalent, but for some reason, you weren't getting the same results in Excel as you did in SPSS. To be honest, I don't know why that is, but I suspect that there was some rounding issues: numbers could have been dropped as calculations moved from columns P to Q to R ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Logistic Regression with SPSS

    This solution is comprised of a detailed explanation of Logistic Regression. This solution mainly discussed the Logistic Regression with SPSS. This solution mainly discussed the SPSS output of logistic regression.

  • Logistic Forward Multiple Regression Analysis Using SPSS

    580476 Logistic Forward Multiple Regression Analysis Using SPSS Logistic Regression: Discovering Statistics (4th ed) Using IBM SPSS Statistics Chapter 19, "Logistic Regression", and using IBM SPSS Statistics the following: 1.

  • Logistic regression

    Note: Needs SPSS v19 to view output .sav and .spv files Please see the answers . Calculations are done in SPSS. Step by step method for analyzing the data using logistic regression is given in the answer.

  • Logistic Multiple Regression Analysis Using SPSS

    This solution is comprised of a detailed explanation of Logistic regression analysis using SPSS. This solution mainly discussed the Logistic regression analysis with the help of SPSS software. The solution provides the interpretation of SPSS output.

  • Step-wise logistic regression using SPSS

    598721 Step-wise logistic regression using SPSS An HIV researcher explored the factors that influenced condom use with a new partner (relationship less than 1 month old).

  • Comparing Least-Squares Regression with Logistic Regression

    The input variables for logistic regression can be a mix of continuous, interval, and nominal data and need not be normally distributed. Statistical software like SPSS is used for conducting logistic regression.

  • Binary logistic regression with SPSS

    598307 Binary logistic regression with SPSS Task: Four hundred and sixty-seven lecturers completed questionnaire measures of Burnout (burnt out or not), Perceived Control (high score = low perceived control), Coping Style (high score = high ability to

  • Regression

    4903 Regression A. Fit a logistic regression model to predict the probability of successful completion of the MBA program based on undergraduate grade point average and GMAT score. b.

  • Multiple logistic regression in SPSS

    236889 Multiple logistic regression in SPSS Question 2: Multiple logistic regression The model presented below is an extension of the simple logistic model above, except that there are now two predictors of 'expire': 'blunt' and 'iss.'

View More Related Solutions