MGSC 2207 Saint Marys University Introductory Statistics Problems complete in 10 hours with high correct rate i put assignment down blow can just directl

MGSC 2207 Saint Marys University Introductory Statistics Problems complete in 10 hours with high correct rate

i put assignment down blow

can just directly type the answer to this file 1.
[31]Using the data file MGSC2207 SSI 20 A1 Data, and the tab labelled: Div Yield for
DJIA Companies answer the following:
(a) [1]What level of measurement is “Company”? ____________________________
(b) [1] What level of measurement is “Dividend Yield”? _________________________
(c) [2] Is this data set Time Series or Cross-sectional? Why?
__________________________________________
(d) [2] Use Excel to produce a Descriptive Statistics table. Highlight the mean, median, and
standard deviation. Insert your table here:
(e) [2] Use Excel to develop a relative frequency table for the dividend yields. Decide on
reasonable bins. (Remember that the frequency table is a by-product of the Histogram
function and from that table you can quickly produce a relative frequency column. Insert
your table here:
Page 1 of 6
(f) [4] Below is a chart for the data set. (1)Name the chart, (2) explain what the numbers
represent in each of the three columns, (3) explain what the bracketed (10) number represents
and (4) determine, from the chart, which yield is most common.
4
0 0459
6 1 35
12 2 124599
(10) 3 0344466899
8 4 247
5
5 58
3
1
6 36
7
1
1
8
9 2
(1)
(2) Col 1:
Col 2:
Col 3:
(3) Bracketed number indicates
(4)
(g) [3]Using Excel, produce a relative frequency histogram and an ogive (cumulative polygon)
for the dividend yields. Insert your graph here:
(h) [3]Use Excel to determine the first quartile, third quartile and then calculate the IQR for the
dividends. Insert your Excel results and your IQR calculation here:
Page 2 of 6
(i) [3] Using a five-number summary and your histogram, comment on the
skewness/symmetry of the data set. Support your claim.
(j) [4] Develop a 97% confidence interval for the proportion of companies with a dividend yield
exceeding 3% in 2009. (Include formula, substitutions, calculations & statement.) In context,
what can you say about the dividend yields? Include a statement.
Page 3 of 6
(k) [4] The margin of error in the last part is too great. What sample size would be needed to
achieve a margin of error of 10%? Use both the pilot study and worst case scenario.
(l) [4] Develop a 90% confidence interval for the mean dividend yield. (Include formula,
substitutions, calculations & statement.)
(m)[3] What sample size in the 90% CI on the mean would be needed to achieve a margin of
error of +/- 0.5?
Page 4 of 6
(n) [2] Dividend yield is the annual dividend paid by a company expressed as a percentage of the
price of the stock (Dividend/Stock Price * 100). What company had the highest dividend
yield? If the stock for this company currently sells for $14 per share and you purchase 500
shares, how much dividend income will this investment generate in one year?
2. [12] In a recent poll of 1000 Nova Scotians, 37.3% use Twitter. It is believed that the true
proportion of all Nova Scotians using Twitter is 35%.
a) [5]What is the probability that the sample proportion of Nova Scotians “Tweeting” in a random
sample of 1000 would be within  5% of the population proportion.
b) [5]What is the probability that in a random sample of 1000 Nova Scotians, 37.3% or more
“Tweet”?
c) [2] Given that the statistic in b) was actually observed, do you believe there is evidence that
the true proportion of Nova Scotians “Tweeting” has increased?
Page 5 of 6
3. [12] The basic materials stock sector, comprised of companies specializing in industrial commodities,
had a very poor showing during the first six months of 2000. The average stock price in this sector
was down an average of 27% for this period. Assume that the returns were distributed as a normal
random variable with a mean of -27% and a standard deviation of 15%.
a) [3] If an individual stock were selected from this population, what is the probability that it
would have a return of between -37 and -17%?
b) [3] If an individual stock were selected from this population, what is the probability that it
would have made a profit – i.e. a return greater than 0.0%?
c) [3] If random samples, of 10 stocks were selected from this population. What proportion of
the samples would have a mean return of between -37% and -17%?
d) [3] If random sample of 10 stocks were selected from this population, what proportion of the
samples would have made a profit?
Page 6 of 6

Purchase answer to see full
attachment