• 文献检索
  • 文档翻译
  • 深度研究
  • 学术资讯
  • Suppr Zotero 插件Zotero 插件
  • 邀请有礼
  • 套餐&价格
  • 历史记录
应用&插件
Suppr Zotero 插件Zotero 插件浏览器插件Mac 客户端Windows 客户端微信小程序
定价
高级版会员购买积分包购买API积分包
服务
文献检索文档翻译深度研究API 文档MCP 服务
关于我们
关于 Suppr公司介绍联系我们用户协议隐私条款
关注我们

Suppr 超能文献

核心技术专利:CN118964589B侵权必究
粤ICP备2023148730 号-1Suppr @ 2026

文献检索

告别复杂PubMed语法,用中文像聊天一样搜索,搜遍4000万医学文献。AI智能推荐,让科研检索更轻松。

立即免费搜索

文件翻译

保留排版,准确专业,支持PDF/Word/PPT等文件格式,支持 12+语言互译。

免费翻译文档

深度研究

AI帮你快速写综述,25分钟生成高质量综述,智能提取关键信息,辅助科研写作。

立即免费体验

在 Microsoft Excel 中对 Quigley 混合房价模型进行校准和评估。

Calibration and evaluation of Quigley's hybrid housing price model in Microsoft Excel.

机构信息

Department of Sociology, Anthropology and Criminology, University of Windsor, Windsor, Ontario, Canada.

Department of Economics, University of Windsor, Windsor, Ontario, Canada.

出版信息

PLoS One. 2019 Apr 25;14(4):e0215954. doi: 10.1371/journal.pone.0215954. eCollection 2019.

DOI:10.1371/journal.pone.0215954
PMID:31022248
原文链接:https://pmc.ncbi.nlm.nih.gov/articles/PMC6483207/
Abstract

Quigley derived his hybrid price model to improve the precision of predicted prices of sold homes by statistically merging data of resold homes in a repeat sales model with that of once-sold homes in a single sales hedonic price model. The literature has few applications of the hybrid model aside from those by Quigley and his collaborators. Two reasons for this underuse may be its computational intensiveness and its marginal empirical improvement in comparison with two other models. This paper first demystifies this computational intensiveness by calibrating models in Microsoft Excel with transferable procedures into other software. It second evaluates the hybrid price model's empirical improvement as a reason for its underuse by predicting prices of 2,559 sold and resold homes observed in two inner-city neighbourhoods in Windsor, Ontario, during a 30-year period. The results as hypothesized are its lower standard errors of regression coefficients and higher simple R-squared than those of a single sales hedonic price model. Moreover, the hybrid model's predictions have higher correlations than those of the single sales model with not only in-sample observed prices or changes in prices but also out-of-sample ones. The conclusion speculates in plans for future research about reasons for two models' similar or dissimilar regression coefficients and standard errors predicting correspondingly similar or dissimilar sale prices of homes through time.

摘要

奎格利的混合价格模型旨在通过将重复销售模型中的转售房屋数据与单一销售特征价格模型中的一次性销售房屋数据进行统计合并,从而提高已售房屋预测价格的准确性。除了奎格利及其合作者之外,该混合模型在文献中很少有应用。这种低使用率可能有两个原因:其计算强度高,与另外两个模型相比,其经验改进幅度较小。本文首先通过将可转移程序的模型在 Microsoft Excel 中进行校准,来消除这种计算强度的神秘感,然后将其转移到其他软件中。其次,通过预测安大略省温莎市两个内城区在 30 年期间观察到的 2559 套已售和转售房屋的价格,评估混合价格模型作为其低使用率的一个原因的经验改进。根据假设,结果是回归系数的标准误差较低,简单 R 平方值较高,优于单一销售特征价格模型。此外,与单一销售模型相比,混合模型的预测与样本内观察到的价格或价格变化以及样本外价格具有更高的相关性。结论推测了未来研究的计划,研究两个模型的回归系数和标准误差预测相似或不同的原因,以及相应地预测房屋销售价格随时间的相似或不同的原因。

