made up X values in column B, and your Y values in column C. Forecast intervals of up to 5-steps-ahead forecasts are reported to Excel. So you need X and Y values, you have only provided (I am guessing) Y values.Īssuming that the Y values are equally spaced in X, I am going to make up some X data. for the Mac designed to extract knowledge from data stored in Excel. All values must be of the same value type. x-values must contain number values, date/time values, or duration values. X-values: The collection containing the x (independent) values. On Windows, click the 'Options' button and choose 'Selection' or 'Entire Workbook' under 'Publish What.' On a Mac, these options are displayed at the bottom of the save dialog. Select File > Export > Create PDF/XPS Document. y-values must contain number values, date/time values, or duration values. 1 hour ago &0183 &32 To export a cell range as a PDF, first select the range with your cursor or using keyboard shortcuts. Y-values: The collection containing the y (dependent) values. x-value must contain a number value, date/time value, or duration value. X-value: The x value for which the function should return a forecasted y value. The FORECAST function returns the forecasted y value for a given x based on sample values using linear regression analysis. enter the function you want in the cell, or search for the function in the built-in help to see the details for each function.įrom the built-in help, here is the description for FORECAST: select the cell where you want to enter the formula You can use the built-in help in Numbers while entering formulas:
0 Comments
Leave a Reply. |