Linear regression in Excel

[Jen123456]

I need to use linear regression to get missing data values on Excel in order to normalise the data.

E.g. I have 85 values for height (1 missing) and 85 values for shoe size (1 missing).

How do I calculate the missing value by using the other 84 (with linear regression)

 

[pgc01]

Hi

Check the function FORECAST()

 

[Jen123456]

Hi,

Thanks for your help. Unfortunately its mandatory to use Linear Regression to find the missing value. Attached is an example of what it looks like on my side.

Thanks

 

[pgc01]

Hi,

Thanks for your help. Unfortunately its mandatory to use Linear Regression to find the missing value. Attached is an example of what it looks like on my side.

Thanks

Forecast() uses Linear Regression

You can confirm it in the official doc from ms here:

FORECAST and FORECAST.LINEAR functions - Microsoft Support

Calculate, or predict, a future value by using existing values. The future value is a y-value for a given x-value. The existing values are known x-values and y-values, and the future value is predicted by using linear regression. You can use these functions to predict future sales, inventory...

support.office.com

As you can see they not only state clearly that Forecast() uses Linear Regression but also show the equations used, which is what you'd expect for Linear Regression.

 

[Jen123456]

Oh wow, sorry my mistake (I'm new to all this)

Thanks so much for your help, I really appreciate it!

 

[pgc01]

You're welcome. I'm glad it helped.