Binary Logistic Regression - Evaluation of Survey Responses

abhipatel

Involved In Discussions
#1
Am trying to evaluate the survey responses from a group (Yes or no answers to questions 1-4) and rated scale answers (scale of 1-5 (Poor- Excellent) for questions 5-7).

So am running a binary logistic regression for first 4 questions (individually in minitab for each question) and ordinal regression for questions 5-7.

hmmm...issue is I do not know how to interpret much from the results.

Can anyone assist or guide me in interpreting the results and what they reflect?

File is attached (results in seperate tabs).

Thanks:agree:
 

Attachments

Elsmar Forum Sponsor

reynald

Quite Involved in Discussions
#2
Re: Binary Logistic Regression

Hi abhipatel,
I think i don't understand yet what you are trying to accomplish.
Logistic Regression's goal is to create a model where in you can quantify the probability of having "yes" answers given a set of predictors. That is you model the Probability Pr(Answer) = Function of (Predictor Variables).
In your excel file which factors are you considering as the independent variable(s).
Is it the questionaire number such that you are trying to model
Pr(Answer) = Function of (Questionaire #)?
Please let us know,
Regards,
Reynald
 

abhipatel

Involved In Discussions
#3
Re: Binary Logistic Regression

Hi,

Thanks! appreciate the response..maybe i should have done some additional research....anyways we have a survey questonnaire posted out for operators to fill in regarding one of our auditing process system.

Based on their answers we want to determine how effective it is and what counter measures we can take to improve based on their feedback.

A sample question was :How effective do you think your current auditing system is? (Rank : 1-5 (Poor - Excellent)). We want to gauge the perception of the system's user.

Is there a better way to statistically determine and analyze the results? I was under the impression that logisitic regression could do it but based on your answer I think I grossly misunderstood.

Kindly assist with any alternate suggestions if you have one.
 

reynald

Quite Involved in Discussions
#4
Hi,
Maybe a simple confidence interval would do the trick.
It can be interpreted as "I am 95% confident that the percentage of people who would answer yes to Question#1 is between 46.27% and 76.81%.".
The special consideration here is if the interval includes 50%, then you can say that the response if about 50%-50%. If the inteval is higher that 50%, then you can say there more than 50% is infavor of "yes", and os on.
I have re-attached the excel file with a formula for the confidence interval. I only used nornal approxiation though. If you want an 'exact' (more precise, more reliable) you may have to run it in minitab or some other stat software.

Hope that helps,
Reynald
 

Attachments

abhipatel

Involved In Discussions
#5
Thanks Rey,

What would I do for the ordinal scale data in the second tab? How do I interpret those? They are ranked data from 1-5.

Is there any way I could link it to y = f(x) for regression with y being my audit effectiveness and the function of x or predictor variables being the set of questions?

I mean I want to know based on responses how effective mfg thinks their audits are.....what would be the model if the survey is a combination of binary (yes/no answers) and ordinal questions?

Thanks and really appreciate your responses for the confidence interval theory. Hope you could teach me more stuff :cool:
 

reynald

Quite Involved in Discussions
#6
Thanks Rey,

What would I do for the ordinal scale data in the second tab? How do I interpret those? They are ranked data from 1-5.
oopps, i did not notice the second tab.
For that case you can extend the confidence interval into multiple comparisons of proportions. The method is known as the Analysis of Means
Unfortunately it is not easy to do it in excel, so you need to use a stat software for this.
Here is sample output of your data (as well as in attached)
You may look at it this way, "categories 2,4, and 5 have equal proportions of about 0.05 - 0.34. Category 1 has lower proportion than that while category 3 has a higher proportion"
View attachment ANOMeans.bmp

Is there any way I could link it to y = f(x) for regression with y being my audit effectiveness and the function of x or predictor variables being the set of questions?

I mean I want to know based on responses how effective mfg thinks their audits are.....what would be the model if the survey is a combination of binary (yes/no answers) and ordinal questions?
I think thier objectives are not aligned. What you did was to gather data to assess the effectiveness of your audits. If you will use regression then the goal is to gather data to Predict the future effectiveness of audit based on the answers on Q1-Q7 (which will not make sense since audit in itself is concerned with past&present activities).

Thanks and really appreciate your responses for the confidence interval theory. Hope you could teach me more stuff :cool:
I keep on learning as well from the great folks here. They are the really cool guys. :applause:
 

Attachments

Thread starter Similar threads Forum Replies Date
J Binary logistic regression for attribute/discrete data Using Minitab Software 7
J Minitab Rank Deficiency Issue - Binary Logisitic Regression Using Minitab Software 1
optomist1 Sample Size for Attribute Binary Data Inspection, Prints (Drawings), Testing, Sampling and Related Topics 10
A Which test should I use? Binary Y, Continuous X Using Minitab Software 1
howste National Binary Day - 11 November 2011 Coffee Break and Water Cooler Discussions 5
optomist1 Binary & Attribute Data Measures - Electrical Field Failures or Opens Capability, Accuracy and Stability - Processes, Machines, etc. 2
S Calculating Standard Error for a percentage (binary question) from a sample survey Statistical Analysis Tools, Techniques and SPC 1
G Logistic organization and controls - IATF/ISO 9001 audit Nonconformance and Corrective Action 2
A QMS (Quality Management System) for Logistic Agency ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
E How to run an OLS or Logistic Regression when I have Panel Data in Minitab Using Minitab Software 1
S Using Minitab for Multinomial Logistic Regression Using Minitab Software 2
M Internal Warehouse Handling - A Reverse Logistic Case! Process Maps, Process Mapping and Turtle Diagrams 6
W Z-values in Logistic Regression stem from a Wald test? Using Minitab Software 7
M Problem with nonlinear regression Using Minitab Software 12
V Regression and homoscadasticity test Statistical Analysis Tools, Techniques and SPC 8
S Significance of regression, correlation coefficient, hypothesesi, confidence interval Using Minitab Software 8
S Least squares estimate, regression model and corresponding residuals Using Minitab Software 13
N Regression Model (Minitab 18) - Which values my input parameters should have Using Minitab Software 2
A Why I get a different kind of regression equation when I do the same data in a differ Using Minitab Software 7
P Basic Minitab Help - It's about Linear Regression Using Minitab Software 1
R Regression for MTBF (Medical Device: Repairs vs Install Base) with Reliability Data Reliability Analysis - Predictions, Testing and Standards 16
S Regression Control Chart - Process Capability Statistical Analysis Tools, Techniques and SPC 18
C Regression with Life Data, Incorrect Minitab Documentation? Reliability Analysis - Predictions, Testing and Standards 4
P How to do Multiple Regression Analysis in Minitab 16 Using Minitab Software 8
B Using Minitab 17's Stepwise Regression to Predict Feature Using Minitab Software 2
A Predictive Model Development (Regression?) Statistical Analysis Tools, Techniques and SPC 5
S How to use Dummy Variable in Regression Model in Minitab Six Sigma 2
S ANOVA/Regression - Analyzing a Dataset which contains over 4500 Points Using Minitab Software 3
O Minitab Script to Save Regression Plots to an Image File Using Minitab Software 8
W Zero setting of correlation graph when plotting best fit linear regression Statistical Analysis Tools, Techniques and SPC 7
S Regression Analysis / ANOVA using Excel Excel .xls Spreadsheet Templates and Tools 2
M Understanding of Regression and ANOVA in Minitab Statistical Analysis Tools, Techniques and SPC 8
P Regression Analysis for Aging Study in Minitab Statistical Analysis Tools, Techniques and SPC 10
A Questions about Regression for Modeling, Best Experimental Design Using Minitab Software 2
N Linear Regression Formula with Four Variables to a Power Regression Formula Using Minitab Software 2
Q Regression Analysis for the Attached Data - help needed - TIA Reliability Analysis - Predictions, Testing and Standards 13
B Regression analysis with discrete dependent variable and continuous independent var. Statistical Analysis Tools, Techniques and SPC 13
S How to interpret a Linear Regression in Minitab? Using Minitab Software 3
D Multiple regression with student t distribution Using Minitab Software 1
P How to do Nonlinear Regression and generate a Correlation Statistical Analysis Tools, Techniques and SPC 14
BradM Calling all Regression Analysis Pros! Statistical Analysis Tools, Techniques and SPC 1
C Degrees of Freedom with Linear Regression - Pressure Sensor Uncertainty Measurement Uncertainty (MU) 15
S CQE sample exam - Question 23 about a regression model Statistical Analysis Tools, Techniques and SPC 3
R Prediction Intervals for Quadratic Regression Statistical Analysis Tools, Techniques and SPC 4
S Interpreting Linear Regression Results from Minitab Using Minitab Software 15
R Can Factorial Design provide Regression Equation like RSM? Using Minitab Software 4
V Identifying Significant Factors - Regression Analysis vs Correlation vs ANOVA vs DOE Quality Tools, Improvement and Analysis 7
Q Can I use Regression Analysis in the following scenario Statistical Analysis Tools, Techniques and SPC 18
E Minitab Regression Analysis to predict Horse Racing result Using Minitab Software 2
M Regression Analysis Help - Factors influencing a Dependent Variable Using Minitab Software 7

Similar threads

Top Bottom