Interpreting Statistics and Data, BC 303, Handout #1A
Frequency distributions, Histogram and Descriptive Statistics Using Excel
Answers/Excel output provided at the end
Example: The Cambridge Power and Light Company selected 20 residential customers at ra

Chapter 10
6.
Null Hypothesis:
0: = 3
0 : < 3
Alternative Hypothesis:
Test Statistic
z
x 2.75 3
1.77
1
n
50
At 0.05 level the table value is -1.645
P-Value: 0.0385
Reject
0 and accept
1 when z < -1.65
Sample provides evidence to support the claim that

Chapter 8:
6.
a. 2,2; 2
2,4; 3
2,4; 3
2,4; 3
2,4; 3
2,8; 5
2,8; 5
4,4; 4
4,8; 6
4,8; 6
b. Population mean=(2+3+3+3+3+3+4+5+5+6+6)/10=4
(2+2+4+4+8)/5=4
c. There is more dispersion with population data compared to the sample means. The
sample means vary fro

Chapter 7: 16, 18, 20, 22, 26, 28
16.
a) Z1=
415400
=1.5
10
Z2 =
400400
=0
10
P (415 < X < 400) = P (0 < Z < 1.5) = 0.4332
b) Z1=
395400
=0.5
10
Z2=
400400
=0
10
P (395 < X < 400) = P (-0.5 < Z < 0) = 0.1915
c) Z =
395400
=0.5
10
P (X < 395) = P (Z < -0.5

Chapter1
2)
A ratio
B nominal
C ratio
D ratio
4)
a) sample
b) population
c) population
d) sample
6)
Population: the entire set of objects or individuals of interest
Sample: a part of the population of interest
8)
a) In my opinion, I choose population beca

EXAMPLE
A recent national survey found that high school students watched an average (mean) of 6.8 videos
per month. A random sample of 36 college students revealed that the mean number of videos
watched last month was 6.2, with a standard deviation of 0.5

Research Plan
1
Research Plan
BC 303: Interpreting Statistics and Data
Research Plan
Research Plan
2
1. The research question and hypothesis statement.
Comparing number of sportsmen who have been succeeded by doing hard work or just to be
talented.
What i

Interpreting Statistics and Data, BC 303
Outline:
What is Statistics
Frequency distribution
Measures of central tendency: mean, median, mode; Measure of Dispersion: range, variance
and standard deviation.
The following example is supposed to highlight why

Interpreting Statistics and Data, BC 303, Handout #4
Normal Distribution Using Excel
1. Calculating probabilities. Use command NORMDIST(a,1). You can find this command in
Function wizard under statistical functions (go to Insert/Function)
The result is th

Interpreting Statistics and Data, BC 303, Handout #3
Binomial Distribution Using Excel
Refer to lecture notes for reference to the following Excel commands:
1. = BINOMDIST(a, n, , 0)
This command calculates the probability of exactly a successes in n tria

Interpreting Statistics and Data, BC 303, Handout #2
Descriptive Statistics Using Excel
Please note that the answers are provided at the end.
1.
Suppose the following data represents distribution of vehicle selling price in thousands of dollars. The
class

Chapter 12:
4.
n 11 = 5 1 = 4
n 21 = 7 1 = 6
With the numerator of 4 and denominator of 6 looking up on the F Distribution at a
1 percent level of significance (Appendix G) and the critical value is 9.15.
H0 is rejected if F > 9.15.
2
s1
F=
2
s2
122
=2.94