probability plotting

B

BOZO

New Member
Joined
May 2, 2002
Messages
1
In Excel, how do you plot exceedance frequency data on a graph with x-axis in percent (log-normal distribution)and y axis having sample values? Buy a stand alone program? Buy an add-in? Or can standard Excel do this?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
Make sure you have installed the Analysis Tool Pack.
After, check out histograms, charts, trends, ect...
I'm not much for math beyond 2+2=5 so that is the best I can do for you.
I would be surprised if you could not accomplish what you need with Excel.
Tom
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Neep help setting up table for plot graph
Replies
0
Views
89
supermom28115
S
P
  • Question
Excel Line graph - Y axis issues - seems to be summing the data
Replies
2
Views
159
panesai1
P
O
  • Question
Creating a Graph/Chart needing TWO secondary axis options for a combination of Clustered and Stacked Graph Columns
Replies
0
Views
315
OrangeJuice
O
S
  • Question
Trendline values using Dynamic Range in Excel - comparing with LINEST function
Replies
1
Views
195
Domenic
D
M
  • Question
Percentile of x if y is between A and B
Replies
0
Views
226
mnemosign
M

Forum statistics

Threads
1,214,812
Messages
6,121,693
Members
449,048
Latest member
81jamesacct

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top