R语言实现分性别奥运夺冠时长散点图的双组最优拟合线添加
可落地实现:基础R绘图模式下为男女组散点添加独立最优拟合线
你目前使用基础R的plot()/points()流程绘图,不需要切换ggplot语法,仅靠原生函数就能完成拟合线添加,全程逻辑和你现有代码完全兼容。
先修正你原代码的几个易报错问题
- 引用带空格的列名时,
$符号后不要加空格,要用反引号把列名包裹,比如正确写法是gender_data$Olympic year``,原写法gender_data$ "Olympic year"会触发语法错误 - 原女子组设置的标记
pch=""`是输入笔误,换成常规实心点即可区分 lm()线性建模函数会自动跳过数据中的NA空值,不需要手动清洗缺失样本
完整可运行代码
# 清空环境变量 rm(list = ls()) # 直接替换成你自己的excel读取代码即可,这里用内置测试数据做兼容 gender_data <- structure( list( `Olympic year` = c(1900, 1904, 1908, 1912, 1916, 1920, 1924, 1928, 1932, 1936, 1940, 1944, 1948, 1952, 1956, 1960, 1964, 1968, 1972, 1976, 1980, 1984, 1988, 1992, 1996, 2000, 2004), `Men's winning time (s)` = c(11, 11, 10.8, 10.8, NA, 10.8, 10.6, 10.8, 10.3, 10.3, NA, NA, 10.3, 10.4, 10.5, 10.2, 10, 9.95, 10.14, 10.06, 10.25, 9.99, 9.92, 9.96, 9.84, 9.87, 9.85), `Women's winning time (s)` = c(NA, NA, NA, NA, NA, NA, NA, 12.2, 11.9, 11.5, NA, NA, 11.9, 11.5, 11.5, 11, 11.4, 11.08, 11.07, 11.08, 11.06, 10.97, 10.54, 10.82, 10.94, 10.75, 10.93) ), class = "data.frame", row.names = c(NA, -27L) ) # 第一步:绘制男子组基础散点(绿色星型标记) plot( x = gender_data$`Olympic year`, y = gender_data$`Men's winning time (s)`, xlab = "奥运年份", ylab = "夺冠时长(秒)", ylim = c(7, 13), col = "green", pch = "*", cex = 1.2 # 放大星型标记,提升辨识度 ) # 第二步:叠加女子组散点(蓝色实心标记) points( x = gender_data$`Olympic year`, y = gender_data$`Women's winning time (s)`, col = "blue", pch = 16 ) # ---------- 核心操作:添加两组各自的最优拟合线 ---------- # 男子组最小二乘线性拟合 men_fit <- lm(`Men's winning time (s)` ~ `Olympic year`, data = gender_data) # 将男子拟合线叠加到图上,颜色与对应散点保持一致,线宽加粗便于查看 abline(men_fit, col = "green", lwd = 2) # 女子组最小二乘线性拟合 women_fit <- lm(`Women's winning time (s)` ~ `Olympic year`, data = gender_data) # 将女子拟合线叠加到图上 abline(women_fit, col = "blue", lwd = 2) # 可选优化:添加图例,区分散点和对应拟合线 legend( "topright", legend = c("男子夺冠时长", "男子拟合线", "女子夺冠时长", "女子拟合线"), col = c("green", "green", "blue", "blue"), pch = c("*", NA, 16, NA), lty = c(NA, 1, NA, 1), bty = "n" # 去掉图例边框,更简洁 )
补充说明
- 上述代码生成的拟合线是统计定义下的最小二乘最优拟合直线,完全匹配line of best fit的要求
- 如果需要调整线条样式(比如换成虚线),在
abline()里加参数lty = 2即可 - 代码里所有步骤和你原有的绘图逻辑完全衔接,不需要重写已经做好的散点部分,只要在原绘图代码后追加拟合相关的代码就行
内容的提问来源于stack exchange,提问作者SJJ
相关产品推荐
相关产品推荐

