Homework Answers
Stock C - correct Option
Stock C carries more risk because the higher the standard
deviation, the riskier the investment.
Add Answer to:
16. Over the last 12 months, monthly returns (%) were tracked for 3 stocks. Stock A...
Question 1. a. What is the average rating for all CBC movies? How about ABN movies...
Question 1.
a. What is the average rating for all CBC movies? How about ABN
movies and BBS movies?
b. Include a table that shows the average and the other
descriptive statistics (using the data analysis tool pack in Excel)
for the ratings of the three networks (one column for each
network). Explain what you learn from each of the metrics in the
table.
c. Comment on which network is doing best.
| Η 1 CBC 15.6 AB DE BBS...
Summary of Descriptive Statistics Excel will tabulate a summary of the descriptive statistics for...
Summary of Descriptive Statistics Excel will tabulate a summary of the descriptive statistics for central tendency and using the Data Analysis Pack. Click Data Click Data Analysis .In the pop-up list click on Descriptive Statistics and hit OK . In the pop-up box in the input range type A2:A75 or highlight this region . Click the box next to summary statistics Click OK A box of summary statistics will appear like the one below Mean Standard Error Median Mode Standard...
11] The Excel output on GPA below was generated from a sample of 30 students in...
11] The Excel output on GPA below was generated from a sample of 30 students in Stats II using the descriptive statistics function in Excel. These are all sample statistics. What is the upper bound to the 95% confidence interval around the mean? n 30 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum 2.943666667 0.09068004 2.84 2.5 0.496675037 0.246686092 1.011303207 0.36205901 1.74 2.17 3.91 88.31 30 0.185461504 a. 2.978 b. 3.129 C. 3.341 d. 2.873...
Consider the following 6 months of returns for 2 stocks and a portfolio of those 2...
Consider the following 6 months of returns for 2 stocks and a portfolio of those 2 stocks Note: The portfolio is composed of 50% of Stock A and 50% of Stock B a. What is the expected return and standard deviation of returns for each of the two stocks? b. What is the expected return and standard deviation of returns for the portfolio? c. Is the portfolio more or less risky than the two stocks? Why? a. What is the...
Consider the following 6 months of returns for 2 stocks and a portfolio of those 2...
Consider the following 6 months of returns for 2 stocks and a
portfolio of those 2 stocks:
The
portfolio is composed of 50% of Stock A and 50% of Stock
B.
a. What is the expected return and standard deviation of returns
for each of the two stocks?
b. What is the expected return and standard deviation of returns
for the portfolio?
c. Is the portfolio more or less risky than the two stocks?
Why?
this is the entire question...
2. A financial analyst measures the monthly returns of two stocks (A and B) over a...
2. A financial analyst measures the monthly returns of two stocks (A and B) over a twenty year period. Over that time period, stock A had an average return of 11% (per year) with a standard deviation of 20%. Over that same period, stock B had an average return of 13% with a standard deviation of 17%. The analyst estimates the CAPM for both stocks. The results are below: Stock A: SUMMARY OUTPUT Regression Statistics Multiple R 0.734020234 R Square...
4. The data below are waiting times (in minutes) for service at a local bank. Also...
4. The data below are waiting times (in minutes) for service at a local bank. Also included are son summary statistics produced by Excel. Waiting Time Waiting Time Statistics 2.7 3.6 Mean 3.82 1.5 Standard Error 0.61 4.9 Median 3.00 2.8 Mode 2.70 Standard Deviation 2.21 Sample Variance 4.89 Kurtosis 7.79 Skewness 2.55 Range 9.00 Minimum 1.50 Maximum Sum 49.60 Count 13.00 27 4.1 10.50 (Continued) Refer to the bank waiting times data on the previous page. b. Using the...
For the other set of quantitative data, use sample mean and sample standard deviation (from Project 2 or find again), a...
For the other set of quantitative data, use sample mean and sample standard deviation (from Project 2 or find again), and test a claim about the Population Mean (you will need to make the Claim, then use hypothesis testing to see how the data supports/rejects your claim or (fails to do so). Min Wage Per State Descriptive Statistics Mean 8.94 Standard Error 0.24 Median 8.60 Mode 7.25 Standard Deviation 1.69 Sample Variance 2.85 Kurtosis -0.28 Skewness 0.68 Range 6.50 Minimum...
3. A stock had returns of 2%, -3%, -6%, 6%, 16%, over the last five years....
3. A stock had returns of 2%, -3%, -6%, 6%, 16%, over the last five years. Calculate: a. Arithmetic mean (5 pts) b. Geometric mean (6 pts) c. Standard deviation (9 pts)
you observed the following returns on company a's stock over the past five years: 12%,23%,18%,7% and...
you observed the following returns on company a's stock over the past five years: 12%,23%,18%,7% and 13%. A. What was the average return on the stock over this five year period? B. What was the standard deviation of the returns this period? C. What range of returns would you expect to see 68% of the time for this stock?
Question 1.
a. What is the average rating for all CBC movies? How about ABN
movies and BBS movies?
b. Include a table that shows the average and the other
descriptive statistics (using the data analysis tool pack in Excel)
for the ratings of the three networks (one column for each
network). Explain what you learn from each of the metrics in the
table.
c. Comment on which network is doing best.
| Η 1 CBC 15.6 AB DE BBS...
Summary of Descriptive Statistics Excel will tabulate a summary of the descriptive statistics for central tendency and using the Data Analysis Pack. Click Data Click Data Analysis .In the pop-up list click on Descriptive Statistics and hit OK . In the pop-up box in the input range type A2:A75 or highlight this region . Click the box next to summary statistics Click OK A box of summary statistics will appear like the one below Mean Standard Error Median Mode Standard...
11] The Excel output on GPA below was generated from a sample of 30 students in Stats II using the descriptive statistics function in Excel. These are all sample statistics. What is the upper bound to the 95% confidence interval around the mean? n 30 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum 2.943666667 0.09068004 2.84 2.5 0.496675037 0.246686092 1.011303207 0.36205901 1.74 2.17 3.91 88.31 30 0.185461504 a. 2.978 b. 3.129 C. 3.341 d. 2.873...
Consider the following 6 months of returns for 2 stocks and a portfolio of those 2 stocks Note: The portfolio is composed of 50% of Stock A and 50% of Stock B a. What is the expected return and standard deviation of returns for each of the two stocks? b. What is the expected return and standard deviation of returns for the portfolio? c. Is the portfolio more or less risky than the two stocks? Why? a. What is the...
Consider the following 6 months of returns for 2 stocks and a
portfolio of those 2 stocks:
The
portfolio is composed of 50% of Stock A and 50% of Stock
B.
a. What is the expected return and standard deviation of returns
for each of the two stocks?
b. What is the expected return and standard deviation of returns
for the portfolio?
c. Is the portfolio more or less risky than the two stocks?
Why?
this is the entire question...
2. A financial analyst measures the monthly returns of two stocks (A and B) over a twenty year period. Over that time period, stock A had an average return of 11% (per year) with a standard deviation of 20%. Over that same period, stock B had an average return of 13% with a standard deviation of 17%. The analyst estimates the CAPM for both stocks. The results are below: Stock A: SUMMARY OUTPUT Regression Statistics Multiple R 0.734020234 R Square...
4. The data below are waiting times (in minutes) for service at a local bank. Also included are son summary statistics produced by Excel. Waiting Time Waiting Time Statistics 2.7 3.6 Mean 3.82 1.5 Standard Error 0.61 4.9 Median 3.00 2.8 Mode 2.70 Standard Deviation 2.21 Sample Variance 4.89 Kurtosis 7.79 Skewness 2.55 Range 9.00 Minimum 1.50 Maximum Sum 49.60 Count 13.00 27 4.1 10.50 (Continued) Refer to the bank waiting times data on the previous page. b. Using the...
3. A stock had returns of 2%, -3%, -6%, 6%, 16%, over the last five years. Calculate: a. Arithmetic mean (5 pts) b. Geometric mean (6 pts) c. Standard deviation (9 pts)
Most questions answered within 3 hours.
-
If the vapor pressure of carvone is approximately 9.4 torr at 99
°C, approximately how much...
asked 8 minutes ago -
A juice bottling company is carrying out a test at 10%
significance that the mean population...
asked 19 minutes ago -
What is the reflectivity (in percent) needed to keep water at a
temperature near its freezing...
asked 22 minutes ago -
Suppose that the average surface temperature of Earth is 300K.
Assume this is uniform over its...
asked 23 minutes ago -
Draw the condensed structural formula for alkenes and alkynes or
the line-angle structural formula for cycloalkenes...
asked 22 minutes ago -
M. Laing has suggested a new arrangement of the periodic table
(J.Chem.Ed.1989, 66,
746). Answer the following...
asked 44 minutes ago -
Café Michigan's manager, Gary Stark, suspects that demand for
mocha latte coffees depends on the price...
asked 43 minutes ago -
A US merchant purchases wine from a vineyard outside of Paris.
The wine is transported to...
asked 49 minutes ago -
we have (TTN)*
We have to use just one 2-bit counter with 1-bit global
history?
and...
asked 50 minutes ago -
Firms that fail to compete with lower prices and/or better
products will go bankrupt. Does this...
asked 51 minutes ago -
Question 1 Current and Resistance
Part A: A current of -14.5 nanoamperes is how many electrons...
asked 52 minutes ago -
The population standard deviation for the height of college
basketball players is 3.4 inches. If we...
asked 1 hour ago