{"id":122148,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/have-two-ms-excel-assignment-i-need-help-with"},"modified":"2017-08-12T07:23:09","modified_gmt":"2017-08-12T07:23:09","slug":"have-two-ms-excel-assignment-i-need-help-with","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/have-two-ms-excel-assignment-i-need-help-with\/","title":{"rendered":"Have two MS Excel Assignment I need help with"},"content":{"rendered":"<p>Here&nbsp;are the basic of the assignment:<\/p>\n<p>Question 10-50<\/p>\n<p>A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand for clubs. The file P10_50.xlsx contains the price of a set of clubs and the monthly sales.<\/p>\n<p>a)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Assume the only factor influencing monthly sales is price. Fit the following three curves to these data: linear (Y = a + bX), exponential (Y = abX), and multiplicative (Y = aXb). Which equation fits the data best?<\/p>\n<p>b)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Interpret your best-fitting equation.<\/p>\n<p>c)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using the best-fitting equation, predict sales during a month in which the price is $470.<\/p>\n<p>Question 12-64<\/p>\n<p>Let Yt be the sales during month t (in thousands of dollars) for a photography studio, and let Pt be the price charged for portraits during month t. The data are in the file P11_45.xlsx. Use regression to fit the following model to these data:<\/p>\n<p>Yt = a + b1Yt\u22121 + b2Pt + et<\/p>\n<p>This equation indicates that last month\u2019s sales and the current month\u2019s price are explanatory variables. The last term, et, is an error term. a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If the price of a portrait during month 21 is $10,<\/p>\n<p>what would you predict for sales in month 21? b.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Does there appear to be a problem with<\/p>\n<p>autocorrelation of the residuals?<\/p>\n<p>63.<\/p>\n<p>59.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here&nbsp;are the basic of the assignment: Question 10-50 A golf club manufacturer is trying to determine how the price of a set of clubs affects the demand for clubs. The file P10_50.xlsx contains the price of a set of clubs <a href=\"https:\/\/www.benedictsol.com\/blogs\/have-two-ms-excel-assignment-i-need-help-with\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-122148","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/122148","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=122148"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/122148\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=122148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=122148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=122148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}