the number of murders and robberies per 100,000 population for a random selection of states is show.
a.Find the correlation coefficient.
b.Find the equation of the regression line
c.Find the value for y when x=4.5 using the regression equation from above. Assume there is a relationship.
Murders 2.4 2.7 5.6 2.6 2.1 3.3 6.6 5.7
Robberies 25.3 14.3 151.6 91.1 80 49 173 95.8
X :- Murders
Y :- Robberies
ΣX = 31
ΣY = 680.1
ΣX * Y = 3202.71
ΣX2 = 142.52
ΣY2 = 80033.99
Correlation coefficient
r = 0.804
Equation of regression line is Ŷ = a + bX
b = 25.333
a =( Σ Y - ( b * Σ X) ) / n
a =( 680.1 - ( 25.3326 * 31 ) ) / 8
a = -13.151
Equation of regression line becomes Ŷ = -13.151 + 25.333 X
When X = 4.5
Ŷ = -13.151 + 25.333 X
Ŷ = -13.151 + ( 25.333 * 4.5 )
Ŷ = 100.85
the number of murders and robberies per 100,000 population for a random selection of states is...
The number of murders and robberies per 100,000 population for a random selection of states are shown. Let the x variable be murders and the y variable be robberies. Given that r = 0.8042, Sx = 1.789, Sy = 56.337. Murders 2.4 2.7 5.6 2.6 2.1 3.3 6.6 5.7 Robberies 25.3 14.3 151.6 91.1 80 49 173 95.8 a) Find the equation for the regression line. b) Find the predicted value for the number of robberies when x = 4.
(a) A recent study of home technologies reported (as per the following table) the number of hours of personal computer usage per week for a sample of 60 persons. 9.3 5.3 6.3 8.8 6.5 0.6 5.2 6.6 9.3 4.3 6.3 2.1 2.7 0.4 3.7 3.3 1.1 2.7 6.7 6.5 4.3 9.7 7.7 5.2 1.7 8.5 4.2 5.5 5.1 5.6 5.4 4.8 2.1 10.1 1.3 5.6 2.4 2.4 4.7 1.7 2.0 6.7 1.1 6.7 2.2 2.6 9.8 6.4 4.9 5.2 4.5...
The data on the below shows the number of hours a particular drug is in the system of 200 females. Develop a histogram of this data according to the following intervals: Follow the directions. Test the hypothesis that these data are distributed exponentially. Determine the test statistic. Round to two decimal places. (sort the data first) [0, 3) [3, 6) [6, 9) [9, 12) [12, 18) [18, 24) [24, infinity) 34.7 11.8 10 7.8 2.8 20 9.8 20.4 1.2 7.2...
INN
MARGIN
ROOMS
NEAREST
OFFICE
COLLEGE
INCOME
DISTTWN
1
44.2
3471
2.1
523
12
35
9.4
2
29.8
3567
1.8
140
13.5
42
5.7
3
38.4
3264
1.6
404
22.5
45
4.4
4
54.4
3234
1.1
649
19.5
35
6.5
5
34.5
2730
4
171
17
41
10.5
6
44.9
3003
3.4
402
15.5
37
4.6
7
46
2341
2
580
23
45
7.4
8
50.2
3021
2.6
572
8.5
33
9.3
9
46
2655
3.2
666
22
40
6.7...
Please use excel to solve. Any
help would be greatly appreciated.
A B E F G 1 C D Changes in Consumer Price Index, 1960-2006 (Percent) 2 Year-Year Percent Change in Commodities CPI Year-Year Percent Change in Services CPI 3 4 5 6 7 8 Commodities% 0.9 Services% 3.4 0.6 1.7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37...
INN
MARGIN
ROOMS
NEAREST
OFFICE
COLLEGE
INCOME
DISTTWN
1
61
3203
0.1
549
8
37
12.1
2
34
2810
1.5
496
17.5
39
0.4
3
46
2890
1.9
254
20
39
12.2
4
31.9
3422
1
434
15.5
36
2.7
5
57.4
2687
3.4
678
15.5
32
7.9
6
47.5
3080
2.4
488
13.5
31
6.7
7
54.4
2756
1.1
832
14.5
35
6.9
8
46.2
2244
0.7
496
15.5
38
8.9
9
54.1
2862
1.4
809
16.5
33
3...
data file: "STATE" "MALE" "BIRTH" "DIVO" "BEDS" "EDUC" "INCO" "LIFE" AK 119.1 24.8 5.6 603.3 14.1 4638 69.31 AL 93.3 19.4 4.4 840.9 7.8 2892 69.05 AR 94.1 18.5 4.8 569.6 6.7 2791 70.66 AZ 96.8 21.2 7.2 536.0 12.6 3614 70.55 CA 96.8 18.2 5.7 649.5 13.4 4423 71.71 CO 97.5 18.8 4.7 717.7 14.9 3838 72.06 CT 94.2 16.7 1.9 791.6 13.7 4871 72.48 DC 86.8 20.1 3.0 1859.4 17.8 4644 65.71 DE 95.2 19.2 3.2 926.8 13.1...
2. Regression review II, problem 6 Aa Aa E This question aims to review the La Quinta Inn model building exercise as discussed in lecture and described in the course packet. The data collected can be obtained in this Excel file. (Note: Reload this file each time you go through this problem.) The coefficient of multiple determination for the regression of profit margin (MARGIN) on all the other variables is The adjusted coefficient of multiple determination is From the regression...
All Greens is a franchise store that sells house plants and lawn and garden supplies. Although All Greens is a franchise, each store is owned and managed by private individuals. Some friends have asked you to go into business with them to open a new All Greens store in the suburbs of San Diego. The national franchise headquarters sent you the following information at your request. These data are about 27 All Greens stores in California. Each of the 27...
All Greens is a franchise store that sells house plants and lawn and garden supplies. Although All Greens is a franchise, each store is owned and managed by private individuals. Some friends have asked you to go into business with them to open a new All Greens store in the suburbs of San Diego. The national franchise headquarters sent you the following information at your request. These data are about 27 All Greens stores in California. Each of the 27...