# Why And How To Use Forecasting Linear Regression In Excel Spread Sheet

## FAQs

important takeaways Simple linear regression is often used in forecasting and financial analysis, such as when a corporation wants to know how a change in the GDP would effect sales. Although Microsoft Excel and other applications can perform all of the calculations, it's useful to understand how simple linear regression works.

The FORECAST. LINEAR function forecasts a value based on previous values that follow a linear trend. FORECAST. LINEAR uses linear regression to produce future value predictions and can be used to predict numeric values such as sales, inventory, test results, expenses, measurements, and so on.

Click Forecast Sheet in the Forecast group on the Data tab. Select a line chart or a column chart for the visual depiction of the forecast in the Create Forecast Worksheet box. Select an end date in the Forecast End box, then click Create.

The FORECAST function in Excel forecasts a value based on previous values in a linear trend. FORECAST uses linear regression to produce future value forecasts and can be used to anticipate numeric values like as sales, inventory, expenses, measurements, and so on.

The standard number for the confidence interval is usually 95 percent. This indicates that Excel is 95% certain the anticipated number will fall between the two lines. The repetitive nature of your schedule is defined by seasonality.

## Recommended Courses

### Share With Friend

Have a friend to whom you would want to share this course?   ######    