Skip to main content
SkillsCommons
You are currently using guest access (
Log in
)
MTH 245 - Math for Biological, Management, Social Science
Home
Courses
Mathematics
MTH 245
Credit Unit 1 Module 6
Competency Assessment: (CU1 M6) Linear Functions i...
Competency Assessment: (CU1 M6) Linear Functions in Excel Answer Key
Answer Key
(Google Doc)
Last modified: Tuesday, 6 July 2021, 2:35 PM
◄ Competency Assessment: (CU1 M6) Linear Functions in Excel
Jump to...
Jump to...
Announcements
Notes/Questions
Credit Unit 1 Introduction
Module 1 Introduction: (CU1 M1) Algebra and Percents
Reading: (CU1 M1) Algebra Basics and Percents
Self-check: (CU1 M1) Algebra Basics and Percents
Competency Assessment: (CU1 M1) Algebra Basics and Percents
Competency Assessment: (CU1 M1) Answer Key
Congratulations! (CU1 M1)
Module 2 Introduction: (CU1 M2) Excel Basics
Reading: (CU1 M2) Numbers and Formatting in Excel
Video: (CU1 M2) Excel Basics 1
Self-check: (CU1 M2) Excel Basics 1
Competency Assessment: (CU1 M2) Earthquakes and Format Numbers
Competency Assessment: (CU1 M2) Answer Key
Congratulations! (CU1 M2)
Module 3 Introduction: (CU1 M3) Create Interactive Tables in Excel
Reading: (CU1 M3) Interactive Tables in Excel
Video: (CU1 M3) Excel Basics 2 & 3
Self-check: (CU1 M3) Excel Basics 2 & 3
Competency Assessment: (CU1 M3) Tip and Tax Table
Competency Assessment: (CU1 M3) Answer Key
Competency Assessment: (CU1 M3) Credit Card Debt
Competency Assessment: (CU1 M3) Credit Card Debt Answer Key
Congratulations! (CU1 M3)
Module 4 Introduction: (CU1 M4) Excel as a Graphing Calculator
Reading: (CU1 M4) Excel as a Graphing Calculator
Video: (CU1 M4) Tables in Excel
Self-check: (CU1 M4) Tables in Excel
Competency Assessment: (CU1 M4) Excel Graphing
Competency Assessment: (CU1 M4) Excel Graphing Answer Key
Competency Assessment: (CU1 M4) Tables and Graphs
Competency Assessment: (CU1 M4) Tables and Graphs Answer Key
Congratulations! (CU1 M4)
Module 5 Introduction: (CU1 M5) Use Goal Seek in Excel
Reading: (CU1 M5) Solving Equations Using Goal Seek
Video: (CU1 M5) Goal Seek
Self-check: (CU1 M5) Goal Seek
Competency Assessment: (CU1 M5) Using Goal Seek
Competency Assessment: (CU1 M5) Using Goal Seek Answer Key
Competency Assessment: (CU1 M5) Goal Seek
Competency Assessment: (CU1 M5) Goal Seek Answer Key
Congratulations! (CU1 M5)
Module 6 Introduction: (CU1 M6) Linear Function Application
Reading: (CU1 M6) Linear Functions; Revenue, Cost & Profit
Video: (CU1 M6) Linear Functions PRC, Linear Functions in Excel
Self-check: (CU1 M6)
Competency Assessment: (CU1 M6) Linear Functions in Excel
Competency Assessment: (CU1 M6)
Congratulations! (CU1 M6)
Credit Unit Assessment: (CU1)
Credit Unit Assessment: (CU1) Answer Key
Credit Unit 2 Introduction
Module 1 Introduction: (CU2 M1) Graphing Functions in Excel
Reading: (CU2 M1) Piecewise Linear Functions
Video: (CU2 M1) Piecewise 2 Pieces, Piecewise 3 Pieces
Self-check: (CU2 M1)
Competency Assessment: (CU2 M1) Piecewise Functions and IF Statements
Competency Assessment: (CU2 M1) Piecewise Functions and IF Statements Answer Key
Competency Assessment: (CU2 M1) Functions and IF Statements
Competency Assessment: (CU2 M1) Functions and IF Statements Answer Key
Congratulations! (CU2 M1)
Module 2 Introduction: (CU2 M2) Scatter Plots and Linear Regression in Excel
Reading: (CU2 M2) Regression Lines
Video: (CU2 M2) Lin Reg in Excel 10
Self-check: (CU2 M2)
Competency Assessment: (CU2 M2) Regression Line Predictions
Competency Assessment: (CU2 M2) Regression Line Predictions Answer Key
Competency Assessment: (CU2 M2) Find the Linear Regression Line
Competency Assessment: (CU2 M2) Linear Regression Line Answer Key
Congratulations! (CU2 M2)
Module 3 Introduction: (CU2 M3) Linear Families and Isolines
Reading: (CU2 M3) Linear Functions as Families and Systems
Video: (CU2 M3) Isos and Ineqs, System of Eqs 2 Variables
Self-check: (CU2 M3)
Competency Assessment: (CU2 M3) Graphing
Competency Assessment: (CU2 M3) Graphing Answer Key
Competency Assessment: (CU2 M3) Graphing Isolines and Systems of Inequality
Competency Assessment: (CU2 M3) Graphing Isolines/Systems of Inequality Answer Key
Congratulations! (CU2 M3)
Module 4 Introduction: (CU2 M4) Linear programming
Reading: (CU2 M4) Linear Programming and Optimizing Systems
Video: (CU2 M4) Linear Programming Set Up Ex 1
Self-check: (CU2 M4)
Competency Assessment: (CU2 M4) Optimizing Equations
Competency Assessment: (CU2 M4) Optimizing Equations Answer Key
Competency Assessment: (CU2 M4) Graphing Inequalities and Optimizing Equations
Competency Assessment: (CU2 M4) Graphing Inequalities/Optimizing Equations Answer Key
Congratulations! (CU2 M4)
Module 5 Introduction: (CU2 M5) Linear Programming Continued
Reading: (CU2 M5) Linear Programming in Excel
Video: (CU2 M5) Linear Programming Solver Ex 1, Linear Programming Solver Ex 2
Self-check: (CU2 M5)
Competency Assessment: (CU2 M5) Mining Sensitivity Report
Competency Assessment: (CU2 M5) Mining Sensitivity Report Answer Key
Competency Assessment: (CU2 M5) Inequalities and Optimizing
Competency Assessment: (CU2 M5) Inequalities and Optimizing Answer Key
Congratulations! (CU2 M5)
Credit Unit Assessment: (CU2)
Credit Unit Assessment: (CU2) Answer Key
Credit Unit 3 Introduction
Module 1 Introduction: (CU3 M1) Theoretical Probability - Vocabulary and Rules
Reading: (CU3 M1) Randomness and Probability
Self-check: (CU3 M1)
Competency Assessment: (CU3 M1) Probability
Competency Assessment: (CU3 M1) Probability Answer Key
Competency Assessment: (CU3 M1)
Congratulations! (CU3 M1)
Module 2 Introduction: (CU3 M2) Empirical Probabilities
Reading: (CU3 M2) Empirical Probability
Video: (CU3 M2) Intro to Empirical
Self-check: (CU3 M2)
Competency Assessment: (CU3 M2) Probability
Competency Assessment: (CU3 M2) Probability Answer Key
Competency Assessment: (CU3 M2)
Competency Assessment: (CU3 M2) Assessment Answer Key
Congratulations! (CU3 M2)
Module 3 Introduction: (CU3 M3) Empirical Probabilities Continued
Reading: (CU3 M3) Modeling Randomness
Video: (CU3 M3) Modeling Randomness, More Empirical Examples
Competency Assessment: (CU3 M3) Coin Toss
Competency Assessment: (CU3 M3) Coin Toss Answer Key
Competency Assessment: (CU3 M3)
Competency Assessment: (CU3 M3) Assessment Answer Key
Congratulations! (CU3 M3)
Module 4 Introduction: (CU3 M4) Theoretical vs. Empirical Probability Distributions
Reading: (CU3 M4) Random Variables and Probability Distributions
Self-check: (CU3 M4)
Competency Assessment: (CU3 M4) Gambling
Competency Assessment: (CU3 M4) Gambling Answer Key
Competency Assessment: (CU3 M4)
Competency Assessment: (CU3 M4) Assessment Answer Key
Congratulations! (CU3 M4)
Credit Unit Assessment: (CU3)
Credit Unit Assessment: (CU3) Answer Key
Credit Unit 4 Introduction
Module 1 Introduction: (CU4 M1) Using Excel to Calculate Descriptive Statistics
Reading: (CU4 M1) Descriptive Statistics
Self-check (CU4 M1)
Competency Assessment: (CU4 M1) Descriptive Statistics
Competency Assessment: (CU4 M1) Descriptive Statistics Answer Key
Congratulations! (CU4 M1)
Module 2 Introduction: (CU4 M2) Expected Value
Reading: (CU4 M2) Expected Value
Self-check: (CU4 M2)
Competency Assessment: (CU4 M2) Expected Value
Competency Assessment: (CU4 M2) Expected Value Answer Key
Competency Assessment: (CU4 M2)
Competency Assessment: (CU4 M2) Assessment Answer Key
Congratulations! (CU4 M2)
Module 3 Introduction: (CU4 M3) Binomial Distribution
Reading: (CU4 M3) Binomial Distribution
Video: (CU4 M3) Binomial Distribution
Self-check: (CU4 M3)
Competency Assessment: (CU4 M3) Binomial Distribution
Competency Assessment: (CU4 M3) Binomial Distribution Answer Key
Competency Assessment: (CU4 M3)
Competency Assessment: (CU4 M3) Assessment Answer Key
Congratulations! (CU4 M3)
Module 4 Introduction: (CU4 M4) Normal Distribution
Reading: (CU4 M4) The Normal Distribution
Video: (CU4 M4) Normal Distribution
Self-check: (CU4 M4)
Competency Assessment: (CU4 M4) Normal Distribution
Competency Assessment: (CU4 M4) Normal Distribution Answer Key
Competency Assessment: (CU4 M4)
Competency Assessment: (CU4 M4) Assessment Answer Key
Congratulations! (CU4 M4)
Credit Unit Assessment: (CU4)
Credit Unit Assessment: (CU4) Answer Key
End of Course
Resources and Citations
Course Citations
Competency Assessment: (CU1 M6) ►