Does the regression fit the data well

Reference no: EM131271181

I need 2-3 page answer of the following assignment. Must cite all sources in APA. Carefully follow each and every step of the given instructions and grading criteria. I also attached here professor's guideline with Regression Analysis Guideline files that how you do this assignment, and the associated template. Must provide both word and excel sheet of this assignment.

Instructions:

Multiple regression analysis is widely used in business research in order to forecast and predict purposes. It is also used to determine what independent variables have an influence on dependent variables, such as sales.

Sales can be attributed to quality, customer service, and location. In multiple regression analysis, we can determine which independent variable contributes the most to sales; it could be quality or customer service or location.

Now, consider the following scenario. You have been assigned the task of creating a multiple regression equation of at least three variables that explains Microsoft's annual sales.

Use a time series of data of at least 10 years. You can search for this data using the Internet.

Before running the regression analysis, predict what sign each variable will be and explain why you made that prediction.
Run three simple linear regressions by considering one independent variable at a time
After running each of the three linear regressions, interpret the regression.
Does the regression fit the data well?
Run a multiple regression using all three independent variables.
Interpret the multiple regression. Does the regression fit the data well?
Does each predictor play a significant role in explaining the significance of the regression?
Are some predictors not useful?
If so, did you consider removing those and rerunning the regression?
Are the predictors related too significantly to one another? What is the coefficient of correlation "r"? Do you think this "r" value suggests a strong correlation among the predictors (the independent variables?

On a separate page, cite all sources using the APA guidelines.

Reference no: EM131271181

Questions Cloud

What questions would her sphr friend ask betty smith : Case Study Questions: What questions would her SPHR friend ask Betty Smith? Do you think it is a good idea for the CEO to bring a gun to work? Justify your response. Consider the Second Amendment

The equivalent of having marketing myopia in the 1960s : The absence of IMC now is the equivalent of having marketing myopia in the 1960s.' Explain why you either agree or disagree with this sentiment.

Determine the required diameter of the model : the required diameter of the model

Explain relationship between the micro and macro environment : Explain why distributors are of interest to the marketing communicator. Illustrate your response with examples from consumer and organizational markets.

Does the regression fit the data well : After running each of the three linear regressions, interpret the regression. Does the regression fit the data well? Run a multiple regression using all three independent variables. Interpret the multiple regression. Does the regression fit the data ..

Differentiate between ordinary and subliminal advertising : Differentiate between ordinary and subliminal advertising using examples to illustrate.- Compare and contrast the consumer and organizational buyer in terms of the hierarchy of effects sequence.

Describe methods to deal with high employee turnover : Examine the significant effect of each identified staffing model on processes that may be occurring within the organization (e.g., outsourcing, contingent workers, consulting firms, etc.).

Explain the five stages of the conventional consumer : Explain the five stages of the conventional consumer decision-making process. Contrast this with the organizational buyer decision-making process.

What might be the biggest challenge you will face : What might be the biggest challenge you will face in working in a learning team? What strategies might help mitigate these challenges

User Account

All Pages