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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!