# Thread: Simple linear regression, constructing an ANOVA table

1. ## Simple linear regression, constructing an ANOVA table

Hi guys

Please see my question about fitting an ANOVA table. I presume this model will be fitted by $\displaystyle y=\alpha+\beta ~logx_i$

I've started doing some work, by taking the logs of all the prices, and finding the means:

Please find attached the excel spreadsheet containing all the data and what i've done so far.
regression question excel.xls
I'm confused in the sense, what do I have to x and y. I only have values for 2 years of tyres.
I would greatly appreciate any assistance on this,

Many thanks