Question

In: Statistics and Probability

1) Please find the partially completed multiple regression analysis below, which explores the relationship between the...

1) Please find the partially completed multiple regression analysis below, which explores the relationship between the sales (in hundreds) and the independent variables price(in dollars), promotional expenditure(in hundreds of dollars) and the quality score ( 0-100) for a very popular Christmas season toy.

The regression equation is

Sales = 343.2 - 0.23* Price + 2.7* Promotional exp + 0.22* Quality

Predictor Coef Standard Error/ SE Coef    VIF

Constant 343.20 / 62.59 / 0

Price -0.23358 / 0.0373 / 2.415

Promotional exp 2.704 / 1.4 / 1.047

Quality 0.2204 / 0.1429 / 10.387

R-Sq =

  

Analysis of Variance

Source DF SS   

Regression 0 / 2847.78

Residual Error   

Total 15 / 3933.40

Answer questions A - F based on the above analysis

A) Is the factor Promotional Exp significant at α=0.05 ? Perform the test of hypothesis and show all the relevant calculations.

B) Construct a 95% confidence interval estimate of the population slope of sales with Quality showing all the relevant calculations and also state whether 'Quality' is a significant factor in predicting sales.

C) What is the value of the partial F test statistic (FSTAT) for the independent variable 'Price' (show all the relevant calculations)?

D) Is there a problem with multi-collinearity  among independent variables in this analysis? Explain.

E) What is the adjusted R2 value?(show all the relevant calculations)

F) Based on the ANOVA presented, perform the overall F- test showing all the relevant calculations and also state if the regression is significant? (α=0.05)

Solutions

Expert Solution

orchestra answered 1 year ago
Next > < Previous

Related Solutions

Multiple Regression Analysis was used to find out which X variable have relationship with my Y...
Multiple Regression Analysis was used to find out which X variable have relationship with my Y variable (reduce overspending on food and beverage), and how strong relationship is.FIT A FIRST ORDER AUTO AGGRESSIVE MODEL (AR(1) USING Y(T) AS THE RESPONSE VARIABLE Y (T-1) AS THE INPUT VARIABLE. RECORD THE REGRESSION EQUATION. CALCULATE THE EXPONENTIAL SMOOTHING MODELS AND CALCULATE A MOVING AVERAGE MODEL. 4-Mar $31.69 5-Mar $4.19 5-Mar $19.01 5-Mar $7.99 6-Mar $3.32 6-Mar $57.11 7-Mar $4.07 8-Mar $2.49 8-Mar $6.30...
Multiple regression analysis was used to study the relationship between a dependent variable, y, and four...
Multiple regression analysis was used to study the relationship between a dependent variable, y, and four independent variables; x1, x2, x3, and x4. The following is a partial result of the regression analysis involving 31 observations. Coefficients Standard Error Intercept 18.00 6.00 x1 12.00 8.00 x2 24.00 48.00 x3 -36.00 36.00 x4 16.00 2.00 ANOVA df SS MS F Regression 125 Error Total 760 a) Compute the multiple coefficient of determination. b) Perform a t test and determine whether or...
~~~~~~~~~~~~TO BE COMPLETED USING RSTUDIO~~~~~~~~~~~~~~ ~~~~~~~~~~~~(Please display all RCode used)~~~~~~~~~~~~~~ Regression Is there a relationship between...
~~~~~~~~~~~~TO BE COMPLETED USING RSTUDIO~~~~~~~~~~~~~~ ~~~~~~~~~~~~(Please display all RCode used)~~~~~~~~~~~~~~ Regression Is there a relationship between the number of stories a building has and its height? Some statisticians compiled data on a set of n = 60 buildings reported in the World Almanac. You will use the data set to decide whether height (in feet) can be predicted from the number of stories. data from buildings.txt. (Note that this is a text file, so use the appropriate instruction. If you...
~~~~~~~~~~~~TO BE COMPLETED USING RSTUDIO~~~~~~~~~~~~~~ ~~~~~~~~~~~~(Please display all RCode used)~~~~~~~~~~~~~~ Regression Is there a relationship between...
~~~~~~~~~~~~TO BE COMPLETED USING RSTUDIO~~~~~~~~~~~~~~ ~~~~~~~~~~~~(Please display all RCode used)~~~~~~~~~~~~~~ Regression Is there a relationship between the number of stories a building has and its height? Some statisticians compiled data on a set of n = 60 buildings reported in the World Almanac. You will use the data set to decide whether height (in feet) can be predicted from the number of stories. data from buildings.txt. (Note that this is a text file, so use the appropriate instruction. If you...
Please find at least one application of a multiple linear regression model in business analysis and...
Please find at least one application of a multiple linear regression model in business analysis and post your comments/thoughts and the web link of the information source,
Questions about relationship* 1. Explain the relationship between correlation analysis dan regression analysis( * is relationsip,...
Questions about relationship* 1. Explain the relationship between correlation analysis dan regression analysis( * is relationsip, not difference ) 2. Explain the relationship between correlation covariance 3. Explain the relationship on this three analysis
Using the partially completed analysis of variance and table of means provided below, answer the following...
Using the partially completed analysis of variance and table of means provided below, answer the following questions. Use the .05 significance level. All three groups have the same sample size. Source SS df MS F Treatment 4.3669 Error 9.03 Total 29 Group A B C sample mean 278.3 275.4 274.5 10. Find the value of LSD for comparing Groups A and B. 11. Is the difference between groups A and B significant? yes no maybe? Antidisestablishmentarianism 12. What's the value...
A condensed balance sheet for Simultech Corporation and a partially completed vertical analysis are presented below....
A condensed balance sheet for Simultech Corporation and a partially completed vertical analysis are presented below. Required: 1. Complete the vertical analysis by computing each missing line item as a percentage of total assets. 2-a. What percentage of Simultech’s total assets relate to inventory? 2-b. What percentage of Simultech’s total assets relate to property and equipment? 2-c. Which of these two asset groups is more significant to Simultech’s business? 3. What percentage of Simultech’s assets is financed by total stockholders'...
1. Distinguish between a bivariate regression model and a multiple regression.
1. Distinguish between a bivariate regression model and a multiple regression.
4. Interpretation of simple linear regression The linear model below explores a potential association between property...
4. Interpretation of simple linear regression The linear model below explores a potential association between property damage and windspeed based on observational data from 94 hurricanes that hit the United States between 1950 and 2012. The variables are Damage: property damage in millions of U.S. dollars (adjusted for inflation to 2014) for each hurricane Landfall.Windspeed: Maximum sustained windspeed in miles per hour measured along U.S. coast for each hurricane * Assume that the sample data satisfies all assumptions for linear...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT