Plotting the standard normal PDF & CDF of a column of Data

[budder8818]

I have 20-40 columns of data in an access query. There are 8 queries, so that makes about 320 columns of data I want to plot in a standard normal function. Is it possible to generate the standard normal function and plot it with the average, std in a report/graph?

I am guessing that I will need to use VBA. Typically when i do this, I export the data to CSV and do the plots using python. However, I really want to encapsulate everything inside access if possible.

1. Loop over each column of data.
a) Calculate Mean, and Stand Dev. And sort the column of data x in accending order.
b) Calculate p(x) for each data point and store into temp array.
c) plot the temp array into a report graph along with the standard statsical measures like mean, meadian, standdev. ect..



Just wanted to put the question out there to see if anyone had done something like this. I am not really famliar witht he VBA lanaguage or how it interfaces with Access.

[ItsMe]

I am not a chart expert but...

Not quite sure what you are after but if you want to render a chart and display it via an Access user interface, there is a wizard that can create a chart based on data within tables. I believe Best Practices dictate that fancy charts are rendered in an Excel (xls or xlsx) file. You can use VBA to display the results in an OLE object.

Access is about data management so calculations are usually done on the fly and calculated results are not typically stored in tables.

[June7]

Access has functions for Mean (Avg) and Standard Deviation (StDev) and Variance (Var). These functions can be used in an aggregate query to summarize columns of data. The aggregate query can be the data source for graph element on form or report. Access does not have intrinsic function for Median.

What is p(x)?

Tables and queries have a limit of 255 fields.

Why do you have 8 queries? Why would they be joined in query?

[budder8818]

p(x) is the standard normal function.

Each query is represents a different time set of data from the master table.

[June7]

I guess you will need custom functions. Maybe this will help http://www.spreadsheetadvice.com/201..._distribution/

Or use the Excel alternative described by ItsMe.

Still not understanding why 8 queries. What are the time criteria? Possible this can be accomplished with a single query of the master table. Would need to know more about the data.