Influences the sales of his specialty deep-dish pizza

Assignment Help Operation Management

Reference no: EM131746750

(IN EXCEL FORMAT) The owner of Original Italian Pizza restaurant chain wants to understand which variable most strongly influences the sales of his specialty deep-dish pizza. He has gathered data on the monthly sales of deep-dish pizzas at his restaurants and observations on other potentially relevant variables for each of several outlets in central Indiana. These data are provided in the file P10_04.xlsx. Estimate a simple linear regres- sion equation between the quantity sold (Y) and each of the following candidates for the best explanatory variable: average price of deep-dish pizzas, monthly advertising expenditures, and disposable income per household in the areas surrounding the outlets. Which variable is most strongly associated with the number of pizzas sold? Explain your choice. Outlet Number Quantity Sold Average Price Monthly Advertising Expenditures Disposable Income per Household 1 85,300 $10.14 $64,800 $42,100 2 40,500 $10.88 $42,800 $38,300 3 61,800 $12.33 $58,600 $41,000 4 50,800 $12.70 $46,500 $43,300 5 60,600 $12.29 $50,700 $44,000 6 79,400 $9.79 $60,100 $41,200 7 71,400 $11.26 $55,600 $41,700 8 70,700 $11.23 $57,900 $43,600 9 55,600 $11.97 $52,100 $39,900 10 70,900 $12.07 $60,700 $44,800 11 77,200 $10.68 $64,400 $41,800 12 63,200 $12.49 $55,600 $44,200 13 71,100 $12.36 $60,900 $40,100 14 55,500 $9.96 $47,200 $39,100 15 42,100 $11.77 $46,100 $38,000

Reference no: EM131746750

Questions Cloud

Explain decoy effect-how marketers can benefit from decoys : Explain decoy effect and how marketers can benefit from decoys?

Define the appliance center revenue arrangement : Assume that the maintenance services are priced separately. Identify the separate performance obligations related to the Appliance Center revenue arrangement

What is the maximum amount of ram : PIC32's have increased their flash and RAM over the years. What is the maximum amount of flash memory a PIC32 can have before the current choice of base.

Find the five-number summary for these data : The Wade Tract in Thomas County, Georgia, is an old-growth forest of longleaf pine trees (Pinus palustris) that has survived in a relatively.

Influences the sales of his specialty deep-dish pizza : The owner of Original Italian Pizza restaurant chain wants to understand which variable most strongly influences the sales of his specialty deep-dish pizza.

How a scholarship will help me achieve my goals : How a scholarship will help me achieve my goals and Why i deserve a scholarship? Essay should be no longer than two typed pages, double-spaced in 12-point font.

Discuss general types of income under the code : Since the enactment of the passive activity rules, the Code now provides for three general types of income under the Code

Describe the special features section of the data sheet : If you want your PBCLK frequency to be half the frequency of SYSCLK, which bits of which Device Configuration Register do you have to modify?

The inputting should continue until negative values : The inputting should continue until negative values (sentinel values) are encountered or 25 records are obtained (size of the array).

User Account

All Pages