Explore BrainMass
Share

# Examining Regression Analysis

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

https://brainmass.com/statistics/regression-analysis/examining-regression-analysis-148168

#### Solution Preview

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

#### Solution Summary

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

\$2.19
Similar Posting

## Regression Analysis - Study Time and Exam Score

Using Excel, prepare a linear regression equation for the following data and use it for prediction.

A random sample of study times for 12 students tracks hours of study for their advanced tax exam and the percentage grades they subsequently earned on their tax exam. Assume that study times have been compiled over a weekend.

Using Excel, prepare a linear regression equation for the following data and use it for prediction.

A random sample of study times for 12 students tracks hours of study for their advanced tax exam and the percentage grades they subsequently earned on their tax exam. Assume that study times have been compiled over a weekend.

Hours 10 16 12 11 9 15 14 13 9 10 11 12
Grade 98 90 85 92 75 95 90 85 70 85 80 93