FOR Rahul5077 only, quantitative methods

profilepcwc0506
workm3a1.xlsx
Home>Business & Finance homework help>Accounting homework help>FOR Rahul5077 only, quantitative methods

Question 1

1. Call centers typically have high turnover. The director of human resources for a large bank has compiled data on about 70 former employees at one of the bank's call center in the Excel file Call Center Data. In writing
an article about call center working conditions, a reporter has claimed that the average tenure is no more than two years. Formulate and test a hypothesis using these data to determine if this claim can be disputed.
Length of Service (years)
7.02
3.47
2.07
1.78
4.42
3.29
3.05
0.49
0.61
3.12
2.95
2.15
4.03
3.53
2.47
2.15
3.27
1.10
1.78
1.94
2.91
3.02
2.53
1.84
2.88
2.20
1.44
2.53
1.41
1.08
0.98
0.63
1.30
2.13
2.30
2.05
2.13
2.12
2.16
2.04
1.70
2.11
1.75
2.15
2.12
0.37
1.95
1.02
1.26
1.04
1.64
1.75
1.71
1.29
1.48
1.31
1.46
1.88
1.16
1.16
1.05
0.96
1.24
0.81
0.87
0.99
0.76
0.32
0.35
0.57

1 - Call Center Data

Call Center Data
Male = 1 Female = 0 Yes = 1 No = 0 Yes = 1 No = 0
Gender Starting Age Prior Call Center Experience College Degree Length of Service (years)
0 18 0 0 7.02
1 18 1 0 3.47
0 19 0 0 2.07
0 19 0 0 1.78
0 19 0 0 4.42
0 19 0 0 3.29
0 19 1 0 3.05
1 19 1 0 0.49
1 19 1 0 0.61
1 19 0 0 3.12
0 20 0 0 2.95
0 20 1 0 2.15
0 20 0 0 4.03
1 20 0 0 3.53
1 20 0 0 2.47
0 21 0 0 2.15
1 21 0 0 3.27
1 21 0 0 1.10
1 21 0 0 1.78
0 22 0 0 1.94
0 22 1 0 2.91
0 23 1 0 3.02
0 23 1 0 2.53
0 23 0 1 1.84
1 23 1 0 2.88
1 23 0 0 2.20
1 23 0 1 1.44
1 24 0 0 2.53
1 24 0 1 1.41
1 24 0 1 1.08
0 25 1 1 0.98
1 25 1 0 0.63
1 25 0 1 1.30
1 25 1 1 2.13
0 26 1 0 2.30
0 26 1 1 2.05
0 26 1 1 2.13
1 26 1 1 2.12
1 26 0 1 2.16
1 27 0 0 2.04
0 28 0 0 1.70
0 28 0 1 2.11
1 29 0 1 1.75
0 30 0 1 2.15
1 30 1 0 2.12
1 30 0 1 0.37
0 31 0 0 1.95
0 31 0 0 1.02
0 31 0 1 1.26
1 31 0 0 1.04
0 32 0 1 1.64
1 32 1 0 1.75
1 32 1 1 1.71
1 33 0 0 1.29
0 34 1 0 1.48
0 34 0 1 1.31
1 34 0 0 1.46
1 34 1 0 1.88
1 36 0 1 1.16
0 39 0 0 1.16
0 39 0 1 1.05
1 39 0 0 0.96
0 40 1 0 1.24
0 40 0 0 0.81
1 41 1 0 0.87
0 43 1 0 0.99
0 43 1 0 0.76
0 45 0 0 0.32
0 47 1 1 0.35
0 50 1 0 0.57

Question 4

5. The Excel file Sales Data provides data on a sample of customers. An industry trade publication stated that the average profit per customer for this industry was at least $4,500. Using a test of hypothesis,
do the data support this claim or not? The company believes that their average profit exceeds $4,500. Test a hypothesis to determine if there is evidence to support this.

4 - Sales Data

Sales Data
Customer Percent Gross Profit Gross Sales Gross Profit Industry Code Competitive Rating*
1 51.0% $170.00 $86.70 1 2
2 32.0% $181.00 $57.92 3 4
3 20.0% $203.00 $40.60 2 2
4 22.0% $249.00 $54.78 5 1
5 21.0% $476.00 $99.96 5 1
6 21.0% $476.00 $99.96 5 4
7 22.0% $635.00 $139.70 2 3
8 34.0% $856.00 $291.04 3 3
9 26.0% $1,062.00 $276.12 4 2
10 16.6% $1,110.00 $183.71 7 3
11 20.0% $1,153.00 $230.60 7 3
12 36.0% $1,392.00 $501.12 4 2
13 18.0% $1,743.00 $313.74 4 2
14 20.0% $2,307.00 $461.40 7 3
15 5.0% $2,534.00 $126.70 4 5
16 29.0% $2,683.00 $778.07 7 2
17 10.0% $2,780.00 $278.00 2 3
18 37.0% $3,272.00 $1,210.64 5 3
19 60.0% $3,864.00 $2,318.40 7 1
20 24.0% $3,988.00 $957.12 6 3
21 9.0% $4,072.00 $366.48 7 3
22 50.0% $4,190.00 $2,095.00 5 3
23 17.0% $4,219.00 $717.23 3 4
24 32.0% $4,711.00 $1,507.52 7 1
25 15.0% $4,824.00 $723.60 6 3
26 10.0% $4,878.00 $487.80 7 4
27 13.0% $5,157.00 $670.41 7 2
28 22.0% $5,552.00 $1,221.44 2 3
29 17.0% $5,876.00 $998.92 1 3
30 19.0% $5,888.00 $1,118.72 6 4
31 6.0% $7,632.00 $457.92 5 4
32 23.0% $8,058.00 $1,853.34 3 3
33 23.0% $12,056.00 $2,772.88 7 2
34 14.0% $12,981.00 $1,817.34 2 4
35 22.0% $13,406.00 $2,949.32 2 3
36 14.0% $15,882.00 $2,223.48 7 3
37 28.0% $16,343.00 $4,576.04 3 3
38 27.0% $19,985.00 $5,395.95 5 3
39 3.0% $20,160.00 $604.80 5 5
40 46.0% $26,616.00 $12,243.36 5 2
41 26.0% $28,018.00 $7,284.68 5 3
42 11.0% $28,950.00 $3,184.50 4 4
43 18.0% $29,646.00 $5,336.28 4 3
44 37.0% $31,019.00 $11,477.03 6 1
45 20.0% $31,305.00 $6,261.00 2 3
46 21.0% $34,769.00 $7,301.49 7 1
47 10.0% $34,817.00 $3,481.70 4 3
48 14.0% $38,609.00 $5,405.26 1 3
49 9.0% $38,923.00 $3,503.07 2 5
50 16.0% $40,536.00 $6,485.76 4 3
51 22.0% $54,851.00 $12,067.22 6 2
52 21.0% $54,861.00 $11,520.81 7 2
53 17.0% $58,063.00 $9,870.71 5 4
54 11.0% $62,862.00 $6,914.82 4 5
55 7.0% $78,574.00 $5,500.18 3 5
56 14.0% $92,776.00 $12,988.64 4 3
57 15.0% $112,837.00 $16,925.55 1 4
58 13.0% $115,999.00 $15,079.87 4 5
59 21.0% $120,854.00 $25,379.34 5 4
60 14.0% $179,101.00 $25,074.14 6 3
*Rates the amount of competition for sales of the products sold to these customers: 1 = very little competition to 5 = very competitive

Question 9

9. Using the data in the Excel file Consumer Transportation Survey, test the following null hypothesis:
a. Individuals spend at least 10 hours per week in their vehicles.
b. Individuals drive an average of 450 miles per week.
c. The average age of SUV drivers is no greater than 35.
d. At least 75% of individuals are satisfied with their vehicles.

9 - Consumer Transportation Sur

Consumer Transportation Survey
Vehicle Driven Type Satisfaction with vehicle Gender Age # of hours per week in vehicle Miles driven per week Number of Children Average number of riders Miles from work
Truck Domestic Yes Male 31 10 450 0 1 30
Truck Domestic Yes Male 29 5 370 1 1 22
Truck Foreign No Male 26 12 580 0 1 15
Truck Domestic No Male 18 6 300 0 1 20
SUV Domestic Yes Male 49 21 1000 0 1 22
SUV Foreign Yes Male 50 16 840 2 1 45
SUV Domestic Yes Male 48 15 1400 3 4 25
SUV Foreign Yes Male 45 5 300 2 2 20
SUV Domestic Yes Male 45 15 850 0 1 25
SUV Domestic Yes Male 44 10 700 2 1 40
SUV Foreign Yes Male 41 5 350 1 1 20
SUV Domestic Yes Male 41 30 1500 4 3 15
SUV Foreign No Female 39 6 280 1 1 17
SUV Foreign Yes Female 36 4 400 0 1 20
SUV Foreign Yes Female 33 3 420 0 1 25
SUV Domestic Yes Male 31 10 675 0 1 35
SUV Domestic No Female 31 15 800 1 1 50
SUV Domestic No Female 29 4 300 1 1 20
SUV Domestic Yes Male 28 3 400 1 1 15
Mini Van Domestic Yes Female 55 8 400 0 2 0
Mini Van Domestic No Female 43 10 700 2 3 0
Mini Van Domestic Yes Female 41 10 720 1 2 15
Mini Van Foreign Yes Female 38 10 450 4 5 0
Mini Van Foreign Yes Female 39 15 1000 1 2 0
Mini Van Domestic No Male 35 5 350 2 2 0
Mini Van Domestic Yes Female 33 10 800 2 3 0
Mini Van Foreign Yes Female 32 2 200 4 5 5
Mini Van Foreign Yes Female 28 8 350 3 4 0
Car Domestic Yes Female 21 4 150 0 1 0
Car Domestic No Female 62 5 175 0 2 0
Car Domestic Yes Female 61 5 355 0 1 15
Car Foreign Yes Male 60 5 150 0 1 10
Car Domestic No Male 58 10 600 0 1 35
Car Domestic Yes Female 51 11 600 0 1 40
Car Domestic Yes Female 47 4 300 0 1 21
Car Domestic No Male 46 4 275 0 1 18
Car Domestic No Male 44 6 285 2 3 16
Car Foreign No Female 42 5 400 2 3 22
Car Foreign Yes Female 41 5 350 2 2 23
Car Domestic No Female 41 10 600 1 2 34
Car Domestic Yes Female 39 10 700 1 2 45
Car Foreign Yes Female 34 10 600 1 2 16
Car Foreign Yes Male 33 5 400 1 2 22
Car Foreign Yes Male 30 5 350 1 2 18
Car Domestic Yes Female 29 5 250 0 1 19
Car Foreign Yes Female 27 6 355 0 2 23
Car Foreign Yes Female 26 5 175 0 1 11
Car Domestic No Female 24 5 300 0 1 4
Car Domestic Yes Female 22 5 350 0 1 3
Car Foreign No Female 19 5 500 0 2 4

Question 11

11. The Excel file Baseball Attendance shows the attendance in thousands at San Francisco Giants' baseball games for the 10 years before the Oakland A's moved to the Bay Area in 1968, as well as the combined
attendance for both teams for the next 11 years. Is there a statistical reason to believe that overall attendance has changed after the A's move?

11 - Baseball Attendance

Baseball Attendance
0 = San Francisco Giants (1958-1967 seasons)
Year Attendance 1 = Giants plus Oakland A's after A's move to Oakland (1968-1978 seasons)
1958 1273 0
1959 1422 0
1960 1795 0
1961 1391 0
1962 1593 0
1963 1571 0
1964 1504 0
1965 1546 0
1966 1657 0
1967 1242 0
1968 1674 1
1969 1652 1
1970 1519 1
1971 2021 1
1972 1569 1
1973 1835 1
1974 1366 1
1975 1601 1
1976 1408 1
1977 1196 1
1978 2267 1