﻿ 美国留学生统计学方面课程作业辅导-statistics_paper代写_新西兰代写assignment_澳洲代写-论文哥代写

## 美國留學生統計學方面課程作業輔導-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%
------分隔線----------------------------

#### 在線客服  Badgeniuscs  