hOW TO HANDLE MISSING DATA IN EXCEL

[davebarnaby]

Very very helpful video. I just wanted a quick way to know how to get the missing data points or zeros to connect or show up as part of individual or separate data paths. Thanks for sharing this.

[masakonamulanga]

Thanks it is short and straight to the point.

[anjanackm]

Sir, how do we find the interpolated values from the graph?

[anjalikarolnair]

Finally, how do you copy-paste the interpolated values to get the full series with the missing values?

[xoscarx]

You can also use a statistic model to have a better approximation. With the tendency line in excel obtain the formula and R^2, then you can impute the missing data.

[anmolanjam]

Thanks! very helpful for someone who was looking for a quick way to know how to use edexcel to interpolate data.

[Rainstorm]

Thanks sir. Is it OK to replace missing values with 0 or -999 if I want to calculate the average of the scores in excel?

[tilayeworku]

Very shallow, where is the data that you filled rather than connecting with a straight line?

[sidraines]

Or fill the missing data with an average value for that column.

[shallegramoye]

As someone who is numbers-challenged and struggling through a graduate biostatistics class, I thought this tutorial was highly informative and timed perfectly.