The strategic planner for the corporation believes dollars spent on advertising can to some extent be a predictor of total sales dollars. As an aid...

A corporation owns several companies. The strategic planner for the corporation believes dollars spent on advertising can to some extent be a predictor of total sales dollars. As an aid in long-term planning, she gathers the following sales and advertising information from twelve of the companies for 2011 (in $ millions). Solve by excel and by mega stat.ADVERTISING: 12.5 ; 3.7 ; 21.6 ; 60.0 ; 37.6 ; 6.1 ; 16.8 ; 41.2 ; 18.4 ; 26.3 ; 48.7 ; 58.4SALES: 148; 55 ; 338 ; 994 ; 541 ; 89 ; 126 ; 379 ; 232 ; 312 ; 442 ; 5131)