Normalizing Graph in Excel: Step by Step Guide

[aidin]

Dear all ,

Thank you for any help in advance.

I have a graph in Excel which represents counts (photons) vs pixel i.e distance. This is from a cross sectional profile of an X-ray image.

I would like to normalise my graph with respect to my background. I have attached the graph. I know I have to draw a best fit line on my background and find the equation but a step by step process would be relly helpful.

Thank you

 

[Simon Bridge]

Welcome to PF;
It is tricky to figure what you want because you say "normalize" at first, then you want "best fit line" later... which is it?
It would have help if you showed us what you have tried or how you are thinking about what is needed.
Anyway - off your post, I can suggest the following howto's. You can tell us which was right for you, and, if you get stuck, where.

Single-line 'best fit" method.
http://serc.carleton.edu/mathyouneed/graphing/bestfit.html

Crossed lines method - good if you need uncertainties.
http://www.schoolphysics.co.uk/age16-19/General/text/Uncertainties_in_graphs/index.html

Normalizing curves in excel;
http://www.ehow.com/how_12167214_normalize-curves-excel.html

 

[ssd]

This appears to be an incomplete Beta function. You have to find its parameters from data, setting the truncation value ahead from experience. Normalization means subtraction of mean from the values and then division by sd.