The FORECAST Function in Excel will use current or existing data to predict or forecast future values. The Forecast function has three arguments. All are required. In this video, we will use the forecast function in three examples:
1) Existing sales for a company to predict future sales values by years
2) We will look at an automobile or car deprecation
3) World population - we will examine the world population for 2020 to 2050 in five-year increments.
Three arguments for the forecast function:
X Required. The data point for which you want to predict a value.
Known_y's Required. The dependent array or range of data.
Known_x's Required. The independent array or range of data.
FORECAST(x, known_y's, known_x's) is the syntax for the function.
Microsoft's support webpage for the Forecast Function
support.office.com/en-us/arti...
#msexcel #forecastfunction #excelfunctions #exceltips #forecastexamples #chrismenard #forecast
Chris Menard's website:
chrismenardtraining.com
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera - amzn.to/3vdgF5E
○ Microphone - amzn.to/3gphDXh
○ Camera tripod - amzn.to/3veN6Rg
○ Studio lights - amzn.to/3vaxyy5
○ Dual monitor mount stand - amzn.to/3vbZSjJ
○ Web camera - amzn.to/2Tg75Sn
○ Shock mount - amzn.to/3g96FGj
○ Boom Arm - amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording - Camtasia - chrismenardtraining.com/camtasia
○ Screenshots - Snagit - chrismenardtraining.com/snagit
○ KZitem keyword search - TubeBuddy - www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Негізгі бет Тәжірибелік нұсқаулар және стиль Forecast Function in Excel to predict future values by Chris Menard
Пікірлер: 22