Show work (excel if possible but show formulas you used in
excel):
If I buy a new car and pay $399 a month for 5 years and the
maintenance costs are $50 the first year and increase by $200 a
year for each year after that, how much money would I have to
barrow today at a nominal interest rate of 9% to cover my monthly
payment and my yearly maintenance bill?
Show work (excel if possible but show formulas you used in
excel):
If I buy a new car and pay $399 a month for 5 years and the
maintenance costs are $50 the first year and increase by $200 a
year for each year after that, how much money would I have to
barrow today at a nominal interest rate of 9% to cover my monthly
payment and my yearly maintenance bill?
Please explain your answers and use Excel to show the
excel formula you used to get your solution.
6. A manufacturing process produces connecting rods
whose diameter is normally distributed with mean 1.495 cm and
standard deviation .05 cm. In what range will the “middle 80%” of
the diameters lie? What about the “middle 98%”?
Explain why learning Excel could be useful outside of the work
environment.
Which unit concept did you think was the most difficult to
learn? Describe what you needed to do to clarify that concept. Add
the helpful information or video link if applicable.
Most important in the work below is to show THE FORMULA'S USED
IN EXCEL especially for the table asked to be built in (c).
5. According to a recent study, 9% of adults have been diagnosed
with diabetes. 8 adults are randomly selected and then each is
tested to see if she or he has diabetes. Use this situation to
answer the parts below.
(a) Recognizing that this is a binomial situation, give the
meaning S and F in this...
show Excel ( show all work including formulars
)
You are considering an investment in the stock market and have
identified two potential stocks, they are Westpac Banking Corp.
(ASX: WBC) and Singapore Airlines Ltd. (SGX: C6L). The historical
prices for the past 10 years are shown in the table below.
in the table below.
Year
ASX: WBC
SGX: C6L
2009
23.70
13.82
2010
22.85
14.76
2011
21.01
11.1
2012
27.85
10.99
2013
30.66
9.59
2014
34.23
12.65
2015
30.85...
PLEASE SHOW WORK IN EXCEL THANK YOU!
Green-Log Manufacturing
Capital Budgeting Analysis
In 1997 Michelle Green started Green-Log Manufacturing, a
company dedicated to manufacturing environmental friendly man made
logs that can be burned in fire places, fire pits in the backyard,
and when camping. The logs are made from environmental friendly
products like cardboard and clean wax and emit fewer greenhouse
gases and less harsh chemicals. The logs come in three pound and
five pound sizes. Green-logs are also available...
Evaluate each integral in and explain why you used the method
you did. ∫ ?11 ??? ( ?/z3 ) ??, where ? is
the perimeter of a square with vertices?1 =?+?,
?2 =−?+?, ?3 =−?−?, and
?4=?−?.
Show work and explain how you got your answer, do not just post
an excel spreadsheet with answers please.
You are deciding between two mutually exclusive investment
opportunities. Both require the same initial investment of
$ 10.3
million. Investment A will generate
$ 2.18
million per year (starting at the end of the first year) in
perpetuity. Investment B will generate
$ 1.51
million at the end of the first year, and its revenues will
grow at
2.2 %
per...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!!
SHOW CALCULATIONS / FORMULAS IN
EXCEL!!!!!!!!
Voters arrive at a polling station at an average of 4 per minute
(Poisson) where the service rate is 50 per hour (Poisson).
a. What is the average number of voters in the system with 5
voter booths? (10 pts)
b. What is the minimum number of voting booths needed to keep
the average time in the system under three minutes? (10 pts)
PLEASE SHOW ALL WORK IN...