Please note that the data is excel sheet is not my real data and my intention behind attaching the excel file is only to give our feedback community a clearer idea of how my data is expressed. This is the reason I have not run a two way ANOVA for this hypothetical data values. However, I have run a two-way ANOVA for my actual dataset.
Description:
Let's suppose I have a dataset for 'three types of vehicles (let's call them A,B,C), three types of tires (let's call them P,Q,R), and I measure the speed of each vehicle for each type of the tire. I record total 6 values for speed for each combination of vehicle and tire (Please view the excel file so as to get a clearer idea of how my data is expressed). I run a two-way ANOVA and I realize that my data does not follow homogeneity of variance. However, it is normally distributed and there are no outliers.
Then, I transform my data to log values however, I encounter the same issue (i.e. homogeneity of variance violated, data is however, normally distributed and no outliers).
So, my question is, do we have a non-parametric test that I can run instead of two-way ANOVA to analyze my data and obtain similar parameters in the output as a two-way ANOVA (such as mainly telling me the significant differences if there are any between "tires P for vehicle B" and "tire Q for vehicle C")?
Software I use: Excel, SPSS.