p*******y
发帖数: 133 | 1 【 以下文字转载自 Software 讨论区 】
发信人: pennyjudy (penny), 信区: Software
标 题: how to do weighted linear regression in Excel?
发信站: BBS 未名空间站 (Sat May 22 13:07:59 2010, 美东)
Hi
I am trying to create a excel sheet to do weighted linear regression. This
sheet is intended to be shared with other ppl as a template.
I used user defined function downloaded from http://www.adamslim.com/ModellingGuides/ModellingGuidesWLR.htm. However, when I copy the excel sheet to other drive or other computer, it always report |
|
C*********r
发帖数: 902 | 2 在计算interest capitalization前要先算weighted accumulated expenditures.通常
情况下，因为项目会在12月结束，所以会用120,000*10/12.不过这题项目3月开始，6月
结束，怎么算呀？谢谢各位高手。还有一题作为比较。
On March 1, Felt Co. began construction of a small building. Payments of $
120,000 were made monthly for three months beginning March 1. The building
was completed and ready for occupancy on June 1. In determining the amount
of interest cost to be capitalized, the weighted-average accumulated
expenditures are
a. $30,000.
b. $60,000.
c. $120,000.
d. |
|
i*****e
发帖数: 159 | 3 【 以下文字转载自 Mathematics 讨论区,原文如下 】
发信人: iamfine (iamfine), 信区: Mathematics
标 题: matlab算weighted least square
发信站: Unknown Space - 未名空间 (Sun Nov 21 17:54:07 2004) WWW-POST
有人知道怎么在matlab里面解weighted least square吗？就是
min sum（yi－f(xi,b))^2, f（.)是个非线性方程，b是最优解。我看了matlab里做least
square的function，都不能直接调用x和y的数据。不知道谁比较了解？
然后，如果同其他的软件，大家有什么建议吗？ |
|
D******n
发帖数: 2836 | 4 my target function is not a weighted sum using the weights. |
|
a*i
发帖数: 1652 | 5 what is the relationship between domain size vs molecular weight in block
copolymers? Does the domain size change much with proportional increase of
molecular weight? Thanks. |
|
d**s
发帖数: 920 | 6 Do you know any heavy weight person who predict the next big boom ?
Jim Rogers predicted Commodities boom in 1998. I wish I could get the
message earlier
Do you know any other prediction of next big boom (or bust) by heavy
weighted (credible ) people ? |
|
c****s
发帖数: 63 | 7 ccs 包括了一系列药品的名字，是array,也就是ccs[1-285]，里面包含了285种药的名
字。老板想知道每一种药的weighting。CCS is independent var. and mortality as
dependent var.
weighting 是这些药品也许会对死亡率会有更多地解释。
不知道有没有人知道用什么方法？或用SAS怎么做的呢？谢谢了！ |
|
D******n
发帖数: 2836 | 8 This is really a (my) subjective approach, but u can see why in an example
z=w1*x1+w2*x2;
when w1=1,w2=1
z x1 x2
13 10 3
22 20 2
31 30 1
ok, w1=1 and w2=1 is "supposed" to show x1 and x2 are equivalently improtant
, same "weighting factor"
however x1's variance is much larger than x2's , so u can see the result is
basically from the "opinions"
of x1. That said, x1 actually is more important in this desicion making
procedure. so the actual "weighting
factor" of x1,x2 should be no |
|
E**A
发帖数: 85 | 9 知道能做lasso，但现在想对weighted least square（比如用triangular kernel取
weight），做L1 regularization，请问用glmnet能实现吗？怎么编啊？不行的话，用
LARS能做吗？ |
|
d******g
发帖数: 130 | 10 关于使用glmnet实现adaptive lasso,对于有大量input variable,考虑multi-
collinearity,想问问大家是不是先run ridge regression,将ridge regression得到的beta绝对值求倒数，然后作为weight赋值给"glmnet"中的"weight" option。 去实现adaptive LASSO.
非常感谢各种input! |
|
d******g
发帖数: 130 | 11 关于使用glmnet实现adaptive lasso,对于有大量input variable,考虑multi-
collinearity,想问问大家是不是先run ridge regression,将ridge regression得到的beta绝对值求倒数，然后作为weight赋值给"glmnet"中的"weight" option。 去实现adaptive LASSO.
非常感谢各种input! |
|
o****o
发帖数: 8077 | 12 Isn't this the recommendation from Zou's original paper (2006 JASA)?
的beta绝对值求倒数，然后作为weight赋值给"glmnet"中的"weight" option。 去实现
adaptive LASSO. |
|
v*******e
发帖数: 506 | 13 这个weight是要你去计算么? data set里是不是应该有这个variable 阿？？即使是用
post stratification 这种方法计算weight也很难, 因为要考虑race, gender, age 至
少这3个因素. |
|
w*******9
发帖数: 1433 | 14 Just compare the weighted means with variance estimates also appropriately
adjusted. In R, use weights::wtd.t.test() |
|
g*******s
发帖数: 1157 | 15 【 以下文字转载自 Fitness 讨论区 】
发信人: galapagos (碧落星辰近), 信区: Fitness
标 题: 【卖】100 kg Olympic Weight Set + bench $100 in Maryland
发信站: BBS 未名空间站 (Wed Oct 5 09:53:54 2011, 美东)
版主留情
100 kg Olympic Weight Set
20kg 15kg 10kg 2.5kg 1kg 各一对
标准杆
+
bench
家里没地儿放了， 有人要么， 马里兰，
可以送上门。。。 |
|
s****h
发帖数: 3979 | 16 问个问题：一堆（1M）二维座标系的点，每个点有weight，怎么做clustering？
假如一个cluster是一个圆，要求找 不相交/或少许相交的一些圆（例如top100），这
些圆内weight值最大。
多谢。 |
|
s****h
发帖数: 3979 | 17 比如说，给你一个地图，刑事案件发生的地点和严重程度。
严重程度就是weight
或者说是商品销售的目的地，货物类型/数量/价格，这个数量/价格和运输费用就是
weight |
|
f****a
发帖数: 4708 | 18 50:50 wd 就是bmw自己炒作，基本就是用来恶心前驱车的。
其前置后驱被后置引擎后驱车秒杀。
911起步时，dynamic weight distribution front:rear 26:74，刹车时，42:58。
cayman 33:67 and 36:64
http://www.caranddriver.com/features/the-mid-vs-rear-engine-deb
Accurately knowing the CG location in both cars reveals that the rear (
driving) tires carry 74 percent of the 911’s weight during hard initial
acceleration versus only 67 percent of the Cayman’s. (More load equals
better launch traction.) During braking, when nearly equivalent tire loading
yields t... 阅读全帖 |
|
|
|
|
|
|
G*******s
发帖数: 10605 | 24 【 以下文字转载自 SmartShopper 俱乐部 】
发信人: GoRockets (火箭加油), 信区: SmartShopper
标 题: Sennheiser Light Weight Headset $48.90 Free Shipping
发信站: BBS 未名空间站 (Wed Sep 14 20:04:53 2011, 美东)
Amazon has Sennheiser PX 100-II i Light Weight Supra-Aural Headset with 3
Button Control for i-Pod,i-Phone and i-Pad (Black) On Sale (not sold by
Amazon, Sold by Triplenet Pricing) for $48.90 (original price $119.95). Free
Shipping.
http://userquote.com/forum/index.php?topic=768.msg1003#msg1003 |
|
w*******y
发帖数: 60932 | 25 Walmart B&M had Gold's Gym 2" Olympic Weight Plates on clearance yesterday.
YMMV
From memory.....
45#, $25
25#, $13
10#, $5
5#, $3They were all nearly 50% off as well as I can remember. Not sure if
this is a great deal or not because I am not familiar with current prices on
weight plates. My 1" plates were used and dirt cheap.
Individual plates aren't listed on Walmart's website, so this is in-store
only. For reference, here is a link to the same kind of plates that are on
clearance: Link:
h... 阅读全帖 |
|
|
t******g
发帖数: 462 | 27 A lot of options will be dead
http://www.businessweek.com/news/2012-04-09/vivus-weight-loss-d
Vivus Inc. (VVUS) (VVUS) said U.S. regulators delayed their decision date on
whether to approve the obesity pill Qnexa by three months to July 17.
The date was extended after Vivus submitted, at the Food and Drug
Administration’s request, a risk evaluation and mitigation strategy, the
company said today in a statement. The strategy is based on discussions with
the agency after advisers voted Feb. 22 in ... 阅读全帖 |
|
U*E
发帖数: 3620 | 28 【 以下文字转载自 Olympics 讨论区 】
发信人: pacific (hh), 信区: Olympics
标 题: why Bo Gu Kailai gains weight in the jail?
发信站: BBS 未名空间站 (Thu Aug 9 20:16:45 2012, 美东) |
|
p*****c
发帖数: 20445 | 29 【 以下文字转载自 Olympics 讨论区 】
发信人: pacific (hh), 信区: Olympics
标 题: why Bo Gu Kailai gains weight in the jail?
发信站: BBS 未名空间站 (Thu Aug 9 20:16:45 2012, 美东) |
|
s*****r
发帖数: 11545 | 30 Will human beings win? Maybe!
If not, sex frequency divided by weight must do. |
|
p*********r
发帖数: 7944 | 31 教我再读一遍高中，绝对拿不到un weighted 3.75。 |
|
w*********r
发帖数: 42116 | 32 高中有Weighted scales。最典型的是去上AP classes，难度高，GPA从5.0起。
Stanford
the |
|
t*******h
发帖数: 2744 | 33 Trump's latest: Former Miss Universe 'gained a massive amount of weight' |
|
t*******h
发帖数: 2744 | 34 When she brought up that person that became - I know that person. It was a
Miss Universe person. She was the worst we ever had," Trump said on "Fox &
Friends."
"Ultimately a winner. They had a tremendously difficult time with that Miss
Universe... She was a winner, and she gained a massive amount of weight, and
we had a real problem. We had a real problem with her." |
|
h*****g
发帖数: 1523 | 35 我的2.0 4-cylinder.
curb weight / horsepoer@6000rpm = 3240/140= 23.14.
一个简单的加速能力的测算，应该这个数字越小越好？ |
|
p****e
发帖数: 48 | 36 买了辆丰田corolla,MSRP是17600，但是DVS在办理plate的base value or gross weight空格处
却被填15600。请问这是不是说这个车货不对板？请大侠指教
感觉计算Registration tax是根据这个Base Value来计算的，而且DVS填的数据的从数据库中查到的。但是不明白这个数据来自何方？ |
|
d******g
发帖数: 6966 | 37 power to weight ratio的确是影响加速度最重要的部分,lz说的没什么大错
至于torque和hp的关系去看车迷版的那个帖子吧 |
|
b**********1
发帖数: 854 | 38 简单说hp决定最高速度，torque决定最大加速度，weight间接决定车的安全程度 |
|
z**j
发帖数: 87 | 39 声明几点：
1.这些车都是紧凑型SUV(compact SUV),从外观看都是差不多大的
2.所有数据（curb weight）来自今日（Oct 10, 2015）的官网，由原始数据的lbs转换
到KG
3.参与比较的车都是选的AWD（四轮驱动）
4.有的数据有区间，那是因为有多款车是AWD
Subaru Forrest: 1505-1656KG
Nissan Rogue: 1609-1612KG
Toyota RV4: 1610KG
Honda CRV: 1578-1630KG
BMW X3: 1830-1920KG
Audi Q5: 1855-1975KG
Volvo XC60: 1927-1940KG
大家看清了吗，以后谁再说日本车省油，我就把这数据甩他一脸，尼玛这么轻，不省油
就怪了。 |
|
k*********s
发帖数: 4474 | 40 Mazda省油，不全是curb weight. 从2014那代换了发动机, 提高压缩比，燃油效率高了 |
|
b*****g
发帖数: 2322 | 41 Make: Mercedes-Benz
Model: G63 AMG 4WD
Curb Weight: 5,625 lb/2,551 kg
Seating: 2 + 3
这个也是compact suv吧 |
|
c**0
发帖数: 9331 | 42 We calculated your charges based on a dimensional weight of 31.0 lbs.,22" x
21" x 13", divided by 194. |
|
HQ
发帖数: 19201 | 43 赫赫，我觉得阿
如果你老老实实写重量，不会让你占便宜，但是好像也不会吃亏
少写重量容易碰上这种事情。
Kinect
weight |
|
d*****e
发帖数: 3868 | 44 我上个月遇到过10磅的东西算成67磅，收我33刀，同样的东西类似距离是13刀；昨天打
电话，打到一半断了，过几天看看。
多个1－2磅也就算了，这个太离谱。
Kinect
weight |
|
d*****e
发帖数: 3868 | 45 actual weight 34lbs
fedex现在太贵了。ups现在价格如何？ |
|
b***n
发帖数: 13455 | 46 Rated Weight = L x W x H / 166 |
|
w****a
发帖数: 6326 | 47 premier应该是 75 磅 rated weight。 |
|
D****9
发帖数: 10889 | 48 correct weight of 3 xbox should be more than 35 lbs |
|
c**0
发帖数: 9331 | 49 Seems Amazon is doing major change, most printer change to Office, at the
same time they did not update the weight, so defult become 1lbs, who the
hell they are hiring to do such project, A intern? |
|
e*****k
发帖数: 282 | 50 想请教很多问题啊。
包括如何集成ebay amazon的顶到做bath打印，同时生成报表。
我现在使用USPS First Class Parcel，但是丢件太厉害了，几乎达到1%。
我知道DHL global Mail和UPS Mail Innovation都是针对light weight的。不知道有没
有人使用过这种服务来说说经验？ |
|
