Forecast.pptVIP

Copyright ? 2007 Pearson Education, Inc Publishing as Pearson Addison-Wesley. Only use technology that’s worth it只用那些值得使用的科技 ?Anheuser-Busch InBev November 16, 2008 Company Confidential * Copyright ? 2007 Pearson Education, Inc Publishing as Pearson Addison-Wesley. Slide * Slide * Copyright ? 2007 Pearson Education, Inc Publishing as Pearson Addison-Wesley. Time Series Analysis时间序列分析 Time Series Analysis时间序列分析 How to create a Time Series Plot?如何创建一个时间序列图？ What is Time Series Analysis?什么是时间序列分析？ What are Time Series used for?时间序列分析的主要用途 Copyright ? 2007 Pearson Education, Inc Publishing as Pearson Addison-Wesley. How to create a Time Series Plot?如何创建一个时间序列图 What is Time Series Plot?什么是时间序列图 IMPORTANT 重要提醒: : When using this graph we must maintain the integrity of the order of the data. It must be plotted and viewed in the order in which the data was collected。 当我们运用时间序列图的时候，一定要保证数据的完整性，中间不能缺失，它必须是依据数据的时间顺序来绘制和显示。 A time series plot is a graphical representation of data collected over time.时间序列图是一段时间内收集数据的图形表示 * Create a Time Series Plot in Excel在EXCEL中创建一个时间序列图 Step 1: Import data table into Excel and highlight the data set including the row and column titles by left mouse clicking and dragging down第一步: 把数据输入电子表格中，然后用鼠标点击并向下拖动选中包括行标题和列标题的数据集 Step 2: Click on the “Chart Wizard”第二步: 点击“图表向导” Step 3: In the “Standard Types” dialogue box select “line” and click on “next”第三步: 在“标准类型”对话框中选择“折线图”，然后点击“下一步” Step 4: Enter the Chart – title, X-axis name, and Y-axis name and then click on “Finish” to create the plot第四步: 输入图标的名称，X轴的名字和Y轴的名字，然后点击“完成” 来创建一个图表 Create a Time Series Plot in Excel在EXCEL中创建一个时间序列图 Let’s create a Time Series plot using the following example:让我们用下面的例子来创建一个时间序列图 Step 1: Open worksheet “Revenue” (Forecast.xls) and left mouse click and highlight the data as shown on the left第一步: 打开工作表“营业收入”(Forecast.xls)，然后点击鼠标左键并拖动选中左面的数据集 * Step 2: Left mouse click on the “Chart Wizard” on the top tool bar第二步：单击工具栏上的“图表向导” Step 3: In the