Wednesday:
Calculation_f18.xls Calculate the students' homework average, lab average,
test average (with a drop test). Calculate the weighted average for their overall average. Use VLOOKUP to assign
a letter grade.
Use the matrix approach in Excel to solve the following set of simultaneous, linear equations:
x + y + z = 6
2x + 3y + 4z = 17
-x + 2y + 3z = 1
Use Mathematica to make a 3d plot of cos((x2+y2)0.5) for
-4 < x < 4 and -4 < y < 4.
Plot3D[Cos[Sqrt[x^2 + y^2]], {x, -4, 4}, {y, -4, 4}, PlotRange -> All]
Due: Dec. 14
Regarding the final:
Material on final that has not previously been tested.
- Excel: Matrix (MINVERSE and MMULT)
- Excel: CONVERT
- Excel: sort data, print preparation (landscape, fit to pages, add headers)
- Mathematica: Logistic function
- All (Excel, R, Mathematica): "3D" (Surface) plots
Until I put in a final grade, homework and lab assignments can be submitted. Late assignments will
not receive full credit but will still help your grade. If I missed grading an assignment, then forward
your original email so I know the original submission was on time and that I should make the assignment
eligible for full credit.