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 during the preceding month. The manager has collected the data shown in the following table:
DEMAND FOR GREEN SHADES
BASS DRUMS TV APPEARANCE
3 3
6 4
7 7
5 6
10 8
8 5
(a) Graph these data to see whether a linear equation might describe the relationship between the group’s television shows and bass drum sales.
(b) Using the equations presented in this chapter, compute the SST, SSE, and SSR. Find the least squares regression line for this data.
(c) What is your estimate for bass drum sales if the Green Shades performed on TV six times last month?
Problem 4-13
Students in a management science class have just received their grades on the first test. The instructor
has provided information about the first test grades in some previous classes as well as the final average
for the same students. Some of these grades have been sampled and are as follows:
STUDENT 1 2 3 4 5 6 7 8 9
1st test grade 98 77 88 80 96 61 66 95 69
Final average 93 78 84 73 84 64 64 95 76
(a) Develop a regression model that could be used to predict the final average in the course based on
the first test grade.
(b) Predict the final average of a student who made an 83 on the first test.
(c) Give the values of r and for this model. Interpret the value of in the context of this problem.
Problem 4-28
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?
Problem 4-30
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.
Category Total Cost Median SAT
Public 21,700 1990
Public 15,600 1620
Public 16,900 1810
Public 15,400 1540
Public 23,100 1540
Public 21,400 1600
Public 16,500 1560
Public 23,500 1890
Public 20,200 1620
Private 30,400 1630
Private 41,500 1840
Private 36,100 1980
Private 42,100 1930
Private 27,100 2130
Private 34,800 2010
Private 32,100 1590
Private 31,800 1720
Private 32,100 1770
Chapter 5: 5-13, 5-15, 5-25, 5-27,
5-13 Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD.
A 3-month moving average forecast was developed in the section on moving averages in the Table Below.
MONTH ACTUAL SHED SALES 3-MONTH MOVING AVERAGE
January 10
February 12
March 13
April 16 (10 + 12 + 13)/ 3 = 11.67
May 19 (12 + 13 + 16)/ 3 = 13.67
June 23 (13 + 16 + 19)/ 3 = 16.00
July 26 (16 + 19 + 23)/ 3 = 19.33
August 30 (19 + 23 + 26)/ 3 = 22.67
September 28 (23 + 26 + 30)/ 3 = 26.33
October 18 (26 + 30 + 28)/ 3 = 28.00
November 16 (30 + 28 + 18)/ 3 = 25.33
December 14 (28 + 18 + 16)/ 3 = 20.67
January — (18 + 16 + 14)/ 3 = 16.00
Wallace Garden Supply decides to forecast storage shed sales by weighting the past 3-months as follows:
WEIGHTS APPLIED PERIOD
3 Last month
2 Two months ago
1 Three months ago
3 × Sales last month + 2 × Sales two months ago + 1 × Sales three months ago
6 Sum of the weights
Problem 5-15
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?
Problem 5-25
Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows:
Sales (1,000s) MONTH Sales (1,000s) MONTH
11 January 14 August
14 February 17 September
16 March 12 October
10 April 14 November
15 May 16 December
17 June 11 January
11 July
(a) Using a moving average with three periods, determine the demand for vacuum cleaners for next February.
(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.
(c) Evaluate the accuracy of each of these methods.
(d) What other factors might R. Lowenthal consider in forecasting sales?
Problem 5-27
Emergency calls to Winter Park, Florida’s 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?
Week Calls Week Calls Week Calls
1 50 9 35 17 55
2 35 10 20 18 40
3 25 11 15 19 35
4 40 12 40 20 60
5 45 13 55 21 75
6 35 14 35 22 50
7 20 16 25 23 40
8 30 16 55 24 65
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer Saint GBA334 module 3 assignment
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 during the preceding month. The manager has collected the data shown in the following table:
DEMAND FOR GREEN SHADES
BASS DRUMS TV APPEARANCE
3 3
6 4
7 7
5 6
10 8
8 5
(a) Graph these data to see whether a linear equation might describe the relationship between the group’s television shows and bass drum sales.
(b) Using the equations presented in this chapter, compute the SST, SSE, and SSR. Find the least squares regression line for this data.
(c) What is your estimate for bass drum sales if the Green Shades performed on TV six times last month?
Problem 4-13
Students in a management science class have just received their grades on the first test. The instructor
has provided information about the first test grades in some previous classes as well as the final average
for the same students. Some of these grades have been sampled and are as follows:
STUDENT 1 2 3 4 5 6 7 8 9
1st test grade 98 77 88 80 96 61 66 95 69
Final average 93 78 84 73 84 64 64 95 76
(a) Develop a regression model that could be used to predict the final average in the course based on
the first test grade.
(b) Predict the final average of a student who made an 83 on the first test.
(c) Give the values of r and for this model. Interpret the value of in the context of this problem.
Problem 4-28
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?
Problem 4-30
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.
Category Total Cost Median SAT
Public 21,700 1990
Public 15,600 1620
Public 16,900 1810
Public 15,400 1540
Public 23,100 1540
Public 21,400 1600
Public 16,500 1560
Public 23,500 1890
Public 20,200 1620
Private 30,400 1630
Private 41,500 1840
Private 36,100 1980
Private 42,100 1930
Private 27,100 2130
Private 34,800 2010
Private 32,100 1590
Private 31,800 1720
Private 32,100 1770
Chapter 5: 5-13, 5-15, 5-25, 5-27,
5-13 Develop a four-month moving average forecast for Wallace Garden Supply and compute the MAD.
A 3-month moving average forecast was developed in the section on moving averages in the Table Below.
MONTH ACTUAL SHED SALES 3-MONTH MOVING AVERAGE
January 10
February 12
March 13
April 16 (10 + 12 + 13)/ 3 = 11.67
May 19 (12 + 13 + 16)/ 3 = 13.67
June 23 (13 + 16 + 19)/ 3 = 16.00
July 26 (16 + 19 + 23)/ 3 = 19.33
August 30 (19 + 23 + 26)/ 3 = 22.67
September 28 (23 + 26 + 30)/ 3 = 26.33
October 18 (26 + 30 + 28)/ 3 = 28.00
November 16 (30 + 28 + 18)/ 3 = 25.33
December 14 (28 + 18 + 16)/ 3 = 20.67
January — (18 + 16 + 14)/ 3 = 16.00
Wallace Garden Supply decides to forecast storage shed sales by weighting the past 3-months as follows:
WEIGHTS APPLIED PERIOD
3 Last month
2 Two months ago
1 Three months ago
3 × Sales last month + 2 × Sales two months ago + 1 × Sales three months ago
6 Sum of the weights
Problem 5-15
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?
Problem 5-25
Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows:
Sales (1,000s) MONTH Sales (1,000s) MONTH
11 January 14 August
14 February 17 September
16 March 12 October
10 April 14 November
15 May 16 December
17 June 11 January
11 July
(a) Using a moving average with three periods, determine the demand for vacuum cleaners for next February.
(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.
(c) Evaluate the accuracy of each of these methods.
(d) What other factors might R. Lowenthal consider in forecasting sales?
Problem 5-27
Emergency calls to Winter Park, Florida’s 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?
Week Calls Week Calls Week Calls
1 50 9 35 17 55
2 35 10 20 18 40
3 25 11 15 19 35
4 40 12 40 20 60
5 45 13 55 21 75
6 35 14 35 22 50
7 20 16 25 23 40
8 30 16 55 24 65
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer