g19ly的博客

OLS一元回归（GPA on act）#data inputgpa=c(2.8,3.4,3.0,3.5,3.6,3.0,2.7,3.7)#读入数据：GPA因变量act=c(21,24,26,27,29,25,25,30)#读入数据：自变量student=1:8#生成1到8编号data=cbind(student,gpa,act)#按列合并，生成3列#data=rbind(student,gpa,act)#按行合并，生成3行#simple linear regresionols=lm(gpa

#exercise 2.4#part 1wage=data[,1]IQ=data[,3]ave_wage=mean(wage)ave_IQ=mean(IQ)sd_IQ=sd(IQ)#part 2ols=lm(wage~IQ)summary(ols)#Multiple R-squared:0.09554 IQ can explain less than 10% influence in wage beta_hat=ols$coefficients15*8.303064#part 3

学习网站：https://blog.csdn.net/iblade/article/details/116267870Step 1：打开word粘贴网址，保存选择txt并修改后缀为.iqy（还得回到保存地址修改后缀）, 同时注意文本编码选择MS-DOSStep 2：打开excel-数据-获取外部数据-运行web查询-选择需要的.iqy就完成了还需解决：有些中文导入表格后会乱码如何设置自动更新频率...

一、符号.* 与./https://blog.csdn.net/xiaotao_1/article/details/79026406

Lesson 13:% _ 模糊查询SELECT *FROM customersWHERE last_name LIKE '%b%'//%可以是任何字母，空格也可以WHERE last_name LIKE '_y'//单词必须只是两个字母，然后第二个是yWHERE last_name LIKE 'b____y'//6个字母，b开头y结尾//注意用OR的时候LIKE前后都要写才完整WHERE address LIKE ‘%trail%’ OR address LIKE ‘%avenue%’