Course Project Instructions
===========================
For 50 consecutive days in early Spring,
the numbers of Canadian geese...
Course Project Instructions
===========================
For 50 consecutive days in early Spring,
the numbers of Canadian geese and sparrows in a certain park
in Kentucky are recorded.
Geese
13, 16, 14, 12, 10, 10, 15, 10, 14, 12,
15, 13, 15, 11, 13, 14, 17, 15, 14, 11,
15, 15, 14, 10, 13, 13, 16, 10, 13, 10,
12, 13, 15, 13, 14, 15, 18, 16, 13, 11,
12, 15, 12, 13, 10, 15, 13, 13, 14, 13
Sparrows
45, 47,...
Excel Lab 2: Regression and Goal Seek
In this lab, you will use Excel to determine...
Excel Lab 2: Regression and Goal Seek
In this lab, you will use Excel to determine the equation of the
model which best fits a set of ordered pairs
obtained from data sets. You will enter data, graph the data, find
the equation for the regression model,
and then use that equation to make predictions for the dependent
variable. You will use the goal seek to make
predictions for the independent variable. Then you will consider
how accurate your predictions...
(a) Develop
proforma Project Income Statement Using Excel Spreadsheet
(b) Compute Net Project Cash
flows, NPV,...
(a) Develop
proforma Project Income Statement Using Excel Spreadsheet
(b) Compute Net Project Cash
flows, NPV, IRR and PayBack Period
(c) Develop Problem-Solving
and Critical Thinking Skills
1) Life Period of the
Equipment = 4 years
8) Sales for first year (1)
$ 200,000
2) New equipment cost
$ (200,000)
9) Sales increase per year
5%
3) Equipment ship &
install cost
$ (35,000)
10) Operating cost:
$ (120,000)
4) Related start up cost
$ (5,000)
(60 Percent of...