Statistics

Order Instructions/Description

Cleveland Clothing Store is interested in investing in advertising to increase their sales. They consider 4 different channels of advertisement: TV, radio, print, and other (i.e. social media). They want to find the relationship between the amount spent in each advertisement type and the sales amount.They take measurements for 18 days and the data is given below:

$1000s    $1000s    $1000s    $1000s    $1000s
Row    sales    tv    radio    print    other
1    18.4    48.4    34.9    14.9    8.4
2    21.8    55.4    23.8    12.1    9.7
3    21.6    56.6    20.6    11.9    7.9
4    33.8    61.6    14.1    17.5    9.9
5    20.9    49.4    28.6    10.9    8
6    15.9    47.4    27.9    12.4    7.9
7    49.5    72.8    43.4    13.1    11.4
8    26.7    59.9    13.7    14.7    9.8
9    28.7    58.3    27.3    9.8    9.1
10    19.7    51.8    22.9    21.1    8.8
11    45.8    65.1    39    29.4    12.3
12    54.4    68.2    41.4    32.7    14.3
13    18.9    49.9    31    13.5    6.8
14    11.4    45.5    24.8    16.6    5.8
15    28.9    55.4    18.2    19    9.8
16    28.6    57.3    14.6    22.8    11
17    41.9    63.5    37.9    34.2    13.5
18    49.2    71.1    23.1    13.6    11.5
1) Find the least squares prediction equation where the sales is the dependent variable and the amount of investments in TV, radio, print, and other type of advertisements as the independent variables