Purchase Solution

Forecasting on Sales

Not what you're looking for?

Ask Custom Question

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.

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

Purchase this Solution

Purchase this Solution


Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce