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

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. Unit 4 Assignment- Part 2 CORN SOYBEANS WHEAT 4152 1127 1352 6639 1798 2381 4175 1636 2420 7672 1861 2595 8876 2099 2424 8226 1940 2091 7131 1938 2108 4929 1549 1812 7525 1924 2037 7933 1922 2739 The International Agricultural Producers publishes annual data on various selected farm products. Shown above are the unit production figures (in millions of bushels) for three farm products for 10 years. Use this data and multiple regression analysis to predict corn production by the production of soybeans and wheat. Comment on the results. Please see attachment for the description of my question


Document Preview:

_KULogo.jpg Assignment Unit 4 Assignment- Part 1 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. Unit 4 Assignment- Part 2 CORN SOYBEANS WHEAT 4152 1127 1352 6639 1798 2381 4175 1636 2420 7672 1861 2595 8876 2099 2424 8226 1940 2091 7131 1938 2108 4929 1549 1812 7525 1924 2037 7933 1922 2739 The International Agricultural Producers publishes annual data on various selected farm products. Shown above are the unit production figures (in millions of bushels) for three farm products for 10 years. Use this data and multiple regression analysis to predict corn production by the production of soybeans and wheat. Comment on the results.



May 15, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here