- 文章信息
- 作者： kaiwu
- 点击数：743
（1）选中【A1】单元格，输入数字“初始值”——【1】
（2）点选菜单【开始】——【填充】——【系列】
（3）在弹出的对话框，做如下设置
- 选择【行】
- 选择【等差序列】
- 输入【步长值】——1
- 输入【终值】——一个非常大的数值，输入1，后面按好多0
- 点击【确定】
（4）拖动Excel工作表页面底端的工具条，就可以看到一个Excel工作表最右端的情况，可以看到Excel2010工作表有16384列
- 文章信息
- 作者： kaiwu
- 点击数：999
中文报道很多：
搜狐新闻：http://learning.sohu.com/20171103/n521334246.shtml
360文件：http://www.360doc.com/content/17/1028/15/9689171_698830080.shtml
英文论文的引文：
https://www.sciencedirect.com/science/article/pii/S0040162516302244
如果没有Sciencedirect数据库的授权，可以从如下网址下载论文的全文：
https://www.oxfordmartin.ox.ac.uk/downloads/academic/The_Future_of_Employment.pdf
“Tech Support” by R. Kikuo Johnson.
《NewYorker》杂志的封面文章，https://www.newyorker.com/culture/cover-story/cover-story-2017-10-23
https://www.npr.org/sections/money/2015/05/21/408234543/will-your-job-be-done-by-a-machine
Source: The Future of Employment: How Susceptible Are Jobs to Computerisation? Data provided by the authors.
Credit: Quoctrung Bui and Christopher Groskopf/NPR; Illustrations by Naftali Beder
- 文章信息
- 作者： kaiwu
- 点击数：988
官方网址：https://www.ibm.com/products/spss-statistics
SPSS中国：http://spss.com.cn/
官方历史：http://www.spss.com.hk/corpinfo/history.htm
代理商简介：http://www.cabit.com.cn/products/stat/spss/index.htm
维基百科：https://en.wikipedia.org/wiki/SPSS
百度百科：https://baike.baidu.com/item/spss
官方操作指南：https://www.spss-tutorials.com/
英文SPSS学习视频：https://www.spssvideotutor.com/
SPSS英文在线学习资源：8 useful spss online resources
http://www.dummies.com/education/math/statistics/8-useful-spss-online-resources/
SPSS （Statistical Package for the Social Sciences）统计分析软件是一款在调查统计行业、市场研究行业、医学统计、政府和企业的数据分析应用中久享盛名的统计分析工具，是世界上最早的统计分析软件，由美国斯坦福大学的三位研究生（Norman H. Nie, Dale H. Bent, and C. Hadlai Hull.）于 1968 年研制， 1984 年SPSS首先推出了世界上第一个统计分析软件微机版本 SPSS/PC+ ，极大地扩充了它的应用范围，并使其能很快地应用于自然科学、技术科学、社会科学的各个领域。2022年11月最新的SPSS版本为29.0（几乎每年8月都推出一个新版本），SPSS已经拓展了可编程能力，支持开源软件R和Python。
2006年5月18日，SPSS China成立于上海，SPSS China在北京和广州都设有分支机构。
2009年7月28日，SPSS公司被IBM公司收购
2009-2010年，SPSS一度被更名为IBM PASW (Predictive Analytics SoftWare)
1.官方报价
https://spss.mairuan.com/newbuy.html
基础版，租用版（sbuscription）（每月99美元），每年11288
2.面向学生、教职工的订阅（subscription，租赁）的版本
https://www.ibm.com/products/spss-statistics-gradpack
2.1 hearne
https://www.hearne.software/SPSS-Selection-v28?adoper=174258_2_OT3
SPSS Base版，每年58美元（每年约368元人民币）
SPSS Standard版，每年76美元（每年约482元人民币）
SPSS Premium版，每年89美元（每年约564元人民币）
根据2022年3月31日汇率（1美元兑6.34元人民币）
2.2 joureyed
https://www.journeyed.com/products/IBM+SPSS/IBM+SPSS+Statistics
还有SPSS27，SPSS26等此前版本可供选择，价格更便宜
2.3 studentdiscounts
https://studentdiscounts.com/?adoper=174258_2_OT1
开源免费的SPSS替代软件PSPP，只有40兆，实现了SPSS所有基本功能（复杂的、高级的分析功能，目前还没有）。
界面几乎完全一样，包括syntax都完全一样，SPSS用户几乎不用任何转换。
官方网址：http://www.gnu.org/software/pspp/
多平台版本下载网址：https://www.gnu.org/software/pspp/get.html
windows版下载网址：http://pspp.awardspace.com/
维基百科：https://en.wikipedia.org/wiki/PSPP
https://www.gnu.org/software/pspp/get.html
如果想更改界面语言（中文操作系统，PSPP默认的界面语言是中文zh_CN）, 如果想使用英文界面：
（1）打开安装目录C:\Program Files\PSPP\share\locale
（2）删除或重命名【zh_CN】文件夹，那么PSPP的默认界面语言就改为英文。
SPSS参考书籍列表：https://www.douban.com/doulist/45508075/
- Collier, J. (2009). Using SPSS Syntax: A Beginner’s Guide. SAGE.
-
Coolican, H. (2019). Research Methods and Statistics in Psychology (7th). Routledge.
- Dancey, C. P., & Reidy, J. (2020). Statistics Without Maths for Psychology (8th). Pearson.
- Field, A. (2009). Discovering Statistics Using SPSS (3rd). SAGE.
- Field, A. (2017). Discovering Statistics Using IBM SPSS Statistics (5th). SAGE.
- George, D., & Mallery, P. (2022). IBM SPSS Statistics 27 Step by Step: A Simple Guide and Reference (17th). Routledge.
- Howitt, D., & Cramer, D. (2017). Understanding Statistics in Psychology with SPSS (7th). Pearson.
- Roni, S. M., & Djajadikerta, H. G. (2021). Data Analysis with SPSS for Survey-based Research. Springer.
- Sarstedt, M., & Mooi, E. (2019). A Concise Guide to Market Research: The Process, Data, and Methods Using IBM SPSS Statistics (3rd). Springer.
- Singh Kaurav, R. P., Gursoy, D., & Chowdhary, N. (2021). An SPSS Guide for Tourism, Hospitality and Events Researchers. Routledge.
- Verma, J. P. (2016). Sports Research with Analytical Solution using SPSS . Wiley.
-
Coolican, H. (2019). Research Methods and Statistics in Psychology (7th). Routledge.
-
吴喜之. (2004). 统计学：从数据到结论. 中国统计出版社.
-
张文彤. (2002a). 世界优秀统计工具SPSS11.0统计分析教程（基础篇）. 北京希望电子出版社.
- 张文彤. (2002b). 世界优秀统计工具SPSS11.0统计分析教程（高级篇）. 北京希望电子出版社.
- 文章信息
- 作者： kaiwu
- 点击数：934
The Zen of Python
Beautiful is better than ugly.
Explicit is better than implicit.
Simple is better than complex.
Complex is better than complicated.
Flat is better than nested.
Sparse is better than dense.
Readability counts.
Special cases aren't special enough to break the rules.
Although practicality beats purity.
Errors should never pass silently.
Unless explicitly silenced.
In the face of ambiguity, refuse the temptation to guess.
There should be one-- and preferably only one --obvious way to do it.
Although that way may not be obvious at first unless you're Dutch.
Now is better than never.
Although never is often better than *right* now.
If the implementation is hard to explain, it's a bad idea.
If the implementation is easy to explain, it may be a good idea.
Namespaces are one honking great idea -- let's do more of those!
翻译参考https://zhuanlan.zhihu.com/p/111843067
https://docs.conda.io/en/latest/miniconda.html
ios系统中运行Python：
来自踏宇科技的pythoni和pythoni3.3等，有多个Python版本的免费、收费版本。
pythoni(2.7): https://itunes.apple.com/cn/app/pythoni/id493505744?mt=8
pythoni3.3：https://itunes.apple.com/cn/app/pythoni3.3/id585633449?mt=8
android系统中运行Python：http://www.qpython.com/
云上运行Python：https://www.pythonanywhere.com/
轻松呈现python运行的每个步骤
- 文章信息
- 作者： kaiwu
- 点击数：862
from wikipedia
Python is a high-level, interpreted, general-purpose programming language. Its design philosophy emphasizes code readability with the use of significant indentation. Python is dynamically-typed and garbage-collected. It supports multiple programming paradigms, including structured (particularly procedural), object-oriented and functional programming. It is often described as a "batteries included" language due to its comprehensive standard library. Guido van Rossum began working on Python in the late 1980s as a successor to the ABC programming language and first released it in 1991 as Python 0.9.0.Python 2.0 was released in 2000 and introduced new features such as list comprehensions, cycle-detecting garbage collection, reference counting, and Unicode support. Python 3.0, released in 2008, was a major revision that is not completely backward-compatible with earlier versions. Python 2 was discontinued with version 2.7.18 in 2020.Python consistently ranks as one of the most popular programming languages
The Zen of Python
Beautiful is better than ugly.
Explicit is better than implicit.
Simple is better than complex.
Complex is better than complicated.
Flat is better than nested.
Sparse is better than dense.
Readability counts.
Special cases aren't special enough to break the rules.
Although practicality beats purity.
Errors should never pass silently.
Unless explicitly silenced.
In the face of ambiguity, refuse the temptation to guess.
There should be one-- and preferably only one --obvious way to do it.
Although that way may not be obvious at first unless you're Dutch.
Now is better than never.
Although never is often better than *right* now.
If the implementation is hard to explain, it's a bad idea.
If the implementation is easy to explain, it may be a good idea.
Namespaces are one honking great idea -- let's do more of those!
https://docs.conda.io/en/latest/miniconda.html
ios apps for Python：
pythoni(2.7): https://itunes.apple.com/cn/app/pythoni/id493505744?mt=8
pythoni3.3：https://itunes.apple.com/cn/app/pythoni3.3/id585633449?mt=8
android apps for Python：
run python in the cloud
https://www.pythonanywhere.com/
https://colab.research.google.com/