2
2.
(Submit a screenshot of your written or typed answer)
Describe the natures of the
histogram in question 1 (uniform, normal, skewed left, skewed right).
3.
(Submit a screenshot of the frequency distribution table.)
Using Excel to construct a
frequency distribution table, relative frequency distribution, and cumulative relative
frequency distribution of the data using the following class limit. For relative frequency
and cumulative relative frequency, use percent format with zero decimal.
Lower Limit
Upper limit
0
1
1.1
2
2.1
3
3.1
4
4.1
5
5.1
6
6.1
7
7.1
8
4.
(Submit a screenshot from Excel)
Using Excel to calculate the descriptive statistic for
column E (Close): mean, median, standard deviation (consider the given data as a
sample), first quartile (Q1), third quartile (Q3), and interquartile range (IQR). Use
QUARTILE.INC
for quartile. Keep 2 decimals where applicable.
5.
(Submit a screenshot of Box-plots).
Construct a box-plot for column E (Close). Use
your name as the chart title. Identify 5-number summary on the box-plot. Calculate
1.5*IQR, Q3 + 1.5*IQR, Q1-1.5*IQR. How do you determine the outliers? Keep whole
numbers.
6.
(Submit a screenshot of your written or typed answer)
On January 12, 2023, the
closing price for ACB is $1.29. Calculate the z-score for 1.29. Keep 2 decimals. Explain
to someone about this z-score who does not have statistics knowledge.
7.
(Submit a screenshot of your written or typed answers for parts a to e)
Based on the
given data about ACB stock,
a.
Identify the sample and the population.
b.
The mean you calculated in question 4 is a statistic. True or False?
c.
How would you name the data based on the measurement scale (nominal, ordinal,
interval, and ratio) for ABC stock Open, High, Low?
d.
The data is obtained by using probability sampling or non-probability sampling?
e.
If you want to conduct a study about this ACB stock, is the study observational
study or design of experiment?
