Question

Advertising and sales data: 36 consecutive monthly sales and advertising expenditures of a dietary weight control product ExpAnswer the following questions, in complete sentences, for each data set. (7 points each)

  1. Are all the required conditions of the regression met?
  2. When there is no advertising, does the company have positive sales?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

The conditions for regression can be checked by fitting a regression model to given data and by observing the graphs related to it. I have used Minitab software for regression analysis of given variables. attaching output images and graphs too.

Analysis of Variance

Source DF Adj SS Adj MS F-Value P-Value
Regression 1 4920 4920.4 22.54 0.000
Advertise 1 4920 4920.4 22.54 0.000
Error 34 7421 218.3
Lack-of-Fit 30 6394 213.1 0.83 0.671
Pure Error 4 1027 256.8
Total 35 12341

Model Summary

S R-sq R-sq(adj) R-sq(pred)
14.7734 39.87% 38.10% 33.17%

Coefficients

Term Coef SE Coef T-Value P-Value VIF
Constant -18.0 10.1 -1.78 0.084
Advertise 1.918 0.404 4.75 0.000 1.00

Regression Equation

Sales = -18.0 + 1.918 Advertise

Required Graphs are as follows:

Normplot of Residuals for Sales Normal Probability Plot (response is Sales) 95 90 80 70- C 60 O 50 D 40 30 20- 10 5 40 -10 -3

Residuals vs Fits for Sales Versus Fits (response is Sales) 401 30 20- 10 10 20 -30 183 20 40 03 10 30 50 Fitted Value

As you can see, the residuals and fitted values are randomly distributed, there is no pattern in the plot of residuals vs fitted values.

Residual Histogram for Sales Histogranm (response is Sales) 12 10 €3. 4 2- 30 0- 20 10 10 20 -30 Residual

Regression Equation

Sales = -18.0 + 1.918 Advertise

As you can see, when advertisement is zero, the sales are negative.

Hope this helps. All the best...!!

Add a comment
Know the answer?
Add Answer to:
Answer the following questions, in complete sentences, for each data set. (7 points each) Are al...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Write down the linear model Identify the dependent, and the independent variable

    Write down the linear model Identify the dependent, and the independent variable Advertising and sales data: 36 consecutive monthly sales and advertising expenditures of a dietary weight control product Exported from datamarket.com Date exported 2014-10-26 21:28 On DataMarket Unknown; please assume a restricted license (all rights reserved); contact DataMarket if you need different licensing Time Series Data Library Source URL Advertisi Sales Indicator 0001-01 0001-02 0001-03 0001-04 0001-05 0001-06 0001-07 0001-08 0001-09 0001-10 0001-11 0001-12 0002-01 20.5 15.3 23.5 24.5...

  • Use the following tide table to answer the questions in the Assessing Your Learning section of...

    Use the following tide table to answer the questions in the Assessing Your Learning section of this lab. This tide table shows the predicted ocean heights for Santa Cruz/Monterey Bay, California during December 2011. 1. A visit to Santa Cruz/Monterey Bay, California is planned during the week of December 4-10 to view the tide pools. To observe intertidal animals during the daytime at the lowest possible tide, the best time to visit the beach is on _________________ at _________________. (4...

  • Create a chart of T-Accounts and post each journal entry to the appropriate accounts Debit Credit...

    Create a chart of T-Accounts and post each journal entry to the appropriate accounts Debit Credit 70,000 70,000 140,000 140,000 130,000 130,000 23,676 23,676 535,500 240,975 294,525 112,000 112,000 230,000 230,000 21,500 21,500 160,000 160,000 365,000 365,000 650,000 425,000 225,000 2,531.25 2,531.25 Date Accounts 01/01 Cash Common stock 01/01 Equipment Cash 01/01 Cash Notes payable (long-term) 01/05 Cash Interest receivable 01/22 Inventory Cash Accounts payable 01/25 Accounts payable Cash 01/01 Equipment (*office Furniture) Cash 12/31 Depreciation Expense Accumulated Depreciation 02/01...

  • Use the tables in the next page to answer the following questions in SQL. 1. Print...

    Use the tables in the next page to answer the following questions in SQL. 1. Print the names of employees who work in a project located in Houston. 2. Print the names of employees with no dependents. 3. Print the names of employees who are managers. 4. Print the names of employees who have more than one wife. 5. Print the names of employees who work in all the projects. EMPLOYEE Frame John Franklin Minit B T S K A...

  • Please use the following data to answer the questions. The ticker symbols are for Tesla Inc...

    Please use the following data to answer the questions. The ticker symbols are for Tesla Inc (TSLA), Barrick Gold Corporation (GOLD) and Apple Inc (AAPL). The prices shown are the closing stock prices for the date shown. Your first task is to compute the monthly holding period returns for each stock for each month, using the Holding Period Return formula, which is HPR = (P1 - P0)/P0, where P1 is the end of period price and P0 is the start...

  • Write MySQL query statements for the questions below including the output that proves the accuracy of...

    Write MySQL query statements for the questions below including the output that proves the accuracy of your solution. Your answers should be stored in a text file that captures your interaction with MySQL. 1. Find the movieID, title, year and DVDPrice of all movies where the DVD-Price is equal to the discountPrice. 2. Find the actorID, lastName, firstName, middleName, and suffix of all actors whose middleName is not NULL. 3. Suppose you remember a movie quote as “Play it again,...

  • A survey found that women's heights are normally distributed with mean 63.7 in and standard deviation...

    A survey found that women's heights are normally distributed with mean 63.7 in and standard deviation 23 in A branch of the military requires women's heights to be between 50 in and on a. Find the percentage of women meeting the height requirement. Are many women being denied the opportunity to join this branch of the military because they are too shorter too? b. If this branch of the military changed the height requirements so that wil women are eligible...

  • Answer all questions in this Section. 1. Read the following and answer questions that follow.   ...

    Answer all questions in this Section. 1. Read the following and answer questions that follow.    The following information was taken from Masego Leero’s books. 01/01/2015 Started business with P20, 000 cash 03/01/2015 Deposited P15, 000 cash into the bank account 05/01/2015 Bought furniture on credit P3, 000 from Supreme 07/01/2015 Bought goods P7, 000 paying by cheque. 09/01/2015 Sold goods P6, 000 by cash 11/01/2015 Sold goods on credit to Lesego R P1, 000, Lorato L P2, 000 and...

  • In a test of the effectiveness of garlic for lowering cholesterol 49 subjects were treated with...

    In a test of the effectiveness of garlic for lowering cholesterol 49 subjects were treated with garlic in a procese tabletform. Cholesterol levels were measured before and her the treatment. The charges before the cholesterolin mg/dL) have a mean of 4.6 and a standard deviation of 175. Construct a conoce interval estate of the mean not change in LOL hehehe garlic treatment Click here to view distribution table Click here to view of the standard normal distribution table Click here...

  • Exercise 12A-6 Basic Present Value Concepts (L012-7) The Caldwell Herald newspaper reported the following story, Frank...

    Exercise 12A-6 Basic Present Value Concepts (L012-7) The Caldwell Herald newspaper reported the following story, Frank Ormsby of Caldwell is the state's newest millionaire. By choosing the six winning numbers on last week's state lottery, Mr. Ormsby won the week's grand prize totaling $1.14 million. The State Lottery Commission indicated that Mr. Ormsby will receive his prize in 20 annual installments of $57,000 each Click here to view Exhibit 123.1 and Exhibit 128-2. to determine the appropriate discount factor(s) using...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT