[go: up one dir, main page]

0% found this document useful (0 votes)
78 views78 pages

Practical For IT Skill

The document contains a series of exercises related to frequency distributions, cumulative frequencies, and ogives across various datasets, including phone call lengths, homeowner fees, pollutants, river flows, investment indifference points, newspaper typesetting times, and CD store sales. Each question requires constructing frequency distributions, cumulative frequencies, and interpreting the results to answer specific questions. The solutions include detailed calculations and graphical representations of the data.

Uploaded by

ashodhiya14
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
78 views78 pages

Practical For IT Skill

The document contains a series of exercises related to frequency distributions, cumulative frequencies, and ogives across various datasets, including phone call lengths, homeowner fees, pollutants, river flows, investment indifference points, newspaper typesetting times, and CD store sales. Each question requires constructing frequency distributions, cumulative frequencies, and interpreting the results to answer specific questions. The solutions include detailed calculations and graphical representations of the data.

Uploaded by

ashodhiya14
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 78

Exercises

Question:-1
Here is a frequency distribution of the length of phone calls made by 175 people during a labo

length of minutes frequency


1-7 45
8-14 32
15-21 34
22-28 22
29-35 16
36-42 12
43-49 9
50-56 5

(a) Describe the general shape of the histogram. Does there appear to be a pattern?
(b) Suppose all the people were making their calls from a room that had 10 different phones, and e
(c) Does the order affect the length of time to complete all calls?

Chart Title
50 45
45
40
34
35 32
frequency

30
25 22
20 16
15
10
5
0
1-7 8-14 15-21 22-28 29-35
lenght(in mintue)

(a) With one minor exception the frequencies decrease as length of the calls increase
(b) Let the prople with the longest calls go first ,Whenever a phone becomes available ,let a person
(c) Yes, If we allowed all the 1-7 minutes calls to be made first and then worked upward , the 50-56

Question:-2
Golden acres is a homeowners' association that operates a trailer park outside Orlando,Florid

DATA 66 65
93 66
69 61
73 77
57 56
Construct an ogive that will help you answe these questions;
(a) Roughly what proportion of residents would be eligible for no fee?
(b) Approximately what fee would the board have to change to the remaining (fee-paying) resident

class frequency CF
50-59 5 5
60-69 7 12
70-79 5 17
80-89 3 20
90-99 5 25

CLASS CF CRF
less then 50 0 0
less then 60 5 0.2
less then 70 12 0.48
less then 80 17 0.68
less then 90 20 0.8
less then 100 25 1
SUM 79 3.16

CRF
1.2
cumulative relative frequency

0.8

0.6

0.4

0.2

0
80 100 120 140 160
Age

(a) About 80% will be eligible


(b) The fee will have to be increased to about $60

Question:-3
The Massachusetts Friend's of fish has the following data representing pollutants (in parts per

Pollutants(in ppm ) Frequency


5-8.9 14
9-12.9 16
13-16.9 28
17-20.9 36
21-24.9 20
25-28.9 16
29-32.9 9
33-36.9 7
37-40.9 4

Construct an ogive that will help you answer the following questions:
(a) Below what value (approx.)do the lowest one-fourthof these observations fail?
(b) If the Friends of fish heavily monitor all sites with more than 30 ppm of pollutions<what percen

Solution:-
Pollutants(in ppm ) Frequency C.F(cum.)
less than 5 0 0
less than 9 14 14
less than 13 16 30
less than 17 28 48
less than 21 36 84
less than 25 20 104
less than29 16 120
less than 33 9 129
less than 37 7 136
4 200

Pollutants(in ppm ) C.f


5 0
9 14
13 30
17 48
21 84
25 104
29 120
33 129
37 136
200

(a) 25% of the observations fall below abovt 14 ppm


(b) Approx 11% of the sites will be heavily monitored.

Question:-4
Before constrating a dam on the Colorado River, the U.S Army Corps of engineers performed a

River flow Frequency


1001-1050 7
1051-1100 21
1101-1150 32
1151-1200 49
1201-1250 58
1251-1300 41
1301-1350 27
1351-1400 11
total 246

(a) Use the data given in the table to construts a"more-than" cumulative frequency distribution an
(b) Use the data given in the table to construts a"less-than" cumulative frequency distribution and
(c) Use your ogive to estimate what proportion of the flow occurs at less than 1300 thousands of G

Solution:-

(a) River Flow Frequency Cum. Fre.


more than 1000 246 1
more than 1050 239 0.971544715447155
more than 1100 218 0.886178861788618
more than 1150 186 0.75609756097561
more than 1200 137 0.556910569105691
more than 1250 79 0.321138211382114
more than 1300 38 0.154471544715447
more than 1350 11 0.044715447154472
more than 1400 0 0

River Flow Cum. Fre.


1000 1
1050 0.971544715447155
1100 0.886178861788618
1150 0.75609756097561
1200 0.556910569105691
1250 0.321138211382114
1300 0.154471544715447
1350 0.0447154471544715
1400 0

(b) River Flow Frequency Cum. Fre.


less than 1001 0 0
less than 1051 7 7
less than 1101 21 28
less than 1151 32 60
less than 1201 49 109
less than 1251 58 167
less than 1301 41 208
less than 1351 27 235
less than 1401 11 246
Sum 246

River Flow Cum. Fre.


1001 0
1051 7
1101 28
1151 60
1201 109
1251 167
1301 208
1351 235
246

(c) About 85%

Question:-5
Pamela Mason, a consultant for a small local brokerage firm, was attempting to design investm

Indifference point frequency


70-74 2
75-79 5
80-84 10
85-89 14
90-94 11
95-99 3
100-104 3
105-109 2

(a) Construct both "more-than" "and ""less than" cumulative relative frequemvy distribituion
(b) Graph the 2 distributions in part (a) into relative frequemcy ogives

Solution:-
Indifference Point Frequency Rel. Fre.
70-74 2 0.04
75-79 5 0.1
80-84 10 0.2
85-89 14 0.28
90-94 11 0.22
95-99 3 0.06
100-104 3 0.06
105-109 2 0.04
Sum 50 1

(a) Indifference Point Frequency Cum. Fre.


more than 69 2 1
more than 74 5 0.96
more than 79 10 0.86
more than 84 14 0.66
more than 89 11 0.38
more than 94 3 0.16
more than 99 3 0.1
more than 104 2 0.04
more than 109 0 0

indifference point cum. Fre.


$69 1
74 0.96

cumulative relative frequency


1.2
1
79 0.86 1
84 0.66
0.8
89 0.38
0.6
94 0.16
99 0.1 0.4

104 0.04 0.2


109 0 0
65 70

(b) Indifference Point Frequency Cum. Fre.


less than 69 2 1
less than 74 5 0.96
less than 79 10 0.86
less than 84 14 0.66
less than 89 11 0.38
less than 94 3 0.16
less than 99 3 0.1
less than 104 2 0.04
less than 109 0 0

indifference point cum. Fre.


$70 0
75 0.04
1.2
80 0.14
relative frequency

85 0.34 1

0.8

0.6
1.2

cumulative relative frequency


1
90 0.62 0.8
95 0.84
100 0.9 0.6
105 0.94 0.4
110 1
0.2

0
60

Question:-6
At a newspaper office thre time required to set the entire font page in type was recorded for5
20.8 23.3
25.3 25
23.7 24.1
21.3 24.3
19.7 25
22.8 20.9
20.7 19.5
20.3 19.8
21.5 21.1
24.2 22.2
21.9 22.9
22.5 24.1
23.6 23.9
23.1 20.9
23.8 22.8
22 23.5
21.2 24.2
19 22.8
20.7 21.6
19.9 20.1
20.7 19.5
23.8 21.8
25.1 23.9
24.2 22.7
23.8
20.9

(a) Arrange the data in a array from smallest to largest


(b) Construct a frequency distributiopn and a less than cumulative frequency distributruion frequen

Solution:- (a)
19 22.8
19.5 22.9
19.5 23.1
19.7 23.3
19.8 23.5
19.9 23.6
20.1 23.7
20.3 23.8
20.7 23.8
20.7 23.8
20.7 23.9
20.8 23.9
20.9 24.1
20.9 24.1
20.9 24.2
21.1 24.2
21.2 24.2
21.3 24.3
21.5 25
21.6 25
21.8 25.1
21.9 25.3
22
22.2
22.5
22.7
22.8
22.8

(b)
Minutes to set type frequency
19.0-19.7 4
19.8-20.5 4
20.6-21.3 10
21.4-22.1 5
22.2-22.9 7
23.0-23.7 5
23.8-24.5 11
24.6-25.3 4
TOTAL
50

Chart Title
12
1
10
10

8
7

6
5 5
4 4
4

2
8
7

6
5 5
4 4
4

0
0 1 2 3 4 5 6

Question:-7
Chien-Ling Lee owns a CD store specializing in spoken-word recordings. Lee has 35 months of

Monthly Sales Frequency


$10,000-12,499 2
12,500-14,999 4
15,000-17,499 7
17,500-19,999 5
$20,000-22,499 6
22,500-24,999 8
25,000-27,499 2
27,500-29,999 1

(a) Construct a relative frequency distribution.


(b) Construct,on the same graph, a relative frequency histogram and a relative frequency polygon.

Solution:-
(a) Monthly Sales Frequency Rel. fre.
$10,000-12,499 2 0.057142857142857
12,500-14,999 4 0.114285714285714
15,000-17,499 7 0.2
17,500-19,999 5 0.142857142857143
$20,000-22,499 6 0.171428571428571
22,500-24,999 8 0.228571428571429
25,000-27,499 2 0.057142857142857
27,500-29,999 1 0.028571428571429
Sum 35 1

(b) Mid-Value Frequency


8750 0
11,250 2
13,750 4
16,250 7
9
18,750 5
8
21,250 6
7
23,750 8
Relative frequency

6
26,250 2
5
4
3
2
8
7

Relative frequency
6
5
28,750 1 4
31,250 0 3
2
1 0
0
5000 10000

Question:-8
The National Association of Real Estate Sellers has collected these data on a sample of 130 sales

Earnings Frequency
$ 5,000 or less 5
$ 5,001-$ 10,000 9
$ 10,001-$ 15,000 11
$ 15,001-$ 20,000 33
$ 20,001-$ 30,000 37
$ 30,001-$ 40,000 19
$ 40,001-$ 50,000 9
Over $ 50,000 7

Construct an ogive that will help you answer these questions.


(a) About what proportion of the salespeople earns more than $ 25,000?
(b) About what does the "middle" salespeople in the sample earn?
(c) Approximately how much could a real estate salespeople whose performance was about 25 per

Solution:-
Class Frequency Rel. fre.
< 5,001 5 0.038461538461538
5,001- 10,000 9 0.069230769230769
10,001-15,000 11 0.084615384615385
15,001- 20,000 33 0.253846153846154
20,001- 30,000 37 0.284615384615385
30,001- 40,000 19 0.146153846153846
40,001- 50,000 9 0.069230769230769
> 50,000 7 0.053846153846154
Sum 130 1

0 0
5,000 0.0384615384615385
10,000 0.107692307692308
15,000 0.192307692307692
20,000 0.446153846153846
30,000 0.730769230769231
40,000 0.876923076923077
50,000 0.946153846153846

(a) About 42%


(b) About $22,000
(c) About $31,000

Question:-9
Here is frequency distribution of weight of 150 people who used a skill lift a certain day .Const

Class Frequency
75-89 10
90-104 11
105-119 23
120-134 26
135-149 31
150-164 23
165-179 9
180-194 9
195-209 6
210-224 2

(a) What can you see from the histogram about the data that was not immeediatily apparent from
(b) If each ski lift chair holds two people but is limited in total safe weight capicity to 400 pounds, w

Solution:-
Mid-value Frequency
82.5 10
97.5 11
112.5 23
127.5 26
142.5 31
157.5 23
172.5 9
187.5 9
202.5 6
217.5 2
(a) The lower tail of the distribution if fatter (has more observation in it) than the upper tail .
(b) Because there are so few people who weight 180 pound or more , than observation can afford t

Question:-10
Centeral Carolina hostipal has the following data representiong weight in pound at birth of 20

Class Frequency
0.5-0.9 10
1.0-1.4 19
1.5-1.9 24
2.0-2.4 27
2.5-2.9 29
3.0-3.4 34
3.5-3.9 40
4.0-4.4 17

Construct an ogive that help you answer these Question:


(a) What was the approximate middle value in the original data set?
(b) If premature babies under 3.0 pounds are normally kept in an incubator for several days as a pr

Class Cum. Fre. C.R.F.


less than 0.5 0 0
less than 1.0 10 0.05
less than 1.5 0 0
less than 2.0 0 0
less than 2.5 10 0.05
less than 3.0 29 0.145
less than 3.5 53 0.265
less than 4.0 80 0.4
less than 4.5 109 0.545

Weight(pound) CRF
0.5 0
1 0.05
1.5 0.145
2 0.265
2.5 0.4
3 0.545
3.5 0.715
4 0.915
4.5 1
(a) The middle value was about 2.8 pounds.
(b) About 55 percent will need incubators.

Population variance
x x2
0.04 0.0016
0.06 0.0036
0.12 0.0144
0.14 0.0196
0.14 0.0196
0.15 0.0225
0.17 0.0289
0.17 0.0289
0.18 0.0324
0.19 0.0361
0.21 0.0441
0.21 0.0441
0.22 0.0484
0.24 0.0576
0.25 0.0625

GROUPED DATA Variance

Class Lower Limit


700-799 700
800-899 800
900-999 900
1000-1099 1000
1100-1199 1100
1200-1299 1200
1300-1399 1300
1400-1499 1400
1500-1599 1500
1600-1699 1600
1700-1799 1700
1800-1899 1800

∑fx 124950
∑fx2 162805025
N 100
u 1249.5
u2 1561250.25
(∑128▒ 〖𝑓𝑥 ^2 〗 )/𝑁 1628050.25
σ2 66800
σ 258.456959666402

SAMPLE VARIANCE

x x2
863 744769
903 815409
957 915849
1041 1083681
1138 1295044
1204 1449616
1354 1833316
1624 2637376
1698 2883204
1745 3045025
1802 3247204
1883 3545689

∑x 16212

𝑥 ̅
n 12
1351

(𝛴𝑥^2)/(𝑛−1)
∑x2 23496182
2136016.54545455
(𝑥 ̅ )^2
(𝑛(𝑥 ̅ )^2)/(𝑛−1)
1825201
1991128.36363636
s2 144888.181818182
s 380.641802510158
Ques 3-14 In an attemp tomestimate potential future demand , the nattiona

Number of Cars f
0 2
0.5 14
1 23
1.5 7
2 4
2.5 2

∑fx
n

𝑥 ̅
∑fx2

