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 λ.(adsbygoogle = window.adsbygoogle || []).push({});

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

**Physics Forums - The Fusion of Science and Community**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Excel, proper equation format.

Loading...

Similar Threads - Excel proper equation | Date |
---|---|

What should be the rules to write excellent code? | Mar 12, 2018 |

Python Interesting article how to use Pandas with Excel sheets | Feb 19, 2018 |

Rapid data retrieval from Excel (or similar) | Dec 26, 2017 |

Python Insert data into excel, calculate+retrieve data using Python | Sep 3, 2017 |

JavaScript How can I properly test my web application? | Feb 25, 2016 |

**Physics Forums - The Fusion of Science and Community**