Explore BrainMass

Explore BrainMass

    Forecasting on Sales

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Carpet City wants to develop a means to forecast its carpet sales. The store manager believes that the store's sales are directly related to the number of new housing starts in town. The manager has gathered data from county records on monthly house construction permits and from store records on monthly sales. Please see the attachment file for the data and provide an answer in Excel format.

    a. Develop a linear regression model for these data and forecast carpet sales if 30 construction permits for new homes are filed.
    b. Determine the strength of the casual relationship between monthly sales and new home construction by using correlation.

    © BrainMass Inc. brainmass.com November 30, 2021, 2:08 am ad1c9bdddf