Analysis of variance

Assignment Help Basic Statistics
Reference no: EM13556055

Please find the partial multiple regression analysis performed to explore the relation 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 - 0.234 Price + 2.70 Promotional exp + 0.220 Quality



Predictor Coef SE Coef T P VIF

Constant 343.20 62.59

Price -0.23358 0.05734 2.415

Promotional exp 2.704 1.240 1.047

Quality 0.2204 0.1429 2.387



S = 6.75231 R-Sq = 88.4%



Analysis of Variance



Source DF SS MS F

Regression 3 3477.5 1159.2 25.42

Residual Error 10 455.9 45.6

Total 13 3933.4

Answer questions A - F based on the above analysis

A) Is the factor Quality significant at α=0.05 ? Perform the test of hypothesis. (10 points)

B) Construct a 95% confidence interval estimate of the population slope of sales with price and also state whether price is a significant factor in predicting sales. (10 points)

C) What is the value of the partial F test statistic (FSTAT) for the independent variable 'Promotional Exp' ? (10 points)

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

E) What is the adjusted R2 value? (10 points)

F) Based on the ANOVA presented, perform the F- test and state if the regression is significant? (α=0.05)

Reference no: EM13556055

Questions Cloud

Magnitude of the net force thateach charge experiences : Three point charges have equal magnitudes, two being positive andone negative. These charges are fixed to the corners of anequilateral triangle, as the drawing shows.
The dipole is parallel to the electric field : A dipole of moment 0.5 e·nm is placed in a uniformelectric field with a magnitude of 15multiplied by 104 N/C.What is the magnitude of the torque on the dipole for each of thefollowing situations?
The model based on mallows cp criterion : Excluding the combination that includes all the variables, which variables would you consider to include into the model based on Mallows Cp criterion?
Combination is temperature independent : suppose you made a 5.40 kiloOhm resistor from a carbonresistor and a Nichrome wire-wound resistor connected together so the total resistance is the sum of their separate resistances. Whatvalue should the carbon resistor have (at 0 degrees Celsius)..
Analysis of variance : Analysis of Variance
Please develop the expected frequencies table : A) Please develop the Expected frequencies table based on the above information.
What is amplitude of oscillation-what is the speed of ball : A 100 g ball attached to a spring with spring constant 2.50N/m oscillates horizontally on a frictionless table. Its velocityis 20.0 cm/s when x = -5.00 cm. What is the amplitude of oscillation?
The typical supermarket trip takes a mean of 22 minutes : The typical supermarket trip takes a mean of 22 minutes
What is the wavelength in the almunium : A 2.50 kHz sound wave is transmitted through an aluminum rod. What is the wavelength in the almunium. What is the sound wave's frequency when it passes into theair?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Describe confidence interval for population proportion

The new Twinkle bulb is being developed to last more than 1000 hours. A random sample of 100 of these new bulbs is selected from the production line.

  In a mathematics exam the average grade was 82 and the

in a mathematics exam the average grade was 82 and the standard deviation was 5. all students with grade between 88 to

  Develop a multiple linear regression equation

Develop a multiple linear regression equation that describes the relationship between tenure and the other variables in the chart above. Use the Analysis Toolpak located in Excel to perform this multiple regression.

  Game and prepare the odds of winning

Define a game and prepare the odds of winning. The game could be a card game with two cards or a dice game. Use MS-Excel (if possible) to solve this problem

  What is the linear correlation coefficient

A data set of ordered pairs with a negative linear correlation has a coefficient of determination of 85.2%. What is the linear correlation coefficient?

  Find probability that defective product came from binford

A customer receives a defective product. What is the probability that it came from Binford? What assumptions did you make to answer this question?

  Normal probability-reaction time of female candidates

In a standard test for reaction time, female candidates for flight school are found to have times that are normally distributed with a mean of 0.65 seconds and a standard deviation of 0.15 seconds.

  Exponential function and critical points

Find all critical points of f (x) and classify them as maximums or minimums. State the intervals where f (x) is increasing and decreasing.

  In a study of the effects of stress on illness

In a study of the effects of stress on illness, a researcher tallied the number of colds people contracted during a six month period as a function of the amount of stress they reported during that same time period.

  Find probability that carbon monoxide concentration exceeds

Find the probability that the carbon monoxide concentration exceeds 9 ppm during a randomly selected one-hour period.

  Find probability that three consumers recognize brand name

Find the probability that exactly 3 of the 5 consumers recognize the brand name. Also find the probability that the number who recognize it is not 3.

  Use binomial probability formula to calculate probibilities

use Microsoft excel, as your graphing calculator, or the binomial probability formula to calculate the probibilities of the following events. Event A: The probability that you will have to oay out exactly $20.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd