- #1
ricky12tt
- 5
- 0
Ok, so the teacher gave us an assignment to write a program that calculates the ratio below, tabulate it and plot it.. for given values of R and λ.
T_b/T_a =([R^4-(R-λR)^4])/([4λR^2 (R-λR/2)^2])
I figured that I would use Excel to do this.
I think the above equation converts to the function below in excel but I keep getting zero for all values I try.
C2=R
And A4=λ
=QUOTIENT(((POWER(C2,4))-(POWER((C2)-(PRODUCT(C2,A4)),4))),(PRODUCT((POWER(((C2)-(QUOTIENT((PRODUCT(A4,C2)),2))),2)),4,A4,(POWER(C2,2)))))
Any help would be appreciated.
Thanks
T_b/T_a =([R^4-(R-λR)^4])/([4λR^2 (R-λR/2)^2])
I figured that I would use Excel to do this.
I think the above equation converts to the function below in excel but I keep getting zero for all values I try.
C2=R
And A4=λ
=QUOTIENT(((POWER(C2,4))-(POWER((C2)-(PRODUCT(C2,A4)),4))),(PRODUCT((POWER(((C2)-(QUOTIENT((PRODUCT(A4,C2)),2))),2)),4,A4,(POWER(C2,2)))))
Any help would be appreciated.
Thanks