(𝛴𝑓𝑥^2)/(𝑛−1)

(𝑥 ̅ )^2
(𝑛(𝑥 ̅ )^2)/(𝑛−1)
s2
s

Coffecient of variation

SC 3-15
Group 1 Group 2
mean(u) 32.11 19.75
σ2 68.09 71.14
σ 8.2516664983505 8.43445315358382

(𝜎/𝑢)100
25.6981205180645 42.7060919168801

Group 1 has less relative varibility

SC 3-16
Lee Forest
62.2 62.5
61.8 61.9
63.4 62.8
63 63
61.7 60.7

𝑥 ̅(lee)
𝑥 ̅(forest)
𝑥 ̅(davish)
σ (lee)
σ (forest)
σ (davish)
(𝜎/𝑢)100

(𝜎/𝑢)100

(𝜎/𝑢)100

s 3-13
x x-x bar
50 50
56 56
55 55
49 49
52 52
57 57
56 56
57 57
56 56
59 59
sum 54.7 54.7
mean

SC 3-1 The frequency distribution below represents the weights in pounds of a sample of packages carried last month by a s

Class Frequency
10-10.9 1
11-11.9 4
12-12.9 6
13-13.9 8
14-14.9 12
15-15.9 11
16-16.9 8
17-17.9 7
18-18.9 6
19-19.9 2

a) Compute the sample mean using Equation 3-3.


b) Compute the sample mean using the coding method (Equation 3-4) with 0 assigned to the fourt
c) Repeat part (b) with 0 assigned to the sixth class.
d) Explain why your answers in parts (b) and (c) are the same.

Solutions:-

a) Class interval Midpoint(x) Code(u)


10-10.9 10.45 -4
11-11.9 11.45 -3
12-12.9 12.45 -2
13-13.9 13.45 -1
14-14.9 14.45 0
15-15.9 15.45 1
16-16.9 16.45 2
17-17.9 17.45 3
18-18.9 18.45 4
19-19.9 19.45 5

xₒ=14.45
w=1 x̄ =xₒ+w(Σ(u*f)/n)
u*f=46
n=65 a) answer

b)
Class interval Midpoint(x) Code(u)
10-10.9 10.45 -3
11-11.9 11.45 -2
12-12.9 12.45 -1
13-13.9 13.45 0
14-14.9 14.45 1
15-15.9 15.45 2
16-16.9 16.45 3
17-17.9 17.45 4
18-18.9 18.45 5
19-19.9 19.45 6

xₒ=13.45
x̄ =xₒ+w(Σ(u*f)/n)
w=1 x̄ =xₒ+w(Σ(u*f)/n)
u*f=46
n=65 b)answer

c)
Class interval Midpoint(x) Code(u)
10-10.9 10.45 -5
11-11.9 11.45 -4
12-12.9 12.45 -3
13-13.9 13.45 -2
14-14.9 14.45 -1
15-15.9 15.45 0
16-16.9 16.45 1
17-17.9 17.45 2
18-18.9 18.45 3
19-19.9 19.45 4

xₒ=15.45
w=1 x̄ =xₒ+w(Σ(u*f)/n)
u*f=46
n=65 c)answer

15.15769231
d) Shifting the class assigned the code of 0 up by k classes places xₒ by xₒ +kw and changes each co
= ̄xₒ+w(Σ(u*f)/n)
= (xₒ+kw)-kw+w(Σ(u*f)/n)
= (xₒ+kw)+w(Σ(u-k)f/n)
= x ꜥꜚ

TABLE 3-5 ANNUAL SNOWFALL IN HARLAN, KENTUCKY


Class interval Midpoint(x) Code(u)
0-7 3.5 -2
8_15 11.5 -1
16-23 19.5 0
24-31 27.5 1
32-39 35.5 2
40-47 43.5 3

xₒ=19.5
w=8
u*f=5 x̄ =xₒ+w(Σ(u*f)/
n=20

SC 3-2 Davis Furniture Company has a revolving credit agreement with the First National Bank. The loan showed the followi
Jan. $121300 Apr.
Feb. $112300 May
Mar. $72800 June

The company is eligible for a reduced rate of interest if its average monthly balance is over $650

Solution:-
Class
121300
112300
72800 mean=sum of observation/total number
72800
72800
57300
58700
61100
50400
52800
49200
46100
mean 68966.6666666667
answer= Because this exceeds $65,000, they do qualify for the reduced int

3-8 These data represent the ages of patients admitted to a small hospital on February 28, 1996:
85 75 66
88 80 56
89 83 65
87 83 52
a) Construct a frequency distribution with classes 40–49, 50–59, etc.
b) Compute the sample mean from the frequency distribution.
c) Compute the sample mean from the raw data.
d) Compare parts (b) and (c) and comment your answer

