• 100% Satisfaction Guarantee
linda_us, Master's Degree
Satisfied Customers: 852
Experience:  A tutor for Business, Finance, Accounts and other related topics.
19873544
linda_us is online now

# Multiple regression

### Customer Question

Attachment: 2013-10-18_000119_mgt3509_w4a3_ms_data.xlsx

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? Submit your answers in a two- to three-page Word document.

The required data is attached

Submitted: 3 years ago.
Expert:  Angela--Mod replied 3 years ago.

Hello, I'm a moderator for this topic. I've been working hard to find a professional to assist you right away, but sometimes finding the right professional can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. Please let me know and I will assist further. Thank you!

Best,

Angela

Customer: replied 3 years ago.

I can wait a few more days but will need it by Tuesday at the latest.

THank you,

Gregg

Expert:  Angela--Mod replied 3 years ago.

Thank you for your patience while we continue to search for a professional to assist you.

Customer: replied 3 years ago.

Hello,

You can cancel this question. I was able to fine other assistance.

Thank you,

Gregg