Equation that can be used to predict annual sales of dolls

Assignment Help Mechanical Engineering

Reference no: EM131173786

A toy company has assigned you to analyze the factors influencing the sales of its most popular doll. The number of these dolls sold during the last 23 years is given in the file P11_52.xlsx. The following factors are thought to influence sales of these dolls:

¦ Was there a recession?

¦ Were the dolls on sale at Christmas?

¦ Was there an upward trend over time?

a. Determine an equation that can be used to predict annual sales of these dolls. Make sure that all variables in your equation are significant at the 10% level.

b. Interpret the coefficients in your equation.

c. Are there any outliers?

d. Is heteroscedasticity or autocorrelation of residuals a problem?

e. During the current year (year 24), a recession is predicted and the dolls will be put on sale at Christmas. There is a 1% chance that sales of the dolls will exceed what value? You can assume here that heteroscedasticity and autocorrelation are not a problem.

Reference no: EM131173786

Questions Cloud

Find whether advertising dollars are generating sales : This means that each advertising dollar has to generate at least $10 of sales or the advertising is not cost-effective. Use regression to determine whether advertising dollars are generating this type of sales response.

When should not one rely on standardized tests : What information you think the standardized test scores can provide? Do you think that it is valid to use student assessments to evaluate effectiveness of teaching? Give reasons in your answer.

Why the coefficient of labor hours is not significant : Run the regression for the first 36 months. Explain briefly why the coefficient of labor hours is not significant.

Discuss the examples of at risk students and online learners : What specific populations might struggle more with self regulation and how can you promote it? Discuss the examples of at risk students and online learners and how self regulation plays an important role in both.

Equation that can be used to predict annual sales of dolls : Determine an equation that can be used to predict annual sales of these dolls. Make sure that all variables in your equation are significant at the 10% level.

What is the probability of a type i error : What is the correlation between student anxiety scores and number of study hours? Select alpha and interpret your findings. Make sure to note whether it is significant or not and what the effect size is.

Find the probability that customer will not switch companies : If profits are discounted at 10% annually, use simulation to estimate the value of this customer to GLC. Also estimate the value of a customer to GLC if it can raise its customer satisfaction rating to 85%, to 90%, or to 95%. You can interpret the..

Find its npv for the next 10 years from the drug : Again assuming that Mutron enters the market, it can be 95% certain that its actual NPV from the drug is between what two values?

Describe the concepts of territorialit and privacy space : Examine how the concepts of territoriality, privacy, and personal space have become increasingly important as populations become denser. Clarify the effect nature (e.g., zoos, parks, gardens) has on individuals living in urban environments.

User Account

All Pages