![]() To make the calculations easier, I gave these range names of datessheet1 and unitssheet1. We want to know what the units sold will be for June through December. You need dates and their corresponding numbers for all the forecasting functions. ![]() This type of data doesnt have a cycle, which means the sales dont depend on the time of year. The Forecast Sheet chart isnt available on the Mac edition of 2016, but you can still create a regular chart. Once you have the results, you can create a chart in the Windows version that shows the forecasts and expected margins of error. The older FORECAST function still exists for compatibility with worksheets created in older versions, but if youre creating a new sheet, youll want to use one of these.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |