View the step-by-step solution to:

# 4.23, 4.27, 4.33, and 4.35. 4.23 Sales of vegetable dehydrators at Bud Banis's discount department store in St. Louis over the past year are shown

I need help with this question. I have attached the excel file and it's formatted. Three questions are needed to be answered.
4.23 Sales of vegetable dehydrators at Bud Banis’s discount department store in St. Louis over the past year are shown below. Management prepared a forecast using a combination of exponential smoothing and its col ective judgment for the 4 months (March, April, May, and June of 2010) (Render 142) a) Compute MAD and MAPE for management’s technique. b) Do management’s results outperform (i.e., have smal er MAD and MAPE than) a naive forecast? c) Which forecast do you recommend, based on lower forecast error? 4.27 Mark Cotteleer owns a company that manufactures sailboats. Actual demand for Mark’s sailboats during each season in 2006 through 2009 was as fol ows: (Render 142-143) Mark has forecasted that annual demand for his sailboats in 2011 wil equal 5,600 sailboats. Based on this data and the multiplicative seasonal model, what wil the demand level be for Mark’s sailboats in the spring of 2011? (Render 143) 4.33 The number of transistors (in mil ions) made at a plant in Japan during the past 5 years fol ows: (Render 143) a) Forecast the number of transistors to be made next year, using linear regression. b) Compute the mean squared error (MSE) when using linear regression. c) Compute the mean absolute percent error (MAPE). (Render 143) 4.35 John Howard, a Mobile, Alabama, real estate developer, has devised a regression model to help determine residential housing prices in South Alabama. The model was developed using recent sales in a particular neighborhood. The price (Y) of the house is based on the size (square footage = X) of the house. The model is: Y = 13,473 + 37.65X The coefficient of correlation for the model is 0.63. a) Use the model to predict the sel ing price of a house that is 1,860 square feet. b) An 1,860-square-foot house recently sold for \$95,000. Explain why this is not what the model predicted. c) If you were going to use multiple regression to develop such a model, what other quantitative variables might you include? d) What is the value of the coefficient of determination in this problem? (Render 143-144) 4.23, 4.27, 4.33, and 4.35.

Let me explain the... View the full answer

4.23, 4.27, 4.33, and 4.35. 4.23 Sales of vegetable dehydrators at Bud Banis’s discount department store in St. Louis over the past year are shown below. Management prepared a forecast using a...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents