1. Estimating impact of Predictor

Hi,

I have a simple regression with 24-36 months of data, let's say of Sales which is the dependant variable and % spend on promotions in that month as independent variable (amongst other variables). I am running a normal linear regression on this

The independent variable , let's say can vary from 0-100% and the Dependant variable Sales varies from 7-10K \$.

After running the regression, i am getting unusually high beta for the Predictor, 50-60K as the value.

What i want to understand is, is this the right construct of running a linear regression and if any transformation is required? I dont think so, as when i plotted the two on a scatter plot and fit a linear trend like,it fit perfectly and while displaying the R-squared, it showed a value of 60%.

if i want to understand, what is the impact on Sales on a 1% increase in the INdependent variable - how do i do this?

Currently, what i am doing is :

1. Computing Y (Baseline) as (beta * Average X + C)

in my case Beta is 60K, Average X is, let's say 15% and hence i obtain Y (Baseline) as 8.5k

2. For a 1% increase in X, i want to compute Y... so, i keep beta as same, C as same, i add 1% to average X and hence compute Y

i subtract this Y from Y(Baseline) computed in Step #1.

Is there anything i am doing wrong...?

Thanks!

2. Re: Estimating impact of Predictor

If this isn't time series the model should be appropriate. The one thing you would need to look out for is, the distribution of IV, and whether a majority of values are at the lower or upper bounds (e.g., 0% or 100%), if that is possible. Meaning can you have 11% or negative percentage.

3. The Following User Says Thank You to hlsmith For This Useful Post:

confusedguy15 (09-22-2017)

4. Re: Estimating impact of Predictor

So, the valuesof IV arent at extreme ends, its mostly in 5-15% range

5. Re: Estimating impact of Predictor

Any reason why i would see the high beta and anything to correct that?. Also, is my method of computing DV increase for 1% increase in IV, correct?

 Tweet

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts