Preview

Linear Correlation and Regression Analysis

Satisfactory Essays
Open Document
Open Document
363 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Linear Correlation and Regression Analysis
Project 1: Linear Correlation and Regression Analysis

Gross Revenue and TV advertising:

Pfizer Inc, along with other pharmaceutical companies, has begun investing more promotion dollars into television advertising. Data collected over a two year period, shows the amount of money Pfizer spent on television advertising and the revenue generated, all on a monthly bases.

|Month |TV advertising |Gross Revenue |
|1 |17 |4.1 |
|2 |14 |3.9 |
|3 |20 |5 |
|4 |18 |4.8 |
|5 |16 |4.7 |
|6 |16 |4 |
|7 |16 |4.6 |
|8 |19 |5.1 |
|9 |15 |4.4 |
|10 |15 |4.4 |
|11 |16 |4.8 |
|12 |17 |5.1 |
|13 |17 |5 |
|14 |17 |4.8 |
|15 |17 |5.2 |
|16 |16 |4.6 |
|17 |16 |4.8 |
|18 |17 |5.2 |
|19 |17 |5.3 |
|20 |18 |5.5 |
|21 |17 |5.2 |
|22 |17 |4.9 |
|23 |18 |5.4 |
|24 |17 |4.8 |

Objective:

The objective of this report is to conduct a correlation and regression analysis that studies the relationship between Revenue and TV advertising in arriving at a mathematical equation that can help to understand and forecast

You May Also Find These Documents Helpful

  • Satisfactory Essays

    The equation of the ‘best fit’ line or the regression equation is SALES(Y) = 9.638 + 0.2018 CALLS(X1)…

    • 1056 Words
    • 6 Pages
    Satisfactory Essays
  • Powerful Essays

    Television is one of the most dominating forms of communication in the world. In any first-world country, it would be surprising to hear of someone who doesn 't have a TV or have access to a TV. In Australia, people watch up to 6 hours of TV daily (Screen Australia, 2013). With this sort of attention, it 's only natural that businesses would utilise it to advertise their products, and as this and other technologies evolves it makes it far easier to access other markets that would have been unavailable in the past. Advertising, as a medium, is so…

    • 2025 Words
    • 9 Pages
    Powerful Essays
  • Better Essays

    Linear Regression Model

    • 1041 Words
    • 5 Pages

    a) be biased away from zero, so that the impact of skipped on colGPA is…

    • 1041 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Pfizer Inc. is a large pharmaceutical company that engages in the discovery of new technologies, the manufacture of prescription and "over the counter" (OTC) medicines, as well as the marketing of such products. It operates in three distinct segments that include Human Health, Consumer Healthcare, and Animal Health. For fiscal year 2004, the company generated approximately $53 billion in revenue that contributed to over $11 billion in net income. (Pfizer, 2004)…

    • 1018 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Escape Fire Pros And Cons

    • 623 Words
    • 3 Pages

    The $395 billion US pharmaceutical industry spent $5.2 billion on advertising prescription drugs directly to consumers in 2015. All of this money spent on advertising could have been spent on helping people lower the risk of suffering from their diseases. We are probably still advertising prescription drugs because of the money and how it makes people think that it is helping them while it is also harming them.…

    • 623 Words
    • 3 Pages
    Good Essays
  • Best Essays

    On economic aspect, advertising is likely to be one of the most important tools of marketing communications, which can help the company to maintain and enlarge the market shares. There are two important concepts, share of market (SOM) and share of voice (SOV), whose relationship can measure relative marketing effectiveness. Shimp (2010: 172) defines brand’ SOM as ”the ratio of one brand’s revenue to total category revenue” and brand’ SOV as ”the ratio of a brand’s advertising expenditures (its [ad spend]) to total category advertising expenditures”. Shimp (2012: 172) also points out higher SOVs can contribute to higher SOMs for a brand. For example, table 1 and table 2 in the appendix illustrate advertising expenditures of top-10 wireless phone brand and top-10 beer brand in 2002 (Shimp 2010: 172). The data show that, in general, share of market is directly proportional to the share of voice. They can interact. In fact, companies have not ignored the expenditures on advertising. Furthermore, the expenditures trend…

    • 1613 Words
    • 7 Pages
    Best Essays
  • Good Essays

    1. Calculate real GDP for 2004 and 2005 using 2004 prices. To calculate the real GDP we use the constant price for 2004 which was $20.…

    • 650 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    The decision made by the analyst on the first week was to increase the advertising budget to $169 million. This increase in the advertising budget will allow Blues Inc. to have a stronger marketing plan and to advertise Blues Inc. across the country. According to the reports the correlation coefficient of…

    • 255 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Yeast Population Growth

    • 569 Words
    • 3 Pages

    | since the transmission and absorbance is being measured at a specific wave length, so if we change it the results will also change…

    • 569 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    2. Competitors Analysis TFC, CNN and Lifetime are three giant players in the fashion channel market which comprises 110 million television households in the United States. Exhibit 1 shows the average ratings figures for each company concerning viewers over 18 years old. Scores are 1.0 (1.1 million households), 3.0(3.3 million households) and 4.0 (4.4 million households) respective. As for the advertising revenue from female audience of the age of 18 through 34, there is a big gap between Lifetime and TFC. The percentage for Lifetime is 43% which is 10% higher than TFC. With both the male and female audience aged 54 through 74, CNN accounts for 45% and 26%, while TFC only has 39% and 20%. From the above data, it is easy to draw the conclusion that TFC is in an unfavorable position. However, when we take the time schedule into consideration, it might be argued that TFC has…

    • 1356 Words
    • 6 Pages
    Powerful Essays
  • Satisfactory Essays

    References: Maitland, O. 2013. Digital Broadcasting - 2012 - Executive Summary. [online] Available at: https://www.keynote.co.uk/market-intelligence/view/product/10639/digital-broadcasting?utm_source=kn.reports.browse [Accessed: 22 Oct 2013].…

    • 287 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    - The explanatory variable is games won, because that was stated in the problem. I…

    • 430 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    In the PRF, Ut is the population error term. The population error term is a random variable that cannot be explained by the PRF. This term represents the difference between the actual value of TNHS and the value predicted by the regression equation. In other words, the error term accounts for variables that affect TNHS…

    • 500 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Regression Analysis

    • 1285 Words
    • 6 Pages

    This presentation on Regression Analysis will relate to a simple regression model. Initially, the regression model and the regression equation will be explored. As well, there will be a brief look into estimated regression equation. This case study that will be used involves a large Chinese Food restaurant chain.…

    • 1285 Words
    • 6 Pages
    Better Essays
  • Good Essays

    Conventional Therapy Cons

    • 793 Words
    • 4 Pages

    Ever observe how many drug commercials consumers are exposed to? The mass media is about making capital just like the pharmaceutical industy and those ads must be making profit for the media and visa-versa. Over the past few yrs. mass media commercials for drugs have exploded. Multi-billions are exhausted on advertisements for prescription drugs and consumers do listen and make inquiries with their doctor on particular drugs they saw or heard in an ad.…

    • 793 Words
    • 4 Pages
    Good Essays