Excel Statistics 69: #1 Normal Probability Excel Functions & Area Charts

To anyone that will listen...I need serious help with excel and graphing. I
am taking statistics, and our instructor wants us to graph normal probability
distributions. I seem to be typing in the wrong information, although I am
not sure how. My book isn't very clear on how to do it, and neither do the
excel tutorials. I need this explained in PLAIN ENGLISH, as I am not overly
familiar with "computer lingo". The problem is: standard deviation=4.7,
mean=21.7 x is numbers 1-10, y is (in order) 25, 19, 17, 15, 20, 24, 30, 19,
16, 23. Please tell me what to type and where to put it in. (I have gotten
as far as going to fx, then "statistical", then NORMDIST. WHAT THEN???
Thank you!

I saw this page which is full of all sorts of wonderful charting ideas. Chart #8 (the panel chart) is something I really want to create in Excel, but seeing the info on peltiertech and Andy Pope's page, it doesn't look like it's anywhere to be found. Has anyone seen a step-by-step tutorial on how to build a chart like that, or am I going to have to figure it out myself?

I am trying to find the normal probability density function on excel. I have found the formula:
BETADIST(x,alpha,beta,A,B)

x is the function that i am trying to find the formula of, and a and b are optional upper and lower bounds which i will not be using.

i do not understand what alpha and beta mean though, if anybody could shed any light on how to use this formula it would be greatly appreciated

Chris

I have a workbook with six worksheets in 3 pairs. Each pair contains a
'detailed data' worksheet and a 'summary' worksheet. The summary
worksheet summarizes data from the detailed data. The summary
worksheet also has a chart based on the data summary.

The problem is that the Excel charts do not display unless I click on
the shaded area where the charts should appear. Once the chart is
visible, if I click outside the area, the chart disappears and is
replaced by a shaded area.

I started experiencing this problem when I shared the workbook with my
colleagues. Now I do not share it any longer, but continue to have
this issue.

The whole workbook is less than 2 MB. I am using Excel 2000, Windows
XP.

I would appreciate any advice.

Thank you folks!.

I have created a waterfall chart and would like to show a data-table with the chart. the normal Excel option to show a data-table is not good enough because it shows all the data the chart (and in a waterfall chart you have a few hidden series etc - and I want to show additional data in the data-table that is not in the chart).

my work-around is to put the chart as an object in a sheet and to constuct my own data-table underneath the chart using normal Excel cells. with a bit of work you can align the cells underneath perfectly with the columns above in the chart.

However, if the scale of the data in the chart changes the Plot Area shifts and spoils the alignment (the Y-axis values change and take up more or less space).

The only ways I have found to fix the Plot Area is:
- Insert a data-table into the chart (and then format it to have no lines and white text - it "disappears", but still takes up space and doesn't look very good).
- change the Y-axis scaling to not be "auto" - this is no good because the data could vary a lot.

neither of the above is really a workable solution.

Any ideas?

on a similar topic (which also might help solve the issue above):

Are there ways of fixing other objects to points in the Plot Area (or chart area)? an example of this would be to insert a text box into a chart that exactly fit across the width of the Plot Area - and didn't lose its position if the Plot Area moved because of a scale change

Any ideas would be much appreciated

Steve

Hi, I have a couple of stacked area charts in excel 2010 with over 400 entries on the horizontal axis, this itself is not causing a problem. However, my boss wants me to put some data labels into the chart, if I switch on the data labels they all overwrite each other and are totally illegible.
I would like to get the chart to display every tenth (for example) value as a data label. How do I go about this?
Thanks, Peter

Hi,
I was hoping someone could help me with this particular statistics+excel problem that I cannot solve, or, at least need some confirmation that I am solving it correctly...

MY DILEMMA: Let's say I am asking people to choose their favorite letter(s) ranging from a-vvv (1-100). I ask 9 people to choose their favorites, but they can't choose more than 100 #'s (obviously since a-vvv represents 100 letters). Once I gather the information, the only way I know how to create the proper order is to AVERAGE the data by inputting zero into the fields/letters that were not chosen (since no one chose all 100 letters). My question is... HOW DO I PROPERLY ORDER THE "LETTERS" FROM MOST TO LEAST POPULAR BASED ON THE SUBMISSIONS??? I realize this is a statistics problem, but I'm hoping something efficient can be done in excel.

I've also attached the working excel file to use as a working document. Feel free to PM if you would like to attach an excel file.

Thanks in advance everyone!

-Ryan

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

Can someone provide plain english instructions on how to do this. I have a range of 49 - 74 with a MEAN 65.244, STDEV: 2.985, ZMIN -1.34, ZMAX 1.34. I can get a curve with using the occurrances in the range, but need to be able to create a proper Normal Distribution with shaded area.
49-50 1
50-51 0
51-52 1
52-53 1
53-54 0
54-55 1
55-56 3
56-57 4
57-58 13
58-59 9
59-60 18
60-61 35
61-62 34
62-63 68
63-64 75
64-65 115
65-66 140
66-67 150
67-68 116
68-69 76
69-70 41
70-71 18
71-72 2
72-73 2
73-74 1
74-75 2

When I prepare a file with macro's (to be used by other people), I save this file as a template with macro's with the extension *.xltm (template with macro).
Therefore no one can overwrite my file.

These other people can open this template (e.g. double-click, but not file-open).

But ............. when these people save this file, Excel automatically saves it as a normal Excel-file with the extension *.xlsx.
Ok, a message is seen after pressing <enter> or clicking Save, but does normal users know, what they have to do then?

If I'm making a template with macro's, I want Excel to have this file saved as a file with macro's.
Whatever did I make a file with macro's for?

Is this a bug or is it done on purpose?

Thnx in advance for any reaction.