![]() ![]() 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. Forecast sheet in excel mac: On the Data tab, in the Forecast group, click Forecast Sheet. 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. y-values must contain number values, date/time values, or duration values. 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. To use the forecast sheet, first select the rows and columns of your dataset, then click. 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: This function isn’t available on the same Excel versions running on other operating systems such as Mac. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |