Build an Earned Value Management (EVM) model using these variables:

Planned Value: $45,000

i.Note for understanding, this based on time, and what we expected to use based on time.  Your schedule variance is based on earned and planned.

Actual Cost: $39,500

Earned Value (how much has been spent based on planned costs) : $43,500

i.Note for understanding, this usually based on expected costs at the task level.  In other words, for the tasks complete the project was expected to use this much costs. Your cost variance is based on actual and earned.

Balance at Completion: $172,000

Original Time in Months: 14

Calculate in the model:

Cost Variance

Schedule Variance

Cost Performance Index

Schedule Performance Index

Estimate at Completion

Estimated Time

Use conditional formatting to render any “bad” values red, “good” values green and “0” values yellow.  Do cell by Cell.

Analyze the data and denote your evaluation of the project.  Include in the evaluation comments on schedule, costs, and performance

You will need the following variables:

ExamAvg, FinalExam, Partication, AssignAvg, MyName, Grade

Create lists for Exams and Assignments, ExamList and AssignList.

Assume Participation is 100% for now and assign values to assignments and exams (you'll have to guess at Exam2). Use methods we have learned on lists to calculate the averages.  

Your grade is calculated by the following weighting formula:

Grade = (0.30)*(ExamAvg) + (0.25)*FinalExam + (0.05)*Participation + (0.40)*AssignAvg

Use a series of if-else, and elif statements to calculate (and print) your grade according to the following:

if 90 <= grade <= 100 Congratulations, MyName, you earned an A.  

if 80 <= grade <= 89 Good work, MyName, you earned a B.

if 70 <= grade <= 79 You earned a C, MyName, perhaps a bit more work?

if 60 <= grade <= 69 You earned a D, MyName, come for help if you need it.

if grade < 60 You are failing the course. Please come for help.  

You are free to use different variable names, put values in a list, etc.  

Q. 1) Generally, in 2016, which of the folloing events will trigger the Employer Shared Responsability Penalty?

a) A part-time employee who works for employer with 50 or more employees, receives qualified health insurance from the Marketplace, and receives the premium tax credit.

b) A full-time employee who works for employer with 50 or more employees, receives qualified health insurance from the Marketplace, and receives the premium tax credit

c) A part-time employee who works for an employer with fewer than 50 employees, receives qualified health insurance from the Marketplace, and receives the premium tax credit.

d) A full-time employee who works for employer with fewer than 50 employees, receives qualified health insurance from the Marketplace, and receives the premium tax credit.

Smoking habits of UK residents: A survey was conducted to study the smoking habits of UK residents. Below is a data matrix displaying a portion of the data collected in this survey. Note that "£" stands for British Pounds Sterling, "cig" stands for cigarettes, and "N/A" refers to a missing component of the data.

a) What does each row of the data matrix represent?

• a variable
• an observation

b) How many participants were included in the survey?
c) Identify each variable, determine whether each variable is numerical or categorical. If the variable is numerical, specify continuous or discrete. If the variable is categorical, specify whether the variable is ordinal or not.

• The variables are sex (regular categorical), age (discrete), marital status (regular categorical), earnings (ordinal), whether or not the individual smokes (regular categorical), amount the individual smokes per day on a weekday (discrete), amount the individual smokes per day on a weekend (discrete)
• The variables are sex (regular categorical), age (discrete), marital status (regular categorical), earnings (continuous), whether or not the individual smokes (regular categorical), amount the individual smokes per day on a weekday (discrete), amount the individual smokes per day on a weekend (discrete)
• The variables are sex (ordinal), age (continuous), marital status (regular categorical), earnings (discrete), whether or not the individual smokes (regular categorical), amount the individual smokes per day on a weekday (discrete), amount the individual smokes per day on a weekend (discrete)

Get help: Video

Animal cloning is a technique to produce many copies of animals from one cell. Thus, it is saving us time to breed the animal for world consumption. The very idea of animal cloning is interesting but resulted in so many issues. Discuss the issues and give your opinion on this subject.

There is looming trade war discussion between US and China, two economic giant in the world. Technology and intellectual property are a big part of the discussion. What's your thoughts on trade war? What international law could be applied? Analyze the situation from the technical standpoint only.

1. What is the relationship between the federal funds rate and Inflation? 2. if the graph of federal rates is in recession, is the inflation graph in expansion? 3. How about vice versa? Please explain with definitions and examples from the US economy. This can be answered as a paragraph. Thank you.