Answer the following questions, in complete sentences, for each data set. (7 points each)
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:
As you can see, the residuals and fitted values are randomly distributed, there is no pattern in the plot of residuals vs fitted values.
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...!!
Answer the following questions, in complete sentences, for each data set. (7 points each) Are al...
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 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 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 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 (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 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 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. 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 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 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...