{"id":78150,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/saint-gba334-module-3-assignment-2"},"modified":"2017-08-18T07:19:53","modified_gmt":"2017-08-18T07:19:53","slug":"saint-gba334-module-3-assignment-2","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/saint-gba334-module-3-assignment-2\/","title":{"rendered":"Saint GBA334 module 3 assignment"},"content":{"rendered":"<p>Homework unit 3<br \/> Chapter 4: 4-10, 4-13, 4-28, 4-30.<\/p>\n<p>4-10 The operations manager of a musical instrument distributor feels that demand for bass drums may be related to the number of television appearances by the popular rock group Green Shades during the preceding month. The manager has collected the data shown in the following table:<\/p>\n<p>DEMAND FOR GREEN SHADES<br \/> BASS DRUMS TV APPEARANCE<br \/> 3 3<br \/> 6 4<br \/> 7 7<br \/> 5 6<br \/> 10 8<br \/> 8 5<br \/> (a) Graph these data to see whether a linear equation might describe the relationship between the group\u2019s television shows and bass drum sales.<br \/> (b) Using the equations presented in this chapter, compute the SST, SSE, and SSR. Find the least squares regression line for this data.<br \/> (c) What is your estimate for bass drum sales if the Green Shades performed on TV six times last month?<\/p>\n<p>Problem 4-13<br \/> Students in a management science class have just received their grades on the first test. The instructor<br \/> has provided information about the first test grades in some previous classes as well as the final average<br \/> for the same students. Some of these grades have been sampled and are as follows:<\/p>\n<p>STUDENT 1 2 3 4 5 6 7 8 9<br \/> 1st test grade 98 77 88 80 96 61 66 95 69<br \/> Final average 93 78 84 73 84 64 64 95 76<\/p>\n<p>(a) Develop a regression model that could be used to predict the final average in the course based on<br \/> the first test grade.<br \/> (b) Predict the final average of a student who made an 83 on the first test.<br \/> (c) Give the values of r and for this model. Interpret the value of in the context of this problem.<br \/> Problem 4-28<br \/> Use the data in Problem 4-27 to develop a multiple linear regression model. How does this compare with each of the models in Problem 4-27?<br \/> Problem 4-30<br \/> A sample of nine public universities and nine private universities was taken. The total cost for the year (including room and board) and the median SAT score (maximum total is 2400) at each school were recorded. It was felt that schools with higher median SAT scores would have a better reputation and would charge more tuition as a result of that. The data is in the table below. Use regression to help answer the following questions based on this sample data. Do schools with higher SAT scores charge more in tuition and fees? Are private schools more expensive than public schools when SAT scores are taken into consideration? Discuss how accurate you believe these results are using information related the regression models.<br \/> Category Total Cost Median SAT<br \/> Public 21,700 1990<br \/> Public 15,600 1620<br \/> Public 16,900 1810<br \/> Public 15,400 1540<br \/> Public 23,100 1540<br \/> Public 21,400 1600<br \/> Public 16,500 1560<br \/> Public 23,500 1890<br \/> Public 20,200 1620<br \/> Private 30,400 1630<br \/> Private 41,500 1840<br \/> Private 36,100 1980<br \/> Private 42,100 1930<br \/> Private 27,100 2130<br \/> Private 34,800 2010<br \/> Private 32,100 1590<br \/> Private 31,800 1720<br \/> Private 32,100 1770<br \/> Chapter 5: 5-13, 5-15, 5-25, 5-27,<\/p>\n<p>5-13 Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD.<br \/> A 3-month moving average forecast was developed in the section on moving averages in the Table Below.<\/p>\n<p>MONTH ACTUAL SHED SALES 3-MONTH MOVING AVERAGE<br \/> January 10<br \/> February 12<br \/> March 13<br \/> April 16 (10 + 12 + 13)\/ 3 = 11.67<br \/> May 19 (12 + 13 + 16)\/ 3 = 13.67<br \/> June 23 (13 + 16 + 19)\/ 3 = 16.00<br \/> July 26 (16 + 19 + 23)\/ 3 = 19.33<br \/> August 30 (19 + 23 + 26)\/ 3 = 22.67<br \/> September 28 (23 + 26 + 30)\/ 3 = 26.33<br \/> October 18 (26 + 30 + 28)\/ 3 = 28.00<br \/> November 16 (30 + 28 + 18)\/ 3 = 25.33<br \/> December 14 (28 + 18 + 16)\/ 3 = 20.67<br \/> January \u2014 (18 + 16 + 14)\/ 3 = 16.00<\/p>\n<p>Wallace Garden Supply decides to forecast storage shed sales by weighting the past 3-months as follows:<br \/> WEIGHTS APPLIED PERIOD<br \/> 3 Last month<br \/> 2 Two months ago<br \/> 1 Three months ago<br \/> 3 \u00d7 Sales last month + 2 \u00d7 Sales two months ago + 1 \u00d7 Sales three months ago<br \/> 6 Sum of the weights<\/p>\n<p>Problem 5-15<br \/> Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the table attached. Develop a 3-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. Which method do you think is best?<\/p>\n<p>Problem 5-25<br \/> Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows:<br \/> Sales (1,000s) MONTH Sales (1,000s) MONTH<br \/> 11 January 14 August<br \/> 14 February 17 September<br \/> 16 March 12 October<br \/> 10 April 14 November<br \/> 15 May 16 December<br \/> 17 June 11 January<br \/> 11 July<\/p>\n<p>(a) Using a moving average with three periods, determine the demand for vacuum cleaners for next February.<\/p>\n<p>(b) Using a weighted moving average with three periods, determine the demand for vacuum cleans for February. Use 3, 2 and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively. For example, if you were forecasting the demand for February, November would have a weight of 1, December would have a weight of 2, and January would have a weight of 3.<\/p>\n<p>(c) Evaluate the accuracy of each of these methods.<\/p>\n<p>(d) What other factors might R. Lowenthal consider in forecasting sales?<\/p>\n<p>Problem 5-27<br \/> Emergency calls to Winter Park, Florida\u2019s 911 system, for the past 24 weeks are as follows: (Attached Excel Data) (a) Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week and use smoothing constant for forecasts=0.1 What is the forecast for the 25th week? (b) Reforecast each period using smoothing constant for forecasts= 0.6 (c) Actual calls during the 25th week were 85. Which smoothing constant provides a superior forecast?<br \/> Week Calls Week Calls Week Calls<br \/> 1 50 9 35 17 55<br \/> 2 35 10 20 18 40<br \/> 3 25 11 15 19 35<br \/> 4 40 12 40 20 60<br \/> 5 45 13 55 21 75<br \/> 6 35 14 35 22 50<br \/> 7 20 16 25 23 40<br \/> 8 30 16 55 24 65<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Homework unit 3 Chapter 4: 4-10, 4-13, 4-28, 4-30. 4-10 The operations manager of a musical instrument distributor feels that demand for bass drums may be related to the number of television appearances by the popular rock group Green Shades <a href=\"https:\/\/www.benedictsol.com\/blogs\/saint-gba334-module-3-assignment-2\/\" 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-78150","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/78150","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=78150"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/78150\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=78150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=78150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=78150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}