DISCUSSION BOARD FORUM 1/PROJECT 2 INSTRUCTIONS Standard Deviation and Outliers Thread:

For this assignment, you will use the Project 2 Excel Spreadsheet to answer the questions below. In each question, use the spreadsheet to create the graphs as described and then answer the question. Put all of your answers into a thread posted in Discussion Board Forum 1/Project 2. This course utilizes the Post-First feature in all Discussion Board Forums. This means you will only be able to read and interact with your classmates’ threads after you have submitted your thread in response to the provided prompt. For additional information on Post-First, click here for a tutorial. This is intentional. You must use your own work for answers to Questions 1–5. If something happens that leads you to want to make a second post for any of your answers to Questions 1–5, you must get permission from your instructor.

1. A. Create a set of 5 points that are very close together and record the standard deviation. Next, add a sixth point that is far away from the original 5 and record the new standard deviation. What is the impact of the new point on the standard deviation? Do not just give a numerical value for the change. Explain in sentence form what happened to the standard deviation.

B. Create a data set with 8 points in it that has a mean of approximately 10 and a standard deviation of approximately 1. Use the second chart to create a second data set with 8 points that has a mean of approximately 10 and a standard deviation of approximately 4. What did you do differently to create the data set with the larger standard deviation?

2. Go back to the spreadsheet and clear the data values from Question 1 from the data column and then put values matching the following data set into the data column for the first graph. 50, 50, 50, 50, 50. Notice that the standard deviation is 0. Explain why the standard deviation for this one is zero. Do not show the calculation. Explain in words why the standard deviation is zero when all of the points are the same. If you don’t know why, try doing the calculation by hand to see what is happening. If that does not make it clear, try doing a little research on standard deviation and see what it is measuring and then look again at the data set for this question.

3. Go back to the spreadsheet one last time and put each of the following three data sets into one of the graphs. Record what the standard deviation is for each data set and answer the questions below. Data set 1: 0, 0, 0, 100, 100, 100 Data set 2: 0, 20, 40, 60, 80, 100 Data set 3: 0, 40, 45, 55, 60, 100 Note that all three data sets have a median of 50. Notice how spread out the points are in each data set and compare this to the standard deviations for the data sets. Describe the relationship you see between the amount of spread and the size of the standard deviation and explain why this connection exists. Do not give your calculations in your answer—explain in sentence form. For the last 2 questions, use the Project 1 Data Set. 4. Explain what an outlier is. Then, if there are any outliers in the Project 1 Data Set, what are they? If there are no outliers, say no outliers.

5. Which 4 states have temperatures that look to be the most questionable or the most unrealistic to you? Explain why you selected these 4 states. For each state, give both the name and the temperature. Replies: After you have submitted your thread, you will be able to see your classmates’ threads. Find 2 classmates who disagreed with at least some part of your answers to Questions 4 and 5 and explain why your answers are correct. If you change your mind about your answers for Questions 4 and 5, explain what you were thinking originally as well as what you think now and why. Replies must be at least 50 words each. Submit your thread by 11:59 p.m. (ET) on Saturday of Module/Week 3. Submit your replies to 2 classmates’ threads by 11:59 p.m. (ET) on Monday of the same module/week.

This question is also doable in Excel

QUESTION 1

You have been appointed as the investment manager for Maximum Asset Managers. You are in the process of selecting a portfolio of assets, and have been presented with returns relating to four assets, as follows:

You want to create a single portfolio comprising of the following combination:

Required:

a) Calculate the expected return of the proposed portfolio GHJ. (Round off your final answer to two decimal places.)

b) Calculate the standard deviation of portfolio GHJ. (Round off your final answer to two decimal places.)

c) Calculate the coefficient of variation of portfolio GHJ. (Round off your final answer to two decimal places.)

Oranges are grown, picked, and then stored in warehouses in Tampa, Miami, and Fresno, These warehouses supply oranges to markets in New York, Philadelphia, Chicago, and Boston. The following table shows the shipping costs per truckload (in hundreds of dollars), supply, and demand. Because of an agreement between distributors, shipments are prohibited from Miami to Chicago:

Formulate this problem as a linear programming model by hand, and then solve it using the computer.

1. A firm has the following relationship between output (Q) and total cost (TC):

1. Say the firm is a perfect competitor. If the market price for its product is $ 60, at what output level will this firm produce at (as a profit maximizer)?

2. At the output level in (a), are firms in this industry making a profit or loss? Will firms enter or exit the market?

3. Say this firm is a monopoly. If the firm maximizes profit where marginal revenue equals $ 30, at what output level will the firm be producing at (as a profit maximizer)?

Federal income tax allows a deduction for any state income tax paid during the year. In addition, the state of Alabama allows a deduction from its state income tax for any federal income tax paid during the year.

The federal corporate income tax is equivalent to a flat rate of 34% of the taxable federal income and the Alabama rate is 5% of the taxable state income. Both the federal and Alabama taxable income for a certain corporation are $1,000,000 before either tax is paid.

Because each tax is deductible on the other return, the taxable income will differ for the state and federal taxes. To find the tax due in this situation, you will use and then compare two different methods.

Iteration:

1. Make an estimate of the federal taxes due by assuming no state tax is due. Deduct this amount from the taxable income, and then calculate an estimate of the state taxes due on the basis of this assumption.

Federal due:

State due:

2. Deduct the estimated state tax due as computed in (1) above from the taxable income, and calculate a new estimate of the federal tax due under this assumption.

Federal due:

3. Deduct the new estimated federal tax due as computed in (2) above from the taxable income, and calculate a new estimate of the state tax due on the basis of these calculations.

State due:

4. Repeat the process in (2) and (3) to get a better estimate of the taxes due to both governments.

Federal due:

State due:

5. Continue this process until the federal tax changes from one repetition to another by less than $1.

What Federal Tax is due?

What State Tax is due?

Matrix Equation:

6. Create two linear equations that describe this taxation situation. Convert the system into a matrix equation, and solve the system to see exactly what tax is due to each government.

7. Does your answer from number 6 above match your answer from number 5? (Hint: it should)

8. What is the effective tax rate that this corporation pays to each government?

The authors of the paper "Age and Violent Content Labels Make Video Games Forbidden Fruits for Youth" carried out an experiment to determine if restrictive labels on video games actually increased the attractiveness of the game for young game players.† Participants read a description of a new video game and were asked how much they wanted to play the game. The description also included an age rating. Some participants read the description with an age restrictive label of 7+, indicating that the game was not appropriate for children under the age of 7. Others read the same description, but with an age restrictive label of 12+, 16+, or 18+.

The paper gave data for 12- to 13-year-old girls. Data consistent with summary values in the paper are shown below.

Do the data provide convincing evidence that the mean rating associated with the game description for 12- to 13-year-old girls is not the same for all four age restrictive rating labels? Test the appropriate hypotheses using

α = 0.05.

Calculate the test statistic. (Round your answer to two decimal places.)

F = ______________

Prove that one of the diagonals of a kite bisects two of the angles of the kite. What about the other diagonal — must it also be an angle bisector? Explain your response.

Two sets are separated if the intersection of the closure of one of the sets with the other is empty.

a) Prove that two closed and disjoint sets of some metric space are separate.

b) Prove that two open and disjoint sets of some metric space are separate.

The objective of this assignment is to look at two aspects of testing, one is an exploration of the theory of testing, the second is the exploration of a practical software tool.

You should pick a specific topic in software testing and explore it in a bit of detail, issues you could look at include: Functional testing, Compatibility testing, Static testing, Dynamic testing, White box testing, Black box testing, Grey box testing, Visual testing, Unit testing, Integration testing, Regression testing, Alpha testing, Beta testing, Usability testing, Certification, etc. or whatever you want.

Write between one page and one and a half pages on the topic, and include at least four references you use - this can be websites, papers, videos or books. Use the six thinking hats as a model for the structure of the article you write so do an Introduction Section (blue hat), some facts and details about the topic (white hat), the benefits of this topic (yellow hat), the shortcomings around this topic (black hat), the alternatives or interesting facts or examples about this topic (green hat), your views and reflections on this topic (red hat), and a conclusion at the end (another blue hat). Additionally include a simple MindMap about the topic.