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 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 $1150? (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 $950 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)

There are also 5 points for miscellaneous items like correct date range, correct mean, correct SD, etc.

Expert Solution

orchestra answered 2 years ago

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...

Submit a processed dataset and Python or SAS script that has been used along with a...

Submit a processed dataset and Python or SAS script that has been used along with a short description of the steps you have been following.

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...

Create a CodeBlocks project with a main.cpp file. Submit the main.cpp file in Canvas. C++ Language...

Create a CodeBlocks project with a main.cpp file. Submit the main.cpp file in Canvas. C++ Language A Game store sells many types of gaming consoles. The console brands are Xbox, Nintendo, PlayStation. A console can have either 16 or 8 gigabytes of memory. Use can choose the shipping method as either Regular (Cost it $5) or Expedite (Cost is $10) The price list is given as follows: Memory size/Brand Xbox Nintendo PlayStation 16 gigabytes 499.99 469.99 409.99 8 gigabytes 419.99...

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...

Create one Excel file to submit named "Exam 3 Team X.xlsx" where X is your team...

Create one Excel file to submit named "Exam 3 Team X.xlsx" where X is your team letter. Show work for credit. USE EXCEL 1. Use the data below. Team C Date DOW 10YTREAS 8-Apr-20 23,719.37 0.729 1-Apr-20 22,653.86 0.736 25-Mar-20 21,917.16 0.698 18-Mar-20 20,704.91 0.816 11-Mar-20 21,237.38 0.997 4-Mar-20 25,018.16 0.748 26-Feb-20 25,917.41 1.01 19-Feb-20 27,081.36 1.33 12-Feb-20 29,232.19 1.556 5-Feb-20 29,276.34 1.59 29-Jan-20 28,807.63 1.603 22-Jan-20 28,722.85 1.641 15-Jan-20 29,196.04 1.769 8-Jan-20 28,939.67 1.818 1-Jan-20 28,583.68 1.827 a. Create...

This course contains a Course Project, where you will be required to submit one draft of...

This course contains a Course Project, where you will be required to submit one draft of the project at the end of Week 5, and the final completed project at the end of Week 7. Using the financial statements for Celgene Corporation and Gilead Sciences, Inc., respectively, you will calculate and compare the financial ratios listed further down this document for the fiscal year ending 2015, and prepare your comments about the two companies' performances based on your ratio calculations....

Write a project report covering the following topics. Please do not copy. Must Submit by 19th...

Write a project report covering the following topics. Please do not copy. Must Submit by 19th April, 2020 Your submission will be checked on-line for plagiarism. 1. What is the role and significance of transportation in pandemic like Covid-19. 2. What are different kind of Transportation policies pursued by different countries during Covid-19 pandemic? • Each student must discuss about transportation policy of any three countries from the following list o Saudi Arabia, USA, China, Japan, South Korea, Italy, UK...

Question