?p???s? ???

1
?p???s? ???ß??µ?t?? µe ?/?

• ?. ?s?µa??p?????
• G. ??aµpat???

2
St????

• ?p??t?s? ßas???? ??a??t?t?? ???s?? t??
  ??e?t??????? ?p?????st?
• ?p???s? p??ß??µ?t?? p?? s??a?t? ??a? µ??a????? ?
  d?????t??? st??e??? st?? p????
• ?fa?µ??? t?? ???se?? se p?a?t??? p??ß??µata

• ??µ???s? te?????? efa?µ???? t?? Excel se
  p??ß??µata p?s?t???? a????s?? ?p??
• ?a???s?as? ded?µ???? (p??a?e? - ??af????
  pa?ast?se??)
• Stat?st??? a????s?
• ???sa?µ??? e??s?se??
• ?????s? ?????se????
• ??????µ??? a???????s?
• ???st?p???s?

3
?e??e??µe?a

• ??sa???? st?? a????s? ded?µ???? ?a? t? ????
  ap?f?se??
• ??sa????
• ????d?? p?s?t???? a????s??
• ???t??a ????st???? f?????
• ?a?a?t???st??? pa?ade??µata

• ?e????af??? a????s? ded?µ????
• ???a?e? ?ata??µ?? s????t?t??, a????st????
  ?ata??µ??
• Stat?st??? µe????
• ?st????µµata
• ??d? ?ata??µ??
• ??a???µµata d?asp????
• ??a???µµata ?????se????

4
?e??e??µe?a

• ???a?e? µetaß??t?? ?a? ?ata??µ?? p??a??t?ta?
• ?ata??µ?? p??a??t?ta?
• ??a???t?? ?ata??µ?? p??a??t?ta?
• ??a???t?? ?ata??µ?? p??a??t?ta? d?? e?a?t?µ????
  µetaß??t??
• ??e???t?te? t??a?e? µetaß??t??

• ??d???? ?ata??µ?? p??a??t?ta?
• ?????µ??? ?ata??µ?
• ?p?????sµ?? µe t? d????µ??? ?ata??µ?
• S??e?e?? ?ata??µ?? p??a??t?ta?
• ?a?????? ?ata??µ?
• ?p?????sµ?? µe t?? ?a?????? ?ata??µ?

5
?e??e??µe?a

• ??t?µ?s? pa?aµ?t??? ?a? ??e???? ?p???se??
• ?ata??µ? de??µat???? µ?s?? t?µ??, ?e?t???? ???a??
  ?e???µa
• ??ast?µata eµp?st?s???? ??a t? µ?s? t?µ?
• ??ast?µata eµp?st?s???? ??a ???e? pa?aµ?t????
• Stat?st???? ?p???se??
• ??e???? ?p???se?? ??a ???e? pa?aµ?t????

• ???sa?µ??? ?aµp???? ?a? a????s? pa???d??µ?s??
• ??d? pa???d??µ?s??
• ??a???µµata d?asp????- s?s??t?s?
• ?p?? ??aµµ??? pa???d??µ?s?
• ????ap?? ??aµµ??? pa???d??µ?s?
• ??-??aµµ??? pa???d??µ?s?

6
?e??e??µe?a

• ?e?????? a??st?p???s??
• ???f?p???s? p??ß??µ?t?? a??st?p???s?? st? Excel
• ???ß??µa a??µ???? (??aµµ???? p????aµµat?sµ??)
• ????????s? ep??d?s?? (a???a??? p????aµµat?sµ??)
• ??a?e???s? ?a?t?f??a???? (µ?-??aµµ????
  p????aµµat?sµ??)
• ???st?p???s? d??t???

• ?e?????? p??s?µ???s??
• ????? p??s?µ???s??
• ?a?a???? t??a??? a???µ??
• ???ß??µa pa?a??e????
• ???t??? ??????µ???? a???????s?? ep??d?s??

7
?e??e??µe?a

• ???????t???a??? ?a??µat???? ?????aµµat?sµ??
• ?da???? s?µe??
• ??a??? ??se??, ?aµp??? Trade-off
• ?????aµµat?sµ?? st????
• ??-??aµµ???? p??????t???a??? p????aµµat?sµ??

• ???????t???a?? ?????s?
• ??ad??as?a a?a??t???? ?e?????s??
• ?p?????sµ?? ßa???
• ?p?????sµ?? ep?d?se??
• ???a?e?? AquaDT

8
?e??e??µe?a

• ?????aµµat?sµ?? st? Excel
• ? ???ssa p????aµµat?sµ?? Visual Basic for
  Applications
• ??µ??????a ?a? e?t??es? µa???e?t????
• ??µ??????a p??sa?µ?sµ???? s??a?t?se??
• ??µ??????a ????????µ???? efa?µ????
• ?? e??a?e?? RetScreen

9
???te???µe?? ??ß?????af?a

• ?e?????? ?????s?? ?ed?µ???? ????? ?p?f?se?? µe
  ???s? Microsoft Excel. ?. ?s?µa??p?????,
  G.??aµpat???. ??d?se?? ?apas?t?????. 2002
• Data Analysis Decision Making with Microsoft
  Excel. S.C. Albright, W.L. Winston, C. Zappe.
  Duxbury Press. 1999
• Data Analysis with Microsoft Excel. K.N. Berk, O.
  Carey. Duxbury Press. 1998
• Management Science Spreadsheet Modeling and
  Applications. W.L. Winston, S.C. Allbright.
  Duxbury Press. 1997

• Excel Models for Business and Operations
  Management. J.F. Barlow. John Wiley Sons. 1999
• Spreadsheet Tools for Engineers. B.S. Gottfried.
  McGraw-Hill. 1988
• ??????t??? ?p?st?µ? ???? ?p??e???µat????
  ?p?f?se?? st?? ???????a t?? ?????f???a?. G.
  ??ast????. ??d?se?? ??a?. Staµ?????. 2000