{"id":43894,"date":"2022-03-21T13:10:45","date_gmt":"2022-03-21T13:10:45","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/needing-help-with-data-analysis-forecasting-with-smoothing-management-science-through-spreadsheets-southern-new-hampshire-university\/"},"modified":"2022-03-21T13:10:45","modified_gmt":"2022-03-21T13:10:45","slug":"needing-help-with-data-analysis-forecasting-with-smoothing-management-science-through-spreadsheets-southern-new-hampshire-university","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/needing-help-with-data-analysis-forecasting-with-smoothing-management-science-through-spreadsheets-southern-new-hampshire-university\/","title":{"rendered":"Needing help with-data analysis: forecasting with smoothing | management science through spreadsheets | Southern New Hampshire University"},"content":{"rendered":"<div>\n<p>Hello all,<\/p>\n<p>I&#8217;m really lost on this week 6 sample assignment. \u00a0See prompt:<\/p>\n<p>\u00a0Prompt: 10.24 \u00a0The choice of the smoothing constants, \u03b1 and \u03b2, has a considerable effect on the accuracy of the forecasts obtained by using exponential smoothing with trend. \u00a0<\/p>\n<p>For each of the following time series, set \u03b1 = 0.2 and then compare MAD obtained with \u03b2 = 0.1, 0.2, 0.3, 0.4, and 0.5.\u00a0<\/p>\n<p>Begin with initial estimates of 50 for the \u00a0average value and 2 for the trend. \u00a0a. 52, 55, 55, 58, 59, 63, 64, 66, 67, 72, 73, 74 \u00a0b. 52, 55, 59, 61, 66, 69, 71, 72, 73, 74, 73, 74 \u00a0c. 52, 53, 51, 50, 48, 47, 49, 52, 57, 62, 69, 74 \u00a0<\/p>\n<p>Step 1) Change the Beta Value and create a graph for each of the 5 given Beta values in each of the 3 databases. You could also create one graph per tab with 5 \u00a0separate lines. The graphs is already part of the spreadsheet, you need to create the lines for the Beta values. There is no need to create additional tabs in the \u00a0spreadsheet. \u00a0<\/p>\n<p>Step 2) Briefly describe the impact of the Beta value on the 3 databases. You should submit a written paragraph with explanation either in a separate Tab in the \u00a0Excel Template for a separate word document. No references needed. \u00a0**************<\/p>\n<p>I&#8217;ve uploaded the page from the assignment book, screenshot 1 is the data sets while screenshot 2 is a data chart with sales metrics. \u00a0The 2nd I think is only for reference as needed.<\/p>\n<p>Also attached is the work template we&#8217;re suppose to complete. \u00a0I&#8217;d like the full steps and template done if possible. \u00a0Thanks so much in advance!<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Hello all, I&#8217;m really lost on this week 6 sample assignment. \u00a0See prompt: \u00a0Prompt: 10.24 \u00a0The choice of the smoothing constants, \u03b1 and \u03b2, has a considerable effect on the accuracy of the forecasts obtained by using exponential smoothing with trend. \u00a0 For each of the following time series, set \u03b1 = 0.2 and then [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-43894","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/43894","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=43894"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/43894\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=43894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=43894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=43894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}