Excel & Statistics 39: Variability Chart - Visual Approach (Dispersion or Spread)

Hello, I have a spreadsheet with calculations that work correctly but, I want to automate these calculations and be able to do so more then once. I have attached a sample of both data and calculations. As you can see the formulas are starting in cell ac2 or there abouts. I want to start this same routine in say row 30. With my original formulas using $b$2:b3 etc. ranges it will not copy paste and work correctly. Help please.

Is it possible to Create excel chart ( normal distribution curve) based on the output of Descriptive statistics

For example : Would it be possible to create normal distribution curve in excel using following Descriptive statistics output


Mean 118247.4547
Standard Error 210.3114405
Median 117081.5
Mode 91374
Standard Deviation 19711.01832
Sample Variance 388524243.3
Kurtosis 0.097330952
Skewness 0.450270462
Range 112097
Minimum 76095
Maximum 188192
Sum 1038685642
Count 8784
Largest(1) 188192
Smallest(1) 76095
Confidence Level(95.0%) 412.2596498


thanks ,

Hi, I am looking to draw the following graph in my attachment (please see attached PDF).

I tried converting them into histogram and then into a bell curve, but couldn't get it to work,
because I don't understand terms such as "bin range". Can someone enlighten me on whether I need to convert the data into a histogram first then into a separate bell curve? If so, could someone show me how I should do it? Many thanks

PS - I understand that the graph I am looking for should be a normal distribution (I'm guessing it's not a standard normal distribution graph as the graph I am looking for is not one with 0 in the middle). Please kindly advise me... Thank you very much!

Hi all,

I am comparing two sets of data (that should be similar) and so I use the XY dispersion graphic. Now I would like to aggregate a 45 degrees line to compare it with the tendency line. How can I do this?
Thanks!
Frank

I need to show in a diagram the capacity, velocity, model and motor of a product. Basically, I have 4 variables. Is it possible?

I have a macro that I wrote that is roughly 1000 lines of code and I have been using it for months now. In the end it gives the correct results. The question I have is why the run time varies so much. Sometimes it takes 1.5 minutes to run and other times it can take 1 hr.

The obvious answer would be that the more information it has to process the long it will take. However, I am always processing roughly 10k records. I have no other appliations running simotaniously and I have rebooted my computer just prior to running the code.

The purpose of this code is to look at hundreds of investment accounts and evaluate a Varity of metrics and write out the results.

I am sure you will want to see the code to make a recommendation but I am really only comfortable sending it via email for a variety of reasons.

Thank you for any help.

Basically, I have two lists and I want to do a lookup function to compare them and find the overlap between them (eventually I'll be making a ven diagram of the two lists). The entries in each of the lists have two basic components: the IPI part (column A and D) and the number part (column B and E). You can merge the two cells (ex. A1 and B1 to produce a merged C1) if that would make the searching easier. The difficult part is that the lookup doesn't need to be exact. I want the lookup function to allow for a margin of error of +/-15 with regards to the numbers in columns B and E. So for example, in list 1 you see IPI12583792 234 and in list 2 you see IPI12583792 232. Clearly these are not the same. However, I want them to be put in the overlap columns I and J, because firstly, the IPIs match, and secondly, 232 is within +/-15 of 234. So, columns A through E are what you start with, and columns G through L are what I want in the end. Note that there may be more than one match in the lists you're searching against. For example, IPI12583792 234, hits both the D3E3 entry AND the D4E4 entry. It's important that the D4E4 entry isn't overlooked even though it comes later in the list. Any help would be very much appreciated!

Basically, I have two lists and I want to do a lookup function to compare them and find the overlap between them (eventually I'll be making a ven diagram of the two lists). The entries in each of the lists have two basic components: the IPI part (column A and D) and the number part (column B and E). You can merge the two cells (ex. A1 and B1 to produce a merged C1) if that would make the searching easier. The difficult part is that the lookup doesn't need to be exact. I want the lookup function to allow for a margin of error of +/-15 with regards to the numbers in columns B and E. So for example, in list 1 you see IPI12583792 234 and in list 2 you see IPI12583792 232. Clearly these are not the same. However, I want them to be put in the overlap columns I and J, because firstly, the IPIs match, and secondly, 232 is within +/-15 of 234. So, columns A through E are what you start with, and columns G through L are what I want in the end. Note that there may be more than one match in the lists you're searching against. For example, IPI12583792 234, hits both the D3E3 entry AND the D4E4 entry. It's important that the D4E4 entry isn't overlooked even though it comes later in the list. Any help would be very much appreciated!

hello there,

I have this word with a bunch of graphs and tables linked to an excel file
changing the file and updating works fine, but if I change the source of the link the dispersion graphs (only) do not update at all. The most bizarre thing is that when I select "edit data" from the contextual menu it actually opens the correct file and chart!

anyone had the same problem??

any workarounds??

at first I thought the problem was that I had added text boxes and things on the graph and that caused the problem, but now I'm trying with unmodified charts and the problem persists...

help!

Hi, I'm using Excel in the version from Office 2003 and I'm trying to display two columns of data in a dispersion X-Y with a logarithmic scale on both the X and Y axes.

What I get is a correct logarithmic scale for the Y, but the values on the X are evenly spaced and the number is just applied on them as a "label".

Does anyone know the correct procedure in order to correctly display the values of the first column on the X and the values of the second column on the Y with proper logarithmic scales on both axes?

Thanks!