Monday:
Lab 23A. Calculation.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.
Lab 23B. 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
Lab 23C. 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]
Lab 23D. Use the data in KleiberData.xls to make an XY-Scatter Graph and fit it to a power law.
Repeat the exercise in R and in Mathematica. (Data from
http://faculty.bard.edu/belk/math314/KleiberPaper.pdf)
Other formats
{{0.021, 3.6},{0.282, 28.1},{0.41, 35.1},{2.98, 167},{1.52, 83},{2.46, 119},{3.57, 164},{4.33, 191},{5.33, 233},{3, 152},{4.2, 207},{6.6, 288},{14.1, 534},{24.8, 875},{23.6, 872},{36, 800},{38, 1090},{46.4, 1254},{46.8, 1330},{57.2, 1368},{54.8, 1224},{57.9, 1320},{300, 4221},{435, 8166},{482, 7754},{600, 7877}}
(0.021, 0.282, 0.41, 2.98, 1.52, 2.46, 3.57, 4.33, 5.33, 3, 4.2, 6.6, 14.1, 24.8, 23.6, 36, 38, 46.4, 46.8, 57.2, 54.8, 57.9, 300, 435, 482, 600)
(3.6, 28.1, 35.1, 167, 83, 119, 164, 191, 233, 152, 207, 288, 534, 875, 872, 800, 1090, 1254, 1330, 1368, 1224, 1320, 4221, 8166, 7754, 7877)
Due: Dec. 6
