中值问题（与以前不同） [英] Median Value Question (Different from previous ones)

问题描述

嗨ppl，


我在Access中编码非常新，我的任务现在涉及查找所有区域的中值，给出一个带有Area的表格， ;已售出单位和价格


示例：

" Area" 已售出单位 价格

加州2 $ 100,000

加州5 $ 120,000

加州3 $ 150,000

纽约7 $ 70,000

纽约5 $ 110,000

纽约2 $ 150,000


我正试图找到一种方法来返回以下查询

" Area" 中位数价格

加州$ 120,000

纽约$ 90,000（$ 70,000 + $ 110,000 / 2）


看了一些代码没有售出单位的单位田野，我的生活很复杂。任何帮助将不胜感激。


谢谢，

Ronald

Hi ppl,

I''m very new to coding in Access and my task now involves finding median values for all Areas, given a table with "Area", "Units Sold" and "Price"

Example:
"Area" "Units Sold" "Price"
California 2 $100,000
California 5 $120,000
California 3 $150,000
New York 7 $70,000
New York 5 $110,000
New York 2 $150,000

I''m trying to find a way to return the following query
"Area" "Median Price"
California $120,000
New York $90,000 (which is $70,000+$110,000 / 2)

Saw some codes which did not have the "Units Sold" field, and my life is complicated by it. Any help would be greatly appreciated.

Thanks,
Ronald

推荐答案

100,000

California 5

100,000
California 5

120,000

California 3

120,000
California 3

150,000

纽约7

150,000
New York 7

这篇关于中值问题（与以前不同）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！