Fill in the empty cells in the following table in order to calculate the standard error of the estimate. 

Note: Sum in the last column is , which is SS_residual.

F. Use the formula and information on p.15 of the Week 12_3 slides. What is the value of the standard error of estimate?What is the value of the residual variance or error variance (MS_residual)? (2 decimals)  

= 2.85

MS_residual = 8.13

G. Use the correlation coefficient you have calculated and p.16 of the Week 12_3 slides. Calculate the coefficient of determination (r²) and interpret its meaning in one sentence. [2 marks]

r² = 0.800

. Fill in the empty cells in the following table in order to calculate the standard error of the estimate. 

Note: Sum in the last column is , which is SS_residual.

F. Use the formula and information on p.15 of the Week 12_3 slides. What is the value of the standard error of estimate?What is the value of the residual variance or error variance (MS_residual)? (2 decimals) 

= 2.85

MS_residual = 8.13

G. Use the correlation coefficient you have calculated and p.16 of the Week 12_3 slides. Calculate the coefficient of determination (r²) and interpret its meaning in one sentence.  

r² = 0.800

You would like to determine if a prospective customer is more likely to purchase a product after viewing a promotional advertisement for that product. You have the following data from the focus group.

Conduct a hypothesis test using a 0.05 level of significance. Remember to show your work and indicate your conclusion.

Use StatCrunch and/or Excel (or another software of your choosing) to create a table of summary statistics for all Quantitative variables in the Cleaned Student Data Survey Results that you submitted for Course Project 3. The table should include the following summary statistics:

n (count)

Mean

Standard Deviation

5-Number-Summary (Min, First Quartile, Median, Third Quartile, Maximum)

Range (= Max - Min)

Inter-Quartile Range (IQR = Q3 - Q1)

The table should include these summary statistics for the following variables: Age, Height (in), Shoe Size, TV, Credits, Sleep, Work, Songs, Facebook Friends, Social Media Checks, tattoos number, and Siblings. I would recommend the following format.Bounds for Outliers (Lower Bound = Mean - 2.5 * Standard Deviation, Upper Bound = Mean + 2.5 * Standard Deviation)

As the national government has increased its voiced approval for the HPV vaccine known as Gardasil, many organizations have begun gathering data to address the rise in prevalence of young girls receiving the vaccine. Last year, the National Center for Health Statistics estimated that the National vaccine prevalence is up to 15% in the same age demographic. In order to test this assumption, a researcher conducted a study and found that out of 3,579 women in the demographic surveyed, 879 reported receiving one or more of the three shots included in the package for the vaccine.

A) Is the sample size large enough to justify the use of the Z formula?

B) Test if the proportion of the prevalence of the vaccine has changed. Use = 0.05. Hint: One sample proportion.

C) Calculate the 95% two-sided confidence interval for p and make a conclusion about H₀.

D) Compare your results and conclusions in a and b above. What would you conclude?

Carry probabilities to at least four decimal places for intermediate steps.

For extremely small probabilities, it is important to have one or two significant non-zero digits, for example, 0.000001 or 0.000034.

Round off your final answer to two decimal places.

*HAND Calculations ONLY, Show ALL steps*

As the first days of work on the Dune Buggy progress, you are concerned that information provided to you from your seconded supervisors, in terms of work completed, may not be accurate. As a result you may be experiencing problems which will only surface much later, when it will be to late for corrective action.

To remedy the problem, you decide to implement the same system of rigid controls that A-1 is being forced to apply on its military contracts, ie. Earned Value.

As a first step, using the following pricing data developed for the Cement Dune Buggy Project augmented with overhead costs, determine a cost/schedule baseline, by calculating the Planned Value (PV) for each of days 10, 25 and 40 .

Assume that all activity costs are distributed evenly on a daily basis.

What is the Budget at Completion (BAC)?

                 Description                                 Durn                 Start                                            Finish                 Cost  

A              Design Dune Buggy                     10                 01                                                 10                 3915

B              Order, Receive Materials             12                 11                                                 22             540

C              Test, Prepare Engine                    11                 23                                                 33                 4061

D              Add Suspension                           06                 25                                                 30                 2063

E              Add Drive Train                          03                 34                                                 36                 1248

F              Add W/A/S to Frame                   04                 31                                                 34                 1269

G              Test Fit Body Shell                      01                 43                                                 43             227

H              Cast Body Shell                           05                 35                                                 39                 2457

I               Sand & Prime Shell                     03                 40                                                 42             725

J               Paint Body Shell                          03                 44                                                 46                 1359

K              Install Engine                               05                 44                                                 48                 1673

L              Attach Body                                 01                 49                                                 49             369

M             Install Accessories                       03                 50                                                 52             964

N              Road Test                                    02                 53                                                 54             608

                                                                                                                                                                     21,478

Your firm, Agrico Products, is considering a tractor that would have a cost of $37,000, would increase pretax operating cash flows before taking account of depreciation by $12,000 per year, and would be depreciated on a straight-line basis to zero over 5 years at the rate of $7,400 per year beginning the first year. (Thus, annual cash flows would be $12,000 before taxes plus the tax savings that result from $7,400 of depreciation.) The managers disagree about whether the tractor would last 5 years. The controller insists that she knows of tractors that have lasted only 4 years. The treasurer agrees with the controller, but he argues that most tractors do give 5 years of service. The service manager then states that some last for as long as 8 years.

Assume that if the tractor only lasts 4 years, then the firm would receive a tax credit in Year 4 because the tractor's salvage value at that time is less than its book value. Under this scenario, the firm would not take depreciation expense in Year 5.

Given this discussion, the CFO asks you to prepare a scenario analysis to determine the importance of the tractor's life on the NPV. Use a 40% marginal federal-plus-state tax rate, a zero salvage value, and a 10% WACC. Assuming each of the indicated lives has the same probability of occurring (probability = 1/3), what is the tractor's expected NPV?

Round your answers to two decimal places. Do not round intermediate calculations. Negative amount should be indicated by a minus sign.

1. Tractor's NPV if actual life is 5 years.
   $
2. 
   
3. Tractor's NPV if actual life is 4 years.
   $
4. 
   
5. Tractor's NPV if actual life is 8 years.
   $
6. 
   
7. Tractor's expected NPV.
   $

Your firm, Agrico Products, is considering a tractor that would have a cost of $35,000, would increase pretax operating cash flows before taking account of depreciation by $13,000 per year, and would be depreciated on a straight-line basis to zero over 5 years at the rate of $7,000 per year beginning the first year. (Thus, annual cash flows would be $13,000 before taxes plus the tax savings that result from $7,000 of depreciation.) The managers disagree about whether the tractor would last 5 years. The controller insists that she knows of tractors that have lasted only 4 years. The treasurer agrees with the controller, but he argues that most tractors do give 5 years of service. The service manager then states that some last for as long as 8 years. Assume that if the tractor only lasts 4 years, then the firm would receive a tax credit in Year 4 because the tractor's salvage value at that time is less than its book value. Under this scenario, the firm would not take depreciation expense in Year 5.

Given this discussion, the CFO asks you to prepare a scenario analysis to determine the importance of the tractor's life on the NPV. Use a 40% marginal federal-plus-state tax rate, a zero salvage value, and a 12% WACC. Assuming each of the indicated lives has the same probability of occurring (probability = 1/3), what is the tractor's expected NPV? Round your answers to two decimal places. Do not round intermediate calculations. Negative amount should be indicated by a minus sign.

Tractor's NPV if actual life is 5 years. $

Tractor's NPV if actual life is 4 years. $

Tractor's NPV if actual life is 8 years. $

Tractor's expected NPV.$

Task 2: Debugging and writing functions

1. In IDLE, use the File -> New Window menu option to open a new editor window for your program, and save it using the name hw4Task2.py. Make sure to specify the .py extension.
2. Copy the following (buggy) code into that file:

def mysum(x, y)

""" takes two numbers and returns their sum """

    total = x + y

    print(total)

3. Save the file using Ctrl-S. Then try to run it using F5. What happens?
4. This function includes two syntax errors – errors that violate the rules of the Python language. See if you can find and fix them, continuing until you are able to run the file without any error messages. (Create a MS Word file and name it Task2 steps”. Use this word file, to write what you did to fix the errors in this step.)
5. Once you have eliminated the syntax errors, test the function from the Shell as follows:

>>> mysum(44, 67)

>>> print(mysum(10, 7))

What happens? Why?

(Use the MS Word file “Task2 steps”, and write your answer to this step.)

6. Fix the function so that both above tests work as expected.  (Use the MS Word file “Task2 steps” and write what you did in this step.)
7. In hw4Task2.py, write a function named sum_double that accepts two integers as parameters. The function should return the sum of the integers, unless the two values are the same, in which case the function should return double their sum. For example:

                 >>> sum_double(1, 2)

                 3

                 >>> sum_double(3, 2)

                 5

                 >>> sum_double(2, 2)

                 8

Be sure to write a docstring for the function.

After writing the function, test it in two ways:

• Make function calls from the Shell like the ones shown above.
• Copy the following code into your file:

def test():

    """ function for testing """

    test1 = sum_double(1, 2)

    print('first test returns', test1)

    # Add more tests below

This code provides the beginnings of a test function, with lines that call the function with a set of inputs and print the return value. It’s worth noting that this function does not need a return statement, because its sole purpose is to make test calls and print their results.

You should:

• add other test cases to the test function
• run the Python file
• call the test function from the Shell (by entering the call test()) and check that you obtain the correct return values for each test case.

(Use the MS Word file “Task2 steps”and write what you did in this step.)

I need a regression analysis done on the following numbers.

A consonsultant wishes to invest up to a total of $25000 in two types of securities, one that yields 10% per year and another than yields 8% per year. They believe that the amount invested in the first security should be at most one third of the amount invested in the second security. What investment program should the consultant pursue in order to maximize income? (Use constraint inqualities with objective function)