![]() ![]() Louis Federal Reserve (FRED)) directly to your spreadsheet for charts, graphs, and tables. made up X values in column B, and your Y values in column C. You can download EIA energy data (and economic data from the St. 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. 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. 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: Open Excel, but dont try to open the xrealstats-mac.xlam or realstats-mac-2011.xlam file that you downloaded earlier. ![]() 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 |