Practical For IT Skill
Practical For IT Skill
Question:-1
Here is a frequency distribution of the length of phone calls made by 175 people during a labo
(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
Question:-3
The Massachusetts Friend's of fish has the following data representing pollutants (in parts per
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
Question:-4
Before constrating a dam on the Colorado River, the U.S Army Corps of engineers performed a
(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:-
Question:-5
Pamela Mason, a consultant for a small local brokerage firm, was attempting to design investm
(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
85 0.34 1
0.8
0.6
1.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
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
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
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
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
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
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
∑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
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
Solutions:-
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 ꜥꜚ
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
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
Solution:-
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
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
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
"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
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.
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?
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
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)
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
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.
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)
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.
ghted averages?
of its food stores. Here are the prices charged by each store for a pound of bacon last week:
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
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
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
9
6
2
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
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
84.5 94.5
Relative Frequency
0.02
0.06
0.16
0.32
0.2
0.16
0.08
Relative Frequency
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
Students
1200
1000
800
600
400
tory
200
0
Commerce Math Pol Sci History Hindi Geography B.A.
B.A.