mathematics

  1. F

    Confidence Interval Trendline

    Hi All. New to the forum, so please be gentle. I have a bubble chart that I have a weighted trendline on. I'm not happy with how the line of best fit gives a misleading representation of the predictability of the data, hence I would like to replace this single line with a band of possible...
  2. P

    How can I justify my eagerness to learn mathematics to office people?

    Hi, Our office has a budget for trainings. But on one condition: It should improve/helpful/ or atleast useful to the current works we do on our team (VBA Development using Access/Excel). I know without the word 'Mathematics' there is no such word called 'Engineering' (all sort of). The problem...
  3. I

    Time Conversion/Fractions of a Second

    Hi guys and gals I got a possible tough question for ya. I'm doing calculations with lap time and race cars and need the fractions of a second. I got my time to work out with a m.ss.000 format. (need the fractions of a second) But I'm doing calculations in formulas that require ^2 and things...
  4. R

    Autofill Mathematics Algorithm??

    Hi all I am trying to find out whether it is capable in MS Excel to write an algorithm or some sort of VBA code whereby excel will fill in the "blanks" of a formula to give pre-determined results. Let me try to explain myself more clearly. Say for example I had 2 equations. Equation #1: (a +...
  5. A

    Mathematical problem-ROUND function doesn't help

    I have an annual sales target of no. of units to be sold which is to be divided quarterly. My historical sales data gives me the ratios in which the annual target is to be divided into quarters, the ratios are 0.17, 0.23, 0.3 and 0.3 respectively for Q1,Q2,Q3 and Q4. When I divide the target...
  6. S

    Complicated(?) Cross Sum function

    Hi All, Does anyone know a formula for the following problem (I have up to 120 iterations to do and the thought of typing them all out makes me want to quit) I have a response curve and a number of volumes and want to sum up the value of the responses e.g.: <TABLE style="WIDTH: 333pt...
  7. O

    Need HELP........

    I am working on a project that involves trackable keypunching for a designated time frame. I need a formula that will give me the average time spent on a certain task. Here's what I have: 1. Number of "batches" completed 2. Number of pages within a single batch 3. Time spent on each batch...
  8. L

    Excel trivia or math challenge?

    In Excel 2007 there are XFD # of columns. My 7th grade computer apps class and I are trying to figure out how many that is? We think if it was ZZZ it would be 27 to the 3rd power, is that even right. Or would AZZ be 27 to the 3rd power? If you know and wouldn't mind explaining the math to us...
  9. P

    Help with formula to extrapolate population characteristics to different demographic set

    Here is my basic flow: State Population State Electorate County Population County Electorate M 45% 42% 40% ? F 55% 58% 60% ? Here is the question I am trying to...
  10. J

    Complex Erlang maths and formulae.

    Hi there, I am doing mathematics that is just extending me a bit too far. I have an excel spreadsheet that is trying to calculate the hold times for a helpdesk. This is the spreadsheet to download http://www.jaybest.com/tempo/Tempo_RosterTool-BetaV1.02(Exposed).xlsx This is the formulae that...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top