Excel Files: Calculus Demos, Templates, and Samples
graphical demonstrations using one fixed curve of the concepts of the tangent being the limit of secants and of Right Rectangle and Trapezoid area approximation methods
emplates for: (1) basic logistic regression, (2) numerical demonstration of the limit of secant slopes approaching the tangent slope, and (3) creation of slope (derivative) and concavity (second derivative) graphs for any function.
templates for: (1) generic numerical integration, (2) improper integration, and (3) calculation of medians, as well as templates for integral approximations using: (4) Right Rectangles, (5) Trapezoids, (6) Simpson's Rule, (7) Left Rectangles, and (8) Midpoint Rectangles
templates for: (1) drawing 3D graphs of any function of 2 variables, (2) a 3x3 test template to test critical points of functions of 2 variables to see if they are local optima or saddle points, (3) a randomized test template to test solutions of functions of any number of variables for local and global optimality (possibly with constraints), (4) calculating Net Present Value and Internal Rate of Return for a cash flow, (5) calculating SSe, SSR, TSS, and R squared for regression models, (6) calculating the mean and variance of returns for an investment, (7) advanced logistic regression, and (8) samples of linear programming using Excel
how these and other Excel tools can be used to solve real-world problems (a sample student project)
Villanova University was founded in 1842 by the Order of St. Augustine. To this day, Villanova’s Augustinian Catholic intellectual tradition is the cornerstone of an academic community in which students learn to think critically, act compassionately and succeed while serving others. There are more than 10,000 undergraduate, graduate and law students in the University’s six colleges.