Normalising Data for plotting graphs in Excel

[@jmlee2115]

Hi, just want to let you know that all of your labchart and graphpad videos are very helpful. Thank you.

[@jayishnuroy8710]

Thank you sooo mucch!
I was searching for intuitive understanding of normalisation from long

[@DoryVideo]

Glad you found it here!

[@edubielalpizar4391]

@@DoryVideo same here, so much to say on this topic and even worse that normalizaing may mean reduction of reduncancy of datasets info instead of statistically (or mathematically if you like) processing data to (I think) reduce dimensionality. Is it the same than stardarisation ?

[@SantoshTata]

finally I understood the data normalization thank you very much

[@teoz21]

Thank you this is super helpful

[@DoryVideo]

Glad you found it useful

[@davidbundgaard]

Actually when you expanded horisontal you actually made column 3 and 4 to be percentage of column 2 as you locked the cell.

[@husso7749]

Thanks a lot for the video, it is really helpful. I also liked the graphs template, how can I get something similar? :)

[@DoryVideo]

Thanks, you can make the graphs in excel very easily

[@mdmonirulislam6153]

Very effective one

[@helloitsme7785]

Is it a stock chart plotting the average and half the stddev above and below for the stick?

[@Shibu1661]

Can I use the same technique for forecasting based on time series data?

[@stijnberendsen6837]

very helpful!

[@DoryVideo]

Thanks

[@antoniolee3920]

Does it make sense to use geo-mean than arithmetic mean here?

[@DoryVideo]

it might well do, yes

[@MrOtisam]

Lifesaver

[@DoryVideo]

Thanks

[@helloitsme7785]

How do you create the chart in the video?

[@DoryVideo]

It’s just a graph in excel. There are plenty of videos on UA-cam that will show you how.

[@naomikingu7594]

Which option on excel did u use for plotting the graph

[@naomikingu7594]

Thanks

[@DoryVideo]

My pleasure. Please subscribe as I’m adding more videos all the time

[@zhaojinxu4355]

good

[@DoryVideo]

Thanks

[@FancyAnimal]

Is this the 6 fingered man from Princess Bride?