analysis of data

Hi I am currently working for an important client with a large number of staff. I am trying to conduct a training needs analysis and need a formula to complete the following rapidly rather than trying to do this manually which would take many hours. I'm sure its pretty strait forward but I...

Hi all. This is my first post in this forum so hope this is ok to post. I have analysed and collected data on the number of kicks per game & kicking distance for 12 International rugby union matches over the last few weeks. I have concluded that kicks per game was a winning predictor in 8/12...

I would like to use excel to predict missing values in a table based on a best fit curve. I suspect non-linear regression analysis is a good way to do this but i am not a statistician and welcome solutions. I have a table of more than 300000 rows but I am posting a small excel sheet with 25 rows...

I have a table with loads of columns. they all have a unique ID (A). In one column (K) it says a date that something was meant to be completed, in the next column (L) it says when it was actually completed. I am trying to do an analysis and show how many of the Projects (A) where delivered on time.

Good morning/afternoon/evening, I work for an Insurance company and i'm running into the following problem: I'm trying to standardise 'free-text clauses' in our insurance system, clauses for insurance products which, for one reason or another, were not entered using a standard clause...

I am thinking about applying a what-if analysis to find out the one time cost for a LED bulb but I am not sure if the what-if analysis should have a two variable (separate fixed and variable cost) or a one (only variable cost) and how I formulate such a what-if condition. I am enclosing a...

Hi, I am in dire need to analyze some sales figures for a lot of different products to identify which ones have similar sales pattern over the course of a 12 month period. No regards to volume, only sales pattern over 12 months is interesting. I need the products with similar patterns to be...

Good morning, I created the following code to make calculations and then copy the results in the "Cash Flow" sheet. It takes 15 seconds but I'm sure that the code can be optimized. In step 1) formulas are applied to a range of cells in "PTF" sheet; step 2) change the date and the formula are...

Hi All, How to integrate contents of rows as headers in values field of pivot table. Please find the attached to understand the question better. Thanks in Advance Divakar file:///C:/Users/divakar_k/Desktop/Mrexcel.JPG C:\Users\divakar_k\Desktop\Mrexcel.JPG