Lab 5 excel sheet

could anyone pleasee help me calculate the constant on the sheet i've tried so many things and I dont get what im doing wrong. this is what ive been using


(4*pi*k'*N)^2
(2(a^2)(4/5)^3

Hey the equation is : (4*pi'*N)^2 / (2*((5/4)^3)*a^2) you just reversed the 5 and 4 i think.

I forgot the k', not pi' but u had that right anyway! whoops

constant = ((4*pi*k'*130)^2)/(2((5/4)^3)*(a^2)

where 130 = N (it says it in the lab - this made me go crazy until I actually read the damn thing lol). It turned green in my excel sheet, so it should work in yours! (comes out to a value with E-07).

I am not getting a...
I am using a=((a_v1+a_v2)+(a_h1+a_h2))/4
What am I doing wrong?

How do you get Delta(Ir)^2??????????

how do u get : error of slope? e/m? error of e/m? error of constant? I have been plugging in so many numbers, nothing is working. thanks!

Error of e/m would be

sqrt((Δconstant/constant)^2+(Δslope/slope)^2)*e/m

Ok for the error in slope our TA told us that somthing around 15000 would work (10000 to 20000, somewhere in that range) but for some reason the excel sheet doesnt want to accept that..

Error in the constant = 2*(Δa/a)*constant

e/m = (V/(IR)^2)/constant = slope/constant

Does anyone know what textbook value of e/m refers to?

I played around with the error of slope for a bit and found that values between 500-700 seem to fit. If you put in values around there, see which max/min lines fit your error bars the best and that should be your error in slope

e/m= charge of electron/mass of electron= (1.6*10^-19)/(9.11*10-31)= 1.76E11 C/kg

How do you find the error slope? Every1 that is saying plugg-in #'s from 100-700 is WRONGGGGGG. Help me

for error in slope:

(delta(Ir)^2/(Ir)^2) * slope value

Hi

How do u find "a" and "Delta r" plz help

what #'s do i plugg-in b/c I tired 2 already and it is not working