## 美国留学生统计学方面课程作业辅导-statistics

 美国留学生统计学方面课程作业辅导-statistics       Demonstrate an ability to use Excel to build simple decision models. Using Excel, you will build a set of models designed to simulate a series of decisions along a supply chain.     Format: Keep everything in one Excel workbook, composed of several worksheets. Be sure to label the  tab at the bottom of each worksheet with an appropriate short titl   Worksheet #1 TITLE   The first worksheet will contain your name, date, “DSCI-305-xx” (where “xx” is  your section number – 01 or 03 or 50) AND your student ID number   The first worksheet will also contain a cell labeled “ANSWER” followed by a number. In this cell you will place the result of calculations you make on other worksheets. (You will be told later exactly which result to put in the ANSWER cell.) Your final answer here will be copied from Worksheet #7.   The first worksheet will also contain a cell labeled “INTERPRETATION.”  In this cell you will type a short statement of what your answer means in a practical sense.   Worksheets 2 through 7 will contain various models. Each model must be generalized so that it works for any set of input values, not some specific set. You must use Excel features to calculate these values; do not simply use Excel as a typewriter.ontain您的姓名，日期，“DSCI-305-XX”（“XX” 您的节数 - 01或03或50）和你的学生身份证号码   第一个工作表，也将包含一个细胞标记后跟一个数字的“答案”。 在这个单元中，您将放置你做其他工作表计算的结果。 （你会被告知以后完全，结果把在答题细胞）。 你最终的答案将被复制表＃7。   第一个工作表也将包含一个细胞标记“解释。” 在这个单元中，你将键入你的答案意味着在实际意义上的简短陈述。   工作表2到7将包含各种型号。每个模型都必须是广义的，它适用于任何一组输入值，而不是一些特定的一组。您必须使用Excel来计算这些值的功能，不只是简单地使用Excel作为一台打字机   Worksheet #2 Forecasting and Forecast Accuracy Inputs: (1) a series of up to 18 historical time periods [given] (2) two different alpha values [given] Process: Make four different forecasts using the four methods in the next paragraph; measure the accuracy of each method. Outputs: (1) forecasts for the 19th period using these methods: (a) a 3-period moving average (b) a 5-period moving average (c) exponential smoothing with alpha = A (d) exponential smoothing with alpha = B (2) MAD calculations using periods 7 through 18 only   Worksheet #3 Expected Value Inputs: (1) the output from Worksheet #2, methods (1a-1d) (2) four different probabilities, matched to input (1) [given] Process: Calculate one EV from the four inputs in the previous paragraph. Outputs: (1) a single Expected Value calculation   Worksheet #4 Inventory / EOQ Inputs: (1) let Demand = the output (1) from Worksheet #3 (2) input cells for Ordering Cost and Carrying Cost [given] Process: Calculate EOQ and Orders Per Year using the basic method. Outputs: (1) EOQ using the Basic model (2)  Orders Per Year using the Basic model   Worksheet #5 Distribution (LP method) Inputs: (1) let Demand #1 = the EOQ output from Worksheet #4 (2) let Demand #2 = best forecast (using MAD), from Worksheet #2 DIVIDED BY Orders Per Year, from Worksheet #4 (3) input cells for two other Demand values [given] (5) input cells for three Supply values [given] (6) twelve cells for Cost Coefficients [given] Process: Using Solver, calculate twelve Decision Variable values, Xij. Outputs: (1) twelve cells, one for each Decision Variable HINT: Each Decision Variable represents a “from-to” quantity, where the “from-to” is identified by “i-j”.   Worksheet #1 ANSWER CELL Your answer will be ONE of the outputs from Worksheet #5 [given]   Method: Models for this project should be variations of the same models you have done earlier as homework exercises. The difference is we are now “chaining” them together to simulate a series of related decisions. Be sure to make your models general enough to work with any set of values, within the limits described above.   Using the Moodle file labeled Individual Input Values, locate your name and use your personal values as inputs to your models. Assuming that you have already validated your models, you will simply plug in the assigned numbers, interpret and revise your models as needed, and read your answer.   HINT: Design your models so that the output of one “flows” automatically to the input of the next (wherever it is needed). If you do that, then the “answer” cell on Worksheet #1 will be automatically populated with the correct answer.     1 Build and solve your models using the instructions above.   2 When you are satisfied with your work, click your cursor on the cell at the top left corner of  Worksheet #1. Then click “save” and end Excel. (This way, when I open the file, it will open  on the page with your name and answer.) Your saved file name should consist of your class section,  last name, and first name (Example: 03 Smith Susan).   3 Send an email to wgarrett@slu.edu with the subject line “305 Project” and attach your saved file. No other content is necessary.提示：设计的模型，使输出的一个“流动”自动输入下一个（在需要的地方）。如果你这样做，那么细胞表＃1“答案”会自动填入正确的答案。     1建立并使用上述指导解决您的模型。   2当你与你的工作感到满意，请单击左上角光标对细胞 表＃1。然后点击“保存”和结束的Excel。 （这样一来，当我打开文件时，它会打开 页面上您的姓名和答案。）你保存的文件名应该由你的类部分， 姓氏和名字（例如：03史密斯苏珊）。   3发送电子邮件至wgarrett@slu.edu的主题行“305工程”和附上您保存的文件。 没有任何其他的内容是必要的。     (责任编辑：selinashen)

(0)
0%

(0)
0%
------分隔线----------------------------