Need some help with excel.

Okay so anyone who knows how to use excel here, please help! lol

For my finance course i needed to gather a bunch of stock data for 5 stocks over 7 years (monthly). Then i had to calculate the monthly returns for each stock, I did all that and have the returns etc.

Now I need to create a frequency diagram for the returns using the historical data. Our instructor told us to use the FREQUENCY function in excel, i'm not too familiar with how this works but my guess is that it measures how many values fall between 2 given values. So if i had 3 returns of 11, 12, 13, then the frequency of those falling between 5 and 15 would be 3?

Any help would be appreciated.

 

Use several Excel functions - but must admit Frequency is not one of them - looking at the Excel examples/help files - you need numbers to compare your data to - in above case you stated 5 and 15 this is what is called you Bin scores. So for you example after you enter the formula and have your data in an array (list of stock prices in one column and list in another column of control numbers or values he set as the lower and upper limits - the answer from your short example above will look something like this:
Scores less than or equal to 5 --> 0
Scores between 6 and 15 --> 3
Scores greater than of equal to 16 --> 0
Obviously from your assignment you have a much larger score list or stock prices than 3.
Hope that clarifies the function