Using excel statistical function"frequency", how can I generate results based on a range ie btwn 1-2
921997
Although you cann't directly setup the instance of the bin as you asked, indirectly you can accomplish the same thing by setting up your bins as:\n0\n.9999999999\n1.999999999\n\nThese bins will still only capture the frequency "up to" that bin value  but add a label beside your data to note specifically what is in the bin.  For the examples above\n0 and below\n.000000001 to .99999999\n1 to 1.9999999999\n2 and above  (for the last bin which is not defined)
266823
Enter the number into MS Excel, then use the standard deviation formula from the "function" option. Your answer will depend on whether those numbers represent the population or just a sample from a population.
981152
Select a cell then F2\n\nVBAXLMan
837908
click here:http://en.wikipedia.org/wiki/Microsoft_Excel
892201
you can do simple time series regression in Microsoft Excel
247558
Cell Name      Entry\nA1 =           Number Hits\nB1 =           Number of Times At Bat\nA2 =           A1/B1 = batting average.  \n\nIf you want it to be in batting average form you should right click on A2 and choose "Format Cells".  Once inside that menu, click number and then put a 3 in the decimal places box.  Enjoy!
431591
Use Microsoft Excel or a slide-rule
668871
You may have to write that fomula out manually. \n \n=OR(AND(A1,NOT(B1)), AND(NOT(A1),B1))
887281
Are there duplicates in either column? That could make this not work very well. If not, use this in a third column, just copy it down alongside.\n\n=IF(COUNTIF($A:$A, B1)>0, B1, "")
965931
u can do it by sorting, filtering i know , other participants already gave u that so i'm including this one\n\nfor largest value \n=MAX(B1:B3)\n\nnote the reference value of this cell in the left top \n\nfor corresponding day \n=LOOKUP(cell reference value of max,B1:B3,A1:A3)\n\ni think it's the best answer
837680
I assume you are talking about the rate function in MS Excel. It is not difficult to explain, but the reference site does a better job then I would.
920884
This all right from Excel's Help - pretty clever, huh?\n\nCreate a histogram   \nYou can analyze your data and display it in a histogram with the Histogram tool of the Analysis ToolPak. This data analysis add-in is available in Excel, but may not be automatically loaded. \n\nNote  If you don't see Data Analysis on the Tools menu, you will need to load the add-in. For more information, see Load or unload add-in programs.\n\n\nEnter the data you want to use as input for the Histogram tool in one column. If you want, you can add a label in the first cell of this column.\nNote  You must enter quantitative numeric data (such as item amounts or test scores) in each cell of the input column— the Histogram tool doesn't work with qualitative numeric data (such as identification numbers).\n\nIn another column, enter the bin numbers you want to use for the analysis. The bin numbers need to be entered in ascending order. To quickly generate a set of evenly distributed bin numbers, you can use the Fill Series option. \n-MM
1075938
This macro will create a random number that does not change, even when the sheet is recalculated. It prompts you for an upper limit, a lower limit and then for (integer or decimal).\n\nSub RandomNumber()\nupperLimit = InputBox("Enter Upper Limit")\nlowerLimit = InputBox("Enter Lower Limit")\nnudp = InputBox("Just hit OK for Integers or type D for decimals")\nIf UCase(nudp) = "D" Then\n   With Selection\n      .ClearContents\n      .NumberFormat = "#,##0.0000"\n   End With\n   For Each cell In Selection\n       cell.Value = Rnd() * (upperLimit - lowerLimit) + lowerLimit\n   Next cell\nElse\n   With Selection\n      .ClearContents\n      .NumberFormat = "#,##0"\n   End With\n   For Each cell In Selection\n       cell.Value = Int(Rnd() * (upperLimit - lowerLimit + 1) + lowerLimit)\n   Next cell\nEnd If\nEnd Sub
479961
List your readings in a vertical column (you will have to decide which readings out of the up-to-6 a day you are taking, or I suppose you can average them daily using the same means I am giving you here).\n  In a blank cell by your list enter the formula =AVERAGE(r1:r7), where r1 is the first daily number and r7 is the 7th daily number.  Use the same format for 14 days (r1:r14) and 30 days (r1:r30).  If you wish to average the several daily readings, list those horizontally and, to their left, enter the =AVERAGE formula, then use those averages in your daily average formulas.
326703
In Microsoft Excel, you can choose the type of number you want displayed in each cell.  \n\n-Simply highlight the cells you want to display this in\n-right click on your mouse\n-choose Format Cells  \n-Click on the Numbers tab\n-Scroll through the list until you find the one that is right for you.\n\nYou can also do this.  Say you want to convert 98% to .98,\n\n-Click on the cell you want .98 (i.e. B1) to appear in\n-Type: =\n-Click on the cell where 98% appears (for instance A1)\n-Type: * (the multiplication sign)\n-Type: 1.0\n-Hit return\n\nYour formula should look like this: =A1*1.0\n\nYou can then copy and paste this formula into any cell.  I hope this helps!
1005206
the same way you do it with excel...
142496
There are a number of available tools in the following website:\n\nhttp://www.functionx.com/