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.
-
Hydrogen fluoride is used in the manufacture of Freons (which
destroy ozone in the stratosphere) and...
asked 6 minutes ago -
Please answer question 3.
2. A city has learned that by buying larger garbage trucks, it...
asked 3 minutes ago -
What is “power” in communication interactions, according to
Martin & Nakayama (2018)?
asked 3 minutes ago -
Would the color red look different if you were immersed in water
rather than in air?
asked 14 minutes ago -
A steel piping is to be produced by centrifugal casting. The
length is 3.5 meters and...
asked 16 minutes ago -
3...
The following information was taken from Indriks Company’s cash
budget for the month of July:...
asked 29 minutes ago -
Country Company had the following partially completed payroll
register:
Partial payroll register:
Earnings
Withholdings
Salaries
Beginning...
asked 33 minutes ago -
I
have to separate 5 ions into 5 different test tubes
-> I CAN’T MAKE THE...
asked 42 minutes ago -
Juanita took a business trip from Houston to New York. She
worked for 4 days, then...
asked 41 minutes ago -
4. If we had
assumed the q for the calorimeter to be zero, would this have...
asked 50 minutes ago -
The following table reports real income per person for several
different economies in the years 1960...
asked 48 minutes ago -
Since the Great Recession, the trade deficit has been
decreasing
staying about the same
increasing
none...
asked 48 minutes ago