Linear Algebra with Spreadsheets: Vectors, Matrices & Systems of Equations

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Treat prices and weekly sales as vectors, compute revenue as a dot product, measure vector lengths and the angle between the product mixes of three stores.
• Add and subtract two sales matrices entry by entry and scale a matrix by a growth factor.
• Multiply a stores × products sales matrix by a products × (price, cost) matrix and read revenue, cost and profit per store from the product.
• Transpose a recipe matrix, use Aᵀ for parts needed and A for cost per product, and check that the identity matrix leaves a matrix unchanged.
• Compute 2×2 and 3×3 determinants, recognise a singular matrix from a dependent row and read an inverse with MINVERSE.
• Write a three-department production problem as A x = b, solve it with MINVERSE and MMULT and verify the answer.
• Push a bike fleet through a transition matrix day by day, compute a two-step probability with P² and solve for the long-run distribution.
• Fit a two-variable cost model by solving the normal equations with TRANSPOSE, MMULT and MINVERSE, and match the result with LINEST.