![]() made up X values in column B, and your Y values in column C. 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. 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. Use extended functions in Excel, interact with our specially designed. All values must be of the same value type. Build models in Excel with all the modern mathematical tools available in our suite. 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. Turn Microsoft Excel or Apple Numbers into a powerful statistical package with StatPlus:mac and perform data analysis on a Mac in the. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |