Variance Analysis

[mikeindtc]

I have two sets of data from two separate years. Each year has three variables (volume, price, total). I'm trying to determine how much of the overall variance is from each variable.

Example:

Year 1 - Volume = 500, Price = 2, Total = Volume x Price or 1000

Year 2 - Volume =100, price = 3, Total = 300

Percent change in Total from Year 2 to Year 1 = 300/1000 or 30%

How much of the 30% is attributable to the change in Volume and how much is attributable to the change in price?

Thanks,
Mike

 

[galactus]

Did you perform a multiple regression analysis?. Look at the R^2 values upon doing so.

Excel runs this and gives the necessary info.