Purchase Solution

Examining Regression Analysis

Not what you're looking for?

Ask Custom Question

I need to identify a business research issue, problem, or opportunity that can be examined using regression analysis.

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

2- Present the data used in the analysis, as a single table in the body of the paper or as an appendix.

3- Present the Excel regression analysis table as an appendix.
Discuss the correlation coefficient, the coefficient of determination, and the regression equation.

4- Show the scatter plot of the data, with regression line superimposed.

5- Must show the hypothesis test of the significance of the correlation coefficient.

6- State the limitations of your analysis, and describe the significance of the results to the organization as a whole.

Purchase this Solution

Solution Summary

This Solution contains over 6000 words and calculations to aid you in understanding the Solution to these questions.

Solution Preview

Please see attached files. Thanks.

Solution
Problem description
A CEO of a large pharmaceutical company would like to determine if he should be placing more money allotted in the budget next year for television advertising of a new drug marketed for controlling asthma. He wonders whether there is a strong relationship between the amount of money spent on television advertising for this new drug called XBC and the number of orders received. The manufacturing process of this drug is very difficult and requires stability so the CEO would prefer to generate a stable number of orders. The cost of advertising is always an important consideration in the phase I roll-out of a new drug. Data that have been collected over the past 20 months indicate the amount of money spent of television advertising and the number of orders received. The results are as follows:
Month Advertising Cost (thousands of dollars) Number of ...

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

Measures of Central Tendency

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