Resources on getting started with Excel are available HERE. Use Regression macro in Data Analysis Tools with no intercept Use Solver routine on sum of squares of weighted residuals Use EXCEL array tools (transpose, minverse, and mmult) to define and manipulate matrices. Care must be taken when using JAVA Applets in that they may not work on all browsers. EXCEL Several methods exist: Transform all variables, including constant. The JAVA Applet BlackBody is great for interactive lectures or student use as it surperimposes the visible spectrum on the Planck radiation curve. Wien's Law, Stefan-Boltzmann Law, and Color Indices.Excel has a function called Price() that can calculate the clean price of a bond on any date. While that isnt always the case, it is here. With modern spreadsheets we expect to have built-in functions that can do the tedious stuff for us. This site has connections to three on-line interactive JAVA Applets: The above process works great, but it is tedious. The Planck Radiation Law ( more info) site introduces Planck's model equation for the spectral irradiance of a black-body radiator and the connection between the Planck Radiation Law, and the Stefan-Boltzman and Wein radiation laws.
0 Comments
Leave a Reply. |