statistics

Hello, Although I have lurked on this forum for some time now, this is my first technical post to the group asking for programming advice. I have some knowledge of VBA, learning it as I go, and some of the advanced statistical functions of Excel. Some of the posts and replies of this group have...

Hi all, I'm just beginning to verse myself with arrays and writing my own functions and was hoping someone could walk me through the following function. Not so much the formula for stdDev, but sytax such as mean(k,Arr)....what is that doing. I'm still a bit uncomfortable with arrays...

Hi, I was quite a few problems using worksheetfunction.ln() to calculate % change. I decided to write more basic code to try to accomplish this but I'm getting an overflow error. Can someone tell me how to fix this. DRows = WorksheetFunction.CountA(Sheets("INFO").Range("A:A")) For r = 1...

Below is code for my volatility calculation. rngvol is the number of days the volatility is taken over volcal is the number of data items cor1 is the standard deviation over a given range volatility 1 should be the volatilty result 'Statistical Volatility Calculation 1 rngvol =...

I'm try to use the StDev function to calculate value. This is what I have so far but I continually get errors. Any thoughts on whats going wrong with the following code?It's saying StDev is an invalid qualifier. rngcorrel = Worksheets("config").Cells(32, 2)...

Hi Mr Excel I run a small business, where I have a few employees. I want to create a timesheet, where the weeks are divided into seperate sheets and in the end i have a aggregated sheet. I need a formula that can aggregate all x, y and z seperately from the week into my aggregated sheet. i...

how is possible to generate a list of numbers from 20 taken 6 at the time, this 20 numbers are taking from 1 to 53, <TABLE style="WIDTH: 528pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=704 x:str><COLGROUP><COL style="WIDTH: 48pt" span=11 width=64><TBODY><TR...

Hi there, I have investment returns for stocks that I would like to calculate the mean for based upon a certain date range i.e. 1st May 2010 to 14th May 2010 (daily date to daily date) or January to March (month to month). The spreadsheet is set up in that Sheet2 has the daily dates...

Hi I'm trying to do some fairly simple statistics using excel and I'm struggling to find the built in functions. I have 2 columns of data and want to calculate the correlation co-efficient of the two data sets, one against the other. This if fairly simple. I also want to calculate the...

Hi guys I need help finding out which formula works best at find similarities between to rows. For example Row A1................... Row B2 8443..................... 1231 1554...

Greetings Power Users! XP, Excel 2003 with stats ad in Yes, this is an assignment AND I have the answers BUT I want to know how to get there (not wating your time). Taking online statistics and everyone in class using calculators, I am the only Excel fan. I approach problem as BINOMDIST...

I'm not sure if this is possible, but... I'm trying to create all possible permutations for a string of keywords in a ell. For instance, Cell A1 contains: Black Air Max M200 Super Light Basketball Shoe So that's 8 words, and I need all possible 2, 3, 4, 5, 6, 7, and 8 word combinations in...

Hello everyone, First time poster, long time visitor. I'm wondering if someone can help me with an excel spreadsheet that contains statistical information for hockey players. We run a tournament in the summer with about 18 teams and each team has 23 players. We have a "top 15" player list and I...

I'm currently using a boxplot to chart data, but the method is "old school". The new method is to use are Beanplots, but they are a complex combination of column, area, and scatter plots. Has anyone dealt with this or know how to have excel graph a Beanplot? This site gives a good visual...

Hello Guys, I am making an excel Database for my newspaper. I have huge database of Articles and their Authors and Regions that the article is talking about. I want to make an sheet for statistics. For each Author how many times his name is listed in specific column, also the same idea for the...

Looking for a faster performance...of Damon Ostrander's code. str1 is limited to 24 characters max since the algorithm takes a bit of time (it's exhaustive in it's comparison against ordered combinations). I need help with augmenting the code to reflect if a match is found that it does not...

Hi all-- I have multiple data sets, each which fit a power curve very well. Each dataset has 30 days worth of data If I graph the data and add a power trendline, I'm able to see an equation on the chart and get a sense for where the data will be at 100 days. How can I accomplish the same...

I am new to both statistical analysis and Microsoft Excel, which I am sure will become apparent from my question. I write for a basketball blog, and I have a question about what type of analysis or formula to use. My idea was to compile a database of statistics for a group of...