a)
Class interval Frequency
40-49 4
50-59 4
60-69 3
70-79 2
80-89 7
sum= 85+88+89+…...
mean= 66.75
c) sample mean from the frequency distribution=66.5
b) Class interval Midpoint(x) Code(u)
40-49 44.5 -2
50-59 54.5 -1
60-69 64.5 0
70-79 74.5 1
80-89 84.5 2
xₒ=64.5
w=10
u*f=4 x̄ =xₒ+w(Σ(u*f)/n)
n=20 66.5

SC 3-3 Dave’s Giveaway Store advertises, “If our average prices are not equal or lower than everyone else’s, you get it free.”
One of Dave’s customers came into the store one day and threw on the counter bills of sale for

1.29 2.97 3.49

Dave’s prices for the same six items are $1.35, $2.89, $3.19, $4.98, $7.59 and $11.50. Dave told
Our average is lower because our sales of these items have been:”
1.35 2.89 3.19
7 9 12

IS Dave getting himself into or out of trouble by talking about weighted averages?
solution:-
mean at the compitition at dave's
5.2 7.5
weighted mean at the comprtition at dave's
4.34422222222222 4.30266666666667
3_-7 Swifty Markets compares prices charged for identical items in all of its food stores. Here are th

1.08 0.98 1.09


1.08 1.22 1.05

a) Calculate the median price per pound.


b) Calculate the mean price per pound.
c) Which value is the better measure of central tendacy of these data?

Solution:-

Sample Median of Grouped Data


m~(median)={[(n+1)/2-(F+1)]/fm*w+lm}
1.08 0.98 1.09
1.08 1.22 1.05

a. median 1.115 the average of items 5 and 6


b.) x bar 1.176
c.) Because the dta are skewed slightly, the median might be a bit better than the mean, but the
ercises
e by 175 people during a labor day weekend .construct a histogram for these data.

o be a pattern?
ad 10 different phones, and each person knew which time call would belong to.Suggest an ordering so that all calls can be

Chart Title

22
16
12
9
5

22-28 29-35 36-42 43-49 50-56


lenght(in mintue)

he calls increase
ecomes available ,let a person in the highest class with calls still remaning make the next call.
en worked upward , the 50-56 minutes calls would have to wait untill the shorter calls wew made . Using suggest in (b) can save time by al

r park outside Orlando,Florida ,where retirees keep their winter homes . In addition to lot rents , a monthly facility fee of $12 is charged

96 80 71
96 75 61
51 84 58
89 69 92
55 78 96

emaining (fee-paying) resident to cover the same total cost of running the clubhouse?

BIN RANGE
59
69
79
89
99

class CRF
50 0
60 0.2
70 0.48
80 0.68
90 0.8
100 1

CRF

140 160 180 200


Age
enting pollutants (in parts per million) at 150 sites in the state:

rvations fail?
pm of pollutions<what percentage of sites will be heavily monitored?

Ogive
Cumulative relative frequency

160
140 120
120 104
100 84
80
60 48
40 30
14
20 0
0
0 5 10 15 20 25 30
Pollutants(in ppm)
orps of engineers performed a series of tests to measure the water flow past the prposed locations of the dam. The results of the testing

tive frequency distribution and ogive.


ve frequency distribution and ogive.
ess than 1300 thousands of Gallons per minute.

"more-than" ogive
1.2 0.9715447154471
1 55 0.8861788617886
1 18 0.7560975609756
Cumulative frequency

1
0.8
0.5569105691056
91
0.6
0.3211382113821
0.4 14
0.1544715447154
47 0.044715447
0.2
715
0
1000 1050 1100 1150 1200 1250 1300 1350
River Flow
"less-than" Ogive
250
208
200
Cumulative Frequency

167

150
109
100
60
50 28
0 7
0
1000 1050 1100 1150 1200 1250 1300
River Flow

s attempting to design investment programs attractive to senior citizens. She knew that if potential customers could obtain a certain lev

frequemvy distribituion
more than graph
cumulative relative frequency

1.2
1 0.96
1 0.86
0.8 0.66
0.6
0.38
0.4
0.16
0.2 0.1
0.0
0
65 70 75 80 85 90 95 100
indifference point

less than graph


1.2
relative frequency

1 0.9 0.94
0.84
0.8
0.62
0.6
less than graph
1.2
cumulative relative frequency

1 0.9 0.94
0.84
0.8
0.62
0.6

0.4 0.34

0.2 0.14
0 0.04
0
60 70 80 90 100
indifference point (dollars)

age in type was recorded for50 days . The data tp the nearest tenth of the minute are given below

quency distributruion frequency distribution from the data using intervals of 0.8 minute
Minutes to set typefrequency
19 0
19.8 4
20.6 8
21.4 18
22.2 23
23 30
23.8 35 60
24.6 46
25.4 50 50

40

30
11
20

8
10
4
0
0
19 20 21

5
4
5
4

6 7 8 9

rdings. Lee has 35 months of gross sales data, arranged as a frequency distribution.

a relative frequency polygon.

Chart Title
9 8
8 7
7
Relative frequency

6
6 5
5 4
4
3 2 2
2 1
1 0
0
8750 11250 13750 16250 18750 21250 23750 26250 28750
Monthly sales($)

