Regression Analysis The Local Grocery Store Wants to Predict Its Daily Sales

question 143

Essay

Regression Analysis

The local grocery store wants to predict its daily sales in dollars.The manager believes that the amount of newspaper advertising significantly affects the store's sales.He randomly selects 7 days of data consisting of daily grocery store sales (in thousands of dollars)and advertising expenditures (in thousands of dollars).The Excel/MegaStat output given above summarizes the results of the regression model.
What is the estimated simple linear regression equation?

---

Definitions:

Flexible Budget

A budget that molds itself to fit changes in the volume or intensity of activity.

Other Expenses

Costs not directly related to the production or selling of goods and services, such as interest expenses and loss from foreign exchange.

Containers Refurbished

Used containers that have been restored to good condition and functionality for reuse.

Activity Variance

A measure of the difference between the actual level of activity and the planned level of activity.