Excel Statistics 27: Dot Plot Chart w REPT & COUNTIF functions

Hi all

I has trying the formulas as =REPT("ra",COUNTIF(A1,{"*APL*","*O23*"}))

But it not Works.


experts,
please learnt me about it

Hi,
I have created a graph from pivot table (see example attached), I would like to get a legend beside it with statistics data such as mean std dev etc.
Can it be done in excel ?

Thanks

Hello all,

I need some help finding a solution creating an in cell bar chart. I have the following values:
1142 2120 636 1598 1196 142 123 120 85 570 138 1125 194 702

I want to create a relevant in cell chart using =REPT("g";(E5/MAX($E$5:$E$18))*20) my problem is that on many of the low values the results are below 1 and therfore blank.

When put all these values in a bar chart this problem does not appear. Does anybody know how Excels built in chart visualization formulas works? Or can I simply modify my rept formula so that it represents my data better?


Thanks for all input I can get!

BR
Per

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 All,

I've created a sheet in which I would like to calculate mean and standard
deviation for a user selected range.

I have a number of ranges of data (arranged in columns and of varying
length) which the user may select.

Once the user has selected a range, I'd like them to be able to click a
button to run a macro that will
display the mean and st.dev. (as a string maybe) in the cell immediately
below and to the right of the lowest
cell selected by the user.

Example, the user selects the range (C24:C31), runs the macro and ends up
with the mean and st.dev. in cell D32.

The output I'm after can be achieved using a formula like,
'="The mean is "&ROUND(AVERAGE(C24:C31),1)&" and the standard deviation is
"&ROUND(STDEV(C24:C31),1)'

Any thoughts ?

TIA,

Neil

The idea behind the design of this spreadsheet is that it logs how many darts you throw for each target, and how many are successful hits you get from those throws. I was also hoping it would add your percentage for each target and display them on a graphic representation of a dartboard.

An example of the input columns for one target would be:
Treble 20 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3
Treble 19 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3
Treble 18 - Throws - Hits - 3 - 2 - 1 - 1 - 2 - 3

the first 3 - 2 - 1 would be red buttons (which count as a miss) that adds to the amount of throws for the target, but does not add anything to the 'hit' column. The 1 - 2 - 3 buttons would be green, and add the relevant amount to the 'hit' column as well as the 'throws' column.

So lets say I aim at Treble 20, miss with 2 darts and hit with 1 dart, I would click the red button labelled '2' and click the green button labelled '1'. Pressing these buttons would update the columns for darts 'thrown' and 'hit' showing that I've thrown three darts and had one dart on target.

I've got the layout for the above, but I am new at this and don't know what code to add for the buttons. So if you guys could supply me with the code then that is the main purpose of this spreadsheet.

Now for the graphic representation of the board... Excel doesn't seem to have a lot of capabilities with combining data with graphics, but I was basically hoping that my above example which would give a percentage of '33.33%' would be added at the Treble 20 on a graphic of a dart board. Are there any ways of doing this?

Hi,

I currently have a pivot table that returns min(date) and max(date) for each by-group 'Name.' So it looks something like this:


Name Min of Date Max of Date
John 1/1/2000 9/1/2000
Mary 4/1/1999 3/1/2000
Chris 2/1/2000 6/1/2006

Now I would like to create a new field that returns the difference between these two dates for each name. However Min of Date and Max of Date do not show up under Field List when I go into Calculated Field. How could I do it and still stay within the pivot table (i.e. not create a formula outside it)?

Thank you in advance for your help.

Hi

I'v got a serie lilke:
jan, feb, march, april,....., december
10, 20, 30, 15, 8, 0, 0, 0, 0

I will draw a bar chart with only values > 0, not the zeroes.
x-axis is moths

Thanks[/code]

I recently had to determine how many cells in a workbook were "manually" input vs. how many cells were formulas with 100% cell references to try an assess the risk of input error.

Example Cells:

=1000+15 'although a formula, this would be a Manual Input.
=A1+2000 'formulas with cell ref and numbers would be a Manual Input
=A1+B1 'This is counted as non-input cell since it is 100% cell refs
=Round(A1,4) 'This is counted as non-input cell

Is there a way to determine input cells / total used cells = manual input %? I tried tinkering with SpecialCells(xlCellTypeFormulas), however, in my situation formula cells can contain values manually input vs. formulas that simply contain cells references so this doesn't seem to work.

Any ideas?

The following is a video that demonstrate to you:
How to plot a chart with Microsoft Excel.
http://raymondlamsk.blogspot.com/200...w-to-plot.html

Cheers.