Share
Explore BrainMass

Regression Analysis in Business Research

Identify a business research issue, problem, or opportunity facing a Learning Team member's organization that can be examined using regression analysis. Then, use the Internet or other resources to collect data pertaining to your selection. Prepare a paper examining a regression analysis on your collected data. Begin by describing the research issue, problem, or opportunity and the accompanying data. Then, perform a regression analysis on your data using any method of computation. Finally, interpret the results of your regression analysis, state the limitations of your analysis, and describe the significance of the results to the organization as a whole. Be sure to attach the results of the regression analysis created to your paper.
I have identified the issue and collected data. I need:

1. Perform a regression analysis on your data using any method of computation. Excel will be preferable
2. interpret the results of your regression analysis
3. state the limitations of your analysis
4. describe the significance of the results to the organization as a whole

Attachments

Solution Preview

Please see attached file. Calculations are done in MS Excel.

1. The scatter diagram of advertising cost and number of orders is given below. We can observe a linear relationship between these two variables. The correlation between advertising cost and number of orders is
Correlation = 0.8419
Thus there is a strong positive association between advertising cost and number of orders.

Thus we can suggests a regression model of the form

Number of Orders = a + b* Advertising Cost

Where a and b are the regression coefficients calculated from the data by the method of least squares. The ...

Solution Summary

The solution includes regression analysis in excel, interpretation of results , limitations of analysis and significance of the results to the organization as a whole.

$2.19