Good day,

My class is called Data Analysis and Business Analytics, which deals with Statistics. My assignment (which consists of 15 questions) deals with quarterly indexes, regression, seasonal indexes, linear trends, exponential trends, quadratic trends, moving averages, (must use Megastat

Chrome File Edit View History Bookmarks People Tab Window Help 5 ) Wed 7:55 PM . . . When You Feel Like Giving 1 x | eCampus: Home x Content Wk 6 - Practice: Wk 6 Exercise x + newconnect.mheducation.com/flow/connect.html III Apps Morgan State Uni. Wk 6 - Practice: Wk 6 Exercises [due Sat] i Saved Help Save & Exit Submit Check my work 4 Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 1-Apr-04 1 . 8564 13-Apr-04 1 . 8160 23-Apr-04 1. 7674 2 2-Apr-04 1. 8293 14-Apr-04 1 . 7902 26-Apr-04 1. 7857 points 5-Apr-04 1 . 8140 15-Apr-04 1. 7785 27-Apr-04 1. 7925 6-Apr-04 1. 8374 16-Apr-04 1 . 8004 28-Apr-04 1. 7720 7-Apr-04 1. 8410 19-Apr-04 1. 8055 29-Apr-04 1. 7751 8-Apr-04 1. 8325 20-Apr-04 1 . 7914 30-Apr-04 1 . 7744 9-Apr-04 1. 8322 21-Apr-04 1. 7720 3-May-04 1 . 7720 12-Apr-04 1. 8358 22-Apr-04 1 . 7684 4-May-04 1 . 7907 Book 5-May-04 1. 7932 13-May-04 1 . 7584 21-May-04 1 . 7880 6-May-04 1 . 7941 14-May-04 1. 7572 24-May-04 7-May-04 17-May-04 25-May-04 1. 7908 1 . 7842 1. 7695 1. 8135 10-May-04 1 . 7723 18-May-04 1. 7695 26-May-04 1. 8142 References 11-May-04 1. 7544 19-May-04 1. 7827 27-May-04 1 . 8369 12-May-04 1. 7743 20-May-04 1. 7710 28-May-04 1. 8330 Click here for the Excel Data File (b) Perform simple exponential smoothing (using Excel's Data Analysis or other software such as Minitab) using a = .05, .10, .20, and .50. The degree of smoothing | (Click to select) : dramatically as a is increased. (c) Which value of a do you prefer? (Round your answers to 2 decimal places.) a = (d) Is exponential smoothing appropriate for this kind of data? (Click to select) ; Mc graw Education L MAY 27 X W PExcel File Edit View Insert Format Tools Data Window Help . . . THE 5 5 . 2 Wk 6 Item 4 Exchange Rate Data 5 Sat 9:52 PM Q = Home Insert Draw Page Layout Formulas Data Review View Acrobat ? Tell me Q @ my d cut Arial 10 AA Copy 29 v 2b Wrap Text v Share Comments General Normal Bad Good Neutral Paste Calculation AutoSum . Format BIUVV LAV = = = = E Merge & Center v $ ~ % 9 68 :28 Conditional Format Formatting as Table Check Cell Explanatory T. Input Linked Cell Note Insert Delete Format Fill X Clear Filter Select Ideas Sensitivity Create and Share G5 Adobe PDF D Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling o AA AB AC AD AG AH AJ AK AL AM AN AO AP AQ AR AS AT AU 1-Apr-04 1.8564 1.8293 15-Apr-04 16-Apr Note: Print area is truncated because files is long. 20-Apr-04 21-Apr Source: Federal Reserve Board of Governors 22-Apr04 (http:/www.federalreserve.gov) 26-Apr 28-May-04 8330 Data Extra Sheet | + 100% 30