Chart Title
9 8
8 7
7 6
6 5
5 4
4
3 2 2
2 1
8
8 7
7 6
6 5
5 4
4
3 2 2
2 1
1 0 0
0
5000 10000 15000 20000 25000 30000 35000
Monthly sales($)

data on a sample of 130 salespeople representing their total commission earnings annualy:

erformance was about 25 percent from the top expect to earn annualy?

Cum. Rel. fre.


0.0384615384615385
0.107692307692308
0.192307692307692
0.446153846153846
0.730769230769231
0.876923076923077
0.946153846153846
1

Chart Title 0.94615384615384


1 0.87692307692307 6
7
0.9 0.73076923076923
relative frequency

0.8 1
0.7
0.6 0.44615384615384
0.5 6
0.4
Chart Title
0.94615384615384
1 0.87692307692307 6
7
0.9 0.73076923076923

cumulative relative frequency


0.8 1
0.7
0.6 0.44615384615384
0.5 6
0.4
0.19230769230769
0.3
0.10769230769230 2
0.2 0.03846153846153 8
0.1 0 85
0
0 10000 20000 30000 40000 50000
Earning($1000s)

a skill lift a certain day .Construct a histogram for these data.

t immeediatily apparent from the frequency distribution.


ight capicity to 400 pounds, what can the operator do to maximize the people capacity of a chair ?Do the data support your proposal?

Chart Title
35
31
30
26
25 23 23
Frequency

20
15
10 11
10 9 9
6
5 2
0
82.5 97.5 112.5 127.5 142.5 157.5 172.5 187.5 202.5 217.5
Weight(in Pound)
10
6
5 2
0
82.5 97.5 112.5 127.5 142.5 157.5 172.5 187.5 202.5 217.5
Weight(in Pound)

it) than the upper tail .


than observation can afford to pair each person who appears to be heavy with lighyer person .This can be done without greatly delaying

weight in pound at birth of 200 premature babies.

ubator for several days as a premature ,about what percentage of Centeral's premature babies will need an incubator?

Ogive
1.2
1
Cumulative relative frequency

1 0.915

0.8 0.715

0.6 0.545
0.4
0.4
0.265
0.2 0.145
0.05
0
0
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5
Weight (pound)
0.4
0.4

Cumulative
0.265
0.2 0.145
0.05
0
0
0 0.5 1 1.5 2 2.5 3 3.5 4 4.5
Weight (pound)

∑x 2.49
∑x2 0.4643
N 15
u 0.166
u2 0.027556
∑x2/N 0.03095333333333
σ2 0.00339733333333
σ 0.05828664798505

Upper Limit x f fx
799 749.5 4 2998
899 849.5 7 5946.5
999 949.5 8 7596
1099 1049.5 10 10495
1199 1149.5 12 13794
1299 1249.5 17 21241.5
1399 1349.5 13 17543.5
1499 1449.5 10 14495
1599 1549.5 9 13945.5
1699 1649.5 7 11546.5
1799 1749.5 2 3499
1899 1849.5 1 1849.5
future demand , the nattional motor company did a study asking marreid couples how many cars the average energy-minded family shou

fx x2 fx2
0 0 0
7 0.25 3.5
23 1 23
10.5 2.25 15.75
8 4 16
5 6.25 12.5

53.5
52
70.75
1.02884615384615

1.38725490196078
1.05852440828402
1.07927978883861
0.307975113122172
0.554955055046958

Davis
62
61.9
63
63.9
61.5

62.42
62.18
62.46
0.749666592559652
0.925742944882648
0.976217188949262

1.20100383300169

1.48881142631497

1.56294778890372

(x-x bar)² x²
2500 2500
3136 3136
3025 3025
2401 2401
2704 2704
3249 3249
3136 3136
3249 3249
3136 3136
3481 3481
2992.09 2992.09
54.7

Section-3
ages carried last month by a small airfreight company.
4) with 0 assigned to the fourth class.

frequency(f) u*f
1 -4
4 -12
6 -12
8 -8
12 0
11 11
8 16
7 21
6 24
2 10
65 46 <---submition(u*f)
Σf=n=65

x̄ =xₒ+w(Σ(u*f)/n)

15.1576923076923

frequency(f) u*f
1 -3
4 -8
6 -6
8 0
12 12
11 22
8 24
7 28
6 30
2 12
65 111 <---submition(u*f)
Σf=n=65

x̄ =xₒ+w(Σ(u*f)/n)
x̄ =xₒ+w(Σ(u*f)/n)
x̄=xₒ+w(Σ(u*f)/n)

15.1576923076923

frequency(f) u*f
1 -5
4 -16
6 -18
8 -16
12 -12
11 0
8 8
7 14
6 18
2 8
65 -19 <---submition(u*f)
Σf=n=65

x̄ =xₒ+w(Σ(u*f)/n)

15.1576923076923

y xₒ +kw and changes each code from u to u-k. but because

w+w(Σ(u*f)/n)

frequency(f) u*f
2 -4
6 -6
3 0
5 5
2 4
2 6
20 5 <---submition(u*f)
subm.f=n=20

