excel

profileKamlesh28
ba6933week_3sp2017.xlsx
Home>Education homework help>excel

Week#3

Name:
Course:
Activity Grade Weight
Ch 7-15 0.00% 2
Ch 7-27 0.00% 4
Ch 7-37 0.00% 4
Ch 8-7 0.00% 5
Ch 8-21 0.00% 5
Ch 8-27 0.00% 5
Ch 8-31 0.00% 6
Week #3 Average 0.00%

Ch 7-15

Ratings
57
20
61
57
86
80
74
79
72
83
73
74
a. 68
b. 17.893625071

Ch 7-27

Wages StdEv
Male 21.68 2.3
Female 18.8 2.05
a. 0.8757528822
b. 0.9154095568
c.
Von Plessner: Select the best answer		 a b
d. 0.0544573472

Ch 7-37

a. Mean Mean 0.12 0.013984118
b. 0.9681
c. 0.7165697591

Ch 8-7

Cost ($)
1902
2042
1936
1817
1504
1572
1532
1907
1882
2153
1945
1335
2006
1516
1839
1739
1456
1958
1934
2094
1739 a 70.6810950418
1434
1667 b.
1679 mean 1836.84
1736
1670 stdev 239.2201923086
1770
2052 Upper Limit 1907.5210950418
1379
1939 Lower Limit 1766.1589049582
1854
1913
2163
1737
1888
1737
2230
2131
1813
2118
1978
2166
1482
1700
1679
2060
1683
1850
2232
2294

Ch 8-21

Savings per Visit ($)
92
105
56
76
93
78
53
34
83
49
48
74
93
82
40
55
40
96
73
100
Mean 71
Stdev 22.351262769
t -2.0930240544
Upper Limit 81.4607129776
Lower Limit 60.5392870224

Ch 8-27

Planning Value 3750
a. 500 0
b 200 0
c 100 0
d
Von Plessner: Select the best answer		 Yes No

Ch 8-31

a 0.25
b 0.0216506351
c
proportion 0.25
Z 1.9599639845
Upper Limit 0.292434465
Lower Limit 0.207565535