Your company is evaluation 4 independent projects and is subject to capital rationing, detailed as follows:

Project  Initial Outlay    IRR      NPV

    1          2 million        18%   2,500,000

    2          1 million        15%      950,000

    3          1 million        10%      600,000

    4          3 million         9%    2,000,000

If you must select projects subject to a budget constraint of 3 million dollars, which set of projects should be accepted so as to maximize firm value?

Is the percentage average room rate increase from May to August affected by the number of stars of a hotel? In order to answer this question you are asked to use one way analysis of variance. 1.1 Compute the percentage Average Room Rate Increase from May to August for each hotel in the sample, rounding up to the second decimal. Call this variable PCT_ARR_INCREASE. 1.2 State the null and alternative hypotheses. 1.3 Test the null hypothesis at the 5% significance level. 1.4 What can you conclude from the above findings? 1.5 A friend of yours insists that the data clearly show that 5-star hotels have larger percentage average room rate increases than lesser star hotels so he/she is confident that the number of stars affects the percentage average room increase. What would be your answer to him/her be?

STARS   ARR_MAY   ARR_AUG
5 95 160
5 94 173
5 81 174
5 131 225
5 90 195
5 71 36
5 85 114
4 70 159
4 64 109
4 68 148
4 64 132
4 59 128
4 25 63
3 76 130
3 40 60
3 60 70
3 51 65
3 65 90
2 45 55
1 35 90
4 22 51
4 70 100
3 60 120
3 40 60
3 48 55
2 52 60
2 53 104
2 80 110
2 40 50
1 59 128
4 90 105
3 94 104
2 29 53
2 26 44
1 42 54
1 30 35
2 47 50
1 31 49
1 35 45
1 40 55
1   40 55
1   35 40
3   40 55
4   57 97
2   35 40
5   113 235
5   61 132
5   112 240
5   100 130
4   87 152
4   112 211
4   95 160
4   47 102
4   77 178
4   48 91
3   60 104
3   25 33
5   68 140
4   55 75
3   38 75
3   45 70
3   45 90
5   100 180
4   180 250
3   38 84
3   99 218
3   45 95
2   28 40
2   30 55
1   16 35
3   40 70
2   60 100
1   16 20
2   22 41
2   55 100
1   40 100
1   80 120
1   80 120
1   18 35
3   80 100
2   30 45
1   40 65
1   30 50
1   25 70
1   30 35
4   215 265
4   133 218
2   35 95
2   100 150
2   70 100
5   60 90
5   119 211
5   93 162
5   81 138
5   44 128
5   100 187
5   98 183
5   100 150
5   102 211
5   103 160
4   40 56
4   69 123
4   112 213
4   80 124
3   53 91
4   73 134
4   94 120
4   70 100
3   40 75
3   50 90
3   70 120
3   80 95
3   85 120
3   50 80
3   30 68
3   30 100
2   32 55
2   50 90
2   70 120
2   30 73
2   94 120
4   100 180
2   70 120
2   19 45
2   35 70
2   50 80
1   25 45
1   30 50
2   55 80
3   95 120
1   25 31
1   16 40
1   16 40
1   19 23
1   30 40 THREE COLUMNS (STARS -ARR_MAY-ARR_AUG)

PLEASE ANSWER QUESTION 1.3,1.4,1.5

THANKS IN ADVANCE

1. Use the above table to obtain the correlection coefficient between the "Price" and the "Number of bedrooms" variable in Excel. Please provide a picture of the Excel spreadsheet results.

2. Interpret the correlation coeffcient that you obtained in part (1), i.e., explain what the number means.

3. Use the above table. Data set and run one multiple regression with "Price" as dependent variable on the following independent variables:

(a) Size

(b) Number of Bedrooms

(c) Number of Baths

(d) Distance to Town Center

(e) Garage dummy

(f) Pool dummy

4. Interpret the estimated value of the intercept, i.e., explain what the number means in this regression.

5. Interpret the estimated value of the coefficient on the “Size (in square feet)” variable, i.e., explain what the number means in this regression.

6. Interpret the estimated value of the coefficient on the “Number of bedrooms” variable, i.e., explain what the number means in this regression.

7. Interpret the estimated value of the coefficient on the “Pool dummy” variable, i.e., explain what the number means in this regression.

8. Are there any coefficient estimates that are statistically significant? If so, name one and explain how you can tell that it is statistically significant.

9. Are there any coefficient estimates that are not statistically significant? If so, name one and explain how you can tell that it is not statistically significant.

10. What is the predicted price for a house that has 2,000 square feet, four bedrooms and two baths, is 12 miles away from the town center, and has neither a garage nor a pool?

11. Consider a new “No Garage dummy” variable that is “1” when a house does not have a garage and “0” when it does have a garage. Suppose that we then run a new multiple regression that is the same regression as in Part (a), but with the “No Garage dummy” variable instead of the “Garage dummy.” What would the estimated value of the coefficient on the “No Garage dummy” be?

12. What percentage of the variation in the dependent variable can be explained by variation in the independent variables?

13. What percentage of the variation in the dependent variable cannot be explained by variation in the independent variables?

A researcher is interested to learn if there is a relationship between the level of interaction a women in her 20s has with her mother and her life satisfaction ranking. Below is a list of women who fit into each of four level of interaction. Conduct a One-Way ANOVA on the data to determine if a relationship exists.

(Language: c++)Write a program that displays a question and 4 possible

answers numbered 1 through 4. . The program should

ask the user to answer 1, 2, 3, or 4 and tell them if they

are correct or not. If the user enters anything besides 1, 2,

3, or 4 the program should return an error message

example outout: whats 2+5?

1. 4

2. 7

3. 1

4. 0

// if user inputs anything other then option 2 the screen should display "incorrect"

// if the user inputs anything other then 1,2,3,or 4 the screen should display "error invalid answer given"

//, when the correct answer is given computer, should display "correct".

Subject 3

George who is the General Director of the Research Institute for Tourism in Greece, believes that the percentage composition of 5 Stars hotels is not the same in Crete and elsewhere (Southern Aegean Islands and Ionian Islands). In order to test this statement, create two additional binary variables as follows:

5STARS: Yes (Code 1) when STARS = 5; No (Code 0) when STARS ≠ 5.

CRETE: Yes (Code 1) when Region_ID = 1; No (Code 0) when Region_ID ≠ 1.

3.1 State the null and the alternative hypotheses.

3.2 Test the null hypothesis at α = 5%.

3.3 What is your conclusion?

3.4 Let π1 denote the population proportion of 5 stars hotels in Crete and π2 the population proportion of 5 stars hotels elsewhere. Set up a symmetric 95% confidence interval estimate of the difference (π1 - π2). What is your main conclusion?

Using Perl create a program that will output the scores of 3 golfers that are playing nine holes of golf.
Create a blank array, this will be a two-dimensional array
@golf_array;
Load up the follow scores
For hole 1: Golfer 1 shot 4, Golfer 2 shot 3, Golfer 3 shot 5
For hole 2: Golfer 1 shot 3, Golfer 2 shot 3, Golfer 3 shot 4
For hole 3: Golfer 1 shot 7, Golfer 2 shot 5, Golfer 3 shot 5
For hole 4: Golfer 1 shot 6, Golfer 2 shot 3, Golfer 3 shot 4
For hole 5: Golfer 1 shot 3, Golfer 2 shot 7, Golfer 3 shot 4
For hole 6: Golfer 1 shot 3, Golfer 2 shot 3, Golfer 3 shot 3
For hole 7: Golfer 1 shot 4, Golfer 2 shot 4, Golfer 3 shot 5
For hole 8: Golfer 1 shot 5, Golfer 2 shot 5, Golfer 3 shot 4
For hole 9: Golfer 1 shot 3, Golfer 2 shot 6, Golfer 3 shot 3
Print out the scores for each golfer
Golfer 1:
Hole 1 – 4
Hole 2 – 3
…
Hole 9 – 3
Golfer 2:
Hole 1 – 3
Hole 2 – 3
…
Extra credit:
Print out which golfer had the lowest score and what that score was.

A teacher is interested in whether the number of bullying incidents by active bullies varies by class. The following data are the number of bullying incidents that occurred for 5 individuals randomly selected from 4 separate classes. Test the null hypothesis at the .01 level of significance that bullying does not vary across class. In so doing, identify: (1) the research and null hypothesis, (2) the critical value needed to reject the null, (3) the decision that you made upon analyzing the data, and (4) the conclusion you have drawn based on the decision you have made.

3. The Hofstadter Conway sequence is defined by a(1)=a(2)=1 and (for n>2 by) a(n)=a(a(n-1))+a(n-a(n-1)). Write a function to quickly compute this sequence.

>>> [hc(i) for i in range(1,20)]
[1, 1, 2, 2, 3, 4, 4, 4, 5, 6, 7, 7, 8, 8, 8, 8, 9, 10, 11]