Question

ht: We would like to analyse expenditures on research and development and use regression analysis, that the total expenditure
ht: We would like to analyse expenditures on research and development and use regression analysis, that the total expenditure
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Please don't hesitate to give a "thumbs up" for the answer in case the answer has helped you

Inferences:

The following inferences are to be made from the model:

R-square - is at 0.9023 or 90.23% which means 90.23% of the variation in the "total expenditure" are explained by the
variation in "Income", "GDP", "investments", and "inflation rate". It is a strong R-Square - which means that the model'
predictive power is high, and has almost all the variables to successfully explain the response variable - "total expenditure"


Predictor variables - At an overall level, the ANOVA table has a p-value of < .05, indicating at least 1 variable is statistically significant. and that the equation can be used to predict the response
variable

"Intercept"  If all other variables are 0 , then y^ = 0 + Intercept = -1754.8285. But since p-value is > .05 this variable is not statistically significant, indicating that actually Intercept = 0. This can be interpreted as "if Income, GDP, Investments and Inflation Rate are 0 then the total expenditure is 0"

"GDP" : has p-value > .05, which means it is not statistically significant.

"Income" is also not statistically significant, as p-value < .05

"Investments" has a p-value of < .05, which means that per increase in investment by $1, the total expenditure increases by $0.8100

"Inflation Rate" has a p-value of < .05, which means that per increase in inflation by 1 point, the total expenditure decreases by $24.6261, which makes sense , because if cost of goods increases due to inflation then total expenditures decreases.

Add a comment
Know the answer?
Add Answer to:
ht: We would like to analyse expenditures on research and development and use regression analysis, that...
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
  • We are doing regression analysis for business analytics class and I am having a hard time reading...

    We are doing regression analysis for business analytics class and I am having a hard time reading this data. Please help. SUMMARY OUTPUT Regression Statistics Multiple R 0.999964 R Square 0.999928 Adjusted R Square 0.9999248 Standard Error 267.074107 Observations 48 ANOVA df SS MS F Significance F Regression 2 44576676715 2.23E+10 312474.2 6.1672E-94 Residual 45 3209786.045 71328.58 Total 47 44579886501 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -42159057 121894.4727 -345.865 1.04E-78 -42404564.6...

  • HW # 5 Linear Regression: Use Data Analysis in Excel to conduct the Regression Analysis to...

    HW # 5 Linear Regression: Use Data Analysis in Excel to conduct the Regression Analysis to reproduce the excel out put below (Note: First enter the data in the next page in an Excel spreadsheet) Home Sale Price: The table below provides the Excel output of a regression analysis of the relationship between Home sale price(Y) measured in thousand dollars and Square feet area (x):    SUMMARY OUTPUT Dependent: Home Price ($1000) Regression Statistics Multiple R 0.691 R Square 0.478 Adjusted...

  • g. Use MS Excel Data Analysis ToolPak to perform a multiple regression analysis using Quality as...

    g. Use MS Excel Data Analysis ToolPak to perform a multiple regression analysis using Quality as the response variable and Helpfulness, Clarity, Easiness, and raterInterest as the explanatory variables. Write down the resulting regression equation and provide the regression output. h. Based on the regression output in part g), which variable(s) seem to be significant predictors of Quality? Which variable(s) do you suggest removing from the model in part g)? Explain why. Regression Statistics ANOVA Multiple R 0.998557685 df SS...

  • For the following question (#19 and #20), please use the following multiple regression output. The dependent...

    For the following question (#19 and #20), please use the following multiple regression output. The dependent variable is Home Price: ($) the independent variables are Number of Bedrooms, Size (square footage), and Pool (0 = no pool, 1 = pool). 19: Which statement is correct? SUMMARY OUTPUT A: The R square of 571 is the best goodness of fit statistic to use for multiple regression analyses. B: The Number of Bedrooms is not a significant predictor variable. Regression Statistics Multiple...

  • I have to complete a multiple regression analysis using the quantity of coal as the dependent...

    I have to complete a multiple regression analysis using the quantity of coal as the dependent variable with the price and GDP as the independent variables. The problem I am having is that when I perform the regression analysis I can't get the Price to be negative and the GDP to be positive. I am attaching the spreadsheet for your reference. Any assistance you can provide will be greatly appreciated. SUMMARY OUTPUT Regression Statistics Multiple R 0.971595991 R Square 0.94399877...

  • 2. The owner of Showtime Movie Theaters would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are as below: TV Advertising...

    2. The owner of Showtime Movie Theaters would like to estimate weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are as below: TV Advertising $1000s 5.0 2.0 4.0 2.5 3.0 3.5 2.5 3.0 Week Weekly gross revenue $1000s 96 90 95 92 95 94 94 94 Newspaper Advertising $1000s 2.0 2.5 3.3 2.3 4.2 2.5 4 6 Following are the regression results for the data using Excel. In this problem, you...

  • A real estate research firm has developed a regression model relating list price (Y in 1,000)...

    A real estate research firm has developed a regression model relating list price (Y in 1,000) with two independent variables. The two independent variables are number of bedrooms and size of the property. Part of the regression results are shown below. ANOVA MS Regression 256881.37 128440.68 Residual 42 726699.96 17302.38 Coefficients Standard Error Star Intercept 54.298 # Bedrooms 53.634 71.326 5.271 33.630 Acres 21.458 1. What has been the sample size? (2 Points) 2. What is the value of the...

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