Skip to content

Commit

Permalink
Merge pull request #1491 from MicrosoftDocs/lindalu-MSFT-patch-1
Browse files Browse the repository at this point in the history
Fix build errors
  • Loading branch information
lindalu-MSFT authored Jan 19, 2022
2 parents 429af4d + 9f6ed4f commit a43a38a
Show file tree
Hide file tree
Showing 3 changed files with 6 additions and 6 deletions.
6 changes: 3 additions & 3 deletions api/Excel.WorksheetFunction.LinEst.md
Original file line number Diff line number Diff line change
Expand Up @@ -73,7 +73,7 @@ The additional regression statistics are as follows.

The following illustration shows the order in which the additional regression statistics are returned.

> ![Formula](../images/awflnst3_ZA06051201.gif)
> ![illustration showing the order in which the additional regression statistics are returned](../images/awflnst3_ZA06051201.gif)

You can describe any straight line with the slope and the y-intercept: `Slope (m)`. To find the slope of a line, often written as m, take two points on the line, (x1,y1) and (x2,y2); the slope is equal to (y2 - y1)/(x2 - x1). Y-intercept (b): The y-intercept of a line, often written as b, is the value of y at the point where the line crosses the y-axis. The equation of a straight line is y = mx + b. After you know the values of m and b, you can calculate any point on the line by plugging the y- or x-value into that equation. You can also use the TREND function.
Expand All @@ -85,9 +85,9 @@ When you have only one independent x-variable, you can obtain the slope and y-in

The accuracy of the line calculated by **LinEst** depends on the degree of scatter in your data. The more linear the data, the more accurate the **LinEst** model. **LinEst** uses the method of least squares for determining the best fit for the data. When you have only one independent x-variable, the calculations for m and b are based on the following formulas:

> ![Formula](../images/awflnst1_ZA06047512.gif)
> ![Formula showing calculations for m and b](../images/awflnst1_ZA06047512.gif)
> ![Formula](../images/awflnst2_ZA06051200.gif)   where x and y are sample means, that is, x = AVERAGE(known x's) and y = AVERAGE(known_y's).
> ![Formula showing calculations for m and b where x and y are sample means](../images/awflnst2_ZA06051200.gif)   where x and y are sample means, that is, x = AVERAGE(known x's) and y = AVERAGE(known_y's).
The line- and curve-fitting functions **LinEst** and **[LogEst](excel.worksheetfunction.logest.md)** can calculate the best straight line or exponential curve that fits your data. However, you have to decide which of the two results best fits your data. You can calculate `TREND(known_y's,known_x's)` for a straight line, or `GROWTH(known_y's, known_x's)` for an exponential curve. These functions, without the new_x's argument, return an array of y-values predicted along that line or curve at your actual data points. You can then compare the predicted values with the actual values. You may want to chart them both for a visual comparison.

Expand Down
2 changes: 1 addition & 1 deletion api/Outlook.Account.md
Original file line number Diff line number Diff line change
Expand Up @@ -7,7 +7,7 @@ ms.prod: outlook
api_name:
- Outlook.Account
ms.assetid: f624438c-4e45-2822-18b6-bfe8074a33c0
ms.date: 12-29-2021
ms.date: 12/29/2021
ms.localizationpriority: medium
---

Expand Down
Original file line number Diff line number Diff line change
Expand Up @@ -17,10 +17,10 @@ Use this procedure to add a control from the [Control Toolbox](../Customizing-Fo
**Note** f you do not see the **Developer** tab in the open form, see the topic [Run in Developer Mode in Outlook](../../How-to/Using-Visual-Basic-to-Customize-Outlook-Forms/run-in-developer-mode-in-outlook.md).
2. Do one of the following:

- Click a control in the **Control Toolbox** and then click in the form. The control appears in its default size. You can then drag the border of the control to change its size.
- Click a control in the **Control Toolbox** and then click in the form. The control appears in its default size. You can then drag the border of the control to change its size.

- Drag a control from the **Control Toolbox** to the form. The control appears in its default size.

- Double-click the control in the **Control Toolbox**, and then click in the form once for each control that you want to create. For example, to create four command buttons, double-click the [CommandButton](../../../api/Outlook.commandbutton.md) control in the **Control Toolbox**, and then click four times in the form.

[!include[Support and feedback](~/includes/feedback-boilerplate.md)]
[!include[Support and feedback](~/includes/feedback-boilerplate.md)]

0 comments on commit a43a38a

Please sign in to comment.