AGBM 106 Exam 1-Excel with 100%
complete solutions graded A+ passed
Count - correct answer ✔✔=count (array, place)
How many data points are needed to add equilibrium lines? - correct answer ✔✔3-(price,0)
(price, quantity) (0, quantity)
How do we find the most precise equilibrium quantity? - correct answer ✔✔"QD-
QS"(referencing "QD" and "QS" equations, with a common "price" cell), goal seek to 0 by
changing "price"
Compliments are what sign in a demand equation? - correct answer ✔✔-
Substitutes are what sign in a demand equation? - correct answer ✔✔+
How do you get a dummy variable(for mode)? - correct answer ✔✔=if("cell"="quoted word"/#,
1(true), 0(false))
What are the three ways of finding the approximate a demand function? - correct answer ✔✔1.
Graphical Analysis
2. Linear Regression Analysis
3. Goodness of fit
How is graphical analysis used. - correct answer ✔✔Graph data as (price, demand), insert trend
line
complete solutions graded A+ passed
Count - correct answer ✔✔=count (array, place)
How many data points are needed to add equilibrium lines? - correct answer ✔✔3-(price,0)
(price, quantity) (0, quantity)
How do we find the most precise equilibrium quantity? - correct answer ✔✔"QD-
QS"(referencing "QD" and "QS" equations, with a common "price" cell), goal seek to 0 by
changing "price"
Compliments are what sign in a demand equation? - correct answer ✔✔-
Substitutes are what sign in a demand equation? - correct answer ✔✔+
How do you get a dummy variable(for mode)? - correct answer ✔✔=if("cell"="quoted word"/#,
1(true), 0(false))
What are the three ways of finding the approximate a demand function? - correct answer ✔✔1.
Graphical Analysis
2. Linear Regression Analysis
3. Goodness of fit
How is graphical analysis used. - correct answer ✔✔Graph data as (price, demand), insert trend
line
