i need list of all the titles with MODE(average) rating 9 or 10(separate for each number).

Hi Mudassar Iqbal,

I'm not certain what you are asking.

Mean - The average, which statisticians call the mean, is the sum of the votes divided by the number of votes.

Median is the middle vote.

Mode is the most common vote.

This article provides a simple explanation of these statistical concepts.

The Mean, the Median and the Mode
http://math.about.com/od/statistics/a/MeanMedian.htm

IMDb provides these statistics for each film on the ratings page for the film. As an example, here is the ratings page for The Shawshank Redemption (1994):
http://www.imdb.com/title/tt0111161/ratings
Number of votes
Arithmetic mean
Median
Mode can be determine be inspection.
weighted average
Your rating if you rated the film
Demographic breakdowns
Rank if the film is in the Top 250 Movies

I'm assuming that your are asking:
How do I create a list of films in descending order of number of votes that have a mode of 10?
How do I create a list of films in descending order of number of votes that have a mode of 9?

IMDb allows users to do an Advanced Title Search. This search allows results to be sorted by:
MOVIEmeter | A-Z | User Rating | Num Votes▼ | US Box Office | Runtime | Year | US Release Date

This search is close to what I believe you want:

Most Voted IMDb "Top 1000" Titles
http://www.imdb.com/search/title?count=250&groups=top_1000&sort=num_votes,desc&view=simp...