Question

Given the following data, find the multiple regression equation for quantity demanded in terms of price,...

Given the following data, find the multiple regression equation for quantity demanded in terms of price, income, and advertising expenditures

Quantity           Price               Income           Advertising Expenditures

200                     25                  1000                           200

250                     22                  1140                           200                   

275                     21                  1230                           225

320                     21                  1232                           225                                       

332                     20                  1232                           230                   

340                     18                  1240                           235

346                     16                  1242                           238

350                     14                  1245                           240

Homework Answers

Answer #1

Regression Summary Output as follows.

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.9640
R Square 0.9294
Adjusted R Square 0.8764
Standard Error 19.1411
Observations 8
ANOVA
df SS MS F
Regression 3 19278.34302 6426.114 17.53934
Residual 4 1465.531976 366.383
Total 7 20743.875
Coefficients Standard Error t Stat P-value
Intercept -235.6675 286.0326 -0.8239 0.4563
Price -3.4946 4.2333 -0.8255 0.4555
Income 0.2454 0.1668 1.4711 0.2152
Advertising Expenditures 1.3948 1.2155 1.1475 0.3151

Estimated regression Equation:

Quantity = -235.6675 - 3.4946 x Price + 0.2454 x Income + 1.3948 x Advertising Expenditure

Know the answer?
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
Similar Questions
Use the following to answer the question on the basis of the following regression equation. (Standard...
Use the following to answer the question on the basis of the following regression equation. (Standard errors in parentheses, n = 200.) Q = -6,500 - 100PA + 50PB + .3I + .2A; R2 =.12 (2,500) (50) (30) (.1) (.08) where Q is the quantity demanded of good A; PA = $10, price of good A; PB = $8, price of good B; I = $12,000, per capita income; and A = $20,000, monthly advertising expenditures. Which of the variables...
A loan made on March 14 is due September 13 of the following year. Find the...
A loan made on March 14 is due September 13 of the following year. Find the exact time for the loan in a​ non-leap year and a leap year. days. The exact time in a​ non-leap year is ? days The exact time in a leap year is ? days. Data Table Sequential Numbers for Dates of the Year Day of Month Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. 1 1 32 60 91 121...
Use the Manufacturing database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression...
Use the Manufacturing database from “Excel Databases.xls” on Blackboard. Use Excel to develop a multiple regression model to predict Cost of Materials by Number of Employees, New Capital Expenditures, Value Added by Manufacture, and End-of-Year Inventories. Locate the observed value that is in Industrial Group 12 and has 7 employees. Based on the model and the multiple regression output, what is the corresponding residual of this observation? Write your answer as a number, round to 2 decimal places. SIC Code...
Researchers in a 2015 study by Flannery et al. sought to estimate the effectiveness of the...
Researchers in a 2015 study by Flannery et al. sought to estimate the effectiveness of the seasonal influenza vaccine in preventing acute respiratory infection (ARI). A total of 507 subjects from Texas who showed symptoms of ARI were recruited for this study. The data provided show the result of each subject's test for influenza. Click to download the data in your preferred format.    CrunchIt!    CSV    Excel    JMP    Mac-Text    Minitab    PC-Text    R   ...
Your firm works in construction and buys ASTM A325M8S bolts in very large numbers. You are...
Your firm works in construction and buys ASTM A325M8S bolts in very large numbers. You are interested in purchasing bolts from different suppliers and have obtained and tested samples of 200 bolts from three suppliers: Allnutt, Boltzman, Coachers.You have tested these in your new bolt testing machine, purchased after you had discovered your old bolt testing machine was performing erratically. (For the purposes of this question, you are safe to assume that the new machine works perfectly and that its...