Data regarding cost-related variables of promotional insert

Assignment Help Operation Management

Reference no: EM13821920

PROBLEM 1

The data regarding cost and related variables of a promotional insert in major magazines is given in the Table below. Answer the questions that follow.

A) Develop the Multiple Regression equation using EXCEL (the dependent variable Y is cost of a promotional insert).

B) Using the equation developed in A, compute the predicted cost of a promotional insert cost for a circulation of 7000, with a median age of 43 and median income of $25,000?

C) Is the overall regression line significant at 0.10 level?

D) Is median age significant at 0.10 level?

E) Which independent variable/s, if any, would you omit and why?

F) Drop only one of these that you identified in Question E and re-run the multiple regression on EXCEL. Are there any improvements in the t-Stat or p-value?

NEED ALL EXCEL SPREADSHEET AND SUPPORTING INFORMATION

Reference no: EM13821920

Questions Cloud

Focus experiences extremely high utilization of equipment : Process Focus experiences extremely high utilization of equipment and facilities. Mass customization is a rapid, high cost producer of gods and services.

List of the mythological hero characteristics : Identify a hero from literature or popular culture who embarks on a mythical quest. Write a 1000 - 1450 word paper that includes the following: A list of the mythological hero's characteristics

Which of following do brand mantras attempt to define : What is the second stage of the consumer buying process - When purchasing, in which state does the consumer set a minimum acceptable cutoff level for each attribute and then makes a buying decision?

Describe the environmental outcome of your recommendation : Describe the environmental outcome of your recommendation, its impact on society The implications should be based on and supported by your findings.

Data regarding cost-related variables of promotional insert : The data regarding cost and related variables of a promotional insert in major magazines is given in the Table below. Answer the questions that follow. Using the equation developed in A, compute the predicted cost of a promotional insert cost for a c..

Write a paper about the story hands by sherwood anderson : Write a paper about the story "Hands" by sherwood anderson.

What are the risk factors : What are the risk factors

In the proposed employee free choice act : In the proposed Employee Free Choice Act, unions could organize workplaces through a card check without a secret ballot election. Would company managers prefer a secret ballot or a card check? Why would unions prefer one over the other?

Public sector increase efficiency or productivity : Labor unions appear to be stronger in the public sector workplace. Why do you think this is the case? Would privatizing union functions in the public sector (either in government or public schools, for example) increase efficiency or productivity? In..

User Account

All Pages