a) Submit a copy of your dataset along with a file that contains your answers to...

a) Submit a copy of your dataset along with a file that contains your answers to all of the following questions.

b) What the mean and Standard Deviation (SD) of the Close column in your data set?

c) If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than the mean for that year? Hint: You do not want to calculate the mean to answer this one. The probability would be the same for any normal distribution. (5 points)

If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at more than $950? (5 points)
If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed within $50 of the mean for that year? (between 50 below and 50 above the mean) (5 points)
If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than $800 per share. Would this be considered unusal? Use the definition of unusual from the course textbook that is measured as a number of standard deviations (5 points)
At what prices would Google have to close in order for it to be considered statistically unusual? You will have a low and high value. Use the definition of unusual from the course textbook that is measured as a number of standard deviations. (5 points)
What are Quartile 1, Quartile 2, and Quartile 3 in this data set? Use Excel to find these values. This is the only question that you must answer without using anything about the normal distribution. (5 points)
Is the normality assumption that was made at the beginning valid? Why or why not? Hint: Does this distribution have the properties of a normal distribution as described in the course textbook? Real data sets are never perfect, however, it should be close. One option would be to construct a histogram like you did in Project 1 to see if it has the right shape. Something in the range of 10 to 12 classes is a good number. (5 points)

DATA SET- Closed stock prices

1044.689941
1077.150024
1080.969971
1089.900024
1098.26001
1070.52002
1075.569946
1073.900024
1090.98999
1070.079956
1060.619995
1089.060059
1116.369995
1110.75
1132.800049
1145.98999
1115.22998
1098.709961
1095.060059
1095.01001
1121.369995
1120.160034
1121.670044
1113.650024

Solutions

Expert Solution

orchestra answered 1 year ago

Next > < Previous

Related Solutions

BUSI 230-Project 3 a) Submit a copy of your dataset along with a file that contains...

BUSI 230-Project 3 a) Submit a copy of your dataset along with a file that contains your answers to all of the following questions. b) What the mean and Standard Deviation (SD) of the Close column in your data set? Mean: 1198.26 Standard Deviation: 85.39 c) If a person bought 1 share of Google stock within the last year, what is the probability that the stock on that day closed at less than the mean for that year? Hint: You...

Please submit your Excel file and highlight your answers in color. Brief Case Has Gold Lost...

Please submit your Excel file and highlight your answers in color. Brief Case Has Gold Lost its Luster? In 2011, when the Gallup organization polled investors, 34% rated gold the best long-term investment. However, in April of 2013 Gallup surveyed a random sample of U.S. adults. Respondents were asked to select the best long-term investment from a list of possibilities. Only 241 of the 1005 respondents chose gold as the best long-term investment. A. With 95% confidence, compute the margin...

Java Question: COSC 2436 Lab 4 (Submit your Word file with answers) If you push the...

Java Question: COSC 2436 Lab 4 (Submit your Word file with answers) If you push the objects x, y, and z onto an initially empty stack, in what order will three pop operations remove them from the stack? What pseudocode statements create a stack of the three strings "Jill", "Jane", and "Joe", in that order with "Jill" at the top? Suppose that s and t are empty stacks and a, b, c, and d are objects. What do the stacks...

The dataset in the file Lab11data.xlsx contains data on Crimini mushrooms. The factor variable is the...

The dataset in the file Lab11data.xlsx contains data on Crimini mushrooms. The factor variable is the weight of the mushroom in grams and the response variable is the total copper content in mg. 1. Plot Copper vs. Weight and describe. 2. Find least squares regression line and interpret slope in the words of the problem. 3. Find the coefficient of determination (R2) and interpret in context. 4. Find the correlation coefficient (R) and interpret in context. 5. Find and interpret...

For Assignment 2, submit a word or pdf file with the SQL queries along with screenshots...

For Assignment 2, submit a word or pdf file with the SQL queries along with screenshots of the outputs. (It is ok if the whole problem cannot be answered, if possible, I just would like an idea of how to begin, thanks in advance!) 9. Write a query to count the number of invoices. 10. Write a query to count the number of customers with a balance of more than $500. 11. Generate a listing of all purchases made by...

Your Answers: Type your answers in the table and submit this worksheet. Use what you have...

Your Answers: Type your answers in the table and submit this worksheet. Use what you have learned about the time value of money to analyze each of the following decisions: Decision #1: Which set of Cash Flows is worth more now? Assume that your grandmother wants to give you generous gift. She wants you to choose which one of the following sets of cash flows you would like to receive: Option A: Receive a one-time gift of $10,000 today. Option...

Using C programming I have a file that contains earthquake data that I will copy and...

Using C programming I have a file that contains earthquake data that I will copy and paste below. I want to use either bubble or insertion sort to sort the file by latitude in ascending order, then create a new file containing the sorted data. example file to sort: time,latitude,longitude,depth,mag,magType,nst,gap,dmin,rms,net 2020-10-17T17:22:03.840Z,32.877,-116.2991667,0.31,1.16,ml,21,119,0.07747,0.26,ci 2020-10-17T17:17:29.980Z,34.1611667,-116.452,2.75,0.87,ml,17,66,0.05224,0.22,ci 2020-10-17T17:03:54.460Z,33.5396667,-116.4613333,8.66,0.63,ml,18,126,0.06084,0.16,ci 2020-10-17T16:55:01.080Z,63.254,-151.5232,8,1.4,ml,,,,0.9,ak

Submit your solution to the problem in an Excel file. Explain your answer as necessary and...

Submit your solution to the problem in an Excel file. Explain your answer as necessary and be sure your calculations are clearly shown. ABC Corporation is large and profitable. This year it is considering buying factory equipment for $100,000,000. ABC’s cost of capital is 7%. Required: a) What is the after-tax cost of the equipment if it qualifies for 100% bonus depreciation? b) What is the after-tax cost of the equipment if it is depreciated using MACRS (7 year recovery...

It is essential that your answers are IN YOUR WORDS. Do NOT copy sentences or phrases....

It is essential that your answers are IN YOUR WORDS. Do NOT copy sentences or phrases. Do NOT take a sentence and change a word here and there. Take the idea and express it the way YOU would say it. Answers to be paragraph length, not just a short sentence or two. Explain your answers. 1. What is an example of a metaphysical question? Explain. 2. What is an argument? What is the difference between a good argument and a...

Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...

Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page. A firm that is in the 35% tax bracket forecasts that it can retain $4 million of new earnings plans to raise new capital in the following proportions: 60% from 30-year bonds with a flotation cost of 4% of face value. Their current bonds are selling at a price of 91...

Subjects