【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: SQL multiply all values of a column in table
发信站: BBS 未名空间站 (Wed Jun 25 17:35:13 2014, 美东)
I need to multiply all float values of a column in table if the column value
is positive. If I find a value is null or negative or not numeric, I raise
an error in SQL server 2008 R2.
given table t0:
col
1.5
2
given table t1:
col
2
-1
5
0
null
NaN
For t0 I should get 3, for t1, I should raise an error.
... 阅读全帖
Assessed value might be determined long time ago. Tax is based on assessed
value, not market value. Sometimes the town will do reassessment and adjust
the assessment value then. To you, all you need to care is the tax amount,
assessment amount is not very important.
★ Sent from iPhone App: iReader Mitbbs Lite 7.39
i would rather think it happens more in a recovering market. when a market
is declining, you are more likely to see the opposite way tax value > market
value. tax assessment is a trailing indicator, isn't it? i know a state
assesses every 3 year. i bought a house for a little over $100k but the tax
value was $350k when it was assessed in 2008. And its tax value dropped to $
170k based upon the new assessment.
有些公司章程里规定stock with no par value，所以股份的对价就是股东愿意出什么
价格就是什么价格。在会计上，这些股份发行所得全部记为capital，也就没有capital
surplus。
至于为什么有公司愿意把stock规定为no par value，主要原因是这样无论公司股票价
值几何，公司对股东都没有负债。不过我认为这不过是文字游戏，公司股票的价值还是
市场说了算。
现在的标准做法就是规定股票par value为0.01或0.001，这样基本上股票价值也不会低
于par value。
Jan 1, 2012 的assessed value 是用来计算2012－2013年度的property tax的。你去
年11月交的是根据1/1/2011 assessed value 得出来的。
程序是 assessment -> determination of property tax per tax rate -> mailing
out property tax bills.
You can appeal before Sep(?) if you don't agree the assessed value.
market value higher, nothing need to do, property tax determined by assessed
value (ur case)
market value lower, use prop 8 to reassess to bring down property tax
for low stake poker player,
so many times when we are holding a hand with a show-down value, we cannot
help checking (at river). is it always legitimate to check?
and it becomes one of strongest "Law" in our thinking process when we trying
to range opponent's hand. it is called "Polarization".
"Vivian either has air or monster if he bet or raise on this spot.."
and most of time, this seems to be correct.
but how can we do better to avoid being predicted this way?
of course we can not check, when... 阅读全帖
I put him on top pair. The 3 on the river didn't make my value bet that thin
. My hand beat a lot of range of his hand. The only possible hands that
could beat me were overpair, straight, trip 3, or full house. From the line
he took, overpair, straight and trip 3 were very unlikely.Plus, if he had
full house, he was going to bet anyway after I checked, and I had to call
him no matter what.So I wouldn't have saved any money by checking the river.
Since the possibility of him having full house was... 阅读全帖
I put him on top pair. The 3 on the river didn't make my value bet that thin
. My hand beat a lot of range of his hand. The only possible hands that
could beat me were overpair, straight, trip 3, or full house. From the line
he took, overpair, straight and trip 3 were very unlikely.Plus, if he had
full house, he was going to bet anyway after I checked, and I had to call
him no matter what.So I wouldn't have saved any money by checking the river.
Since the possibility of him having full house was... 阅读全帖
【 以下文字转载自 Mathematics 讨论区,原文如下 】
发信人: beautumn (星星草), 信区: Mathematics
标 题: Help for the min value. Thanks
发信站: Unknown Space - 未名空间 (Mon Oct 25 12:53:28 2004) WWW-POST
Please help me.....
SUM of a_i is N; where i is changed from 1 to m
SUM of b_i is N; where i is changed from 1 to m
So, what is the max/min value of (SUM of a_i*b_i),where i is changed from 1 to
m.
The max value is N^2 where a_i0=b_i0=N and a_i1=b_i1=0 for all i1<>i0, right?
How do I know the min value? I think it should be like
【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: SQL multiply all values of a column in table
发信站: BBS 未名空间站 (Wed Jun 25 17:35:13 2014, 美东)
I need to multiply all float values of a column in table if the column value
is positive. If I find a value is null or negative or not numeric, I raise
an error in SQL server 2008 R2.
given table t0:
col
1.5
2
given table t1:
col
2
-1
5
0
null
NaN
For t0 I should get 3, for t1, I should raise an error.
... 阅读全帖
O(N) (best case O(1)) if the input values are integers and the range is
finite (and relatively small compared to the array size.)
Suppose the values in the input array are bounded, i.e. input x[k], where
MIN <= x[k] <= MAX. N is the size of input (1 <= k <= N).
Allocate an array of size (MAX - MIN + 1), that is, one element for each
possible integer value between [MIN, MAX]. Each element can contain either a
special value "UNASSIGNED", or an unsigned integer which is an index (k)
from the input ... 阅读全帖
【 以下文字转载自 EE 讨论区 】
发信人: zhuzhufox (I+love+you+), 信区: EE
标 题: Extreme value
发信站: BBS 未名空间站 (Wed Aug 8 13:50:53 2007)
I have an extreme value problem which confused me a lot....
suppose delta=p-q, where p & q are positive and a function of x, and delta
has an maximum value at xc, that is, d(delta)/dx=0 at xc.
Now can I prove that (c-p)/q also has an extreme value at xc??? If yes, how
to prove it???
Thanks a lot advanced!!
Hi,
Assume 10 year bond paid annually price 950. Semi-annual coupon is 60
Know 0.5, 1 year yield rate,
What's the value of 1 year forward contract $970.
1) Present Value of $970 using 1 year rate.
2) PResent value of the remaining cash flow 950- 60*(discount(0.5)+discount(
1))
then 1 - 2 is the forward contract value.
Is this correct?
【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL find distinct values in large table
发信站: BBS 未名空间站 (Wed May 21 17:20:16 2014, 美东)
I have a very large table with 1 billion rows and 12 columns, which are int,
double, varchar. I need to know the distinct values for each volume.
the table has columns :
id id_1 id_2 id_3 id_4 id_5 id_6 id_7 id_8 id_9 id_10 id_11
SELECT COUNT(distinct a.id) as num_dist_id
FROM my_large_table as a
SELECT distinct a.id
FR... 阅读全帖
So I wonder it is a bug of my SAS. It did count null value as well. I set
the value to '00'X. Maybe it is not a good way to assign null value?
Actually I run following code first
count(distinct case when A in ('01',,'02') then B else null end) as ...
However SAS took null as a variable instead value. So I used following code
instead
count(distinct case when A in ('01',,'02') then B else '00'x end)
The code works on oralce database but not on SAS. :(
I am not sure I follow this " convert 2 sided test to 1sided test" here.
Pr(Y>test_statistics) is one sided p-value only, right?
if we want a two-sided p-value, we should have a 2*Pr(Y>test_statistics)
under a symmetric distribution.
So I am very confused with the example. Either they report 0.0093 as p-value
for one sided test Ha: var1>0. or 2*0.0093=0.018 as a two sided p-value for
Ha: var1 ne 0. Why divide 0.0093 by 2 here? Plus I do not think it is necessary to do a two tailed test for varia
有一组数据，非随机地分成 5000 个 Group，然后对每个 Group 的数据进行计算，得到
相应的 p value， p1, ..., p5000.
现在我想对报道其中 p value 最小的一个 Group.请问我需要对 p value 进行怎样的调
整？例如， p value 乘以 5000？
谢谢！
lol, this is common practice in bank/credit bureau. as LS mentioned, the ne
w assigned value would not change the modeling, but it might give some convi
nient values for estimate the effect of the missing value.
The logic behind this is, i think, is that the missing values in trade histo
ry is not that random, they mean sth and can be grouped into one special cat
egory for modeling.
Hi,
I need to solve a problem about predicting values of some numerical vectors
by using other numerical vectors with all these vectors in the same vector
set, which is generated by one or more black box functions.
Given a vector space:
P =[S_1, S_2, …, S_T | Sk is a vector of q numbers, k = 1, ..., T]
Find a sub-group of vectors g = {S_d | d belongs to 1, …, T } and a
function h( S_d )
Such that
Difference between the value of h(S_g) and S_r is minimized
set g + set r = set P
... 阅读全帖
【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: SQL find distinct values in large table
发信站: BBS 未名空间站 (Wed May 21 17:20:16 2014, 美东)
I have a very large table with 1 billion rows and 12 columns, which are int,
double, varchar. I need to know the distinct values for each volume.
the table has columns :
id id_1 id_2 id_3 id_4 id_5 id_6 id_7 id_8 id_9 id_10 id_11
SELECT COUNT(distinct a.id) as num_dist_id
FROM my_large_table as a
SELECT distinct a.id
FR... 阅读全帖
Amazon Lightning Deal: http://www.amazon.com/Kidde-Carbon-Monoxide-KN-COB-B-Smoke/dp/B000IHWL20/ref=sr_1_1?s=hi&ie=UTF8&qid=1291999828&sr=1-1
Deal starts at ~11:10AM PST
not live yet (will update with price ASAP)
I don't know what price it'll be but it's currently $24.54 from Amazon (not
the deal)
I suspect it'll be less than $20 when the deal goes live.
With winter already here, it might be a good idea to install a CO sensor,
especially if your place of residence has any gas appliances or a gas... 阅读全帖
http://www.groupon.com/deals/sears-portrait-studios-lubbock?utm_...
A photo session with an unlimited number of subjects (a $14.99 value)
One digitally enhanced 10''x13'' wall portrait of your favorite pose (a $29.
98 value)
One digitally enhanced 16x20 wall portrait of the same or different pose ($
69.98 value)
Bring this Groupon to any Sears location that lovingly houses a Portrait
Studio to receive this bounteous package of beauteous snapshots that can
feature contemporary poses, striking lig... 阅读全帖
Link for Coupon:
Link: http://www.onsale.com/
Link for Pet Online Store:
www.petcarerx.com: http://www.petcarerx.com
FINE PRINT
$20 Coupon to PetCareRx.com, including: $1.99 paid value plus $18.01
promotional value
Coupon Paid Value Expires: Never
Promotional Value Expires: February 5, 2012
Limit 1 coupon per customer
Limit 1 coupon per household
Redemption Instructions:
- This coupon will serve as your receipt; the coupon code printed on this
form is directly redeemable o... 阅读全帖
Drugstore.com has a 25% off sale in their Vitamin Dept. - wendykroy307
They also have a sale with Free Shipping on all Culturelle Products
In addition you can get a free copy of this DVD Microwarriors: The Power of
Probiotics: http://www.amazon.com/Microwarriors-Probiotics-Health-Care-Prof
- that has a current trade in value of $9.75 on Amazon. (at time of
posting - Note this will probably change - don't wait - lock in your trade
in value)
Click through this link first - 25% off Vitamins:
htt... 阅读全帖
MORRISVILLE, N.C. – U.S. pressure on China to revalue higher its currency
– the yuan – is picking up allies from among executives in China.
The Chinese government has bitterly opposed efforts to let the value of the
yuan rise in value against the dollar.
However, in a series of recent interviews with Bloomberg news, a number of
Chinese executives have support appreciation in the yuan’s value.
Among them is Yang Yuanqing, chief executive officer at Lenovo, the world’s
No. 4 PC maker which bases m
http://www.politico.com/story/2017/01/obama-supports-protests-american-values-are-at-stake-234375
Barack Obama spoke out Monday afternoon against his successor — and in
support of the protests opposing President Donald Trump — with a spokesman
saying the former president thinks they’re “citizens exercising their
Constitutional right to assemble, organize and have their voices heard by
their elected officials is exactly what we expect to see when American
values are at stake.”
Obama, who left off... 阅读全帖
