Hello guys!

I wonder whether anyone of you who is killing in statistics could give an advice. I am writing my master thesis at the moment.
The first part of my research is planned to be focused on the sample of N oilservice firms, in other words, firms in the same industry.
What i want to find out is how different was the level of goodwill impairment in that samle of companies.
I will find out the this year amount of that impairment in % of goodwill level from the last year.
When I get this amount in % for all the firms in the sample, I want to see the trend through the years. For example, did almost all of these firms amortizated goodwill more than the last year or not? IS THE DIFFERENCE BETWEEN THE IMPAIRMENT VALUES SIGNIFICANT AMONG COMPANIES? It can be significantly high or not.


It seems to me that this is a kind of hypothesis test :

H1= significantly different

H1= not significantly different


How could I use the data analysis in excel to show it? Please help! Are there are any other programmes I can use?


Look forward to read your comments!