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.

© BrainMass Inc. brainmass.com October 16, 2018, 8:23 pm ad1c9bdddf
https://brainmass.com/statistics/regression-analysis/examining-regression-analysis-148168

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

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

(a) Paste your printout here.

(b) Compose the prediction equation.

(a) Use the regression equation to predict the grade of a student who takes the same exam the following semester after having studied 12 hours for it.

A multiple regression equation for the list price of homes in a certain community in the USA is , where represents age in years and represents number of rooms.

If a prospective buyer is interested in an older, well-constructed home about 55 years old with 10 rooms, what would be the predicted list price in that community? (Show your procedure.)

View Full Posting Details