Show your work and explain your process for determining the solution for each of these problems on a word document with the solution given below the problem Written explanation, reasoning, and rationale should use complete sentences collect themost recent closing prices of stocksfor your favorite company or brand You can find this by going tofinance yahoo comand searching for Your Company stock history Learn the properties of a probability distribution Choose your favorite company or brand and search finance yahoo com with that company name and historical stock prices Download the stock history for this company for thepast 6 weeksby selecting the appropriate dates and clicking on Download to Spreadsheet at the bottom of page Calculate the daily change in the closing stock prices by taking the difference between the closing and opening price for the day This is the daily stock change Run the Descriptive Statistics Summary Table in Excel Data Analysis on the daily stock change Share the summary table Calculate the 1st and 3rd quartiles of the daily stock change Share these along with the min, median, and max from 3) as your 5 Number Summary develop Box Whiskers Plot using your 5 Number Summary Is your daily stock change distribution right skewed (median mean), left skewed (mean median), or symmetric (mean median) Identify normal probability distributions Would you consider your daily stock change to be normally distributed Why or Why Not Usingyour mean and standard deviation, determine the probability for the average of 9 daily changes of this stock to have A decrease of 0 5 point or more (X 0 5) An increase of more than 0 5 point (X 0 5) A decrease of 1 point or more (X 1) An increase of more than 1 point (X 1) explain if these are high or low likelihoods for change If you wanted to be 95 sure what the daily change would be, what range for a daily change would you expect NOTE FOR THE TUTOR I WOULD LIKE YOU TO CHOOSE CURRENT DATA FROM MICROSOFT

The Answer is in the image, click to view ...

Question: Show your work and explain your process for determining the solution for each of these problems on a word document with the solution given below

Show your work and explain your process for determining the solution for each of these problems on a word document with the solution given below the problem.

Written explanation, reasoning, and rationale should use complete sentences.

collect themost recent closing prices of stocksfor your favorite company or brand. You can find this by going tofinance.yahoo.comand searching for "Your Company stock history.

Learn the properties of a probability distribution.
Choose your favorite company or brand and search finance.yahoo.com with that company name and "historical stock prices". Download the stock history for this company for thepast 6 weeksby selecting the appropriate dates and clicking on "Download to Spreadsheet" at the bottom of page.
Calculate the daily change in the closing stock prices by taking the difference between the closing and opening price for the day. This is the daily stock change.
Run the Descriptive Statistics->Summary Table in Excel Data Analysis on the daily stock change. Share the summary table.
Calculate the 1st and 3rd quartiles of the daily stock change. Share these along with the min, median, and max from 3) as your 5-Number Summary.
develop Box & Whiskers Plot using your 5-Number Summary.
Is your daily stock change distribution right skewed (median < mean), left skewed (mean < median), or symmetric (mean median)?
Identify normal probability distributions.
Would you consider your daily stock change to be normally distributed? Why or Why Not?

Usingyour mean and standard deviation, determine the probability for the average of 9 daily changes of this stock to have:

A decrease of 0.5 point or more (X -0.5)?
An increase of more than 0.5 point (X > 0.5)?
A decrease of 1 point or more (X -1)?
An increase of more than 1 point (X > 1)?
explain if these are high or low likelihoods for change.

If you wanted to be 95% sure what the daily change would be, what range for a daily change would you expect?

NOTE FOR THE TUTOR: I WOULD LIKE YOU TO CHOOSE CURRENT DATA FROM MICROSOFT

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!

Part 2: Show your work and explain your process for determining the solution for each of these problems on a word document with the solution given below the problem. If Excel was used, please...

Show your work and explain your process for determining the solution for each of these problems on a word document with the solution given below the problem. If Excel was used, please indicate that...

Part 2: Show your work and explain your process for determining the solution for each of these problems on a word document with the solution given below the problem. If Excel was used, please...

Chapter 9 Situational Leadership: Training and Development Chapter Overview Integral to a manager's success is the ability to develop the task-relevant readiness of their followers. In fact, part of...

FIR 3303, Introduction to Fire Prevention Course Syllabus Course Description Fire Prevention provides fundamental knowledge relating to the field of fire prevention. Topics include the history and...

Directions: 1. Solve the following problems. Hand write your solutions and explanations on your own paper following the directions in the Canvas assignment. Do not write answers on this page. 2. Show...

Statistics: Written Problem Set Directions : 2. Show your work AND explain your reasoning using complete English sentences. Explanations must directly follow the solution for each part of the...

Swan Ltd purchased vintage equipment on 1 July 2021 for $119 400 cash. Transport and installation costs of $12 600 were paid on 5 July 2021. Useful life and residual value were estimated to be 10...

Given in the following table are 15 randomly selected state expenditures (in millions of dollars) for the fiscal year 1997 (a) Test the data for normality. (b) If the data are not normal, try a...

A standard ARM has a cap such that the rate cannot increase more than 1 percent per year and 5 percent over the life of the mortgage. What will the mortgage rate be after three years if the initial...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...