Shown below are the sales revenue and advertising cost data for seven companies published by International ...

profileguru2009
 (Not rated)
 (Not rated)
Chat

         Use the Excel Regression link located in the Data   Analysis Toolpak.        Shown   below are the sales revenue and advertising cost data for seven companies   published by International Advertising Age.    COMPANY ADVERTISING ($ MILLIONS) SALES ($ BILLIONS)       Wal-Mart 1,073 351.1       Ford   Motor 2,577 160.1       Airbus 4,898 68.2       Reuters   Group 2,822 93.2       ATT 3,345 63.1       Fujifilm 829 91.7       Toyota 3,296 207.3               Use   the above data to develop a regression line to predict the amount of   advertising by sales. Compute the Standard Error and the ‘r2’ from the   regression output.    Comment   on the strength of the regression model.        

    • 8 years ago
    The regression equation is y = -6.62x + 3670.08 ...
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      Shownbelowarethesalesrevenueandadvertisingcostdataforsevencompanies.xls