This is so hard! my class started 13 Jan 2020 ....Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started. For example, if the current term started on April 1, 2018, then use April 1, 2017 – March 31, 2018. (Do NOT use these dates. Use the dates that match up with the current term.) Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next, click the link on the right side of the page that says “Download Data” to save the file to your computer. This project will only use the Close values. Assume that the closing prices of the stock form a normally distributed data set. This means that you need to use Excel to find the mean and standard deviation. Then, use those numbers and the methods you learned in sections 6.1-6.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points. Complete this portion of the assignment within a single Excel file. Show your work or explain how you obtained each of your answers. Answers with no work and no explanation will receive no credit. 1.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) 2.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) 3.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) 4.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) 5.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) 6.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) 7.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.

Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started. For example, if the current term started on April 1, 2018, then use April 1, 2017 – March 31, 2018. (Do NOT use these dates. Use the dates that match up with the current term.) My class started 14 January 2019. Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next, click the link on the right side of the page that says “Download Data” to save the file to your computer. This project will only use the Close values. Assume that the closing prices of the stock form a normally distributed data set. This means that you need to use Excel to find the mean and standard deviation. Then, use those numbers and the methods you learned in sections 6.1-6.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points. Complete this portion of the assignment within a single Excel file. Show your work or explain how you obtained each of your answers. Answers with no work and no explanation will receive no credit. 1. 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) 2. 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) 3. 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) 4. 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) 5. 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) 6. 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) 7. 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)

PROJECT 3 INSTRUCTIONS Based on Brase & Brase: sections 6.1-6.3 Visit the NASDAQ historical prices weblink. First, set the date range to be for exactly 1 year ending on the Monday that this course started. For example, if the current term started on April 1, 2018, then use April 1, 2017 – March 31, 2018. (Do NOT use these dates. Use the dates that match up with the current term - MY COURSE STARTED ON JANUARY 14, 2018.) Do this by clicking on the blue dates after “Time Period”. Next, click the “Apply” button. Next, click the link on the right side of the page that says “Download Data” to save the file to your computer. This project will only use the Close values. Assume that the closing prices of the stock form a normally distributed data set. This means that you need to use Excel to find the mean and standard deviation. Then, use those numbers and the methods you learned in sections 6.1-6.3 of the course textbook for normal distributions to answer the questions. Do NOT count the number of data points. Complete this portion of the assignment within a single Excel file. Show your work or explain how you obtained each of your answers. Answers with no work and no explanation will receive no credit. 1. 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) 2. 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) 3. 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) 4. 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) 5. 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) 6. 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) 7. 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.

Seacrest Company uses a process costing system. The company manufactures a product that is processed in two departments: A and B. As work is completed, it is transferred out. All inputs are added uniformly in Department A. The following summarizes the production activity and costs for November:

1(c) Using the weighted average method, prepare a calculation of unit costs for Department A. Refer to the list of Amount Descriptions for the exact wording of text items within your schedule. Round to two decimal places. (Note: Be sure to enter the unit cost below the table.)

What is the unit cost?

1(d) Using the weighted average method, calculate the cost of EWIP and cost of goods transferred out for Department A.

Cost of EWIP:$ ____

Cost of goods transferred out: $_____

1(e) Using the weighted average method, prepare a cost reconciliation for Department A. Refer to the list of Amount Descriptions for the exact wording of text items within your schedule.

Note: Costs to account for and Costs accounted for will differ due to rounding.

2. CONCEPTUAL CONNECTION: (a) Prepare journal entries on Nov. 30 that show the flow of manufacturing costs for Department A. Use a conversion cost control account for conversion costs. Refer to the Chart of Accounts for the exact wording of account titles. (Note: Be sure to complete part (b) below the journal.)

GENERAL JOURNAL

1. The U.S. Food and Drug Administration (FDA) requires nutrition labeling for most foods. Under FDA regulations, manufacturers are required to list the amounts of certain nutrients in their foods, such as calories, sugar, fat, and carbohydrates. This nutritional information is displayed on the food’s package.

1. Find the equation of a regression line for each pair of variables

1. Calories, sugar

2. Calories, carbohydrates

2. Use the results of the previous exercise to predict each value.

1. The sugar content of one cup of cereal that has 120 calories.

2. The carbohydrate content of one cup of cereal that has 120 calories.

3. Find the multiple regression equations of each form

1. C=β0+ β1S+ β2F+ β3R

2. C=a0+a1S+a2R

4. Use the results from part iii) above, to predict the calories in 1 cup of cereal that has 7 grams of sugar, 0.5 grams of fat, and 31 grams of carbohydrates.

‏ You assume that a power system consists of four generators and seven loads . The number of buses is thirteen . Each bus is connected to two buses in the system . Calculate the number of nonzeros in the Jacobian matrix and the number of nonzeros in the bus admittance matrix for this system . Why is a slack bus needed in the power flow analysis ?

Michael Porter suggests seven ways in which companies can incorporate E-marketing into marketing and sales activities (Section 11-2). Choose an organization that has an online presence and provide real-world examples for two of these methods. Explain how/why these methods are appropriate for your chosen organization.

The following is a stem and leaf chart of the head circumferences (in centimeters) of two-month old female babies:

Is there enough evidence to indicate that the typical two-month old female baby has a head circumference larger than 39.0cm, with a 0.05 significance level? Justify your answer. Use s = 1.6395 cm.

Suppose Ari loses 31 ​% of all ping dash pong games . ​(a) What is the probability that Ari loses two ping dash pong games in a​ row? ​(b) What is the probability that Ari loses six ping dash pong games in a​ row? ​(c) When events are​ independent, their complements are independent as well. Use this result to determine the probability that Ari loses six ping dash pong games in a​ row, but does not lose seven in a row.

​(a) The probability that Ari loses two ping dash pong games in a row is . 0961 . ​(Round to four decimal places as​ needed.) ​(.31)^2

(b) The probability that Ari loses six ping dash pong games in a row is . 0009 . ​(Round to four decimal places as​ needed.) ​(.31)^6

(c) The probability that Ari loses six ping dash pong games in a​ row, but does not lose seven in a row is nothing . ​(Round to four decimal places as​ needed.)