curve

Hi guys, I am trying to calculate the area under the curve on my Power-Time graph so that I can determine the energy. Would anyone have an idea of how I can calculate the area under the curve? The solution would also have to ignore cells with #N/A. Would I also be able to choose a specific...

Hi I have a distribution question, I have this split over 10 qtrs, 100% total, which creates a bell curve <tbody> Quarter % Split Q1 4% Q2 10% Q3 11 Q4 12% Q5 13% Q6 13% Q7 12% Q8 11% Q9 10% Q10 4% </tbody> What I would like to do is evenly distribute the % for the 10...

I have numbers corresponding to years 2015(1.5), 2030(6), and 2050(10.5). I want to make a projection for the years in between in 5 year segments (2015,2020,2025,2030,2035,2040,2045,2050) that yields logistic growth, or a sigmoidal curve, when plotted on a line graph. Can anyone tell me the...

Please excuse me this is my first post and I am not familiar with the lay out or formatting here. I am wondering if there is an easy way to pick out 8 points along my curve or trendline that will best represent the curve. Here's what I have: <colgroup><col><col><col></colgroup><tbody>...

Hi everyone, I have got a set of data points (I don't have an equation unfortunately) from an experiment which I have plotted on a scatter graph. The x-axis has a log scale to the base of 2. I need to find the median for the data points plotted (the curve), therefore the intercept between the...

Hello, I am creating an application to model probability distributions, and I had an idea to allow the user to SKETCH probability distributions intuitively by clicking and dragging the mouse to trace the curve in an embedded chart object or chart window. I need to be able to get an array of XY...

HI, I am trying to create a formula or a way to evaluate two curves, say curve1 and curve 2. These two curves are on different scales. They tend to follow each other. However they "cross over" each other at certain intervals. Question: Is there a way(formula) to flag the "belly" going to...

Hi guys, just wondering why this VBA code posted in this link, seems it's not working.. Do you guys have any ideas how to make it work? I would like to draw smooth shape for my radar chart.. http://peltiertech.com/Excel/Charts/VBAdrawradar.html#SmoothTransShape Thanks a lot before...

I’ve encountered what to me seems to be a very strange problem. I have an Excel worksheet with the prices of the 16 stocks currently in my portfolio, charted on a daily basis – that’s 16 different charts (XY scatter) of day vs. price data. I’ve been updating this worksheet daily for several...

Howdy! I have created a bell curve graph based on the daily results of a machine performance. The line being plotted is OK but would be better if were a proper bell curve style. Anyone know a way to smooth it out? I have tried using the smooth line check box but it causes the line to...

I'm trying to help a friend that is a teacher and wants to make a spreadsheet that grades on a curve. I've seached and found the following - assuming Grades are in A10:A20, then (A10-AVERAGE(A$10:A$20))/STDEV(A$10:A$20) gives the standard deviation of a particular score. Also, I found...