Question: Using the Microsoft stock price data on tab named MSFT on D2L , (Display the decimals as percents to two decimal places.) Assume 95% Confidence

Using the Microsoft stock price data on tab named MSFT on D2L , (Display the decimals as percents to two decimal places.) Assume 95% Confidence Interval.

a. Graph the returns data using histogram to determine if it is roughly normally distributed. Make sure to adjust number of bins and/or bin sizes for a good visual representation. Displaying the returns as percentages would be a good idea as well.

b. Choose the best graph to display the actual price (not returns) across time and graph it.

c. Calculate the mean monthly returns.

d. Calculate the standard deviation of the monthly returns.

e. Calculate the standard error of the mean.

f. What is (alpha) or the level of significance? %5

g. Using the =confidence.t() excel formula, calculate the margin of error.

h. Calculate the lower bound of the confidence interval.

i. Calculate the upper bound of the confidence interval.

j. Calculate the Degrees of Freedom.

Using the Microsoft stock price data on tab named MSFT on D2L

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Using the Microsoft stock price data on tab named MSFT on D2L , (Display the decimals as percents to two decimal places.) Assume 95% Confidence Interval. a. Graph the returns data using histogram to...

Can someone assist with any of these questions below: Question 1.The time required to play a certain game is uniformly distributed between 30 and 52 minutes. Complete parts a through c below. a. Find...

Need Urgent Help with Question 3 and Question 9 of the attached document - Question 3 needs only ~400 words (also attaching an article which might be needed to answer question-3) My word count for...

Name: T.A. name/Class time: MW Lecturer: Lab 11: Multiple Regression Open the lab dataset on Blackboard Learn or previously saved in SPSS. This dataset contains the data for 96 subjects. The...

Excel Activity: Evaluating Risk and Return Bartman Industries's and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2015-2020. The Winslow...

Management Information System- need help with step 6 and 7 For this assignment each team is required to create a fictitious stock portfolio by investing a total of $100,000 (paper money, of course! -...

Please answer these questions and put them in a readable format (ex. 1a, 1b, 2a, 2b, etc...). No explanation needed 1. Exercise 10.09 Algo (lnferences About the Difference Between Two Population...

Winslow 5000 Includes Dividends $11,965.74 $8,971.76 $8,883.00 $6,564.04 $5,751.54 $4,843.52 B D E 1 Evaluating Risk and Return 2 3 Bartman Industries Reynolds Inc. 4 Year Stock Price Dividend Stock...

Part A: Tell us about yourself! Is this your first online class? If not, what advice do you have for fellow classmates to keep track of due dates? Please feel free to post any information about your...

In Problems 1-3, use the vector forms of Green's Theorem to calculate (a) and (b) 1. F = y2i + x2j; C is the boundary of unit square with vertices (0, 0), (1, 0), (1, 1), and (0, 1). 2. F = ayi +...

Which categories are covered as Financial Markets? ( Choose all the correct answers ) Bonds Equities Loans Derivatives Foreign exchange Purchase of goods and services Foreign Direct Investment...

During the month of July, the Town of Lynton recorded the following information related to purchases: Amount of Purchase Order Actual Cost General government $ 5 5 6 , 0 0 0 $ 4 9 6 , 0 0 0 Public...