x̄ =xₒ+w(Σ(u*f)/n)
21.5 <------average annual snowfall

The loan showed the following ending monthly balances last year:
$72800 July 58700 Oct.
$72800 Aug. 61100 Nov.
$57300 Sep. 50400 Dec.

monthly balance is over $65000.Does it Qualify?

m of observation/total number of observation

do qualify for the reduced interest rate.

43 40
56 67
53 75
44 48

frequency(f) u*f
4 -8
4 -4
3 0
2 2
7 14
20 4 <---submition(u*f)
Σf=n=20

x̄ =xₒ+w(Σ(u*f)/n)

yone else’s, you get it free.”


on the counter bills of sale for six items she bought from a competitor for an average price less than Dave’s. The items cost

5 7.5 10.95

, $7.59 and $11.50. Dave told the customer, “My ad refers to a weighted average price of these items.

4.98 7.59 11.5


8 6 3

ghted averages?

of its food stores. Here are the prices charged by each store for a pound of bacon last week:

1.24 1.33 1.14 1.55

of Grouped Data
F+1)]/fm*w+lm}
1.24 1.33 1.14 1.55

e of items 5 and 6

better than the mean, but there really isn't very much difference.
g so that all calls can be

Using suggest in (b) can save time by allowing shorter calls to be made while longer calls are in progress.

a monthly facility fee of $12 is charged for social activities at the clubhouse function
Bin Frequency
59 5
69 0
79 0
89 0
99 0
More 0
129 136
120
104
84

0 25 30 35 40
in ppm)
s of the dam. The results of the testing were used to construts the following frequency distribution.

11382113821
14
0.1544715447154
47 0.0447154471544
715 0
1250 1300 1350 1400
Ogive
235
208

167

0 1250 1300 1350 1400


ow

al customers could obtain a certain level of return, they would be willing to risk an investment, but below a certain level, they would be
0.16
0.1
0.04 0
95 100 105 110

1
0.9 0.94
0.84
1
0.9 0.94
0.84

100 110 120


ars)
Chart Title

50
46

35
30

23
18

8
4

20 21 22 23 24 25 26
8

2
1
0
50 23750 26250 28750 31250

1
1
0
30000 35000

0.94615384615384
0.87692307692307 6
7
0.94615384615384
0.87692307692307 6
7

40000 50000 60000

Do the data support your proposal?

9
6
2

187.5 202.5 217.5


6
2

187.5 202.5 217.5

can be done without greatly delaying any individual turn at the lift.

need an incubator?

1
0.915

0.715

545

3 3.5 4 4.5 5
3 3.5 4 4.5 5

x2 fx2
561750.25 2247001
721650.25 5051551.75
901550.25 7212402
1101450.25 11014502.5
1321350.25 15856203
1561250.25 26541254.25
1821150.25 23674953.25
2101050.25 21010502.5
2400950.25 21608552.25
2720850.25 19045951.75
3060750.25 6121500.5
3420650.25 3420650.25
he average energy-minded family should own in 1998 . For each couple , National averaged the husbandand wife responses to gret the ov
∑(x-x bar)² 30017
x bar(mean) 54.7
x bar(mean)^2 2992.09
∑x 547
N 10
∑x² 30017
∑x²/(n-1) 3335.22222222222
n.x²/n-1 3324.54444444444
s²= ∑x²/(n-1)-n.x²/n-1 10.6777777777775
mean(x bar) 54.7
s²= ∑(x-xbar)²/n-1 3335.22222222222

Column1 Column2 Column3 Column4 Column5 Column6


ƒ x = mean of sample
xₒ= value of the midpoint assigned the code 0
w = numerical width of the class interval
u = code assigned to each class
f = frequency or number of observations in each class
n = total number of observations in the sample
52800
49200
46100
n Dave’s. The items cost

ƒ m! = sample median ƒ
n = total number of items in the distribution ƒ
F = sum of all the class frequencies up to, but not including, the median class ƒ
f m = frequency of the median class ƒ
w = class-interval width ƒ
Lm = lower limit of the median-class interval
tain level, they would be reluctant. From a group of 50 subjects, she obtained the following data regarding the various levels of return r
50

