如何在Excel中进行趋势分析

方法 1

方法 1 的 2:Windows

WH.shared.addScrollLoadItem(‘eb5e02044b2d268142eda91d46a40ba6’)

WH.performance.clearMarks(‘image1_rendered’); WH.performance.mark(‘image1_rendered’);{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8c/Do-Trend-Analysis-in-Excel-Step-1-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-1-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8c/Do-Trend-Analysis-in-Excel-Step-1-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-1-Version-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”

“}
1
打开Excel工作簿。双击数据所在的Excel工作簿文档。
如果在电子表格中没有想要分析的数据,可以打开Excel,然后点击”空白工作簿”打开新的工作簿。然后可以输入数据并从中 创建一个图表。WH.performance.mark(‘step1_rendered’);

WH.shared.addScrollLoadItem(’72fff6eba8f6c8e1ea2b5baef5963c3d’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e5/Do-Trend-Analysis-in-Excel-Step-2-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-2-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e5/Do-Trend-Analysis-in-Excel-Step-2-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-2-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
2
选择图形。点击你想要设定趋势线的图表。
如果你还没有用数据创建图表,先创建一个。

WH.shared.addScrollLoadItem(‘259c37bad94b8c52f60f637e58243d1e’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ed/Do-Trend-Analysis-in-Excel-Step-3-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-3-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ed/Do-Trend-Analysis-in-Excel-Step-3-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-3-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
3
点击+。这是图右上角的一个绿色按钮。然后会出现一个下拉菜单。

WH.shared.addScrollLoadItem(‘40089d2d4775db32d659f5e344aaa863’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f6/Do-Trend-Analysis-in-Excel-Step-4-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f6/Do-Trend-Analysis-in-Excel-Step-4-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-4-Version-3.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”

“}
4
点击“趋势线”框右边的箭头。你可能需要把鼠标悬停在“趋势线”框的最右侧,好让这个箭头出现。点击它会弹出第二个菜单。

WH.shared.addScrollLoadItem(‘655cc6f662cc78e1fd19abdd815f2611’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/09/Do-Trend-Analysis-in-Excel-Step-5-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-5-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/09/Do-Trend-Analysis-in-Excel-Step-5-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-5-Version-3.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”

“}
5
选择一个趋势线选项。根据你的喜好,点击以下选项之一。
线性
指数
线性预测
双周期移动平均
你也可以在选择要分析的数据后,点击“更多选项”打开一个高级选项面板。

WH.shared.addScrollLoadItem(‘aadbf3b3fa635045316b6ecaf2751849’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4c/Do-Trend-Analysis-in-Excel-Step-6-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-6-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4c/Do-Trend-Analysis-in-Excel-Step-6-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-6-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
6
选择要分析的数据。在弹出窗口中点击一个数据系列名称(例如“’系列1’”)。如果已经指定了数据,则单击数据的名称。

WH.shared.addScrollLoadItem(’15adf12b011a80ec4f5c4596fde7f243′)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/22/Do-Trend-Analysis-in-Excel-Step-7-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-7-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/22/Do-Trend-Analysis-in-Excel-Step-7-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-7-Version-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
7
点击OK。它在弹出窗口的底部。这样就可为图形添加趋势线。
如果你之前点击了“更多选项”,就可以选择给趋势线命名,或者在窗口右边改变趋势线的参数。

WH.shared.addScrollLoadItem(‘87960c191254b974e121b441650bbb5b’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/67/Do-Trend-Analysis-in-Excel-Step-8-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-8-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/67/Do-Trend-Analysis-in-Excel-Step-8-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-8-Version-3.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”

“}
8
保存工作。按{{keypress|Ctrl|S}保存更改。如果以前从未保存过这份文档,就会弹出提示让你选择一个保存位置和文件名。

WH.ads.addBodyAd(‘method_ad_1’)
WH.ads.addBodyAd(‘mobilemethod_ad_1’)广告

方法 2

方法 2 的 2:Mac

WH.shared.addScrollLoadItem(‘0a462c4a353387ea459885d94a7a848d’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/49/Do-Trend-Analysis-in-Excel-Step-9-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-9-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/49/Do-Trend-Analysis-in-Excel-Step-9-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-9-Version-3.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”

“}
1
打开Excel工作簿。双击存储数据的Excel工作簿文档。
如果在电子表格中没有想要分析的数据,可以打开Excel,然后点击”空白工作簿”打开新的工作簿。然后可以输入数据并从中 创建一个图表。

WH.shared.addScrollLoadItem(’40ee7364169fb4f6de742a06f9400b8f’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ac/Do-Trend-Analysis-in-Excel-Step-10-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-10-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ac/Do-Trend-Analysis-in-Excel-Step-10-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-10-Version-3.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
2
选择图形。点击你想要设定趋势线的图表。
如果你还没有用数据创建图表,先创建一个。

WH.shared.addScrollLoadItem(‘0111fd2db076638027f00a95ed75d725’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/be/Do-Trend-Analysis-in-Excel-Step-11-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-11-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/be/Do-Trend-Analysis-in-Excel-Step-11-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-11-Version-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”

“}
3
点击 图表设计 标签。在Excel窗口顶部。
X
研究来源

WH.shared.addScrollLoadItem(‘0f3fb03e2ce55c714090ec214ecc39d1’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2b/Do-Trend-Analysis-in-Excel-Step-12-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-12-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2b/Do-Trend-Analysis-in-Excel-Step-12-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-12-Version-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”

“}
4
点击添加图表元素。这个选项位于“图表设计”工具栏的最左边。单击它会出现下拉菜单。

WH.shared.addScrollLoadItem(‘bfe0fcf5c2f73d3bb0a6fc66dea930c6’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/05/Do-Trend-Analysis-in-Excel-Step-13-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-13-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/05/Do-Trend-Analysis-in-Excel-Step-13-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-13-Version-3.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”

“}
5
选择Trendline。在下拉菜单的底部。然后会出现弹出菜单。

WH.shared.addScrollLoadItem(‘d83e3eb987a78b178ac43d3f07eb38f4’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/63/Do-Trend-Analysis-in-Excel-Step-14-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-14-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/63/Do-Trend-Analysis-in-Excel-Step-14-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-14-Version-3.jpg”,”smallWidth”:460,”smallHeight”:341,”bigWidth”:728,”bigHeight”:540,”licensing”:”

“}
6
选择一个趋势线选项。根据你的喜好,在弹出菜单中点击以下选项:[2]
X
研究来源

线性
指数
线性预测
移动平均
你也可以点击“更多趋势线选项”来打开带有高级选项的窗口(例如,趋势线名称)。

WH.shared.addScrollLoadItem(‘6444587649994eaf95d2f1570d0ef270’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e2/Do-Trend-Analysis-in-Excel-Step-15-Version-3.jpg/v4-460px-Do-Trend-Analysis-in-Excel-Step-15-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e2/Do-Trend-Analysis-in-Excel-Step-15-Version-3.jpg/v4-728px-Do-Trend-Analysis-in-Excel-Step-15-Version-3.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”

“}
7
保存更改。按 ⌘ Command + Save,或点击“文件”-“保存”来保存更改。如果以前从未保存过这份文档,就会弹出提示让你选择一个保存位置和文件名。

WH.ads.addBodyAd(‘mobilemethod_ad_2’)广告

发表评论

您的电子邮箱地址不会被公开。