![]() (Before I continue - if all you want to do is predict the Y value from an X value, you don't necessarily have to compute a closed-form mathematical formula following the instructions for "Part 2" of Avraham's answer above will get you what you want. If not, you'll have to do some empirical curve fitting if you want a formula for predicting Y from X. If your data samples were generated from a probability density function and you know what that function is, then you can find the formula for the cdf by computing its integral. What you are graphing is a cumulative distribution function ("cdf"). How do I achieve what I'm trying to do? Any tools that can help me here? Also, does the kind of graph I'm trying to make have an official name? I've tried fiddling with Excel, but I'm not really making much progress. I've never tried anything like this before and don't know where to start. How do I get the most accurate formula for calculating values? If possible, I want to derive an approximate formula for calculating Y for each value X based on the 50.000 data points provided. ![]() This should result in a graph starting at ~100% for the lowest value X, ending at 0% for the highest value X. Y for each value X should describe how many percentage of the data is higher than the X value. To be more specific, I want a graph with 0-100% on the y axis, and the data values along the x-axis in ascending order. I want to create a graph that describes how the data is distributed. I'm trying to do 2 things, but unfortunately I've come to realize my math skills are severely lacking.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |