Access中的百分位数计算 [英] Percentile calculation in Access

问题描述

嘿聪明的人，Excel有= PERCENTILE功能。这会从一组值中计算百分位数值。 Access中是否有任何等价物？

Hey clever people, Excel has the =PERCENTILE function. This calulates a percentile value from an array of values. Is there any equivalent in Access?

推荐答案

Access中没有等效物，但如果有机会我会看看是否可以创建Access版本您，或使用自动化代码使用实际的Excel函数获取Access数据的Percentile。

There is no equivalent in Access, but if I get a chance I''ll see if I can create an Access Version for you, or use Automation Code to obtain a Percentile for Access data using the actual Excel Function.

再次返回，决定让Excel完成所有工作：

Back again, decided to let Excel do all the work:

展开 | 选择 | Wrap | 行号

哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇哇2007年仅作为帮助我整合统计数据的工具。


1.我假设您列出的代码是VB，必须包含在字段I的Data控件的函数中需要计算？


2.我的数组源是由我的客户端系统生成的CSV文件，可以包含20到2000条记录之间的任何内容，每条记录包含8个字段，其中我只需要其中一个领域的第85百分位数。因此，你的步骤10。 ''为数组分配值'实际上已经通过将此文件导入我的Access数据库并运行查询和报告来完成，最终得到原始数据的统一fiew，因此不是手动过程。我假设这个步骤将被替换为引用我的表并将该表（或者可能只是我需要Percentile计算的相关字段）导出到Excel？


感谢您参加是时候回复我的请求了： - ）

Whoa ADezii, you are way above my skill level here *sheepish* I am not a programmer in any shape or form and use Access 2007 only as a tool to help me consolidate statistics.

1. I assume the code you list is VB that has to be included in a function of the Data control of the field I require the calculation on?

2. My array source is a CSV file generated by a system of my client and can consist of anything between 20 and 2000 records, each record containing 8 fields, of which I need the 85th Percentile of only 1 of those fields. Therefore your step "10. ''Assign values to the Array" is actually already done by importing this file into my Access DB and running queries and reports to end up with a consolidated fiew of the original data and is therefore not a manual process. I assume this step will be replaced by referring to my table and exporting that table (or maybe just the relevant field I need the Percentile calculation on) to Excel?

Thank you for taking the time to reply to my request :-)

这篇关于Access中的百分位数计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！