https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/da4ee139d7dd/pone.0215954.g007.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/6bc463c327d0/pone.0215954.g001.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/cbe87931670f/pone.0215954.g002.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/445ff22c58ea/pone.0215954.g003.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/8e7794a0e8b5/pone.0215954.g004.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/f46052e3063a/pone.0215954.g005.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/264b80886187/pone.0215954.g006.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/da4ee139d7dd/pone.0215954.g007.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/6bc463c327d0/pone.0215954.g001.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/cbe87931670f/pone.0215954.g002.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/445ff22c58ea/pone.0215954.g003.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/8e7794a0e8b5/pone.0215954.g004.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/f46052e3063a/pone.0215954.g005.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/264b80886187/pone.0215954.g006.jpg
https://cdn.ncbi.nlm.nih.gov/pmc/blobs/86a5/6483207/da4ee139d7dd/pone.0215954.g007.jpg

相似文献

1
Calibration and evaluation of Quigley's hybrid housing price model in Microsoft Excel.在 Microsoft Excel 中对 Quigley 混合房价模型进行校准和评估。
PLoS One. 2019 Apr 25;14(4):e0215954. doi: 10.1371/journal.pone.0215954. eCollection 2019.
2
Evaluating the effects of supervised consumption sites on housing prices in Montreal, Canada using interrupted time series and hedonic price models.使用中断时间序列和享乐价格模型评估加拿大蒙特利尔监督消费场所对房价的影响。
Drug Alcohol Depend Rep. 2024 May 19;11:100242. doi: 10.1016/j.dadr.2024.100242. eCollection 2024 Jun.
3
Calibrating models in economic evaluation: a comparison of alternative measures of goodness of fit, parameter search strategies and convergence criteria.校准经济评估模型:拟合优度、参数搜索策略和收敛标准的替代度量方法比较。
Pharmacoeconomics. 2011 Jan;29(1):51-62. doi: 10.2165/11584610-000000000-00000.
4
The impact of a federal cigarette minimum pack price policy on cigarette use in the USA.联邦香烟最低包装价格政策对美国香烟使用的影响。
Tob Control. 2018 Mar;27(2):203-208. doi: 10.1136/tobaccocontrol-2016-053457. Epub 2017 Mar 4.
5
Do street-level scene perceptions affect housing prices in Chinese megacities? An analysis using open access datasets and deep learning.街头场景感知会影响中国特大城市的房价吗?利用开放获取数据集和深度学习进行的分析。
PLoS One. 2019 May 30;14(5):e0217505. doi: 10.1371/journal.pone.0217505. eCollection 2019.
6
Changes in prices, sales, consumer spending, and beverage consumption one year after a tax on sugar-sweetened beverages in Berkeley, California, US: A before-and-after study.美国加利福尼亚州伯克利市对含糖饮料征税一年后价格、销量、消费者支出及饮料消费的变化:一项前后对照研究
PLoS Med. 2017 Apr 18;14(4):e1002283. doi: 10.1371/journal.pmed.1002283. eCollection 2017 Apr.
7
How do housing prices affect consumption in China? New evidence from a continuous wavelet analysis.房价如何影响中国消费?基于连续小波分析的新证据。
PLoS One. 2018 Sep 10;13(9):e0203140. doi: 10.1371/journal.pone.0203140. eCollection 2018.
8
Effects of yearling sale purchase price, exercise history, lameness, and athletic performance on purchase price of Thoroughbreds at 2-year-old in-training sales.一岁马拍卖购买价格、训练历史、跛足情况及运动成绩对两岁在训赛马拍卖购买价格的影响
J Am Vet Med Assoc. 2012 Dec 1;241(11):1499-504. doi: 10.2460/javma.241.11.1499.
9
Prices and E-Cigarette Demand: Evidence From the European Union.价格与电子烟需求:来自欧盟的证据
Nicotine Tob Res. 2016 Oct;18(10):1973-1980. doi: 10.1093/ntr/ntw109. Epub 2016 Apr 16.
10
Endogenous Price Bubbles in a Multi-Agent System of the Housing Market.房地产市场多主体系统中的内生价格泡沫
PLoS One. 2015 Jun 24;10(6):e0129070. doi: 10.1371/journal.pone.0129070. eCollection 2015.

引用本文的文献

1
Lie symmetry analysis of the effects of urban infrastructures on residential property values.城市基础设施对住宅物业价值影响的Lie 对称分析。
PLoS One. 2021 Aug 5;16(8):e0255233. doi: 10.1371/journal.pone.0255233. eCollection 2021.

本文引用的文献

1
Truncation effect in closed and open birth interval data.封闭和开放生育间隔数据中的截断效应。
J Am Stat Assoc. 1970 Jun;65(330):678-93. doi: 10.1080/01621459.1970.10481116.