Question: The sample data contains candy sales information during the last 12 weeks for an imaginary brand. For each week we know the sales, advertising expenditure,

The sample data contains candy sales information during the last 12 weeks for an imaginary brand. For each week we know the sales, advertising expenditure, and the price of candy*. Based on this information please answer the following questions: 1. Calculate the correlation between sales, advertising expenditures, and price. Then explain the results. (2 points) 2. Run a regression analysis to see if we can predict sales by knowing advertising expenditures and price. Please explain the results based on the regression table. (4 points) 3. Suppose that for the next week we want to spend $30000 on advertising. Also, the price will be $4. Use the regression model you found in the previous question and predict the sales

Week Sales Advertising Expenditures Price 1 230000 15500 3 2 300000 16000 2 3 350000 20000 2 4 170000 13000 3.5 5 250000 15000 2.5 6 180000 14000 3.5 7 200000 14000 3 8 400000 21000 1.5 9 450000 25000 1 10 100000 10000 5 11 120000 11000 4.5 12 150000 11000 3.5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Read the article, do (i.e., description of the problem, alternatives, key features, solution). 1. do a clearly state what problem you believe the firm is facing. 2. Next you will want to see what the...

MKT500 Week 7 Discussion Board I have attached the question, lecture notes, and an example of a student's response to the questions. Running head: KEYSAN NATURALS COMPANY: AIDA PRINCIPLE Keysan...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

Hudson: Lisa: Fred: Jake: We've made a lot of progress researching various ERP vendors. However, ERP software for car dealerships is still fairly expensive for a small dealership like ours. Combine...

I'm trying to develop Pro Forma financial statements (Balance Sheet and Income Statement) for the next two fiscal years, assuming a 10% growth rate in sales and Cost of Goods Sold (COGS) for each of...

The questions are provided in the document attached; the relevant files are attached as well. a. For 2015, was cash provided by, or used in, Operations? b. For 2015, is Kohl's net Cash Flow from...

I'm using Kohl's Corporation's Annual Statement trying to answer this question. I've attached the annual report below. Assess management performance by calculating Economic Value Added (EVA). UNITED...

From the strategic perspective, should loreal introduce Synergie and/or Belle Couleur or not at all Synergie had recently been introduced successfully in France, the home country for L'Oral. Belle...

what is tge environmental scan of loreal group, synergie, belle colloeur Synergie had recently been introduced successfully in France, the home country for L'Oral. Belle Couleur Case 6-14 L'Oral...

A trading company has eight computers that it uses to trade on the New York Stock Exchange (NYSE). The probability of a computer failing in a day is 0.005, and the computers fail independently....

Defining the Class Theater Define and implement a class Theater as described in the diagram and text below. Theater Private (-) TheaterId Type: string (-) TheaterName Type: string (-) noOfBookedSeats...

The Globally Diversified Many Assets Fund has a variance of 9 0 0 . Expected rate of return on the market is 1 3 % and Market Standard Deviation is 2 4 % , Risk free rate is 5 . 0 % . The required...

Briefly describe the life-cycle activities that occur in the waterfall model. You should, to the extent you're able, state the name of each of the 6 stepsilfe-cycle activities. (10 pts) Briefly...

Jessie and Ashton had offered Sandra more money to stay in her current role with the company. What problems could have occurred if Sandra had accepted their offer?

How might employers ask employees about components of a total rewards program without creating unrealistic expectations? One answer is to ask employees, although there might be concern that by...

Why do you think Tracey did not care about her benefits? What should Ravi do to ensure that his other employees do not feel the same way? Ravi Singh sat at his desk and wondered what his next steps...