Do a regression analysis - goodbelly sales

Assignment Help Managerial Economics
Reference no: EM132187758

Explanation of GoodBelly Sales Spreadsheet

You need to do a regression analysis and prepare a report

The data came from 126 Whole Foods stores over the 10 weeks between May 4 and July 13. There was a total of 1,386 observations.

Variable Definitions

1. Weekly Sales (Volume): The number of units sold per store per week.

2. Average Retail Price: The average retail price for GoodBelly products per store per week.

3. Sales Rep: Defined as 1 if the store had a regional sales rep (face-to-face contact) and 0 if the store had only the national sales rep (no face-to-face contact).

4. Endcap: Defined as 1 if a store participated in an endcap promotion.

5. Demo: Defined as 1 if the store had a demo on the corresponding week.

6. Demo1-3: Defined as 1 if the store had a demo 1-3 weeks ago.

7. Demo4-5: Defined as 1 if the store had a demo at least 4-5 weeks ago.

8. Natural Retailers: The number of other natural retailers within 5 miles of each store.

9. Fitness Centers: The number of fitness centers within 5 miles of each store.

Attachment:- Dataset.rar

Verified Expert

This report has been prepared with regression analysis of sales data.Sales data includes number of units sold and average price per unit.From the regression analysis it is found that sales are highly dependent on demonstrations.The influence of other factors on sales found to be statistically insignificant.

Reference no: EM132187758

Questions Cloud

Create informational speech video using given information : SPC1026 Please consider the following when you create your informational speech video: Your introduction should engage your specific target audience specific.
Create an itemized list of at least ten items : Create an itemized list of at least ten (10) items that you will need for your graduation party. Lay out your Excel spreadsheet following the example below.
Define what you believe is the overall meaning : You need to select one of the poems assigned since our reading of King Lear-one of at least 8 lines. (If you choose a longer work, you should concentrate).
What was the artist trying to do : What was the artist (the director) trying to do? (make sure you talk about BOTH form--cinematography, mise en scene, lighting, color usage, sound usage.
Do a regression analysis - goodbelly sales : Do a regression analysis and prepare a report - Defined as 1 if a store participated in an endcap promotion - The number of units sold per store per week
Discussing the ideas that are packed within : A definition for explication might be, "to make plain or clear; explain; interpret." The word comes from the Latin explicare, which means "to unfold."
What specific facts are you required to know : What specific facts are you required to know, share, and defend in your field? What sources do you consider most credible when you defend facts and statements.
Financial results in government : Comment on the statement "liquidity is more important than financial results in government."
Bonds to non-bank financial firms : If the Fed wishes to raise the equilibrium federal funds rate up to the top end of the target range, will it repo or reverse repo

Reviews

Write a Review

Managerial Economics Questions & Answers

  Estimate the npv and irr

A drug company produces and sells generic over counter drugs in plants located throughout the country. One of its plants is trying to decide whether to automate a portion of its packaging process

  Why should sue pay for the engineer

Would it be in Sue and John's joint interest to hire the engineer? Explain. Why should Sue pay for the engineer? Isn't it John's responsibility to assure that he will comply with the contract?

  Identify and describe four causes

Are some workers more likely than others to be laid off and have a harder time finding another satisfactory job -

  The fact that some airplanes collide is evidence

My doctor charges me a high fee because he has to cover the high cost of his education and equipment. On the other hand, my golfing teacher also charges me a high fee, even though his education is practically absent.” Is either one cheating or foolin..

  Determine the firm optimal output and price

QopyQat specializes in printing business cards and resumes, using latest laser technology. After examine the business, manager has decided that weekly demand can be approximated;

  Correlation in amount of friction in economy demand & supply

Make some research on a topic known to economists as 'friction-free' or 'low-friction' economy. Early writers on this topic foresaw many of the seismic shifts that have occurred in the market place over last one to 2-decades.

  The project can be financed with internal funds

The project is long-term; therefore, it will take years for the company to complete the project and begin receiving cash flows.

  What responses are there other ways of researching managem

You work for a division of a textbook publisher that manages the company's economics textbooks. Senior managers have instructed you to find a way to reduce your division's total cost by 30 percent.

  What conditions could the buyer and producer use

Under what conditions could the buyer and producer use Nash reversion trigger strategies to support purchase of high quality products

  Explain growth maximisation model of morris

Describe critically growth maximisation model of morris - Grade Level : Post Graduate Level

  Regression that specifies natural log of cars

Using the data file (LightUpTempF2015Short2.syz or the Excel equivalent)run a regression that specifies Natural Log of Cars= f(Natural Log of Price). Extract and specify the equation.

  If you make the percentage price change that you calculated

If you make the percentage price change that you calculated in part a) will total revenue increase or decrease? How do you know?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd