Question: You have just been hired as a data science intern for a consulting company in Toronto. Your boss is working with a local company that
You have just been hired as a data science intern for a consulting company in Toronto. Your boss is working with a local company that is interesting in evaluating its advertising effectiveness. You are asked to help in evaluating the effectiveness of the company's advertising for a particular product. Another intern provides you with 14 years of sales and advertising data both for the client company and its major competitor. Your task is to provide insight to the company. (Please note that this is a beginning exploratory analysis meant to provide guidance for further steps.) Analyse the data and provide your boss with (1) Clear conclusions/advice free from statistical jargon and (2) a summary of your final model(s) with appropriate diagnostics.
| Year Number | Sales ($1000s) | Advertising ($1000s) | Advertising Ratio {Company/Competitor} | Personal Disposable Income ($ billion) | Sales |
| 1 | 105,000 | 16,300 | 1.25 | 547.9 | 105,000 |
| 2 | 105,000 | 15,800 | 1.34 | 593.4 | 105,000 |
| 3 | 121,600 | 16,000 | 1.22 | 638.9 | 121,600 |
| 4 | 113,750 | 14,200 | 1 | 695.3 | 113,750 |
| 5 | 113,750 | 15,000 | 1.15 | 751.8 | 113,750 |
| 6 | 128,925 | 14,000 | 1.13 | 810.3 | 128,925 |
| 7 | 142,500 | 15,400 | 1.05 | 914.5 | 142,500 |
| 8 | 126,000 | 18,250 | 1.27 | 998.3 | 126,000 |
| 9 | 162,000 | 17,300 | 1.07 | 1096.1 | 162,000 |
| 10 | 191,625 | 23,000 | 1.17 | 1194.4 | 191,625 |
| 11 | 189,000 | 19,300 | 1.07 | 1311.5 | 189,000 |
| 12 | 210,000 | 23,056 | 1.54 | 1462.9 | 210,000 |
| 13 | 224,250 | 26,000 | 1.59 | 1641.7 | 224,250 |
| 14 | 245,000 | 28,000 | 1.56 | 1821.7 | 245,000 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
