AIPT Cost of Living Adjustments Regression Analysis Worksheet The dataset Concert Sales provides data on sales in dollars and the number of radio, TV, and

AIPT Cost of Living Adjustments Regression Analysis Worksheet The dataset Concert Sales provides data on sales in dollars and the number of radio, TV, and newspaper ads promoting the concerts for a group of cities.
Develop a multiple regression model using the number of radio and TV ads and newspaper ads as the explanatory variables and sales as the response variable. Report the estimated regression equation
Use the model to predict the sales if the number of Radio and TV ads is 20 thousand and the number of Newspaper ads is 55 thousand. (Include your Excel work)
Use the dataset Cost of Living Adjustments to find a multiple regression model to predict the salary as a function of all five of the adjusted cost of living rates.
Interpret the slope coefficient for the Housing rate in context.
Interpret the adjusted R2 value and the standard error of the estimate value in context.
The dataset Cameras lists a sample of cameras variables and their consumer report scores. Recode Brand as a dummy variable with 1 = Nikon and 0 = Canon. a) Develop a multiple regression model predicting the consumer report score based off the camera’s brand, weight, price, and megapixels. Report the estimated regression equation.b) Interpret the coefficient for the Brand dummy variable in context.c) Predict the consumer report score for a Nikon camera that has a price of $350, a weight of 7 ounces, and 11 megapixels. (include your Excel work) Concert Sales
Thousands of Thousands of
Sales ($1000)Radio&TV ads Newspaper ads
$1.119,00
0
40
$973,00
0
40
$875,00
25
25
$625,00
25
25
$910,00
30
30
$971,00
30
30
$931,00
35
35
$1.177,00
35
35
$882,00
40
25
$982,00
40
25
$1.628,00
45
45
$1.577,00
45
45
$1.044,00
50
50
$914,00
50
50
$1.329,00
55
20
$1.330,00
55
20
$1.405,00
60
30
$1.436,00
60
30
$1.521,00
65
35
$1.741,00
65
35
$1.866,00
70
40
$1.717,00
70
40
Cost of Living Adjustments
City
Atlanta
Austin
Boston
Charleston
Charlotte
Chicago
Columbus
Dallas
DC
Denver
Detroit
Indianapolis
Los Angeles
Lousiville
Minneapolis
New Orleans
New York
Philadelphia
Phoenix
Pittsburgh
Portland
San Diego
San Francisco
Seattle
St. Louis
Comparative SalaryGroceries Housing
Utilities
Transportation
$60,482.00
15%
25%
-10%
6%
$57,530.00
-8%
13%
-1%
-1%
$85,904.00
16%
141%
43%
11%
$60,904.00
18%
22%
11%
-7%
$58,012.00
11%
5%
2%
-2%
$70,000.00
23%
73%
1%
18%
$54,578.00
1%
-1%
-5%
-6%
$58,072.00
12%
-4%
-3%
1%
$87,892.00
20%
214%
-6%
13%
$65,843.00
7%
64%
-8%
1%
$57,590.00
-2%
15%
0%
6%
$55,120.00
3%
4%
-11%
-6%
$83,795.00
16%
168%
10%
29%
$55,602.00
1%
2%
-13%
5%
$65,060.00
16%
43%
-10%
10%
$57,530.00
10%
24%
-17%
-5%
$136,024.00
37%
479%
26%
30%
$72,048.00
26%
72%
17%
10%
$57,651.00
7%
21%
-8%
2%
$59,578.00
9%
21%
-3%
14%
$77,349.00
25%
108%
-18%
19%
$86,446.00
18%
187%
18%
27%
$105,241.00
38%
304%
3%
26%
$83,253.00
33%
133%
2%
21%
$56,084.00
14%
-9%
13%
1%
Source: CNN Money Cost of Living Calculator, December 2015
Healthcare
5%
6%
33%
10%
6%
2%
-1%
5%
-3%
11%
-1%
1%
13%
-8%
8%
1%
19%
3%
1%
-1%
15%
15%
22%
24%
4%
Observation
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Brand
Canon
Canon
Canon
Canon
Canon
Canon
Canon
Canon
Canon
Canon
Canon
Canon
Canon
Nikon
Nikon
Nikon
Nikon
Nikon
Nikon
Nikon
Nikon
Nikon
Nikon
Nikon
Nikon
Nikon
Nikon
Nikon
Price ($) Megapixels
Weight (oz.)
330
10
7
200
12
5
300
12
7
200
10
6
180
12
5
200
12
7
200
14
5
130
10
7
130
12
5
110
16
5
90
14
5
100
10
6
90
12
7
270
16
5
300
16
7
200
14
6
400
14
7
120
14
5
170
16
6
150
12
5
230
14
6
180
12
6
130
12
6
80
12
7
80
14
7
100
12
4
110
12
5
130
14
4
Score
66
66
65
62
62
61
60
60
59
55
52
51
46
65
63
61
59
57
56
56
55
53
53
52
50
46
45
42

Purchase answer to see full
attachment