Regression analysis mathematically describes the relationship between a set of independent variables and a dependent variable. There are numerous types of regression models that you can use. This choice often depends on the kind of data you have for the dependent variable and the type of model that provides the best fit. In this post, I cover the more common types of regression analyses and how to decide which one is right for your data.
I’ll provide an overview along with information to help you choose. I organize the types of regression by the different kinds of dependent variable. If you’re not sure which procedure to use, determine which type of dependent variable you have, and then focus on that section in this post. This process should help narrow the choices! I’ll cover regression models that are appropriate for dependent variables that measure continuous, categorical, and count data.
Related post: Guide to Data Types and How to Graph Them
Regression Analysis with Continuous Dependent Variables
Regression analysis with a continuous dependent variable is probably the first type that comes to mind. While this is the primary case, you still need to decide which one to use.
Continuous variables are a measurement on a continuous scale, such as weight, time, and length.
Linear regression
Linear regression, also known as ordinary least squares (OLS) and linear least squares, is the real workhorse of the regression world. Use linear regression to understand the mean change in a dependent variable given a one-unit change in each independent variable. You can also use polynomials to model curvature and include interaction effects. Despite the term “linear model,” this type can model curvature.
This analysis estimates parameters by minimizing the sum of the squared errors (SSE). Linear models are the most common and most straightforward to use. If you have a continuous dependent variable, linear regression is probably the first type you should consider.
There are some special options available for linear regression.
Linear model that uses a polynomial to model curvature Fitted line plots: If you have one independent variable and the dependent variable, use a fitted line plot to display the data along with the fitted regression line and essential regression output. These graphs make understanding the model more intuitive.
- Stepwise regression and Best subsets regression: These automated methods can help identify candidate variables early in the model specification process.
Advanced types of linear regression
Linear models are the oldest type of regression. It was designed so that statisticians can do the calculations by hand. However, OLS has several weaknesses, including a sensitivity to both outliers and multicollinearity, and it is prone to overfitting. To address these problems, statisticians have developed several advanced variants:
- Ridge regression allows you to analyze data even when severe multicollinearity is present and helps prevent overfitting. This type of model reduces the large, problematic variance that multicollinearity causes by introducing a slight bias in the estimates. The procedure trades away much of the variance in exchange for a little bias, which produces more useful coefficient estimates when multicollinearity is present.
- Lasso regression (least absolute shrinkage and selection operator) performs variable selection that aims to increase prediction accuracy by identifying a simpler model. It is similar to Ridge regression but with variable selection.
- Partial least squares (PLS) regression is useful when you have very few observations compared to the number of independent variables or when your independent variables are highly correlated. PLS decreases the independent variables down to a smaller number of uncorrelated components, similar to Principal Components Analysis. Then, the procedure performs linear regression on these components rather the original data. PLS emphasizes developing predictive models and is not used for screening variables. Unlike OLS, you can include multiple continuous dependent variables. PLS uses the correlation structure to identify smaller effects and model multivariate patterns in the dependent variables.
Nonlinear regression
Nonlinear regression also requires a continuous dependent variable, but it provides a greater flexibility to fit curves than linear regression.
Like OLS, nonlinear regression estimates the parameters by minimizing the SSE. However, nonlinear models use an iterative algorithm rather than the linear approach of solving them directly with matrix equations. What this means for you is that you need to worry about which algorithm to use, specifying good starting values, and the possibility of either not converging on a solution or converging on a local minimum rather than a global minimum SSE. And, that’s in addition to specifying the correct functional form!
Most nonlinear models have one continuous independent variable, but it is possible to have more than one. When you have one independent variable, you can graph the results using a fitted line plot.
My advice is to fit a model using linear regression first and then determine whether the linear model provides an adequate fit by checking the residual plots. If you can’t obtain a good fit using linear regression, then try a nonlinear model because it can fit a wider variety of curves. I always recommend that you try OLS first because it is easier to perform and interpret.
I’ve written quite a bit about the differences between linear and nonlinear models. Read the following posts to learn the differences between these two types, how to choose which one is best for your data, and how to interpret the results.
- What is the Difference Between Linear and Nonlinear Models?
- How to Choose Between Linear and Nonlinear Regression?
- Curve Fitting with Linear and Nonlinear Regression
Regression Analysis with Categorical Dependent Variables
So far, we’ve looked at models that require a continuous dependent variable. Next, let’s move on to categorical independent variables. A categorical variable has values that you can put into a countable number of distinct groups based on a characteristic. Logistic regression transforms the dependent variable and then uses Maximum Likelihood Estimation, rather than least squares, to estimate the parameters.
Logistic regression describes the relationship between a set of independent variables and a categorical dependent variable. Choose the type of logistic model based on the type of categorical dependent variable you have.
Binary Logistic Regression
Use binary logistic regression to understand how changes in the independent variables are associated with changes in the probability of an event occurring. This type of model requires a binary dependent variable. A binary variable has only two possible values, such as pass and fail.
Example: Political scientists assess the odds of the incumbent U.S. President winning reelection based on stock market performance.
Read my post about a binary logistic model that estimates the probability of House Republicans belonging to the Freedom Caucus.
Ordinal Logistic Regression
Ordinal logistic regression models the relationship between a set of predictors and an ordinal response variable. An ordinal response has at least three groups which have a natural order, such as hot, medium, and cold.
Example: Market analysts want to determine which variables influence the decision to buy large, medium, or small popcorn at the movie theater.
Nominal Logistic Regression
Nominal logistic regression models the relationship between a set of independent variables and a nominal dependent variable. A nominal variable has at least three groups which do not have a natural order, such as scratch, dent, and tear.
Example: A quality analyst studies the variables that affect the odds of the type of product defects: scratches, dents, and tears.
Regression Analysis with Count Dependent Variables
If your dependent variable is a count of items, events, results, or activities, you might need to use a different type of regression model. Counts are nonnegative integers (0, 1, 2, etc.). Count data with higher means tend to be normally distributed and you can often use OLS. However, count data with smaller means can be skewed, and linear regression might have a hard time fitting these data. For these cases, there are several types of models you can use.
Poisson regression
Count data frequently follow the Poisson distribution, which makes Poisson Regression a good possibility. Poisson variables are a count of something over a constant amount of time, area, or another consistent length of observation. With a Poisson variable, you can calculate and assess a rate of occurrence. A classic example of a Poisson dataset is provided by Ladislaus Bortkiewicz, a Russian economist, who analyzed annual deaths caused by horse kicks in the Prussian Army from 1875-1984.
Use Poisson regression to model how changes in the independent variables are associated with changes in the counts. Poisson models are similar to logistic models because they use Maximum Likelihood Estimation and transform the dependent variable using the natural log. Poisson models can be suitable for rate data, where the rate is a count of events divided by a measure of that unit’s exposure (a consistent unit of observation). For example, homicides per month.
Example: An analyst uses Poisson regression to model the number of calls that a call center receives daily.
Alternatives to Poisson regression for count data
Not all count data follow the Poisson distribution because this distribution has some stringent restrictions. Fortunately, there are alternative analyses you can perform when you have count data.
Negative binomial regression: Poisson regression assumes that the variance equals the mean. When the variance is greater than the mean, your model has overdispersion. A negative binomial model, also known as NB2, can be more appropriate when overdispersion is present.
Zero-inflated models: Your count data might have too many zeros to follow the Poisson distribution. In other words, there are more zeros than the Poisson regression predicts. Zero-inflated models assume that two separate processes work together to produce the excessive zeros. One process determines whether there are zero events or more than zero events. The other is the Poisson process that determines how many events occur, some of which some can be zero. An example makes this clearer!
Suppose park rangers count the number of fish caught by each park visitor as they exit the park. A zero-inflated model might be appropriate for this scenario because there are two processes for catching zero fish:
- Some park visitors catch zero fish because they did not go fishing.
- Other visitors went fishing, and some of these people caught zero fish.
Whew! That’s many different types of regression analysis! If you’re trying to figure out which one to choose, I hope you will use this information to point yourself in the right direction!
If you’re learning regression and like the approach I use in my blog, check out my eBook!
Hi Jim, thanks for the detailed breakdown of the different types of regression analysis!
I would like to seek your advice on how I should run some of my own tests for my undergrad final year study, which is on the topic of how temporary depletion of level of executive functioning may affect honesty behaviour in young children.
– My main IV is executive functioning: either depleted or not depleted (categorical).
– My other variables are a mix of categorical and continuous variables, namely: gender, age (in years), Theory of Mind score, and English vocabulary score.
– My only DV is the child’s honesty behaviour: either truth-teller or lie-teller (categorical).
I am currently about to carry out my statistical tests on SPSS, and have dummy coded my categorical variables to numerical codes.
I haven’t learned the more advanced statistical tests in my undergrad courses, but based on what I have read in your post, I think the Binary Logistic Regression is most suitable for my study’s design. The question I have is, how do I proceed from there?
1) Specifically, how do I control for my other variables (i.e. gender, age, ToM score, vocab score) to ensure that my model is mostly looking at the effects of executive functioning on honesty behaviour? Is that already accounted for by the regression? If not, do I need to do additional tests even before I carry out my regression? What tests would these be to control for these other factors?
2) Conversely, how do I check if the other variables have main effects or interaction effects with my main IV, assuming that they may present? Can the regression reveal these? If not, what other tests should I run?
I am sorry if these questions are really basic, I am just a mess when it comes to math and statistics. I would appreciate any feedback I can get from you! Thank you and stay safe!
Hi Jim,
I hope you’re keeping well wherever you are during these uncertain times.
I’d really appreciate it if you could give me some help when you get the chance!
I’m writing up the results from my study which is looking at the effect of a single nucleotide polymorphism (random genetic variation) on postprandial glucose response.
I have identified no significant difference between any of the three genotype groups and any of my glucose response outcome variables (fasting, peak, 2-hour postprandial, and incremental area under the curve). I have 73 participants in my sample (27 female and 46 male), and identified a significant difference between sexes for 2-hour postprandial glucose concentration.
Using SPSS statistics, I would like to conduct some kind of multiple regression to assess the effects of both sex and genotype on the different measures of glucose response (primarily 2-hour postprandial to begin with). Therefore, my variables will be categorical.
Would I have to assign numbers to my categories?
I am unsure if my data has a linear relationship, and I don’t know how to check this in SPSS especially with categorical variables. Most of my outcome measures are also non-normally distributed.
Will a non-normal distribution and lack of linear relationship prevent me from doing a multiple regression analysis?
Thank you in advance!
Hi Jonny,
Can you more fully describe the nature of your dependent variable and how you’ll record it? That would help me answer. Thank you!
Thank you so much!
Easy explanation of the different types of regression
Hi Jim,
I would like to establish the correlation or lack there of between the cost of accidents and the experience level of the person who caused the accident. I have three levels of experience.
Thank you
thank you jim! its all making much more sense. i guess im getting confused because ive been seeing some examples where people use t tests or mann whitney u tests to compare things like age or amount of a drug (continuous variables) to a categorical outcome, but that would obviously be incorrect since they’re the independent variables not the dependent variables right?
appreciate your help!
Hi There! thank you very much for this. I was wondering what kind of analysis you would use to compare a continuous independent variable (i.e. age) with a binary categorical dependent variable (i.e. mortality)?
would that just be a logistic regression?
Hi Eva, yes, that sounds like a situation where you’d use a binary logistic regression model.
Hello Jim,
So nice of you !
Thank you so much for the guidance 🙂
Regards
Sujit
You’re very welcome! Again, sorry for the delay! 🙂
You Never replied my query 🙂
Regards
Sujit
Hi Sujit,
Apologies for the delay. Sometimes life gets in the way, especially during these days.
Because you’re doing a count of walk-ins, it sounds like you might need Poisson or Negative Binomial regression. Although it depends on the distribution of your count variable. If the count is high enough, the distribution can approximate the normal distribution and OLS might be okay to use. You’ll need to define a consistent period for the count. For more information, read the section in the post titled, “Regression Analysis with Count Dependent Variables”–it’s near the end.
Thanks a lot for the explanation!
I’m collecting data at 2 time points, and would like my variables at Time 1 to predict Time 2. So my DV is a variable at Time 2 and as predictors, I have 1 variable at Time 1 (not continuous) as well as a 1 categorical variable from Time 2 (condition = 1 or 2). I am assuming that I’ll need to use multiple linear regression?
Regression is new to me, so I’m not sure which model to use if I have 1 categorical predictor and another predictor that isnt continuous.
Hi,
What type of variable is Time 1 and what type is Time 2?
I want estimate farmers willingness to use renewable energy. So I want to find out if I can use switch regression to analyze willingness to use. Thanks and waiting your response
I want to test if science and technology has increased peak performance and age amongst different positions in the NFL. What type of regression do you think would be best for this type of test?
Hi James,
Choosing the type of regression analysis is not usually based on the subject area. (There are some exceptions to that rule.) In other words, there’s not a correct type for performance in the NFL. Instead, you need to determine which variable(s) are your dependent variables and the nature of the relationship they have with the independent variables. If your DVs are continuous, I’d recommend starting with least squares regression and determining whether you can obtain a satisfactory fit with it. You can always change analyses as need. Sometimes you’ll learn things along the way that require you to change the type of regression. Although, advance research will help you in that regard as well.
Best of luck with your analysis!
Hello! Hope this finds you well. I am running a multilevel multiple regression analysis for my dissertation. At the individual level, my IV is bullying experiences in schools and DVs are three different health outcomes for students (1 dichotomous, 2 continuous; all mental health). I also have a moderator (LGBTQ identity, dichotomous). This data has been identified all at the school district level for an entire state. At the group level, I have voting data for school districts (second IV; currently in percentages: % for Hillary, % for Trump, in 2016 election). My analysis is hoping to explain the relationship between school district voting records, bullying experiences, and health outcomes for LGBTQ students.
I am planning on using Mplus for analysis. I have a few questions after reading this article:
1) What would your recommended analysis plan be? After reading this article, I was unsure how to apply this to a multilevel, multiple regression analysis in Mplus.
2) What would be the best way to insert voting data into the data set for analysis, given that it is in percentage form? Currently, I was thinking of calculating the difference between voting (80% Clinton, 20% Trump = .60; 20% Clinton, 80% Trump = -.60 on a scale of -1 to 1 from most conservative to most liberal). That way, it could serve as a continuous IV at the group level (level 2) of the multilevel regression.
Lemme know what you think. Thanks for any help you can provide a novice statistician!
Thank you so much Jim . Have a great vacation
Regards
Sujit
Hello Jim,
Any suggestions on my request
Regards
Sujit
Hi Sujit, I’m on vacation now. Will reply when I return. Thanks.
I present my thesis proposal entitled Impacts of ICT on Tax Administration for the Degree Master in Development Economics, I have prepared a yes no questionnaires does ICT has an impact on cost of taxation, tax compliance and tax revenue collection, but here the challenge is which model is preferable, for the time being in the proposal I mention to use Multi-linear regression using OLS, so my question is that my model choice really good?
HI JIM ,
I am going to do master thesis on determinant/factors that affect graduate youth unemployment and which regression model you advise me to use for single dependent variable
Hi Bedilu,
I’d start with linear regression and see how that works. From there you, see how well the model satisfies the assumptions.
Best of luck with your thesis!
Hi everybody,
I’m using panel data to examine the effect of CEO age on tone of annual reports for 5 years. I have applied this model but I am not sure whether it is the best model or no. I am using Stata, year as dummies and random effect:
xtreg tone CEOage controls i.year, re robust
Any help would be hugely appreciated.
Yours Sincerely,
dan billy
Hi,
I want to use a regression model to find the number of charging stations in cities (which is a count data) with respect to different features of the cities (i.e., population, vehicle miles traveled, etc). I tried different models and linear regression gave me the best goodness of fit. Is it wrong to use linear regression for this purpose?
Hi Linda,
The Poisson distribution, which is based on count data, begins to model the normal distribution when the counts are large enough. So, it might be entirely appropriate to use linear regression. Be extra careful in checking those residual plots. If those look good, it’s probably OK to use linear regression. With smaller counts, it’s harder to satisfy the OLS assumptions.
Keep in mind, that you can only interpret goodness-of-fit statistics when the model satisfies the assumption, which you assess by residual plots. A good goodness-of-fit doesn’t necessarily indicate that the residuals are good. Read my post about R-squared for more about this issue. If the residuals aren’t good, you can’t trust the model regardless of what the goodness-of-fit statistics indicate (i.e., you can’t trust them either).
Hello Jim,
Need your guidance for an exercise where I need to establish Walkin to a store as a function of number of print inserts by a brand + print inserts by competition
Regards
Sujit
Hi Jim . If my dependent variable is “Number of job switches” , it is Discrete random variable. Can I still use MLR?
Jim, thanks for the great information. While describing PLS regression you mentioned this is a good technique for predictive models but not good for screening variables. My motivation for wanting to understand regression techniques is largely because I want to be able to make predictions about things. What about PLS regression makes it better suited for this? Can’t we make predictions from any regression technique that fits the data?
Hi Michael,
I guess I wouldn’t say that PLS is better at prediction than other methods in general. Rather, PLS is a good method to use when you face particular problems–few observations per predictor and multicollinearity. In this context, PLS is relatively good at predictions and not so good at screen variables. However, if you don’t have those problems, I wouldn’t consider using PLS and would probably start with OLS. If you have severe multicollinearity and are interesting in determining the significance of particular variables, consider Ridge or LASSO regression.
Hi Jim,
I am a junior doctor and I need to do some paper in Statistics about ,,Types of regression analysis used in biomedical sciences”. Can you help me where I can find that data and which are the types of regression analysis used in biomedical sciences? Everyone is mentioning just linear regression analysis.
Thank you in advance.
Hi,
I wouldn’t be surprised if linear regression is the most common. I’ve also heard that binary logistic regression is commonly used in things like surgical procedures where the researchers want to model the variables that affect the probability of survival. They use binary logistic regression because the outcome is binary (patient either survives or does not). I can also imagine them using binary logistic regression to model the success or failure of other treatments. I once helped a fertility doctor to model the probability of pregnancy by the treatment and other factors. Again, the outcome is binary (pregnant and not-pregnant).
Hospitals could use Poisson regression to model the availability of hospital beds. The outcome is a count of available beds.
I think the medical sciences could use many different types of regression just like other fields. It depends on the nature of the dependent variable and the characteristics of their data. I would guess that linear regression and binary logistic regression are two of the more common types.
I hope this helps!
Hi Jim,
I have a binary outcome variable (presence of disease = yes or no)
And would like to study the effect of different independent variables on the presence of disease
Examples of my independent variables are as follows:
geographic longitude
geographic latitude
age
all of which are on a continuous scale
Which regression model should I use?
Thank you
Hi Naz,
Given your binary outcome (dependent) variable, you’d need to use binary logistic regression.
Hi, Jim. I’d like to ask, I want to examine how self-compassion (iv) can predict depression (dv), self-compassion itself is formed by 6 dimensions, could you suggest what regression that would fit for my research? I already run simple linear regression for sc and depression, so if I use multiple regression for the 6 dimensions and depression, am I doing it right? or should I run simple linear regression for each dimension and depression?
an answer would be really appreciated, thank you! 🙂
Hi Elsa,
The best place to start with is least squares regression. Use multiple regression so you can include all your IVs in the model. You don’t want to fit separate models for each IV because it won’t be controlling for the other variables.
If you had to form the 6 dimensions because of need to reduce the number of dimensions, and now you want to perform a regression on the dimensions (which are not variables), you might need to use something like partial least squares (PLS) regression instead. That will find the dimensions and perform regression on them. I don’t have much experience with that type of regression. There might be other methodologies that I’m unfamiliar with that you can use. Generally, you’ll have a specific need for reducing the number of dimensions and working with those rather than just using the variables themselves.
Thank you your post,
i’m doing advance regression modeling for house price prediction, so there have very large number of variables.do you can give me a suggest a method for the dimension reduction?
Hi Randunu,
I’ve seen regression models for house prices that use least squares regression. Unless you’re using a small sample size, I’m not sure that you need to reduce the dimensions. I’d at least start your investigation using least squares regression and move away from that only if it’s really required.
Hi Jim,
what if I want to apply regression if I have variables of # of complications like: dengue, Malaria etc. and have variable of deaths due to these complications. which regression should be used in this data.
thank you!!
Hi Deepanshu,
One thing I hope to have conveyed and the readers understand about this post is that the type of regression you use large depends on the type of variables you have, particularly for the dependent variable (DV).
For your case, you don’t state how you’re recording deaths. What type of variable is the DV? Are data recorded by patient and you have a binary death/survival outcome for each patient? If so, binary logistic regression. Is it by hospital (or geographic region) and you have counts of deaths, you could use Poisson, Negative Binomial, or possibly least squares regression if the counts are high enough to approximate the normal distribution. In that case, you might need to convert it to a rate for comparison purposes.
Hi, I am a student, am still confused which type of regression should I use, the Dependent variable is binary (Benign or Malignant).
Independent variables are three
1- Age group: which are 6 groups (1,2,3,4,5,6)
2-Color: binary variable only two color option.
3- Third variable is also binary variable.
What should I choose?
thanks in advance Mr. Frost.
Hi Alaa, you’d use binary logistic regression.
Hi I have 11 continuous random variables X1 . . . X10,Y. I need to create a regression model for predicting values of Y based on the values of X1 . . . X10. Which regression should i chose.
Hi Jim, sorry for the confusion! Each observation is a single Likert Value, so I guess Ordinal logistic regression applies. Could stepwise regression still be used with this kind of data?
Jesse
Hi Jesse,
Yes, it sounds like you’ll need to ordinal logistic regression. Also, as I mentioned in an earlier comment, you’ll have some thinking to do about whether to treat the ordinal DVs as continuous or categorical. There are pros and cons both ways. More details in my ebook about regression analysis!
I mean to say discrete and continuous variables…
Hello
Thank you for your time in answering our questions.
I have a problem and I would like your help please.
I have a dependent variable that takes the value 0 and 1. This variable is explained by other independent binary and continuous variables.
Only in the survey the answers of my dependent variable are conditioned by the answer obtained to a previous question ( say Q1)
so that if Q1 = 0 “no” then Q2 (which is my outcome) is asked.
if Q1 = 1 “yes” then Q2 is not asked.
Q1 and Q2 are not exclusive and Q1 is not a selection issue. The individual interviewed can answer yes to Q1 and also answer yes to Q2. I don’t understand why the survey design excludes them and it really bothers me
My question is, apart from a multinomial model, do you see any other models that I could apply to get around this serious selection problem?
Hi Jane,
I’m not entirely clear about the scenario and what you want to analyze.
Q2 is your outcome. And, only particular respondents are presented Q2 based on responses to other questions. At first, it sounded like it depended entirely on their response to Q1, but that might not be the case. Maybe other answers as well? You’ll have to examine how the survey presents questions to respondents to understand that portion.
If you’re analyzing Q2 as your outcome variable, I’d suggest figuring out who exactly answered it. If you can identify a particular subpopulation that answers Q2, you can perform the analysis and understand that the results apply only to that specific subpopulation. If Q2 is binary, you could use binary logistic regression with Q2 as the DV.
I hope that helps!
Hi Jim, Thank you for the response! I’m not sure I understand your question, but I think they are the score of each item, the scores for each scale is not averaged or summed. I think because its a Likert style scale with an absolute zero (ratio data), we would treat it as a continuous variable. But would this be a stepwise regression method to see which variables stay in the equation (i.e., are still significant and have the highest coefficient)?
Thanks!
Hi Jesse,
I’m asking whether for each observation (i.e., row in your data sheet) the values for each variable are a single Likert value (1, 2, 3, 4, 5, 6, or 7). Or is each value an average or sum or multiple Likert scores?
It makes a difference. A straight Likert score item, as I described before, is an ordinal variable. It is not a continuous variable. However, sometimes you can treat sums or averages of multiple Likert scores as a continuous variable. In fact, if you’re using a single Likert score for each value of the DV, you’d need to use ordinal logistic regression rather than least squares regression.
Thank you for the response Jim! To clarify, we had customers fill out a survey, all likert (1-7) style questions. We had an overall satisfaction question (Are you satisfied with our company overall?) and multiple satisfaction questions based on dept (e.g. How satisfied are you with our customer service?, How satisfied are you with our webpage?).
We basically wanted to see which dept was the best predictor of Overall satisfaction… essentially, which area of our company should we focus on most based on satisfaction scores?
Thanks again!!
Thanks for the extra details! I don’t use SPSS so I wasn’t familiar with their Enter Method!
One more question. Are the values for the independent variables and outcome variable for each observation the score of one item (e.g. 1, 2, 3, 4, etc) or the sum or average of multiple items? The answer to that will affect the method you can use. Least squares regression doesn’t play well with ordinal outcome variables. However, if it’s a sum of multiple Likert items, it might work fine.
For the IVs, if you’re using the value of individual items, it’s an ordinal variable which has the properties of both continuous and categorical (nominal). You’d have to go with one or the other. (I talk about that in my ebook about regression analysis.) If you use a sum or average of several items, you might be able to treat them as continuous IVs.
In theory, you should be able to do what you want to do. However, ordinal variables (such as Likert items) can be a bit tricky and you need to work out those details and choose correct analyses.
I hope this helps!
Hi Jim,
This is a simple regression model but I’m getting a difference of opinions on the answers. I’m looking at overall customer satisfaction (likert scale), and I want to know which area of the company is contributing most to this.. each area of the company each has their own likert scale. Would I just use overall satisfaction as a DV and put the different areas of the company as IVs in a ‘Enter’ type regression?
Thank you Jim!
Hi Jesse,
I don’t know what you mean by an “enter” type regression.
Here’s what it sounds like to me that you want to do. Please let know if it’s incorrect. You want see if there’s an association between area of the company and the Likert score? If so, you can do that. The dependent variable is Likert score, which is an ordinal variable if you’re just using a single Likert item for the DV values. In this case, you’d need to use ordinal logistic regression. If you want to use area of company (e.g., department) as an independent variable, that would be one categorical variable where the different values are the various departments. You can fit that model and see if there is a statistically significant association between department and the Likert score.
If you are summing multiple Likert scores and using that summed value as the DV, rather than just using the score for an individual item, you might be able treat the DV as a continuous variable and use least squares regression or ANOVA to assess the differences by department.
I hope this helps!
And by “Enter Method’ I meant in SPSS the ‘Enter’ procedure in linear regression (as opposed to Stepwise, or backward elimination methods. I just put in all the different depts as predictors and total sastisfaction as an outcome variable, then looked at which predictors were significant, and their coefficients.
Hi Jim, thanks for all your great posts! Apologies if this has already been covered but perhaps you can offer some further clarification.
Let’s say I have two variables, a continuous variable (e.g. test performance) and a categorical grouping variable with three levels (e.g. group 1, group 2, and group 3).
My question relates to how to structure the regression analysis itself. We could model “test performance ~ group” (so test performance is the DV and group is the IV). Alternatively we could use a logistic model “group ~ test performance” (so group is the DV and test performance is the IV).
Are there rules of thumb here in deciding which way to structure the model? Are both valid or does it depend on the specifics of the experiment and the underlying data?
Any thoughts on this would be appreciated!
Hi James,
If you’re creating a model to explain the relationships between variables, you’ll use the explanatory variable(s) as the independent variable and the variable you want to explain as the dependent variable. Often you’ll use theory, subject-area knowledge, and literature to guide you about the direction of the relationship. In your example, if you think the group assignment might cause differences in the test scores, you’d use group as the independent variable and score as the dependent variable. You want to learn about how the different groups affect the test scores.
However, if the test scores measure some characteristic of the individuals that might affect the group that the individuals join, you could use test score as the independent variable and group as the dependent variable. You want to learn about the characteristic that the test measures affects the group that individuals join.
So, a large part is the direction of the relationship that you are assuming to be true based on theory and subject-area knowledge.
However, if you’re creating a model to make predictions, then you’ll always use the variable you want to predict as the dependent variable. Imagine you want to predict variable A, which is correlated to variable B. Suppose the value of A causes changes in the values of B. In an explanatory model, you’d use B as the dependent variable because that fits the known nature of the relationships. However, imagine that you want to predict the value of A. In this case, you’d use A as the dependent variable and B as the independent variable.
In the end, you can really do the analysis either way depending on whether you want the model to explain the actual relationships between the variables or you’re making predictions for a variable.
Hi Jim,
I am trying to determine the predictive power of a nominal independent variable with 8 groups (age cohorts) for a continuous count dependent variable (number of stress incidences). What test do you think would be most appropriate? My samples are also very small (<5) for some age cohorts.
sir i have this business problem-
Company collected data from 5000 customers. The objective of this case study is to understand what’s driving the total spend of credit card(Primary Card + Secondary card)
Prioritize the drivers based on the importance.
and i have to built linear regression model.
please help me out like how to deal with two dependent variables at a same time with a set of predictors
Hi Âákäsh,
You’re asking about learning how to use, perform, and interpret multiple regression analysis. That’s way more than I can write about in a comment!
However, you’re in luck, I have written an ebook all about regression analysis, with a focus on multiple regression. Please take a look at my intuitive guide to regression ebook!
Hi Jim,
Thanks for such an insightful article!
I am trying to predict the best time (date) to contact a customer for an offer by analysing purchase history. I want to use Regression for this but having a hard time to decide which one to use. I have considered using logistic Regression where I thought I will see if in a month it is best time or not. But on the other hand also think that date is a continuous variable so I might be better off using multiple linear regression.
Would be very helpful to hear your thoughts.
Many thanks,
Naty
Hi Naty,
In making this decision, a good place to start is to understand your dependent variable. What’s the outcome that you want to explain/predict. What type of variable is it? If it’s something binary, like Sale/No Sale, and you want to use independent variables such as date/time to predict that, you’d need to use binary logistic regression. With binary logistic regression, you can use independent variables such as time (continuous) and day of week (categorical/nominal) to predict the binary dependent variable of sales/no sales.
That sounds like the direction you might want to go, but it really depends on the nature of your dependent variable.
Dear Sir,
If both independent and dependent variables are categorical and dependent variable have natural order, which test variables do you suggest?
Hi, sounds like you should use ordinal logistic regression!
I don’t know what you’re studying. You’ll have to use your subject area knowledge to determine which test variables to include. Depends on what you’re testing!
i am trying to analyse car accident data set.
there is 1 dependent and 1 independent variable in my equation
dependent variable is categorical (4 category) and represents number of wounded person
1- (1 person wounded)
2- (2 person wounded)
3- (3 person wounded)
4- (4 or more person wounded)
independent variable is also categorical (6 category) and represents crash type
1- (rear crash)
2- (side crash)
etcetera……
which type regression should i use to analyse crash type effect on wounded person number?
Hi Michael,
There would seem to be a variety of problems with modeling this data set.
The DV is sort of a count variable except for the four or more category. For count data, you can often use Poisson or Negative Binomial regression as I indicate in this blog post. However, because of the four or more category, it’s not really count data. I suppose the best would nominal logistic regression and treat your DV as a categorical variable.
However, there would seem to be too much information left out of your model to get meaningful results Number of passengers in the car, speed, and seat belt usage just to name three quickly. You might have the worst possible accident yet only have 1 person injured if there is only one person in the vehicle. I suppose if you had a large enough sample size you might get some meaningful information.
Again, you can try nominal logistic regression. Or even perform a chi-square test of independence because you have two categorical variables.
Dear Jim,
I have scale (income) dependent variable and both scale and categorical variables. Which regressuin model is appropriate?
Dear Sir,
I have a continuous dependent variable and a categorical independent variable with three groups.
whereas my covariates are continuous and few are categorical as well. Which statistical test can i apply?
can i use linear regression or ancova?
Dear Sir,
If both Independent and dependent variables are catagorical variables, Which test you suggest to test variables except Chi-square sir?
Hi Ranjith, you can use nominal logistic regression. This type uses categorical dependent variables with categorical and/or continuous independent variables.
Hi Jim!
Thank you for excellent explanations. I hav plotted my data and my curve looks more like a logarithmic graph. How do I best calculate the correlation between my two variables?
Lore
Hi Lore,
It sounds like you might need a log-log relationship, which you can read about in my post about log-log plots. For details on a variety of other methods you can use, read my post about curve fitting.
Ah shoot, I noticed after replying that you’re asking about correlation rather than how to fit the curve! I need more coffee! Try using the Spearman Correlation which can assess monotonic relationships. That’s a fancy word that means that the variables tend to move in the same relative direction (either a positive or negative correlation) but the rate of change is not constant.
Hi Jim,
Thank you for posting several useful information regarding data analysis. I follow your website regularly for statistical matter.
I have one question. Can we natural log transform independent continuous variable. I have independent variable of different distance points (1 to 180 m with nineteen measured distance points with inconsistent data ranges).
My dependent variable is over-dispersed count data (and I am using negative binomial with log link function).
Please could it be possible for you to answer this question.
Thank you.
Hi Sunita,
Thanks for reading! I’m happy to hear that you find my site to be helpful!
Yes, it is possible to use the natural log to transform a continuous independent variable. Of course, there’s no way I’d know whether it’ll resolve whatever problem you’re experiencing. I’d recommend fitting the model without the transformation and checking the residual plots. Then, transform your variable and fit the model again and check the residual plots to see if it helped. Transforming the IVs is particularly helpful for fitting specific types of curvature, which you can assess using residual plots.
Using transformations is a bit of a trial by error process. There are some guidelines that can help, but it often comes down to trying them to see if they do the trick. I write about this in detail my regression ebook. Although, I don’t write about it in the context of negative binomial regression.
I hope this helps!
Thank you for your time, Jim. Looks like i have to crack my head for some time.
Elsa
Hi Jim, I’m completely lost when trying to choose the type of regression analysis for my problem. Is it nominal logistic regression, time series, linear (autoregressive model), nonlinear or other? Can you please give me some advise?
345
658
116
380
651
851
709
196
269
071
478
518
451
989
519
843
662
428
794
949
Suppose, everyday I’m given 20 data as above. They’re random numbers generated by three devices, namely Device A, Device B and Device C. Every device is capable to generate random numbers from 0 to 9.
For the above first data of “345”, “3” was generated by Device A, “4” was generated by Device B and “5” was generated by Device C. Similarly, for the last data of “949”, “9” was generated by Device A, “4” was generated by Device B and the last “9” was generated by Device C.
I want to be able to predict the next outcome variable after the last “949”.
I have a total of 300 historical data for 15 days, 20 data per day.
From my rough observation for the recent 300 data, every device tends to produce repeated sequences. For instance, Device A will repeat the sequence “8-6-4-7-9” (as in the last 5 data). That means this sequence appeared at least twice within the 300 historical data for Device A. Similarly, for Device B and Device C, each of them tends to produce repeated sequences. For another example, the repeatation of the sequence “5-1-8-5-5” (the 2nd to the 6th data) in Device B.
I’d like to predict the next outcome variable after the last “949”. Is it possible to model it with nominal logistic regression, or time series (if i assume that 20 data was taken at successive equally spaced points in time)?
Otherwise, which model is more appropriate?
Thank you in advance.
Elsa
Hi Elsa,
Based on the limited knowledge that I have, this problem doesn’t sound like one that regression analysis can solve. If it’s random as you say, then you can’t predict it. However, if there are patterns in the data, it might be more of a pattern finding problem.
If there was some underlying phenomenon that influenced the numbers that the devices display, you might be able measure the phenomenon and link it to outcomes and use regression analysis to model that process.
Sorry I couldn’t be of more help. But it sounds like you’ll need to use something other than regression.
Hi Jim,
Great website. I have a quick question, excuse me if you have covered it before and i did not notice. When you build a regression model, multiple linear regression model or just simple one, do you need to have all variables with the same units to conduct the regression? . For example, if i want to study the relationship between stock market returns which is in % terms and funds flow which is in dollar terms, do i need to transform both variables to the same unit of measure ie lets say percentage % to study the regression? Thank you.
Hi Jim,
Thank you so much for your reply, very helpful but I am just unsure as to how to test for a linear relationship between a categorical IV and continuous DV… Could you please advise?
When trying to do scatter plots you just get a straight line…
Thank you in advance for any help you can offer!
Hi Sophie,
When you have a categorical IV, the type of relationship you’re testing for differs than between two continuous variables. When you have a categorical IV and a continuous DV, the analysis tests for differences between group means. The categorical IV defines the groups in your data. It’s performing an ANOVA with your data to see if the DV mean varies between groups. And, you don’t use a scatterplot to graph that type of relationship but either a boxplot or individual value plot.
I don’t want to keep pushing my book, but I go through an example of a regression model with both categorical and continuous IVs in it and show how to interpret the results.
Hi Jim,
I love the way you explain the different types of regression so I was wondering if you could help me on a project I am doing…
My IV is bullying victimisation which is categorical (never, some of the time, all of the time) and my DV is internalising problems which is on a scale from 1-20. I also have covariates some continuous, some categorical. What statistical method do you suggest I do? I have quite a few outliers in the DV but as I am using the MCS these are hard to remove and due to their being quite a lot I don’t believe I have a logical reason to remove them. I am also not sure on how to test for a linear relationship with my IV being categorical.
Do you have any suggestions for the above?
Look forward to hearing your thoughts!
Thanks!
Sophie
Hi Sophie,
In your other message, you clarified that the DV is a continuous variable, although constrained to a range of 1-20. Consequently, I’d start by using a least squares linear model first. Try that first and see if you can get a good fit–check the residual plots. Specify a variety of models and possible fit curvature and interaction effects. The constricted range of the DV might be a problem if it causes the scores to be extremely skewed. If your DV is very skewed, you might need to use a data transformation. The residual plots will help you determine what you need to do.
As for the outliers, if they’re a regular part of the distribution of outcomes for your population, it’s often best to leave them in as they represent variability that is inherent in the process. However, if they represent scores from people outside your defined population, or some other fluke during measuring, testing, etc., that doesn’t represent the typical process, consider excluding outliers. Just be sure to record the removed outliers and explain why. But, the default position should be to leave them in unless you have a good rational for removing them.
I write more detail about the above in my ebook about regression. You might consider getting because you’re using for your study.
Best of luck with your study!
Hi Jim,
Could you please suggest any source where I can find why ordinal regression is preferable over multiple regression analysis. Even if you have written any thing on it that will be also great. I am in argument with my team to use ordinal but they says opposite so need some strong sources. I will be very thankful to your help!
Hi Syed,
When you have an ordinal dependent variable, you should use ordinal logistic regression. Ordinary least squares regression is unlikely to provide value results when you have an ordinal dependent variable. Ordinal logistic regression was designed with ordinal DVs in mind. This decision is based on the type of variable you’re using for the dependent variable.
First, ensure that you have an ordinal dependent variable. If you do, I’m not sure why your team would resist ordinal logistic regression?
I don’t have a reference on hand at the moment, but I will check when I can. However, any advanced regression textbook that covers ordinal logistic regression will state this clearly!
Best of luck with your analysis!
Hi Jim,
Thanks for your helpful blog.
I’m hoping you might be able to offer some advice on a project I’m working on to understand customer telephone contact. The sort of questions I’m looking to answer are as follows –
Are customers with certain characteristics more likely to contact us?
Do customers with certain characteristics contact us more frequently?
I have a snapshot from our customer database including customer characteristics such as age, gender, marital status, whether have children, geographical location, etc, as well as the number of telephone calls made in that month. One row for each customer.
My rough plan is to look at the data and run off some descriptive statistics (scatter plots, box plots, etc) to see how frequency of contact varies by different characteristics. Then depending on what that shows, I’m hoping to construct a regression model(s). This is where I’m a little stuck in terms of the type of model.
I’m planning to start by looking at the probability of a customer making a call (a binary logistic regression?) I think this would tell me which characteristics increase/decrease the probability of a customer making a call versus no call.
I’m then thinking an alternative would be to define the dependent variable on the basis of low/medium/high frequency callers and run a regression on that basis. I think an ordinal logistic regression?
Could I also use calls per customer per month as the dependent variable and run a standard linear regression? Or would this be classified as count data and require a different model?
Grateful for any thoughts.
Kate
Greetings Jim
I conducted a simple multiple regression. I firstly tested all the assumptions and then created the models. I would like to know how I can validate these models? Do I have to perform additional tests or can I use information from the model analysis outputs? NB. I do not want to run complex tests that are difficult to interpret. Kind regards and many thanks,
Mario
Hi Mario,
Unlike most statistical procedures, with regression analysis you need to check the assumptions after you fit a model. You can’t check the assumptions before fitting the model. Sometimes you can get a sense that it’ll be hard to satisfy the assumptions before fitting the model. For example, if your dependent variable is highly skewed, it’ll be harder to satisfy the assumptions. So, fit the models and then check the assumptions. To learn more about that process, read my post about Checking the OLS Assumptions.
When you say “validate” the model, there are several ways I can interpret that. One is that you want to ensure that it satisfies all of the assumptions. If you mean that, read my blog post above. It doesn’t involve performing any complex statistical tests.
However, often people will validate a model when they use it to make predictions. They want to ensure that the model predicts new observations as well as it predict the observations used during the model fitting process. If this is what you mean, you’ll need to have a training dataset and a validation dataset. Use the training dataset to fit the model. Then, apply the model to a separate validation dataset and assess how well the model predicts the new set of observations. This process is known as cross-validation.
Because your study involves regression analysis, you might consider buying my ebook: Regression Analysis: An Intuitive Guide. My ebook covers the material in more depth than the blog posts.
Best of luck with your analysis!
Hi Jim,
Thanks a lot for the excellent article!
Can I ask if I have a mix of continuous and categorical dependent variables, can I still use partial least square regression?
Thanks!
Hi Min,
As far as I’m aware, you can use PLS only with continuous dependent variables.
Thanks a lot Jim
Hi Jim you did not reply to me? 🙁
Hi Abbas,
So sorry about that! Sometimes when I get really busy some questions are accidentally missed. I’ll answer your previous question within a day.
Great post Jim. I really like the way you explain the different types of regression.
But I’m little bit confused here. What if my dependent variable is a score, say having value 1-100 & my independent variable is a categorical one? Is poisson regression ok in this case?
Hi Tanvir
Thanks for the kind words!
If you working with a score that has at least 10 values, you can often treat it as a continuous variable. Consequently, I’d try using linear regression.
Poisson regression wouldn’t really be the right choice because you’re not counting outcomes. That’s usually what you use Poisson regression for. Even then, if the mean is high enough, the Poisson distribution begins to approximate the normal distribution and you might still be able to use linear regression.
At any rate, I’d start with OLS regression. If the scores are highly skewed, you might need to transform the data.
Best of luck with your analysis!
Dear Jim,
What type of regression would you recommend in a case when the key independent variable is not regularly reported? My dependent variable is a firm’s investment policy reported every fiscal quarter. The independent variable of the interest is a debt covenant strictness reported just at the moment when the firm issues any loans. I’ve tried to use investment changes over next 4 quarters (8 quarters) after the loan inception as a dependent variable. But I’m not 100% sure that it is a correct empirical design. Is it possible to use as the dependent variable also the investment levels instead?
Thank you!
Best,
Anastasia
hi which one can be the best model when you want to establish the relcatiionship between tax consultant and tax compliance
Hi Prosper,
Usually you don’t pick the type of regression model based on the subject area. In other words, there is no model that is best for taxation studies. Take a look at the type of dependent and independent variables you will use in your model and then read through this post to see which models can handle those types of variables.
Best of luck with your study!
Hi Jim,
Loved your post.
I wanted a suggestion from you regarding my project work.
Could you please suggest which model I can use for regression.
Following is the brief overview of the problem I am facing:
My dependent variable(y) is a non-negative integer and independent variables are categorical as well as continuous variables.
There are 3 continuous variables and 4 categorical variables on which(y) would depend.
Could you please suggest which regression models should I test in this case?
Hi Aki,
If your non-negative integer is a count variable, look in the section for Count Dependent Variables for ideas.
Best of luck with your analysis!
Hi Jim,
I have been reading your articles on regression analysis – they have been super helpful for me as I am just learning about regression analysis!
I am writing a research proposal on what factors influence voters to still vote for their preferred party when they have knowledge of that parties involvement in corruption.
previous research has indicated that voters continue to support the part as they personally benefit from the corruption. Whereas other academic conclude that loyalties to certain parties are a result of a clouded vision causing cognitive dissonance. The most frequently argued factor as to why individuals forgive a corrupt official is that if the economy are secure and improving. Finally, the more extreme the individuals party is (far left or far right) the more likely they are to vote for another party due to a lack of viable alternatives.
I wanted to use a MCQ questionnaire to collect data on all these factors and treat them as independent variables and use regression analysis. Is this possible? and if so how should I go about this. I have spent about 2 weeks on the proposal and I am not totally sure
Best wishes
Catherine
Hi Catherine,
I’m so happy to hear that my regression articles have been helpful! If you like them, you might consider my ebook, which is all about regression analysis.
Yes, it is possible to include MCQs in an analysis. The manner in which you include them depends on the type of answers. If they’re categorical (nominal) variables, such as, “What type of damage? Scratch Dent Tear,” you’d include it as a categorical IV. If it’s an ordinal variable, such as Likert scale responses, they straddle the line and you can potentially enter them in the model as either categorical variables or continuous variables. It depends on the nature of the data and the goals or your analysis. My ebook talks about all of these aspect, categorical IVs and how to handle ordinal IVs.
Best of luck with your analysis. It sounds interesting!
Hello Jim
I trust you are well.
Could you perhaps tell me how I should go about testing the assumptions for generalized linear models.
Thanks,
Mario
Hi, does your book cover all the regression analyses you covered in this blog post?
Hi Josh,
The ebook focuses on linear regression. I cover many aspects of that including, continuous and categorical IVs, main and interaction effects, modeling curvature, checking assumptions, goodness-of-fit, predictions, etc. I offer a few glimpses into the other types of regression, but they’re not the focus.
I can foresee a future book going beyond linear regression and covering the other types in more detail.
To get a better idea of exactly what the book covers, go to my blog post about my ebook. At the bottom you’ll see screenshots of the full TOC.
You can also go to My Store and download a free sample of the ebook, which has the complete first two chapters.
I hope this helps!
Great thread, this was really informative and has made me rethink my current regression model.
My undergraduate dissertation project is on how perfectionist concerns, strivings, and coping skills (7 sub scales) influence sport acute injury occurrence and frequency. The perfectionism data cam in the form ofa composite score made of two subscales from different questionnaires with different item number (5 and 7 items). Thus, a standardised composite score was created. which regression analysis tests would you recommend for an SPSS newbie?
Thanks
Hi Jim,
It would be great to see the kinds of estimates that can be obtained from each of these models, and possibly some of the interpretations that might come with using one of these models. Thanks!
-Frank
Hi Frank,
In future posts, I’ll do that! For now, you can see examples of nonlinear regression and binary logistic regression. I’m always adding posts and will get to the others at some point.
Thanks for writing!
Hi Jim,
I’m having a bit of trouble selecting the right non-linear regression for my analysis. I have data that looks like an inhibition dose response curve with a variable slope. The X is not dose however it is time and I am trying to compare the rate of closure between multiple samples over time. If I do a non-linear fit of [inhibitor] vs response with a variable slope, the curve fitting fits my data very well. I was wondering if in this scenario using a generated hill slope would be sufficient to evaluate rate? Would there be a more appropriate regression or should I consider an alternative such as area under the curve?
Thank you so much for any advice!
Hi, I often find that in nonlinear regression models, subject-area knowledge becomes even more important than it usually is. In nonlinear models, you’re often trying to incorporate underlying physical or biological processes into the regression equation itself. I once saw biologists debate over which nonlinear model is best for plant growth. It turns out that the best model depends on a plant’s specific growth pattern. All of this is to say, I don’t feel like I’m qualified to answer your question. You should consult with subject-area experts and see how similar studies have tackled the problem. Sorry I couldn’t provide a more specific answer!
Hi Jim,
I’m searching for a regression model for the following: I have a categorical dependent variable which comes from a multiple options question, I mean, the individual was being asked for his preference about six different saving alternatives. He could choose all the alternatives that he prefers (he can choose even all the six alternatives). So, I don’t know which could be the type of regression that I could apply.
In conclusion, my dependent categorical variable is non-excluding so I can’t apply a multinomial logit or multinomial probit. Which other models could I use?
Thanks in advance.
Thanks Jim. Very appreciate it
Hello Jim
I have a question about my study. Both the IV and DV in my data are categorical. IVs (nominal) are 5 types of behaviors and DVs (ordinal) are 3 types of reasoning. I am interested in how IVs predict DVs. I am wondering if logistic regression fit my study? Thanks in advance for your efforts.
Hi Franco,
It sounds like you need to use ordinal logistic regression!
Hey Jim,
I got a query.
Suppose we are given voting turnout results (1 for yes, 0 for no) of 4 previous years. And we want to predict it for the next year, and hence we do not have the 2019 result column. Logistic regression need X train and Y train, but in this case we do not have a Y train. How should I proceed with this? Or should I use some other model?
Dear Jim, I came across this article of yours. Very informative. I am a student doing chiasma count on chromosomes. Now I want to compare and contrast different varieties just based on this count number. The count range is limited ranging from 2 to 8. I cannot go for Poisson distribution as it is known that the chiasma occurrence on chromosomes is not random. Infact, two pathways occur, one is non random and second is random, but most of the counts are accounted by non random pathway. I do not know this, just based on the count data. Can you suggest any analysis which can be done to find out differences between varieties.
Hi Jim!
Fantastic blog post. Thank you for laying this out so clearly.
For the regression I am trying to run, the independent variable is number of classes attended. The possible options being 1, 2, 3, and 4 classes attended. To me, this seems like an ordinal variable, but I am not sure.
Is it okay to proceed with a regular linear regression? The output variable is change in symptoms of depression (a continuous variable).
Thank you in advance!
Allie
Hi Allie,
That’s a count variable. Count variables can have non-negative integers. This type of variable is different from a ordinal variable.
An ordinal variable does have a natural order. You can represent ordinal variables using numbers. So, that looks similar to a count variable. But, suppose you are recording how runners finish in a race. You have the first, second, and third place runners that you record as 1, 2, and 3. However. the second place finisher doesn’t necessarily take twice as long as the first place finisher even though 2 is twice the value of 1. You only know that 2nd place is after 1st place. 3rd place is after 2nd and 1st, but it’s not necessarily three times as long as 1st.
Contrast that with counts of 1, 2, and 3. A count of 2 is twice a count of 1. A count of 3 is three times 1. The difference between 1 and 2 is the same as the difference between 2 and 3. Etc.
When you have count IVs and ordinal IVs, neither are quite continuous (ratio) nor are they quite categorical (nominal). You’ll have to decide which way to enter them into your model. That depends on the nature of your data and the goals of your analysis. I write about this in my regression ebook that I just released. But, that’s the issue in a nutshell.
It’s often OK to include this type of variable in a linear model. Just be sure, as always, to check those residual plots to be sure that your fitting an adequate model!
Hi Jim!
First of all many thanks for your helpful, comprehensive tutorial on regression. I have a question that I really appreciate if you reply to it. What is the best possible way to choose the most relevant features in a linear regression model? How we can check the features?
Thanks in advance for your time
Hi Shohreh,
I’m not sure what you mean by “relevant features”? That can range anything from the type of data that a type of regression can model to key statistical output. Can you be more precise what you’d like to know? Thanks!
Hi Jim,
Great and very helpful blog. the way you explain is really helpful.
I want to run a regression on SPSS using customer satisfaction scale (5 point scale) as dependent variable. and other variables as independent variables such as some are on 5 or 10 point scale, some are yes/no. so basically I want to check what are the variables that impact customer satisfaction. Could you please help me to find out which regression analysis I suppose to use?
Hi Abbas,
Sorry about the delay in replying!
Because your dependent variable is an ordinal variable, you need to use ordinal logistic regression. In SPSS, you should use either the PLUM (easier to use) or GENLIN procedure. You can find PLUM in the Output Management System Control Panel under Command Identifiers.
Best of luck with your analysis!
Hello Jim,
First and foremost, thanks a lot for writing this blog – it’s pure gold.
However, I have a dilemma.
I have the data with 5 variables and with 100 units of observation. Every 10 units in the data encompass specific time frame – so first 10 units encompass one year, then next 10 units encompass the following year etc. For each of those 10 units, I have a distribution of 100% for each variable. This means that each variable in the first 10 units makes 100%, then the next 10 units also 100% etc. My dilemma is that units reflect the distribution of something (which makes a sum of 100% for each year) so I am not even sure can this be considered a continuous variable. Here is an example: https://i.imgur.com/dxCQfHT.png
But, to be concrete, I would like to know whether I can use multivariate regression analysis with this data where I would focus on one variable as DV and the other as IV in order to see which IV impact the most DV.
Hi Chris,
Thanks for kind words about my blog! 🙂
It sounds like you want to perform regression analysis with time series data. There are no inherent problems with that but there are special issues you’ll need to address. For example, you’ll need to include time related independent variables in your model, such as the date and lagged variables. You’ll need more specific date information than just the year. You’ll need to know the time between observations. You’ll also need to pay particular attention to correlation between adjacent residuals. See assumption #4 in my post about OLS assumptions.
I don’t see a problem with having the total within a year sum up to 100% of that year. That’s going to be true with all time series data! At least if I understand what you’re saying.
I don’t see an inherent problem with doing what you want to do as long as you know the time between the observations. If there’s a constant time between observations (observations occurred at fixed intervals) you can probably use the ID column as an IV. Just be aware of the issues I mention. In addition to the time related variables, it’s OK to include other IVs. Regression with time series data is not my specialty, so that’s about as far as I can take you. But, it is doable.
If you can fit a good model, here’s a post that can help you determine which IV is the most important.
Hello Jim, thank you for your helpful posts. I am trying to find out influence statistics for 32 states in a country and the states are in scale, nominal variables. How do I conduct spss with that kind of variable?
Hi Bella,
I’m not completely sure what you’re referring to by influence statistics. Are you referring to variables that influence an outcome? Or, perhaps statistics that identify unusual observations in a regression model that have a large influence on the results if they were to be removed from the dataset?
Thanks a lot
Another questions:
can me use Spearman coefficient to check the correlation between binary variable and continues variable?
And can me use person chi square between nominal and nominal or ordinal variables?
Hi, no, you can’t use Spearman’s correlation for that. With binary data, you have two groups. You can use a 2-sample t-test to determine whether the difference between the means of the continuous variable for these two groups is statistically significant.
Hi Jim,
first, thanks for this great website! Very helpful.
I have a question: I have a dependent variable that has been recorded as nominal categories (i.e. defoliation of a tree 0-25%, 26-50%, 51-75%, 76-100%). Should this be treated as nominal and a nominal logistic regression should be used although the intervals are equal?
I have also computed an tree attack level score based on similar categories (defoliation, discoloration, amount of resin flow etc.) by summing them, resulting in scores between 5 and 16, can this score be treated as a continuous variable and ols be used?
Thank you very much if you have time to answer!
Best,
Samuli Junttila
Hi Samuli,
I’m glad to hear my website has been helpful!
Your dependent variable has categories that have a natural order, Consequently, your DV contains ordinal data and you should use ordinal logistic regression.
I’m assuming the tree attack level score is the independent variable? If so, it is most likely fine using it as a continuous predictor. It appears you have a good range of possible values (5-16) as long the actual scores use most of the values. However, you can’t use OLS because you have an ordinal DV.
Be sure to check those residual plots! That’s always important but even more so when you’re combining non-continuous variables to form a different continuous variable.
Best of luck with your analysis!
Hi Jim
Have a nice day
Thank you for above great article, I have some questions I hope to give me advice.
I will conducting study about Risk factors of Anemia among children (< 6 years ) in Sudan, the DV is childhood anemia I will classifying according to hemoglobin concentration level (HCL) as anemic (HCL=11 g/dl)
IV’s are: sex of the child, Birth order, child’s birth weight, child’s age in months, mother’s education level, mother’s age at birth …. etc
this data I will analysis in two stage, first stage I will using bivariate correlation to identify the association between DV (childhood anemia) and IV’s to check whether the IV’s are significantly associated with anemia or not.
In the second stage I will using the ordinal logistic regression between DV and IV’s ( which associated with DV in the first stage) to make a model, and chose the best model based on Akaike Information Criteria (AIC) and 2-log-Likelihood
The End.
My question Is this method it is correct?
Hi,
It sounds like your dependent variable is binary–anemic yes or no. If that’s true, you need to use binary logistic regression.
Additionally, Assuming the DV is binary you can’t use correlation to assess the relationship between the independent variables and the dependent variable. If you have the raw continuous HCL data, you can use correlation between the continuous IVs and HCL. Even though you’re using a binary form of HCL, that correlation with the continuous form can provide meaningful information. I would actually use scatterplots to graph the IVs by HCL. That will allow you see whether there is curvature you need to model.
You won’t be able to use correlation with your IVs like education level because that’s a categorical variable. However, you can use graphs like boxplots or individual value plots to see whether there are differences between levels.
Finally, assuming your DV is binary, use binary logistic regression. Assess the CIs for the odds ratio for each DV and determine whether it excludes 1. Check the residual plots!
Best of luck with your analysis!
Jim,
If you have say 6 IVs and they are all categorical, doesn’t it limit the conclusions somewhat? Wouldn’t a mix of continuous and categorical be better? In other words, isn’t there more information in using interval variables or at least keeping the number of categorical variables to a minimum?
thanks!
Skip
Hi Skip,
In general, yes, continuous data provide more information than categorical data. However, you need to determine which variables actually explain your dependent variable. If for some reason categorical variables explain your DV better, well you’re pretty much stuck using categorical predictors!
You might have other reasons to use categorical variables or indicator variables rather than continuous data. For example, if you have a model that you’re using mainly for prediction and you need to use data that are easy to collect, you might use a series of indicator variables (aka dummy variables). This type of variable is simply a binary variable that indicates the presence or absence of a characteristic. This type of data might be easier/cheaper to collect for predictive purposes rather than gathering potential difficult/expensive to obtain continuous measurements.
Consequently, it depends on your subject area and the purpose/context for your model.
However, when analysts have continuous data and they are considering converting it to a categorical variable (perhaps based on ranges), I’d recommend against that unless there is a very good reason to do so.
I hope this answers your question.
Hi Jim.
I have a mixture of categorical and continuous independent variables. My dependent variable is continuous based on a score. I have 4 dependent variables measuring quality of life. The 4 dependent variables are correlated so I can’t use general linear models. Hope this helps
Hi Mario, having a mix of categorical and continuous IVs is not a problem for OLS. And, if you mean that the IVs are correlated, generalized linear models won’t fix that problem. Run your model using OLS and check the VIFs. If VIFs are high, you might need to use Ridge or LASSO regression. Read my post on multicollinearity for more information.
Hi Jim
I’m having a slight problem. I ran regression using Generalized linear models. How do I interpret the deviance or Pearson chi-square statistic for Goodness of fit. Are there ranges? My deviance statistic is quite high = 151.233.
Thanking you in advance
Hi Mario, first, help me understand why you’re using Generalized Linear Models rather than OLS? Thanks!
Hi Jim,
I have some questions:
1) Let say I have dependent variable which consists of ordinal data, 3 independent variable consists of ordinal data and 1 independent variable consists of nominal data, can I use ordinal logistic regression? Besides ordinal logistic regression, what is the regression analysis that I can use?
2) Before conducting the regression analysis, do I need to do any test on my data? For example the collinearity between independent variables.
Hi Rui,
Because you have an ordinal dependent variable, you’ll probably need to use ordinal logistic regression. For the ordinal independent variables, you’ll need to enter them in the model as either categorical (nominal) variables or continuous variables, depending on which form provides the best fit and the goals of your study.
As for collinearity, I usually fit the model and check the VIFs. However, VIFs only work for continuous data. If you enter the ordinal variables as categorical variables, you might need to use something like the chi-squared test of independence to determine if they’re correlated. Only strong correlations are problematic.
Best of luck with your analysis!
Hi
I need to compare two curves to find if they are similar or not. My question is what is the most appropriate statistical procedure to compare them. I used the compare function in SAS. What about comparative density or kernel distribution can I use that for my comparison. Could you please advise with this
Hello, Jim! Thank for this great post.
I am conducting a study which predicts happiness (continuous dv based on a score). I have a multitude of IV’s (20) which are both categorical and continuous. My readings point to using ‘generalized linear models’ which can accommodate both types of IV’s, or, should I firstly try and reduce the amount of IV’s (can I use univariate regression?) and then only use variables which were found to be significant in the GLM? Am I on the right track?
Thanks Jim
Hi Mario, unless you have count data or binary data for the dependent variable, I’d think that OLS linear regression would be your first choice. If your DV is continuous start with OLS. OLS can accommodate both continuous and categorical independent variables.
Simple and multiple regression are really the same analysis (OLS regression) but have different names based on the number of IVs. But, it’s the same analysis really.
I’d start by creating a matrix of scatterplots that graphs all of your IVs by the DV. Use those graphs along with subject-area knowledge to identify candidates. The scatterplots will also show you whether you need to fit curvature as well. Then, include your candidates in the model and go from there. For help on this subject, read my post about choosing the correct regression model.
Thank you, this article was really helpful for me.
This is great and it has been of good use to me. Thank you for sharing. I have a concern, how will you interpret estimation done by using the PLS procedure.
Hi Doe,
PLS reduces the number of independent variables down to fewer number of components that are not correlated. Then, it performs OLS on these components rather than the original data. Typically, you use PLS more for prediction rather than understanding the role of specific variables because the estimate relates to the components rather than the variables. If your goal is to understand the role of the independent variables using an approach more akin to least squares regression when you have problematic levels of multicollinearity, try using Ridge regression.
Hello Jim,
Great article. I am attempting to measure the influence of culture strength on institutional performance. Two questions: 1) My IV is currently a percent change measure, and ranges from negative to positive, less than zero and greater than one. Is there any regression I can run or do I need to recode into a categorical variable for logistic regression? Although that would be challenging as well since I have three values and not two values – negative, no change, positive.
2) Can my DV be a measure of variance such as standard deviation?
Thanks,
Susan H.
am glad that I found your page. Thank you so much for this informative post.
Actually, I have questions regarding data analysis;I have both scale and nominal variables as independent and 4 categorical dependent variables,how can i analys by which model?
Thank you!!
Abdi
Hi, it sounds like you need nominal logistic regression assuming that your DVs don’t have a natural order. If they have a natural order, then ordinal logistic regression. You’ll need to fit separate models for each DV.
Best of luck with your analysis!
Hi jim,
Thank you for sharing your statistical Knowledge its very helpful indeed.
I just wondered is there an easy was to tell from reading a research article if a statisticians has used a linear or logistic regression model? and if so how?
Thank you
Hi Harriet,
The key giveaway would be the dependent variable. If the dependent variable is binary, ordinal, or nominal, the analyst should be using logistic regression. Also, if the article refers to odds ratios, link functions, or the study uses deviance R-squared, pseudo R-squared, or McFadden’s R-squared, they’re likely using logistic regression. Also, hopefully they’re transparent about which analysis they’re using!
Hi Jim
How can I perform jacknife regression in SPSS and what is the difference between jacknife and bootstrapping
Thanks Jim this is very helpful
JIm I was reading your comments and they seem helpful…so here goes. I have ELL-ESL Training as an ordinal variable and Math Scores as a continuous variable should I run linear regression or logistical regression.
Hi Sylvia,
I’m not sure which variable is your dependent and independent variable. It makes all the difference! From a similar comment you made, I’ll assume that the ELL-ESL training is the independent variable and you want to determine the impact on math scores as the dependent variable.
Assuming that is true, you’ll want to use linear regression because your dependent variable is continuous. You have an ordinal independent variable, which can be tricky to use. Ordinal variables are a bit like continuous variables and a bit like categorical (nominal) variables. Yet, it’s not quite either. You’ll need to include the ELL-ESL training as either a continuous or categorical independent variable. If you included it as a continuous variable you might need to use either a polynomial or log transformation to fit curvature that might be present.
My suggestion is to start by using linear regression and fit different models that include the training variable as a continuous variable and then as a categorical variable and see which provides the best fit. Categorical variables use more degrees of freedom than a continuous variable, which can be problematic depending on your sample size and the number of levels in your categorical variable.
Best of luck with your analysis!
Jim thank you for making statistics easy to learn. However, do you also have one for discrete time survival analysis?
Hi Jim,
I was hoping you might help me shed some light on a math paper I’m doing for my Calculus class. I’m trying to find a regression that might predict the shape of a circle based on a rainbow arc.
Rainbows are actually circles, we just can’t see them fully from our perspective and I wanted to provide more evidence that a circle is in fact the best way to predict a rainbow’s curve using a regression. However, when I tried several regressions based on the points I had found using an outline of the visible arc, the end result looks more like very wide parabola rather than the narrow curvature of the actual circle it’s supposed to be. My professor is trying to push the point of having our paper sound as if we were explaining it to a high school freshman and that makes it a lot harder to explain and the mathematics somewhat tedious as we have to explain every step and justify our choices as well.
Is there any light you can shed on how I can make this a little more feasible?
Thank you,
Emma
Hi Emma,
You’ll most likely need to use a different type of regression analysis, such as nonlinear regression and then choose the correct form of the expectation function. At that point the analysis can fit the data to the model. I think that’s the answer to your problem. Use nonlinear regression and then find the correct expectation function–which I’d guess would be the formula for a circle.
I hope this helps!
Hi Jim, a quick one.
I sent a paper to a scopus index journal.
My model is a panel data with n=4 & T=21
I used fixed effects model to analyse the data.
The journal sent it back saying we have to test for unit root and stationarity because the data is 21years x 4countries. And one reviewer said try ardl.
What is your advise and how do I take care of this?
Hi Seun,
I’m not expert in time series regression model. However, I can confirm that those are legitimate concerns. I have not used ARDL (autoregressive distributed lag) myself. I have used ARIMA (autoregressive integrated moving average)a bit. I don’t know enough about the analyses or you subject area enough to make a recommendation, but yes, you’ll probably need to use something like those analyses. The problem is that you need to account for time order effects and avoid serially correlated residuals.
so does the multiple regression model differ from the least square mode ? because both gave me the same results
There are different types of multiple regression, but, yes, it usually refers to OLS. If the results match, that’s what you’re using.
ah ok thanks for all your help!
For my positive data, it is split into ‘yes’ and ‘unsure’ and ‘no’ so I assumed that is a nominal variable? I may be wrong though!
Those are ordinal data. Two-way ANOVA might still work, but be sure to check the assumptions on the residual plots.
Hi Jim,
thank you for your feedback. I have double checked and my variables are nominal! I am a bit confused whether it is possible to carry out a two way anova on just two nominal variables as I have looked online and the assumptions say I need two independent variables and a dependent variable?
If so, I would do the two way anova and then the post hoc test?
If they are nominal, then your comment about “more positive reviews” is not consistent with that.
Yes, two-way ANOVA is designed exactly for that scenario. Your two independent variables are your two nominal/categorical variables. The dependent variable is your continuous outcome.
Yes, do the two-way ANOVA. If you find that one or both of the independent variables are significant, perform the post hoc test.
Hi Jim,
I have a salary data set with 10 variables. I checked the multicolinearity and there is no multicolinearity. I need to use advance modeling technique other than regression analysis to get higher grade in my assignment. Could you please advise with this? What about principle component analysis will this improve my prediction model?
Hi Shahd,
It all depends on the nature and characteristics of your data. There is no inherently better analysis. In fact, if a linear model fits your data, then OLS is the best possible analysis to use. To see why, see my post about the Gauss-Markov Theorem and OLS Estimates.
However, if your data has specific problems, such a multicollinearity, other methods can be better. Typically, you’d use PCA when you have a large number of correlated predictors often in conjunction with a small sample size. In that scenario, you could also use Partial Least Squares (PLS) regression.
OLS is a great starting place and if you find that it somehow fails to fit your data adequately, use that information about how/why it fails to find another analysis that addresses the problem. And, I wouldn’t say the alternatives are more advanced, they just address various problems/characteristics of your data. So, I really can’t make a recommendation. It depends on the specifics of your dataset.
Also, I am a bit unsure how I would analyse the data once the anova tests have been run because even if it tells me there is a difference, I don’t think it tells you the relationship between the two variables e.g. I am trying to find out if those with more positive views buy more Fair Trade. I am assuming the test would tell me there is a difference between views and goods bought, but not whether those with positive view bought more? I may be wrong!
Thanks again for your help!!
Hi Sam,
For two nominal variables, you’d need two-way ANOVA. Typically, you’d perform ANOVA first and that tells you whether there is a statistically significant difference between group means. However, as you indicate, it doesn’t tell you the nature of those differences. To determine whether differences between specific pairs of groups are significant, you’ll need to perform a post hoc test, such as Tukeys. I need to write a post about post hoc tests! I don’t have one yet!
Now, one thing I notice in what you wrote. You mention “more positive reviews.” That sounds like it’s potentially not a nominal variable. Possibly ordinal or continuous? If so, that changes things. ANOVA is for nominal (categories). Although, it might possibly work for groups based on ordinal data. It can be tricky figuring out how to analyze data when you have ordinal data as a predictor/IV.
Hi Jim,
That’s very helpful thank you! Would I be able to use a one- way anova for two nominal variables?
Thanks again!
Sam
Hi Jim!
I would be very grateful for your help with my data analysis.
I have a dependent continuous variable and an independent nominal variable. I wish to use correlation analysis to examine the relationship between the two variables but I do not think this is possible. How else could I analyse the two variables to see if there is a correlation?
Thank you!
Sam
Hi Sam,
It sounds like you need to use one-way ANOVA. This analysis will tell you how whether the mean of your continuous DV is significantly different across the levels of your nominal IV.
Because the IV is nominal, regular correlation is not possible in the normal sense. In other words, you can’t increase or decrease a nominal variable to see how the other variable tends to change. Nominal variables are a difference in type. Such as type of damage: scratch, dent, and tear. ANOVA will tell you whether the different nominal values (types) are associated with different mean values of your DV.
I hope this helps!
Hi, Jim.
If my parameter estimates in ordinal regression show negative values, do I need to report them one by one or does it suffice if I report the statistical (in)significance in the sig. column?
Thanks,
Ellie
I need to use advance modeling to get A in this class. Can I use lasso regression method. If i didn’t include the interaction term, is this will be a problem ?
Hi, they might if you can show that lasso fits a better model than OLS. Typically, you’d use lasso when you have multicollinearity. It does introduce a bit of bias to reduce the variance. That can be worthwhile in some scenarios. I have no idea if that will produce a better model for your data, but you can give it a try! If it doesn’t produce a better model, it’s not worthwhile doing.
As for the interaction term, again, that depends on your data and study area. If an interaction effect actually occurs in the study area, not including it in the model can produce invalid results. However, not all study areas have interaction effects. Read the link I shared with you in my previous reply.
Best of luck with your analysis!
I did that and I got a good fit. And I need to show what other possible regression model for the salary data set as I was wondering if I have to include interaction term because 3 of those variables are dummy. could you please advise with this
Hi Shahd,
Fitting the correct model is a balance between statistics and subject-area knowledge. There’s no way I can tell you exactly what you need to do. However, I write about the things you need to consider in my post about specifying the correct regression model. I think that post will be particularly helpful.
If you need to learn more about interaction effects, I wrote about that as well. You can include interaction terms for dummy variables. Would that make sense theoretically for your study area?
Best of luck with your analysis!
Hi
What if I have a salary data set and my dependent variable is continuous and I have 10 independent variables one of them is not linear and I transformed it to be exponential
Sounds like you should start with OLS linear regression and see if you can get a good fit. That’s where I’d start.
Sorry I forgot to mention that variables in factor 1 and 3 can follow linear, quadratic… different models! That is why I also wanted to analyse them individualy.
Thank you Jim! I am getting a clearer idea! I have a model which looks like this factor 1–> factor 2 —> factor 3. Factor 1 and 3 are formed by diferent ordinal variables and factor 2 is an ordinal variable! so I am performing two analysis. One saying factor 1 is independent and factor 2 is dependent. Another one saying factor 2 is independent and factor 3 is dependent. Should I perform logaristic regression in both cases? Or Can I consider the independent variable as continuos and dependent variable as continuos/categorical depending on the better fit for both analaysis? So in this way, I would perform a normal regression analysis. Another question I have is: if I say factor 2 is continuous in analysis one, must I say it is continuos for the second analysis? Or can I use it as continuous for analysis one and categorical for the second one? I think I might treat it the same in both analysis so in this case the option would be to assume all the factors are continuous and perform an OLS in both cases.
Thank you again!
Hi Jim,
I am quite confused about which model to use. I have some items that affects a variable. The items follow a likert scale (from 1 to 5), and the variable is an ordinal variable (there are 4 groups that go from highest customization to lowest customization). First I would like to study independently how each item affects the variable, to see if my hypotheses are correct. Can I do I use fitted line plot? I am not sure about which model I might use. And for analysing the impact of all the items on the ordinal variable? Data does not follow normal distribution.
Hi Elisa,
First you need to figure out which variable is your dependent variable and which are your independent variables. It’s not clear from your comment which are which.
If your dependent variable is ordinal data, you’ll need to use ordinal logistic regression. If the DV is continuous, probably OLS linear regression is a good place to start.
It sounds like your independent variables are ordinal data. That can be tricky because ordinal data are a bit like categorical/nominal data and a bit like continuous data. You’ll have to try including them both ways to see which one produces a better fit. All things being equal, you’d prefer to include them as continuous data. When you include them as categorical data, behind the scenes, the analysis is actually fitting many variables that relate to the levels of each categorical variable. In short, your using many more variables going the categorical route, which can cause problems if you treat multiple variables as categorical. However, categorical can sometimes provide a more flexible fit.
You might be able to sum the ordinal variables to create a pseudo-continuous variable. I don’t have experience doing that myself. It seems like ordinal variables are common in some fields, but not others. And, they weren’t in mine. Of course, if you combine them, they might be easier to analyze but you won’t be able to isolate the role of each.
Basically, there’s a lot going on here that goes beyond what I can address in comments. But, that’s the situation in a nutshell! It’ll probably require some research and experimentation on your part to find the best solution out of several possibilities.
Finally, we’re getting to several clear cut answers now! If you include your variables in a regression model, the simple fact that they’re in the model means that analysis controls for them, and you can assess the independent effect of each variable. In other words, when you assess the effect of each variable, the model is holding constant the values of all the other variables that are in the model. That’s makes interpretation easy!
As for how to display the effect, you can’t use a fitted line plot when you have more than one independent variable–you’d need more that two-dimension to display it in! However, you can display the effects on a main effects plot. These are specialized plots that graph the fitted values for values of each variable while holding the other variables constant. How to create main effects plots depends on the software you’re using, but they’re a nice feature because you can use them when you have more than one independent variable. It really helps you to graphically isolate the role of each variable.
I show an example of a main effects plot in my post about interaction effects (most of the graphs in that post are interaction plots but there is one example of a main effects plot). I should probably write a post about those some time soon!
Best of luck with your analysis!
Hi Jim,
Do you have a tutorial on variable selection for logistic regression? I am studying from a textbook that discusses the topic for MLR — the software produces a best-subsets table with adjusted R-squared and Mallow’s Cp for all the different variable combinations. For logistic regression the table contains RSS and Mallows Cp, along with something labeled “probability.”
THanks,
Al
Hallo Jim,
I have a DV, normally distributed, in percentage (the % of women in Governing Board in different companies around the world) and my Independt variables (national gender imbalance indicators) are in %, continuous and ordinals.
Which model should I use? (and do you have any other post of the chose one for me to test the assumptions in Stata to obtain consistent results).
I checked that my DV and IV are significant correlated but there’s no significance when using a GLM model…
thank you,
Marcelo
I appreciate your work. I have learnt a lot from your blog.
Thanks–I’m glad it’s been helpful!
Hello Jim,
I am glad that I found your page. Thank you so much for this informative post.
Actually, I have questions regarding difference in difference (DID) method. I want to employ DID method in my paper to find out the pre-post treatment effect of adopting a technology. When I discussed with a colleague, he recommend me not to choose the treatment and control groups randomly but better to choose from a project. For instance, if the government decide to impose a new policy for X region in Y year and the whole population do not have any other alternatives rather then to adopt, then we can randomly choose treatment group from region X while control group should come from other provinces.
But what if the govenement says its not mandatory but people who will adopt will get many benefits. In this case, if we want to find out the pre-post benefit effects between adopters and non-adopters, can we also employ DID method?
Thank you very much.
Hi Faruque,
I haven’t used the difference in difference method myself. I know it is a method that tries create an experiment but using observational data. So, I don’t have first hand insights.
One difficulty I see in your scenario where it is not mandatory but people choose is that there might be (probably is) a difference between those who choose to participate versus those who do not. If the program provides many benefits, there must be some reason why particular people do not join the program. Whatever that difference is, you’re starting out with it as a selection bias for adopters/non-adopters. This pre-existing difference could bias the results. It’s entirely possible that those who don’t join do that because they won’t receive as many benefits as the average person. If that’s the case, this bias will artificially inflate the difference in benefits between adopters and non-adopters.
It might be that your colleague is making that suggestion about different provinces because it prevents that decision as a source of bias. Maybe. Of course, you then have to worry about whether the citizens of the various provinces are different in some other systematic manner. Such is the nature of observational data!
I always hesitate to offer suggestions based on limit information. But, these are the types of issues to consider.
Dear Jim,
I can’t thank you enough for your advice. I’ll re-do the analysis using ordinal regression.
All the best,
Ellie
Hi, Jim,
I already sought your advice re the multinomial reg. I ran for my IVs (Teachers’ gender, years of experience, qualifications, grade they teach) and and DV (English Teachers’ agreement to promote learner autonomy with four values (1) agree and practice, (2) agree but not practice, (3) unsure, (4) disagree). Among the IVs, gender produced very odd Exp(b) values (e.g., 3972393.841 !!) So, I was thinking of running ordinal regression though the four values defined for the DV are not naturally ordered. This yielded reasonable results all less than 1.
What do you think? Should I report the results of ordinal regression for gender separately or is something wrong in the multinomial analysis which I should fix?
I deeply appreciate your time and advice.
Best,
Ellie
Hi Ellie,
I looked back at your first comment to refresh my memory about. I see that wasn’t totally clear about the nature of your DV. If your DV is discrete and has a natural order, yes, you should use ordinal logistic regression. If the DV is discrete and there is no natural ordinal (i.e., nominal/categorical), you should use nominal logistic regression.
It appears with the new information that there is a natural order, so you should probably use ordinal logistic regression and disregard the other results.
Hi Jim,
This blog is great! If you don’t mind, I was hoping you could help me with something. I’m looking at employing a cross-sectional study to determine health needs in a community. With a couple exceptions (like age, and the distance it takes someone to drive to the hospital), the majority of my variables are nominal (the questions ask about perceived needs, opinions on community strengths, etc.). I believe I need to do a regression analysis but I’m not entirely sure which one. I think I need to use nominal logistic regression but am curious on your thoughts. I might be missing something… Thank you so much!
Sincerely,
E
Hi, it really depends on the type of dependent variable that you have. I couldn’t tell what variable is your dependent variable, so it’s hard to say. You can include nominal variables as independent variables in quite a few different types of regression analysis, which doesn’t narrow it down. If you can clarify the dependent variable specifically, I can give you a better answer. Thanks!
Thanks for your post. That is exactly what is needed for nonstatistican researchers. But I think it would be even more helpful if one can found other cases as well. For instance, when dependent variable is a proportion between 0-1, and independent either continuous or categorical. I found beta regression suggested in the last case. Also, I am pretty sure there is also other varieties of regressions.
best regards
Hi Levan,
I’m sure there are many additional types of regression analysis. This post was meant to cover the most common types. Additional research might be required to determine the correct type for more specialized cases.
Hi Jim !
So basically I have confused myself.
I have an independent variable of age
And the dependent variable is a total of 8yes/no decision tasks. (yes=1 and no=0, so total scores 0-8)
Can you please clarify my understanding? If I was testing each question individually I would use a binomial logistic regression, but by totalling scores I have created a continuous dependent variable and should proceed with a linear regression ? (and if the model is not adequate potentially a non-linear)
Hi Timothy,
Yes, if you analyzed each question individual, you would use binary logistic regression.
Now, summing those eight items together to create a continuous variable might be a bit debatable. The rule of thumb that I’m aware of is that if you have a discrete variable that has 10 equally spaced values and your distribution covers that range, you can consider it a continuous variable. You’re close to that with 8. And, it appears like you satisfy the equally space aspect. However, I don’t have a good reference for my old rule of thumb! I’m not sure how widely accepted the rule is.
What I would do is try fitting the model using it as a continuous variable. Then, be very sure to check the residuals. That’s always a good practice. If the residuals look good, you’re probably fine fitting the model that way. In your write up, you might spend a bit more time explaining how the model satisfies the assumption despite the somewhat unusual dependent variable to allay any fears about that aspect. Also be aware that if you use the model for prediction, you’ll get decimal values and predictions that are potentially past the ends of the data range.
Best of luck with your analysis!
HI Jim!
I am using age as my independent variable (my stats professor said not to code the groups into older and younger) and a total score from a yes/no decision task as my dependent variable (yes = 1 no=0) over 8 related questions. (so total score can be anywhere between 0-8). Does this become a continuous dependent variable? and if my understanding is correct, I should use a linear regression over a binomial logistic (which I would use if I was testing each question individually)?
Jim, I’m a novice trying to recall old business school stats. How do I interpret a high p value for the intercept (0.069) but a significant p (0.01) for the dependent variable?
Hi Dave,
A non-significant p-value for the constant technically means that you fail to reject the null hypothesis that the constant equals zero. In other words, you have insufficient evidence to conclude that the constant is different from zero. However, you typically should not interpret the constant and it’s statistical significance for a variety of reasons. I talk about these reasons in my post about the regression constant.
However, the significant p-value for the independent variable (IV) (and I’m assuming you do mean independent rather than dependent because there are no p-values for the DV) is much more important. First off, there’s no need to attempt to draw a connection or explanation between the lack of significance for the constant and the significance for the IV. Those are independent things. The significant IV indicates that you have sufficient evidence to conclude that there is a relationship between the IV and the DV. For more information about this interpretation, read my post about regression coefficients and p-values.
I hope this helps!
halo am greatful for your detailed work, am a student and am doing my first research, it is really hard for me now, my topic is ” determinants of male participation in family planning decision making” and my dependent variable has three categories ( mainly respondent, mainly husband, joint decision) then the independent variable has demographic and socio-economic determinants. i was requesting help out on which type of regression analysis am to use under SPSS plz
Hi Jim,
I need to see if there is any association between 4 IVs (teachers’ gender, age (four groups coded nominally), grade they teach, years of experience (three groups coded nominally)) and one DV (belief in learner autonomy at four levels).
I am using multinomial logistic regression, and of course I haven’t observed any significant association between my predictors and dependent variable. Have I chosen the correct stat?
Thanks.
Hi Ellie,
For your dependent variable, do the four groups have a natural order? It sounds like they might.
If they do, that order contains some information that you’re missing out on. Instead, you should use ordinal logistic regression.
However, if the groups do not have any type of natural order, then it sounds like you’re using the correct analysis.
I hope this helps!
Agree with you. Thanks, Jim.
HI Jim. Please, can you tell me what is statistical method i should use for analyse impact of independent variable (numerical variable which has same value in period 2012-2016) on dependent variables (numerical variables, which has different values in each year in period 2012-2016). Thank you.
Hi Jim, I have both independent and dependent variable in likert type (strongly agree, agree, somewhat agree, disagree and strongly disagree). What kind of regression method is helpful in order to find the effect of predictor variable on response variable. Thank you
Dear Jim. Really a good post explaining the type regressions to be used in various situation. I need your help. I am working on analysing the determinants of inflation expectations. My dependent variable is categorical, i.e between 0-1, 1-3, 3-5, 5-10 ,10-15 and above 15 (inflation expectations) and independent variables are either categorical (like age group, income and education level) or macro-economical variables like inflation, unemployment and growth. I will be grateful if you could suggest the appropriate regression framework/model.
Hi Jim,
I wanna ask about type of data for multiple regression
I use google to get a rating from a place, for example the ranking for the Eiffel Tower is 4.6. I know, on Google itself, this value is the result of processing between the ratings given by the review of the place being assessed and other factors.
What I want to ask, is a value of 4.6 called ordinal data or numerical data (scale or interval)? so that it can be used as a variable from multiple regression. Because other variables are types of intervals or ratios.
Even if the ranking value is ordinal, should it be changed to numeric first so that it can be used in multiple regression models?
Hi Vivian,
Sorry about the delay in replying to your question. I’ve been away traveling.
Ratings are usually ordinal data. For example, if diners can rate a restaurant from 1 to 5 stars, it’s an ordinal scale. You can average the number of stars and obtain an average of 4.6 or other value. But the data points are ordinal.
However, I don’t know how Google determines the rankings. If it’s more complex than users simply entering an ordinal value, Google’s rating might not be ordinal. I don’t enough about it to really say for sure. But ratings are generally ordinal data.
If the rating is ordinal, you can’t just change it to numeric data. You can represent ordinal data using numbers, but it’s still ordinal data. Image that we use the numbers 1, 2, and 3 to represent first, second, and third in a race. Even though we are using numbers, they are not numeric or continuous data. For example, numerically, the number 2 is twice the value of 1. However, that does not mean that the second place finisher took twice as long as the first place finisher. And, the third place finisher isn’t necessarily three times as long. Etc. You can change how ordinal data are represented, but it doesn’t change the underlying fact that they are ordinal data.
If you have ordinal data and it’s the dependent variable, use ordinal logistic regression. If it’s an independent variable, it can be tricky. You can try using it as an independent variable, but pay extra attention to the residual plots. They may or may not provide a good fit for reasons that I describe in the race example!
Hi Jim
Thanks for this constructive post. I have a question.
I run a multiple regression model in which my dependent variable is the vote for Social Democratic parties and my independent variables are associated with a range of factors.
Do you think that I should keep this single multiple regression model or could I divide this model into more multiple regression models? The advantage of dividing the model into more multiple regression models is that I acquire a better R squared value.
However, my argument in favour of keeping the single multple regression model is that the vote is a complicated phenomenon, which is affected by many factors and by controlling for more factors, we can explain more of the variation in y.
Thank you in advance.
Hi Alex,
I’m not quite sure how you would be dividing up the different models if you’re using the same dependent variable? Maybe by election, region, or year?
To make this determination, you’ll really have to use your subject area knowledge. If you think the relationships between the independent variables and the dependent variable are likely to be constant across the entire large model, that’s a good reason to use just one model. However, if those relationships change based on however you are dividing the models, that’s an argument for either dividing the model or modeling those changes themselves in the large model–possibly by including interaction effects.
Best of luck with your analysis!
First of all, I want to thank you to maintain an excellent blog and it is very helpful for everyone.
I am one of a student who is struggling to find the best regression type for my study. In brief, Animals were fed with a supplement with different doses namely (0, .5 %, 1% ,2% and 3%). Each treatment group has 9 replicates ( ex .5% group has 9 animals). After feeding trail, Different blood parameters (Ex: Immune cells) are measured along with supplement concentration in blood. Now I want to correlate blood parameters(Ex: Immune cells counts ) with supplement concentration in blood.
For this experiment, What is the Correct Type of Regression Analysis?
What is Regression type that I need to work on is it linear regression or non-linear regression? I am still in the learning curve and your help is highly appreciated.
Hi Linch,
It could be either linear or nonlinear regression. It depends on the nature of the relationships between the variables. There’s no way I could possibly guess about that. Definitely start with linear regression and determine whether you can obtain an adequate fit by checking the residual plots. If you can get a good fitting using linear regression, you can avoid nonlinear regression, which is often more complicated.
Best of luck with your analysis!
Hi jim,
Thanks for the post.I have a set of categorical & continous variables that need to predict the success of a event ( fail/pass).The categorical values in the data set take multiple values ( q1 to q400 ) which may be related to region code or some other parameter which may impact the final output.what may be the best model to fit in here.
Hi Geo, because of the binary dependent variable, you’d need to use binary logistic regression. Using this type of regression allows you to determine which variables are correlated with changes in the probabilities of the success of an event. You can use both continuous and categorical independent variables with this type of analysis.
Hi, Jim
i am trying to find the regression line of 1 dependent variable and 35 independent variables (all categorical), but i faced a problem related to the significance of 33 out of 35 coef, all of them is insignificant
I could really appreciate any help
Hi Richard,
That’s a very difficult question to answer. The explanation can range from no relationship existing between those variables to an effect that is too small given your sample size to be detectable (i.e., your statistical power is too low).
Additionally, for 35 categorical independent variables, you probably need at least 700 observations. Possibly higher depending on the number of levels per categorical variable and the distribution of observations across those levels.
Can you narrow those variables down to a few that theory strongly suggests?
actually i can’t since they are the components of the consumption (i.e revenue = C1 + C2 +C3 ……..C35 + S)
Hi, Jim! Thank you for your post.
My doubt is: if I have a continuous dependent variable and a count independent variable, what is the most suited regression analysis?
I understand that if the count variable was my dependent variable, a poisson regression was OK. But I am not sure if the inverse situation demands a regular simple linear regression.
Thank you,
Lis
Thank you Jim. I will increase the time period for the model to include period of growth together with the recession, then use structural breaks to identify effects during the period of recession. Right?
Thanks for your response Jim!
Recall that recession is measured on a quarterly basis and my country experienced recession for a period of 5 quarters which gives us 15 months.
Will it be proper to run an analysis based on data where T=5 (five quarters) & five independent variables.
Will GMM capture this data size? Or what do you suggest?
I think you might have a problem there. I’m not the most familiar with Generalized Methods of Moments (GMM). However, my understanding is that this method trades off efficieny in order to obtain more robust estimates using fewer assumptions. In other words, you need a larger sample size using this method compared to OLS. And, you’d have a problem with using OLS for your study. In OLS, you generally need at least 10 observations per term in your model. You’re nowhere near that. I don’t know the guidelines for GMM, but it is less efficient so presumably you’d need more observations per term.
You probably have an additional issue as well. If you have data only from times of recession, it limits the variability in your dependent variable and possibly the independent variables. This situation weakens the ability of the analysis to detect relationships in the data. It’s much better if you have data from strong and weak economic times because that allows the analysis to more easily determine which independent variables covary with the dependent variable. It’s much harder to determine how the variables covary when at least one of them (dependent variable) doesn’t vary that much.
I think you need more data and particularly include a variety of economic conditions.
Best of luck with your analysis!
Hi Jim,.
Nice work you’re doing here. I’d like to find out the model to use in running a regression where the time period is in months and we are looking at 15months and we have five independent variables. The research aim at looking into factors that significantly increased unemployment during a period of recession which lasted 15 months in my country.
Thanks Seun! Performing regression analysis with time series data can be trick but it’s possible. At some point, I might write a post about that topic! I’d start out with linear regression. You’ll almost certainly need to include time information along with your independent variables. Very possibly include time lagged variables as well. For instance, the state of variable X in the previous time period might affect the current time period. You should always check the residual plots. However, when you’re working with time series data, be sure to check the Residuals versus Time Order plot to ensure that you’re accounting for all the time-related effects.
Hi Jim,
I found this extremely helpful!
I have a very elementary doubt. Is is practically feasible that both dependent and independent variables (all of them) are all dummies, i.e., are binary in nature?
Hi Torsha,
Yes, you can certainly do this using binary logistic regression. That type of regression allows you to use the binary dependent variable, which the other types of regression don’t allow. Then, you can add the binary independent variables, which isn’t unique to binary logistic regression.
I think the type of model you describe is relatively common in the health care field. That’s not my field but I attended a presentation by someone in the field who talked about how they use that type of model to assess the risk of a surgical procedure for different patients. All the independent variables are patient traits (e.g., high blood pressure, etc.) and the dependent variable was survival. The model allowed doctors to enter patient attributes and estimate survival probability. This type of model can also be used in other fields.
Thank you Jim!
I’ve been fiddling around with Minitab trying to get it to include CIs for the parameter estimates, but I just can’t find information online to learn to enable it specifically for parameter estimates. Would you know if this is possible on Minitab, or could you please name some software that I might be able to use to do the CIs? It’s for asymptotic regressions.
Hi Barney, yes, Minitab can display the CIs for parameter estimates. On the main dialog box, click the Results button. Under Display of Results, choose Expanded. When you rerun the analysis, it will now display those CIs along with various other additional results.
Thanks a lot Jim, it does help…..
You’re very welcome! Best of luck with your analysis!
Thanks alot for your replying Jim,
Actually I kinda confused, because my supervisor said that my response variable which is travel time is discrete data. Because the way i collected, because in every interval time, i only have 1 data for every day..
ex. on Sunday– 6am – 6.59am = 42 minutes, 7am-7.59am = 32 minutes, so on
on Monday — 6 am – 6.59am = 40 minutes, 7 am-7.59am = 30 minutes, so on
on Tuesday — 6 am -6.59am = 30 minutes, 7am-7.59am =20 minutes, so on
is it still continuous data or discrete? Because at first I choose continuous too…
And my next question, if i choose time as my predictor variable, how it would like?
because as my example above, it is in interval, can it be like:
Y (mean of travel time at 6am-6.59am) = 37.33,
x (predictor variable) = 6
??
And Jim, can I contact you in private because I really need some suggestions about my research or about regression. Thank you so much
Hi Pipi,
Time is usually a continuous variable even if you collect it once per interval per day. The type of data doesn’t change based on how often you collect measurements. I suppose you could make the case that it’s a count of minutes if you only recorded whole minutes. In that case, you could try Poisson regression. But, generally time is considered a continuous variable. Personally, I’d try least squares regression first and see how well you can model the data using it.
The response variable, you’d just use the travel time.
For the predictor variables you’d include time related variables and you could possibly include other variables as well if you have that data. For example, you can trying including Hour of Day, Day of Week. And, if you have the data, you could try weather conditions too.
I wish I could help more in depth, but if I did that for everyone who asks, I woouldn’t have time for my own life! I get a lot of requests for that. As it is answering comments of a more general nature takes a lot of time! I hope you understand. But, I do try to provide general tips and points–like I am here! 🙂
Hi Jim,
I am now in reseach about regression model. I was wrong before because I used polynomial regression and Trend analysis (Time series) for predicting my data which the response variable is discrete and the predictor is continuous.
Actually I want to estimate and predict the travel time, so I’ll describe the way I collect the data,…
I collected the travel time datas (response variable)about 1 month, everyday.. And in everyday i collected the datas from 6am-10.59pm, where the interval per 1 hour.
Ex. on Sunday– 6am-6.59 am = 42 minutes, then 7am-7.59am= 40 minutes, and so on
so I want to estimate and predicting by using regression.
Is it right if i used Poison regression for solving my problem?
Can I combine with Trend Analysis especially Quadratic ? if I can combine how it would like?
Really need your suggest,
Thanks Jim
Hi Pipi,
Time series analyses require data that are collected at consistent intervals and that do not have any gaps. Your data have gaps (midnight – 5:59AM), so you can’t use time series analysis. Also, you use Poisson regression when your response variable is a count. Your response seems to be a continuous variable.
I would try using linear regression analysis and then including predictors such as time of day, maybe day of week, etc. Include the time components as predictors. You can include polynomials if needed. Regression with time related data can be tricky but it can work.
Trying fitting the models, checking the residuals, and adjusting as necessary. In addition to the regular residual plots, be sure to pay extra attention to the residuals vs order plot because you have time ordered data (assuming you record them in your worksheet in time order).
I have not done much regression with time related data, so I don’t have much more to suggest than trying that approach. Best of luck with your analysis!
Hi Jim,
Very informative article.
Pardon me for perhaps a simplistic question, but is it considered regression analysis if the function is known, and I want to test the correlation of experimental data against the function? If so, what should I research to learn more about it?
Hi Barney,
Thanks! I’m glad it was helpful!
If you have a theoretical function and want to compare it to the fit you obtain for your data when you specify the same model as the theoretical function, you can use the confidence intervals (CIs) for the parameter estimates. If these CIs do not include the parameter values from the known function, you have sufficient evidence to conclude that the differences between your parameter estimates and the known function are statistically significant. Most statistical software should be able to produce this type of CI, although it might not always be included in the default output.
So, that’s what you should look into: CIs for the parameter estimates (coefficients) in a regression equation.
Hi Jim,
Cool article!
How should I proceed when I want to compare a hypothetical non-linear graph with an experimental graph, when the function and the shape of graph is unknown? I want to quantify the two graph shapes, and compare their equations, as opposed to visually overlapping the two graphs.
I have a continuous independent variable of time, and the dependent variable of velocity calculated from previous iterations of velocity starting from 0. Increasing the order of the polynomial that I use brings me closer and closer to the shape, but I do not believe that my function is polynomial.
Thank you!
Hi Kelly,
I’m not 100% sure what you’re asking, but I think might be asking how to specify a model that fits the curve in your data and how to determine whether that model adequately fits the curvature. If so, I’ve got the perfect blog post for you: Curve Fitting Using Linear and Nonlinear Regression. I cover the different methods you can use to fit curves and how to determine which provides the best fit.
For your data, if the polynomials don’t provide a good fit, you might well need to transform your data or use a nonlinear model. Note that nonlinear models are different than linear models that use polynomials to model curvature, which is what you’re doing. I talk about all of that in that post!
I hope that helps!
Hi. Thanks for this post. It is very informative.
I am a student. I have a dataset with 300,00 rows and 77 columns. How do I approach the data?
Also I have to do some predictive analysis. My independent variables are a mix of continuous and nominal categorical variables and my dependent variable is continuous. Which regression model should I use?
Hi Kirti, with a few exceptions, the type of regression analysis you should use doesn’t depend on the size of the dataset and number of variables. Usually, it’s the type of variables that you have.
For your case, I’d start with multiple linear regression. See if you can get a good fit to your data using that procedure.
Hey Jim! Once I’ve trained a logistic model and know which predictors are important, is there a way that I can define an optimal range for my input variables? For example if I’m trying to adjust three settings on a machine to minimize my probability of introducing a defect, how could I use my coefficients from a logistic model to decide what the mean setting should be for all three to maximize probability of no defects? Thanks!
Hi Tony,
There are ways to do optimize your inputs. The process for doing this depends on the statistical software package that you are using. So, it’s hard for me to give any practical advice about it. Essentially the process takes the model that you settled on and then uses an optimization routine to determine which input values optimize the output. So, it’s a separate process from the model specification and fitting process–although your software might tie them together. Typically, you can specify whether you want to obtain a specific target response value, minimize the response value, or maximize the response value. In your case, you probably want to minimize the probability of defects.
Another approach is to perform a Monte Carlo simulation where you generate random data for the input values in your regression equation. The data for each input follow a distribution that you specify. You input these randomly generated data in your regression equation, which produces a distribution of outputs that you can then study. Additionally, you can change the distributions of the inputs to determine how that affects the distribution of the outputs. That allows you to answer “what if” types of questions about changing the inputs.
I hope this helps!
Hi Jim
Thank you so much! This is very helpful. Here’s more information on what I’m trying to do.
The problem:
I’m studying the impact of adopting technological capabilities (independent variables) on teams performance (dependent variables) in IT.
The approach:
Identify significant performance clusters between teams, and understand how the adoption of technological capabilities impact teams performance clusters.
My dataset consists of:
1) 17 independent variables, one variable is ordinal (1 to 7 scale), 7 variables are categorical (true/false), 9 variables are continuous/numbers.
2) 3 dependent variables, these are continuous/numbers.
3) Dataset size is 36 subjects.
My analysis is two steps:
1) Run the 3 dependent variables (performance measures) through clustering algorithm and find out if there are significant clusters. This test was successful and I found 3 significant clusters (high, medium, low).
2) Now I want to test the influence of the 17 independent variables (technological capabilities) on the 3 clusters. I planned to use multinomial regression but it didn’t work due to the issue mentioned in the earlier post.
My questions:
1) Given the number of independent variable (17), is there a recommended data size for the multinomial logistic regression to work successfully? How many subject can be good enough?
2) Since my clusters consist of the 3 dependent variable, I’m thinking of testing the impact of the 17 independent variables on the 3 dependent variables that make the clusters instead of the clusters themselves using PLS or multi linear regressions? This is still a workaround but I may consider it just in case my logistic regression model continuous to fail.
3) Any other recommendations?
Alternatives:
I checked the linear discriminant function and it seems promising. I think the problem is I don’t know how to interpret its results to find out how the independent variables influence the 3 clusters. I’m not planning to build a prediction model with either logistic regression or discriminant function, I only need the “inferential” piece not the “prediction” piece since I just want to understand the influence of the independent variables on the cluster not interested in building a prediction model.
Your help is much appreciated! Thanks again!
Hi Jim – Thank you so much for this clear post! This is very helpful.
I have a question. My dependent variable is categorical (3 categories). when I tried nominal logistic regression using minitab, the model didn’t converge. After some research I found out that my data has a collinearity problem making it difficult for the nominal logistic model to converge.
Instead, I tried both linear regression and partial least squares, using minitab, on the same data and the results seem reasonable. My question is, can I use linear or PLS regression if my response variable is categorical? or do I have to do nominal logistic regression?
Thanks again!
Hi Maro,
Thanks for writing with the great question. Unfortunately, when you have a true categorical variable, you cannot treat it as a numeric variable. Suppose you have three groups. You can label each one with numbers: 1, 2, 3. However, that doesn’t mean you can analyze them as numbers. Those numbers might represent: scratch, dent, and tear. Or maybe gold, silver and bronze. The numeric labels don’t measure/represent the actual characteristic that the groups are based on. To illustrate this, the value 2 doesn’t indicate that it is exactly twice the value of 1. The numbers also suggest a logical order to the groups that just doesn’t exist (otherwise you’d be using ordinal logistic regression).
Consequently, you can’t use linear or PLS regression. I don’t know what your model is or your other variables, but if you have only categorical variables, you can try the chi-square test of independence to look for relationships among categorical variables. Otherwise, I think nominal logistic regression is your best bet. To address the collinearity, you might try removing or linearly combining variables and using them in nominal logistic regression. By linearly combining them yourself, you’re incorporating some aspects of PLS into nominal logistic regression.
I hope this helps!
Hi Jim,
Is there any way we can mention a categorical dependent variable to be ordinal variable before passing into the logistic regression model as it might provide extra edge to the model output
Assuming that I understand your question correctly, if you have an ordinal dependent variable, you should use ordinal logistic regression to analyze your data.
Hi Jim,
I read your blog on regression and it was lucid. But I am confused about the regression testing with the model with below mentioned variables
I have control and test samples which have discrete quantitative variables.
If I have to model this with another independent variables like gender (dummy variable or independent), and one ordinal variable.
Since I have my control and test with other factors like gender and housing. I want to determine the link and analyze the effect of Housing and gender on my control and test samples.
Can you please suggest which regression model would be appropriate. Is that Binary logistic or Multi nominal logistic regression??
Thank you in advance.
Hi Anudeep,
It really depends on what type of dependent variable you have. Can you clarify the nature of your dependent variable?
Hi Jim, Thanks for this post. It clears the regression clouds haunted me for a loooong time! It is really helpful! Statistics had been my nightmare since Uni but I guess no more. Look forward to your next posts!
Hi WW, I’m so happy to read your comment! I strive to make these posts as easy and intuitive to understand as possible. It makes my day to read that they’ve helped you!
Stayed tuned, I am writing more posts but taking a short break at the moment.
Hi Jim,
Really nice article
I am stuck in a problem where i have to do regression but I am unable to decide with which regression model i should proceed. To give you a background, I have sales (dependent variable) and lets say a, b, c,d and e are independent variable(The sales is triggered by these independent variable). My objective is to find the importance of each independent variable, so that we can prioritize on that channel. Now the values in independent variable can be either “Open”, “close” or blank. I thought of using Binary regression model but here i have three type of values but Binary takes only two.
Pls suggest
Thanks in advance
SK
Hi SK,
Assuming that sales is a continuous dependent variable, you do not want to use binary logistic regression or other specialized type. Binary logistic is for cases where the DV is binary. You’re talking about independent variables.
You have categorical independent variables, which you can include in linear regression. Most statistical software will code those as indicator variables automatically. Does “blank” represent a missing value or is that an actual value for the IVs? If you have “Open”, “Close”, and missing values, you’d just need one indicator variable for each IV. The indicator variable could be something like Open_A, which is a 1 if variable A = Open and 0 if variable A = Close. Repeat for the other channels. But, again, most software will do that automatically.
Finding the relative importance of each IV is a separate matter that I write about: Identifying the Most Important IVs
I hope this helps!
Hi Jim,
I am currently doing a research on behavior pattern in Peru.
My dependent variable are binary but my independent variables is a mix between binary and continuous variables . I have to use data from previous round to predict the later round . For example dependent variable is smokes at age 15 which is binary and some of the independent variables are mathscore standardize at age 12 (continuous) and drinks alcohol at age 12 (binary). I also think that there is also an endogeneity problem in this setting. Hence, I do not know what regression in STATA is best for this kind problems? Also how do i solve the endogenous problem ?
I thought of using linear probability model, since it seems the easiest but I don’t think this is the best method .
Thanks in advance
Kind regard,
J.zhong
Hey Jim,
Thanks a lot.
This is very good explanation of regression techniques.
This post will gain another boost if a flow chart or map for choosing the right technique is provided.
Just a suggestion.
Thank You again!
This is really helpful.
Sir which model is best for stock market short time prediction
Hi Sandeep, ah, I get asked that question many times. And, if I knew the answer to that one, I’d be so rich that I’d have more money than I’d know what to do with! The fact is that the stock market is fairly unpredictable. If you could predict it in the short term, then everyone would know exactly where to put there money at any given point. And, then the advantage is gone. So, it doesn’t work that way.
This is fantastic! I’m a 3rd year statistics major at university, and it is so refreshing having this overview of regression set out in such a clear way. Major kudos for all your work!
Thank you, Kai!
Hey Jim,
Thank you for this post, really like the way you explain things.
I am working on a project where I am assessing the relation between discriminative attitude and healthcare provision in health care workers:
– Discriminative attitude: is the independent variable and will be measured using a series of 10 scaled question (scaled from 1 to 5). In that way any respondent will have a score somewhere between 1 and 5, hence i am assuming it is a continuous ordered variable right?
– Healthcare provision: is the dependent variable and will also be measured using a series of 10 scaled question (scaled from 1 to 4) – similarly to the independent variable, i am assuming this is a continuous ordered variable.
In your opinion, what analytical model would be most suitable for that purpose?
Thanks!
Thank you, Jim. This is helpful
Hi, I’m so glad that is helpful!
Hello Mr. Frost,
first of all great website. Wish I knew the existence back when I was in my bachelors studies. My question is concerned with log-linear models and binary variables. I developed a model for a thesis that looks like this:
log y_t – log y_t-1 = beta_0 + beta_1 A + beta_2 B + u. The dependent variable is the percentage change of the Treasury yield and A and B are binary events like FOMC meetings. Is this example considered a log-linear regression model? Thanks in advanvce.
Hi Jim
Im student, have problem with how can choose which regression model i need to use in my case.
i have many variables with one response like mix design variables and the response is compresive strength of concrete
Hi Ahmad, choosing the best regression model is a very important task. In statistics, we call that process model specification. I’ve written an entire blog post about it that will help you. Model Specification: Choosing the Correct Regression Model
Best of luck with your analysis!
That is very helpful, but did not answer my own need. If you can advice my, I have 2 IV and one DV, in addition I have one moderator variable. What is the best test, all variables are ratio scale? thanks in advance for your help
Moderator variables are commonly used in psychology–which isn’t my field. However, from my understanding, they are essentially interaction effects. That is, the effect between an independent variable and a dependent variable depends on the value of another variable. To fit this type of model, you can use OLS multiple regression. You just need to include the appropriate interaction term in the model. For more information, read my post about understanding interaction effects.
Hello Mr. Jim
I hope you are doing very well.
I am in confusion in the testing of regression analysis. Well, as we read in basic Statistics that F test is a two tailed test whereas when we use F test in testing of regression analysis then we always treat it as a one tailed test. Why so?
Thanks
Pankaj
Hi Pankaj,
That’s a great question. As it turns out, for regression and ANOVA, the F-test is always a one-tailed test. The F-test tests the ratio of two variances (technically mean squares rather than variances). In regression and ANOVA, it’s a one-tailed test because of the nature of what you’re testing. In One-Way ANOVA, you’re determining whether the between group variance is greater than the within group variance. In regression, you want to determine whether the model with all of your predictors is better than the model with no predictors (only the constant). Those are one-tailed tests by the definition of how the hypotheses are specified–you are determining whether one variance is significantly larger than the other variance.
To see how the F-test works in detail I suggest you read my post about the F-test and One-Way ANOVA. Regression analyses uses the F-test in a similar way but changes the variances in the ratio. You’re testing the model with all of your predictors compared to the model with no predictors (just the constant). You can also read my post about the F-test of overall significance.
You do use two-tailed F-tests for Variance Tests. In this case, you require the ability to determine whether the variance in the numerator is larger than or less than the variance in the denominator. You’re testing both directions (larger and smaller), hence it’s two-tailed.
I hope this helps!
Thanks Jim for this informative Blog
I want to examine the influence of predictor variables such as Physical activity (low, moderate,high), sedentary time and dietary habits ( fruits, vegetables, junk food etc.) on a dependent variable BMI, collapsed into lower level ordinal categories like underweight, normal, overweight and obese. If I have to see the odds of being overweight/obese for a person based on these behavioural practices. What would be the appropriate regression analysis. Or am i required to dichotomize (1.underweight/normal and 2.overweight/ obese) my dependent variable and use binary logistic regression. Your views will be much appreciated.
Hi Raof,
It sounds like you need to use Ordinal Logistic Regression. Your dependent variable is an ordinal variable. Unfortunately, I don’t have a good example of this type of regression to share with you, but it can do what you describe.
The one problem I see is that you also have an ordinal predictor (physical activity–high, medium, and low). That can be problematic. You can try to fit the model and check the residuals to see if you satisfy the assumptions. If it doesn’t work, you can try converting those three levels to two indicator variables. Indicator variables are binary variables where you have one for each level–however you need to leave one out of your model (e.g. High, Moderate). You need to leave one level out for the analysis to run so I intentionally didn’t include Low–but you can leave any level out.
But, for your ordinal response variable, use ordinal logistic regression.
I hope this helps!
Hi Jim,
Thanks for posting this.
I would appreciate your thoughts on my analyses. I have an independent variable that is a count variable (number of days at work). My dependent variables are all continuous variables. Can I use a simple linear regression model to test a moderated mediation relationship with the the IV as a count variable?
Thanks!
Hi, I’d give the model a try but check the residual plots to be sure that the model satisfies the assumptions. If you’re fitting just the one independent variable, you can use a fitted line plot and really just see at glance if it provides a good fit. I show an example early in this post.
Hai Jim,
It is very informative. I found it very useful for the researcher. I have a doubt in my study, i wish test the relationship between domestic tourists and foreign tourists. when we look at the total number the same trend is observed by the two . so I wish to know which method can be used to prove that the pattern of change of domestic and total are the same or the movement of total tourist is same as the domestic.
thanking you
Shiji
Hi Shiji, I’m not 100% sure I understand what you are studying. However, it sounds like you might need to include one or more interaction term in your model to determine whether the relationships between your independent variables and dependent variables depend on whether a tourist is a domestic or foreign tourist. I write about comparing regression lines in an article. Read that article and, in the graphs where I show the regression lines for two different groups, imagine that one group represents domestic tourists and the other represents foreign tourists. That might be what you’re looking for. I hope this helps!
hi, i am a student and i have a problem, i want to predict bankruptcy in IRAN . and i want to use LASSO regression to choose more effective independent variables, i select dependent variable y(0 , 1), and i have 50 independent variables that are financial ratios , and i do analysis on Spss, but i have many problem with result, so i have a main question, can i use lasso to predictive with 0 and 1 dependent variable, can i use Spss to do it?
thank you Jim.
Hi Nasim, I haven’t done this myself but apparently it is possible. I recommend that you read this about using Lasso with logistic regression. This example uses R, but I’m not sure about SPSS.
Hi. I am a student, and I am having grave difficulty in determining what types of variables I have for my study. (still in the learning phase). This is my problem statement. It is not known if and to what extent a positive correlation exists between organizational commitment of supervisors and practicum success among students, and whether student intrinsic motivation moderates the relationship.
Please, if you were me what analysis would you use and why. And to your best knowledge what types of variables are these? I look so foraward to receiving yuour respose.
Hi Renee, most likely you are working with either continuous or ordinal variables. To determine which type of variable, check out my glossary definitions for both:
Continuous variables
Ordinal variables
For pairs of continuous variables, you can use the Pearson correlation. Be sure to create a scatterplot and determine whether the relationship is linear.
For pairs of ordinal variables, you can use Spearman’s correlation.
Best of luck!
For the count example (number of calls an analyst receives daily), curious about using Log transformation of the the dependent count variable and using random forest on that?
Would that work?
Than you…
Hi John, unfortunately I’m not overly familiar with random forest models. That’s something I should learn more about!
Very intitutive. Loved the way you explained it. Thanks Jim.
Thank you, Abhishek! I really appreciate the kind words and I’m glad you found it to be helpful!
Very knowledgeable points
Thank you, Mukesh!
Technically, regression examines a relationship between predictor and response variables. I wish people will stop using IV and DV incorrectly. There’s nothing the researchers are manipulating in your examples either.
Hi Nicol,
Predictor and response variables are synonyms for independent and dependent variables, respectively. You can use them interchangeably. Also, you’re correct that none of the examples have researchers setting the values for the independent (predictor) variables. However, that’s just fine in regression analysis. These examples are observational studies where you measure data and observe the relationships.
You can also use regression analysis in designed experiments where you use random assignment and the researchers set the values of the experimental variables. The designed experiment approach is particularly good when you want to establish causality (rather than just correlation) and it helps rule out confounding variables. However, this type of experiment isn’t always feasible, and it’s OK to use observational studies as long as you are aware of the limitations and potential problems.
Thanks for writing!
Jim
Great post Jim. I really like the way you explain the different types of regression.
Thank you, Roy! I’m glad that you found it helpful!