Regression Analysis in Business Research
Not what you're looking for?
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.