(EXCEL) DATA 1 :

THE QUESTIONS :

Q1\ The value of the test statisic ?

Q2\ The value of the p value of the test ?

Q3\ What is the H0 rejection region for the testing at the 1% level of significance ? t > ____

Q4/ interpret the result based on your Excel Outputs .

_________________________________________________________________

(EXCEL) DATA 2:

Group 1 Group 2 Group 3 Group 4

44 54 55 44

73 65 78 42

71 79 86 74

60 69 80 42

62 60 50 38

THE QUESTIONS :

Q1\ The value of the test statisic ?

Q2\ The value of the p value of the test ?

Q3\ What is the H0 rejection region for the testing at the 5% level of significance ? F >= ____

Q4/ interpret the result based on your Excel Outputs .

5. Jamestown Furniture Co. is a small, but fast-growing manufacturer of living room furniture. Its two principal products are end tables and sofas. There are five processes in the manufacturing at Jamestown: Cutting the lumber, cutting the fabric, sanding, staining, and assembly. Jamestown has one employee working in fabric cutting and one employee working in staining. These are relatively skilled workers and could be replaced only with some difficulty. The cutting and sanding operations are performed by two workers each, and while there is some skill to these operations, it is less critical than for staining and for fabric cutting. Assembly is the least skill-based process and is currently done by one full-time employee and a group of part timers who provide a total of 175 minutes of working time per week. The other employees work a 40-hour week, with 5 hours off for breaks, training, and personal time. Assume a fourweek month, and that by prior agreement, any of the employees can be switched from one task to another.

The current demand for Jamestown's products and sales prices are provided below. Jamestown expects demand to increase significantly in the coming months (this depends on whether it is able to successfully obtain the order it is negotiating to get from a motel chain). The materials cost for the table is $150 and $275 for the sofa.

The time required for each activity and the total time available are shown below.

Required:

What is the most profitable production plan for Jamestown? Explain your answer with supporting Calculations.

Do not do any interim rounding, calculate values to at least 6 decimal places before converting to a percentage, state answers as a percentage to 2 decimal places, do not include labels (%, $). For example, .06487 should be input as 6.49

Consider the following information about expected returns for two securities, Ravenwood Consulting and Brody Enterprises.

The expected return for a portfolio invested 65% in Ravenwood and 35% in Brody is:

A travel analyst claims that the standard deviation of the room rates for two adults at 3-star hotels in Denver, Colorado is more than $68. A random sample of 18 3-star hotels has a standard deviation of $40. Use a 0.10 significance level to test the analyst’s claim. Assume the population is normally distributed.

a. Hypothesis (steps 1-3):

b. Value of Test Statistic (steps 5-6):

c. P-value (step 6):

d. Decision (steps 4 and 7):

e. Conclusion (step 8):

A company is attempting to select between two financing alternatives. Option 1 is to issue an       additional $1 million in debt at 8%. The second option is to issue $1 million o common shares at $25/share. The firm currently has $250,000 of 7% debt and 100,000 shares of common outstanding. Its tax rate is 40%.

a. What is the indifference point?

b. Which option would you choose if the EBIT is projected to be $100,000?

c. Which option would you choose if the EBIT is projected to be $350,000?

The W.C. Pruett Corp. has $250,000 of interest-bearing debt outstanding, and it pays an annual interest rate of 8%. In addition, it has $600,000 of common stock on its balance sheet. It finances with only debt and common equity, so it has no preferred stock. Its annual sales are $1.6 million, its average tax rate is 40%, and its profit margin is 7%. What are its TIE ratio and its return on invested capital (ROIC)? Round your answers to two decimal places.

. Consider the following sorting procedure. This procedure uses nested loops to make several passes through the array. Each pass compares successive pairs of elements. If a pair is in increasing order (or the values are equal), the sorting procedure leaves the values as they are. If a pair is in decreasing order, the sorting procedure swaps their values in the array.  The first pass compares the first two elements of the array and swaps their values if necessary.  It then compares the second and third elements in the array.  The end of this pass compares the last two elements in the array and swaps them if necessary.  After one pass, the largest element will be in the last index.  After two passes, the largest two elements will be in the last two indices.  After n – 1 pases (where n is the size of the array), the largest n – 1 elements will be in the last n – 1 indices and we have a sorted array.(java

1.  Two 3 kg physical science textbooks on a book shelf are separated by 0.25 m. What is the force of gravitational attraction between the books?   

2. What is the force of gravity between two 1000 kg cars separated by a distance of 20 m on a highway?

3. Using the force, calculated in # 2 above, and the weight of the car, calculate:     

Force (from #2) divided by the weight of car   

4. How would the force of gravity between two masses be affected if the separation distance between them is doubled?

5. How would the force of gravity between two masses be affected if the separation distance between them is decreased by one-half?

6. The separation distance between two 2.0 kg masses is decreased by two-thirds. How is the gravitational force between them affected?

7. A man has a mass of 150 kg. What does he weigh on earth expressed in N?

8. If the gravitation constant on the moon, gm is one-sixth that on the earth, how much does the man in # 7 weigh on the moon?

9. An astronaut on the moon places a package on a scale and finds it weight to be 15 N. What would the package weigh on earth?

10. What is the package's mass on the moon?

Apple is considering marketing one of two new smartphones for the coming holiday season: iPhone 8 and iPhone X. Estimated profits in total USD under high, medium, and low demand are as follows:

There is concern that profitability will be affected by a Google's introduction of the Pixel 2 smartphone viewed as similar to the iPhone 8. Estimated profits in total USD with and without competition are as follows:

a. Develop a decision tree for the Apple problem.

b. For planning, Apple believes there is a 0.99 probability that its competitor will produce a new smartphone similar to the iPhone 8. Given this probability of competition, the director of planning in Cupertino recommends spending the ad dollars and heavily marketing the iPhone X smartphone. Using expected value, what is your recommended decision?

c. Show a risk profile for your recommendation.

d. Use sensitivity analysis to determine what the probability of competition for iPhone 8 would have to be for you to change your recommended decision alternative.