×
英语
很抱歉。本文没有你的语言版本。

Perform a regression analysis

In Excel Online, you can view the results of a regression analysis (in statistics, a way to predict and forecast trends), but you can't create one because the Regression tool isn't available.

You also won't be able to use a statistical worksheet function such as LINEST to do a meaningful analysis because it requires you enter it as an array formula, which isn't supported in Excel Online.

If you have the Excel desktop application, you can use the Open in Excel button to open your workbook and use either the Analysis ToolPak's Regression tool or statistical functions to perform a regression analysis there.

Click Open in Excel and perform a regression analysis.

Button to Edit in Excel

For news about the latest Excel Online updates, visit the Microsoft Excel blog.

For the full suite of Office applications and services, try or buy it at Office.com.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×