26
e responses to gret the overall couple response the answer wer then tabulate
g the various levels of return required for each subject to invest $1000:
Raw data Ascdending Order Descednding Order Name
16.2 #NAME? #NAME? Sandeep
15.7 #NAME? #NAME? Vipin
16.4 #NAME? #NAME? Deepak
15.4 #NAME? #NAME? Pawan
16.4 #NAME? #NAME? Anil
15.8 #NAME? #NAME? Naveen
16 #NAME? #NAME? Arun
15.2 #NAME? #NAME? Manoj
15.7 #NAME? #NAME?
16.6 #NAME? #NAME?
15.8 #NAME? #NAME?
16.2 #NAME? #NAME?
15.9 #NAME? #NAME?
15.9 #NAME? #NAME?
15.6 #NAME? #NAME?
15.8 #NAME? #NAME?
16.1 #NAME? #NAME?
15.9 #NAME? #NAME?
16 #NAME? #NAME?
15.6 #NAME? #NAME?
Marks Name Marks
34 #NAME? #NAME?
43 #NAME? #NAME?
54 #NAME? #NAME?
65 #NAME? #NAME?
27 #NAME? #NAME?
56 #NAME? #NAME?
43 #NAME? #NAME?
56 #NAME? #NAME?
Bin Frequency
34.5 0
44.5 3
54.5 5
64.5 9
74.5 16
84.5 7
94.5 0
More 0
Data
38
42 Class interval Frequency Class inter Frequency
44 30-39 1 30-39 1
47 40-49 3 40-49 3
51 50-59 8 50-59 8
51 60-69 16 60-69 16
51 70-79 10 70-79 10
54 80-89 8 80-89 8
55 90-99 This chart isn't4available in 90-99 4
your version of Excel.
55 Sum 50 Sum 50
56 Editing this shape or saving this workbook into a different file format will
56 permanently break the chart.
60
60
61
62
64
65
65
65
66
66
66
67
68
68
68
69
70
71
73
74
74
75
76
77
78
79
80
82
82
83
83
84
87
88
91
92
98
99 Frequen
Frequency Polygon18
16
14
Frequen
Frequency Polygon18
16
Class inter Mid Frequency
30-39 34.5 1 14
18
40-49 44.5 3 16 12
16
50-59 54.5 8 10
60-69 64.5 16 14
8
70-79 74.5 10 12
10

fREQUENCY
10 6
80-89 84.5 8 8 8
90-99 94.5 4 8 4
Sum 50 6 2 4
4 3
0
2 1 34.5 44.5 54.5 64.5
0
34.5 44.5 54.5 64.5
cLASS 74.5 84.5 94.5
Class interval left right FrequencyRelative Frequency Class inter
30-39 30 39 1 0.02 30-39
40-49 40 49 3 0.06 40-49
50-59 50 59 8 0.16 50-59
60-69 60 69 16 0.32 60-69
70-79 70 79 10 0.2 70-79
80-89 80 89 8 0.16 80-89
el. 90-99 90 99 4 0.08 90-99
Sum 50 1
a different file format will

Relative Frequency
0.35

0.3

0.25

0.2

0.15

0.1

0.05

0
30-39 40-49 50-59 60-69 70-79

Frequency
Frequency

44.5 54.5 64.5 74.5 84.5 94.5

84.5 94.5
Relative Frequency
0.02
0.06
0.16
0.32
0.2
0.16
0.08

Relative Frequency

50-59 60-69 70-79 80-89 90-99


Data Sorted class left end ogive
38 #NAME? less than 30 30 0
42 #NAME? less than 40 40 1
44 #NAME? less than 50 50 4
47 #NAME? less than 60 60 14
51 #NAME? less than 70 70 29
60
51 #NAME? less than 80 80 39
51 #NAME? less than 90 90 46 50
54 #NAME? less than 100 100 50
40
55 #NAME?
55 #NAME?

Ogive
30
56 #NAME?
20
56 #NAME?
60 #NAME? 10
60 #NAME? 0 1
61 #NAME? 0
30 40 5
62 #NAME?
64 #NAME?
65 #NAME?
65 #NAME?
65 #NAME?
66 #NAME?
66 #NAME?
66 #NAME?
67 #NAME? class left end ogive Relative C F
68 #NAME? less than 30 30 0 0
68 #NAME? less than 40 40 1 0.02 1.2
68 #NAME? less than 50 50 4 0.08 1
69 #NAME? less than 60 60 14 0.28
0.8
70 #NAME? less than 70 70 29 0.58

Axis Title
71 #NAME? less than 80 80 39 0.78 0.6
73 #NAME? less than 90 90 46 0.92 0.4
74 #NAME? less than 100 100 50 1
0.2
74 #NAME? 0
75 #NAME? 0
30
76 #NAME?
77 #NAME?
78 #NAME?
79 #NAME?
80 #NAME?
82 #NAME?
82 #NAME?
83 #NAME?
83 #NAME?
84 #NAME?
87 #NAME?
88 #NAME?
91 #NAME?
92 #NAME?
98 #NAME?
99 #NAME?
ogive
60
50
50 46
39
40
29
30

20
14
10
4
0 1
0
30 40 50 60 70 80 90 100
class

Chart Title
1.2
1
1 0.92
0.78
0.8
Axis Title

0.58
0.6

0.4 0.28
0.2 0.08
0 0.02
0
30 40 50 60 70 80 90 100
Axis Title

Column G
Course Students
Commerce 1000
Math 70
Pol Sci 100
Students
History 80
Hindi 200
Geography 150 250
B.A. 250
150

200 1000

80

70
100

Commerce Math Pol Sci History


Hindi Geography B.A.
udents

Students
1200

1000

800

600

400
tory

200

0
Commerce Math Pol Sci History Hindi Geography B.A.
B.A.

You might also like