Purchase Solution

Regression Analysis in Business Research

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution

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.

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 ...

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.