Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Managerial Economics Module 2Demand Theory and Estimation Activity 4Case 3 Using SPSS, MS Excel or other statistical software package, run the given data and answer

Managerial Economics

Module 2Demand Theory and Estimation

Activity 4Case 3

Using SPSS, MS Excel or other statistical software package, run the given data and answer the following in MS Word.

Assume that Electronix, Inc., a small startup company that distributes a particular business machine, has the following monthly data on unit sales (Q), price (P), advertising expenditures (AD), and personal selling expenditures (PSE) over the past year.

If a linear relation between unit sales, price, advertising, and personal selling expenditures is hypothesized, the regression equation takes the following form:

where is the number of units sold, P is the average price per month, D is advertising expenditures, PSE is personal selling expenditures, and is a random disturbance term - all measured on a monthly basis over the past year.

A.Present the computer results of the regression.

Show all results in two decimal places.

MonthUnits Sales Advertising Personal Selling

Price ($) Expenditures ($) Expenditures ($)

January2,5003,80026,80043,000

February2,2503,70023,50039,000

March1,7503,60017,40035,000

April1,5003,50015,30034,000

May1,0003,20010,40026,000

June2,5003,20018,40041,000

July2,7503,20028,20040,000

August1,7503,00017,40033,000

September1,2502,90012,30026,000

October3,0002,70029,80045,000

November2,0002,70020,30032,000

December2,0002,60019,80034,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Economic Relations Since 1945

Authors: Catherine R Schenk

2nd Edition

1351183567, 9781351183567

More Books

Students also viewed these Economics questions