Please answer the two questions with reference to the
half of the total score. The assignment is practicer fo
given for incomplete or incorrect answers if enough w
necessary to correctly asnwer all the questions. Mak
number, table or chart format. Do not hesitate to email
skills required. This is an individual assignment. You
your work in written eference to the context and the data provided. Each answer is worth
nt is practicer for your final exam for the class. Partial credit will be
wers if enough work or commentary is shown. For full score, it is not
questions. Make sure you label each answer, whether it is in text,
esitate to email me with questions about the assignment, or the Excel
ssignment. You may verbally discuss it with others, but do not share
work in written or electronic form. Create or find a data set that has seasonality, deseasonalize it and make a time series forecast. Show
the bias and MSE of the model. Create another data set and discuss if and how that could be used for
a causal forecast. Be specific, describe what your data represent and what the formulas do in a real
life context, different from the spreadsheet posted on Blackboard. Do not use time of the day or day
of the week as seasons, or price as a causal factor. recast. Show
d be used for
do in a real
e day or day For the project represented on the right, assume that all activity
durations are random. The numbers in weeks represent the mean of a
normal distribution. All standard deviations are equal to .5. The
formula to generate random numbers out of this distribution is
=NORM.INV(). So, for example, to generate the duration of activity A
you will type =MAX(0,NORM.INV(RAND(),4,0.5)). Simulate the project
for 10,000 and show the frequency distribution of the project
completion time using a bar chart (histogram). The Excel formula
=FREQUENCY() may be useful here. Google it and learn about array
formulas before use.

SuperTutor

(15)

Status NEW Posted 29 May 2017 12:05 AM My Price 10.00

-----------

Attachments

file 1496016894-Solutions file.docx preview (51 words )

S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e -----------Tha-----------nk -----------you----------- -----------

Not Rated(0)

• Buy Answer