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

This question was answered on Jan 18, 2014. View the Answer
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.
Background image of page 1
Sign up to view the entire interaction

Top Answer

Let me explain the... View the full answer

8526095.xlsx

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...

This question was asked on Jan 16, 2014 and answered on Jan 18, 2014.

Recently Asked Questions

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 and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards