The town hall of a city wants to open some recreational centers. It has been analyzed 3 options. The opening cost and the capacity of each center are listed below.

The selected recreational centers must be hosting the students from 5 schools. In the table below is summarized the number of students at each school.

Each school must be assigned to only one recreational center. And the capacity of each center must be respected. What are the recreational centers that must be open in order to minimize the opening cost?

Illustrate the greedy procedure with the following data:

For the following commands you must be logged in as user “system”. You will need to do some research on the commands CREATE USER; GRANT CREATE SESSION; GRANT CREATE…..; GRANT ALTER …., GRANT SELECT….; REVOKE ……; and EXECUTE …..

5. Create two database users:  The first is a concatenation of your first and last name (e.g. johndoe).  The second is a concatenation of your instructors first and last name (e.g. sallysmith)

6. Assign the two users privileges to connect to the database.

7. Assign the user with your first and last name the privilege to select data from the employees table.

8. Assign the user with your instructors first and last name all privileges to the Departments table.

9. Assign the user with your first and last name the privilege to execute any procedure.

10. Take away the instructors privilege to execute any SQL commands on the Departments table

Regression and Correlation Analysis

Use the dependent variable (labeled Y) and one of the independent variables (labeled X1, X2, and X3) in the data file. Select and use one independent variable throughout this analysis. Use Excel to perform the regression and correlation analysis to answer the following.

Generate a scatterplot for the specified dependent variable (Y) and the selected independent variable (X), including the graph of the "best fit" line. Interpret.

Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable.

Determine the coefficient of correlation. Interpret.

Determine the coefficient of determination. Interpret.

Test the utility of this regression model, represented by a hypothesis test of b=0 using α=0.10. Interpret results, including the p-value.

Based on the findings in steps 1-5, analyze the ability of the independent variable to predict the dependent variable?

Compute the confidence interval for b, using a 95% confidence level. Interpret this interval.

Compute the 99% confidence interval for the dependent variable, for a selected value of the independent variable. Each student can choose a value to use for the independent variable (use same value in the next step). Interpret this interval.

Using the same chosen value for part (8), estimate the 99% prediction interval for the dependent variable. Interpret this interval.

What can be said about the value of the dependent variable for values of the independent variable that are outside the range of the sample values? Explain.

Summarize your results from Steps 1–10 in a 3-page report. The report should explain and interpret the results in ways that are understandable to someone who does not know statistics.

Submission: The summary report and all of the work done in 1–10 (Excel output and interpretations) as an appendix

Format for report:

Summary Report

Steps 1-10 addressed with appropriate output, graphs and interpretations. Be sure to number each step 1-10.

Please solve the following game:

Assume that a total $100 grant will be shared by the three researchers, X, Y, and Z. Each person is rational and selfish. There are six proposals with different shares of (X, Y, Z) for choices as the following.

Proposal I: (X, Y, Z) = (50, 40, 10)

Proposal II: (X, Y, Z) = (60, 10, 30)

Proposal III: (X, Y, Z) = (40, 20, 40)

Proposal IV: (X, Y, Z) = (20, 30, 50)

Proposal V: (X, Y, Z) = (30, 50, 20)

Proposal VI: (X, Y, Z) = (20, 50, 30)

The rule of choosing the final proposal is simple. First, Z is the person to determine who (either X or Y) is the proposal raiser. Then the proposal raiser chooses a particular proposal. Finally, the last person has the right to pass it or reject it. If the last person’s payoff is the smallest among the three, then the proposal will be rejected and no one will get anything. The decision making process can be done by only one time. Which proposal will be the final outcome? Explain the decision briefly.

Please solve the following game:

Assume that a total $100 grant will be shared by the three researchers, X, Y, and Z. Each person is rational and selfish. There are six proposals with different shares of (X, Y, Z) for choices as the following.

Proposal I: (X, Y, Z) = (50, 40, 10)

Proposal II: (X, Y, Z) = (60, 10, 30)

Proposal III: (X, Y, Z) = (40, 20, 40)

Proposal IV: (X, Y, Z) = (20, 30, 50)

Proposal V: (X, Y, Z) = (30, 50, 20)

Proposal VI: (X, Y, Z) = (20, 50, 30)

The rule of choosing the final proposal is simple. First, Z is the person to determine who (either X or Y) is the proposal raiser. Then the proposal raiser chooses a particular proposal. Finally, the last person has the right to pass it or reject it. If the last person’s payoff is the smallest among the three, then the proposal will be rejected and no one will get anything. The decision making process can be done by only one time. Which proposal will be the final outcome? Explain the decision briefly.   

The tables below present expected free cash flow related data for XYZ for Year 1 and selected balance sheet data as of Year 0.  XYZ has reached the steady state growth phase and XYZ’s WACC is 8%.

Year 0 Data                                                               

Year 1 Data

You expect that XYZ would grow at 2.0% per year in perpetuity. What is XYZ’s intrinsic value per share.

Using the miles driven data, test the following claims:

1. 50% of drivers travel less than 40 miles per day.
2. One-third of drivers never travel more than 50 miles per day.
3. 50% of drivers travel less than 350 miles per week.    
4. One-third of drivers never travel more than 400 miles per week.  

A company plans to purchase a new machine. There are two choices. The following are the cash flows from two machines:  

     Machine A:    The machine’s initial purchase price is $99,718, and it has a singlemaintenance fee of $6,000 at the end of year 4. The machine would last for 7 years. Assume that the discount rate is 8% for this machine.

     Machine B:    The machine’s initial purchase price is $10,000, and it has annualmaintenance cost of $10,000 at the end of each year for 5 years. The machine would last for 5 years. Assume that the discount rate is 10% for this machine.

    As a financial analyst assistant, you have been asked to compute Equivalent Annual Annuity (EAA), also called Equivalent Annual Cost (EAC). How much are the EAA of these two machines?

Select two data values from your raw data – one that is inside of the confidence interval and one that is outside – one must be at the high end of the data and one at the low end – and construct two hypothesis tests, one for each value. One of the tests should be a “less than”, the other should be a “greater than”, depending on the value being tested. Use a 95% level of confidence.

Songs
250
5
800
500
850
430
200
600
0
130
1000
1000
400
1500
20
1500
872
150
115
90
252
2345
200
200
300
200
650
1500
600
500
800
400
930
400
10000
456
200
1200
0
500
30
0
950
180
450
1000
730
10
10
55
260
500
0
1327
0
250
0
35
100
1000
10
35
0
1200
2000
200
1813
15
90
5
100
300
1400
200
22
800
300
1000
15
75
200
700
167
200
183
678
50
350
150
400
2000
2000
900
1
400
300
100
150
300
150
100
1200
1500
200
100
1500
300
300
3000
2000
150
100
200
4000
200
500
1500
500
3600
1567
350
181
400
500
0
250
100
50
300
300
500
2000
60
200
0
100
350
400
1000
40
250
1750
0
0
400
840
200
300
500
0
800
200
400
15
45
170
150
0
2409
350
2100
200
200
25
25
0
200
0
0
1200
450
400
2750
300
300
1869
970
300
2900
1140
40
100
2000
500
1000
0
500
30
0
500
812
0