# WorksheetFunction.Forecast_Linear 方法 (Excel)WorksheetFunction.Forecast_Linear method (Excel)

## 語法Syntax

_運算式_代表**WorksheetFunction** 物件的變數。expression A variable that represents a WorksheetFunction object.

## 參數Parameters

Arg1Arg1 必要Required DoubleDouble x-要預測值的資料點。x - the data point for which you want to predict a value.
Arg2Arg2 必要Required VariantVariant known_y's-相依的陣列或資料範圍。known_y's - the dependent array or range of data.
Arg3Arg3 必要Required VariantVariant known_x's-獨立的陣列或資料範圍。known_x's - the independent array or range of data.

## 註解Remarks

Forecast_Linear的方程式為 a + bx，其中  和  其中 x 及 y 為樣本平均數 AVERAGE (所有_known_x's_) 和 AVERAGE (所有_known_y's_).The equation for Forecast_Linear is a+bx, where     and     and where x and y are the sample means AVERAGE(all known_x) and AVERAGE(all known_y).

## 範例Example

``````Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim Arg2 As Object
Dim Arg3 As Object
Dim returnValue As Double

returnValue = instance.Forecast_Linear(Arg1, Arg2, Arg3)

``````