1. You are in the 28 percent income tax bracket and pay long-term capital gains taxes of 15 percent. What are the taxes owed or saved in the current year for each of the following sets of transactions?

a.) You buy 100 shares of ZYX for $10 and after seven months sell it on December 31, 201X, for $23. You buy 100 shares of WER for $10 and after 15 months sell it on December 31 201X, for $7. You buy 100 shares of DFG for $10 and after nine months, on December 31, 201X, it is selling for $15.

b.) You buy 100 shares of ZYX for $60 and after seven months sell it on December 31, 201Y, for $37. You buy 100 shares of WER for $60 and after 15 months sell it on December 31, 201Y, for $67. You buy 100 shares of DFG for $60 and after nine months sell it on December 31, 201Y, for $76.

c.) On January 2, 201X, you buy 100 shares of ZYX for $40 and sell it for $31 after 22 months. On January 2, 201X, you buy 100 shares of WER for $40 and sell it for $27 after 15 months. On January 2, 201X, you buy 100 shares of DFG for $40 and sell it for $16 after 18 months.

d.) On January 2, 201X, you buy 100 shares of ZYX for $60. On October 2, 201X, you sell 100 shares of ZYX for $40. On October 10, 201X, you purchase 100 shares of ZYX for $25.

3.1. A researcher is interested in determining whether a new and cheaper method of analysis to determine the fat content of small organisms works as well as the older method used for many years. She has decided to split 15 samples and determine fat content in the two halves using the two methods. She has decided that simple linear regression will be the best method of analysis because she can test the hypothesis that the two methods give a 1:1 relationship (slope = 1) over the working range of the methods. The data collected are (mg fat/g tissue):

A). Create a well labelled xy scatter plot (where x = old method) on the spreadsheet page with the data; make note of the general pattern of the plotted data and whether there are any suspect data points.

B). Use the advanced regression analysis tool to conduct a complete simple linear regression analysis for the data. You will not require the options for "residuals" for this analysis. Remember to complete the seven steps of hypothesis testing in the spaces provided on the worksheet.

C). Use the linear regression equation determined in part "B" to calculate a set of "predicted y values" for each observed x value.

D). What are the predicted y values (ie predicted “fat content using the new method”) for the following x values? a). 11.3 mg/g b). 17.2 mg/g c). 21.5 mg/g d). 148.4 mg/g

E). Whether the regression from question part “B” is significant or not, use the t-test for slope to test the hypothesis that the slope = 1.0. Remember to complete the five steps of hypothesis testing in the spaces provided on the worksheet. What does this analysis tell you about the two methods?

**please show how you got the answers so that I can learn and understand, as well as each of the steps for the seven steps of hypothesis testing so that I can see each step clearly **

The goal of this lab is to standardize data, to compute probabilities using the standard normal distribution, and to find values given probabilities. Use the Lab Data Set provided to answer all questions. (all of the data is at the bottom of the post.

1. Use Microsoft Excel to compute the mean and standard deviation of Net Sales for the Patagonia file.

Mean:

Standard deviation:

2. Sort the list of 100 data values from smallest to largest, using Microsoft Excel. Write down the raw scores (x values) on lines #1, #20, and #100. Compute the corresponding z-scores by using the formula for calculating z scores. Round to two decimal places. Finally, look up the z score on the appropriate table and place the value of the cumulative area to the left of your z score on the table below.

3. Using the mean and standard deviation from #1 above, and using the formula x = m + zs , find the data value x that goes with the following z-scores.         Use   x = m and    s = s .

For the rest of the lab, you will make the assumption that your data is approximately normally distributed. Use Excel to answer the following questions for the Net Sales data. Copy and paste the output below, don’t include as a separate file, make sure your x axis is labelled properly. You will have to “insert” your graphs in the appropriate places below. Please don’t upload more than one file for me to open and grade, your entire lab should be in ONE uploaded file. If you can’t do that, then print out the separate files and then scan it in as one file, but you should be able to figure out how to copy and paste all your answers into one document.

4. Locate your lowest x value (L) and your highest x value (H) on the axis.

Shade the area between x=L and x=H.

Find the value of the shaded area under the curve. In other words, what is P(L< x<H)?

5. Locate your middle x value (M) and your highest x value (H) on the axis.

Shade the area between x=M and x=H.

Find the value of the shaded area under the curve. In other words, what is P(M< x<H)?

6. Locate your highest x value (H) and your highest x value on the axis.

Shade the area to the right of x=H.

Find the value of the shaded area under the curve. In other words, what is P(x>H)?

7. Shade the area where the lowest 10% of the values would be.

What is the Z-score for this area?     _________________

What is the x-value for this area?    __________________

8. Shade the area where the top 5% of your values would be.

What is the z-score for this area?    _________________

What is the x-value for this area?     _________________

Cain Components manufactures and distributes various plumbing products used in homes and other buildings. Over time, the production staff has noticed that products they considered easy to make were difficult to sell at margins considered reasonable, while products that seemed to take a lot of staff time were selling well despite recent price increases. A summer intern has suggested that the cost system might be providing misleading information.

The controller decided that a good summer project for the intern would be to develop, in one self-contained area of the plant, an alternative cost system with which to compare the current system. The intern identified the following cost pools and, after discussion with some plant personnel, appropriate cost drivers for each pool. There were:

In this particular area, Cain produces two of its many products: Standard and Deluxe. The following are data for production for the latest full year of operations.

Required:

a. The current cost accounting system charges overhead to products based on machine-hours. What unit product costs will be reported for the two products if the current cost system continues to be used?

b. The intern suggests an ABC system using the cost drivers identified above. What unit product costs will be reported for the two products if the ABC system is used?

The current cost accounting system charges overhead to products based on machine-hours. What unit product costs will be reported for the two products if the current cost system continues to be used? (Do not round intermediate calculations and round "Unit cost" answers to 2 decimal places.)

How do you calculate the overturning moment for each story of the building in Excel. Suppose we have a 5 story building that is 50 feet tall and each floor is 10 foot high. The force on the 5th floor is 10 kips, on the 4th floor it's 8 kips, on the 3rd floor it's 6 kips, on the 2nd floor it's 4 kips and on the first floor it's 2 kips. Is there a routine you can use in Excel that will calculate this without much effort. The fourth floor will have an overturning moment of 10*10=100; the third floor will have an overturning moment of 10*20+8*10=280; the second floor overturning moment is 10*30+8*20+6*10=520; the first floor's overturning moment is 10*40+8*30+6*20+4*10=800; the base overturning moment is 10*50+8*40+6*30+4*20+2*10=1100

How do you calculate the overturning moment for each story of the building in Excel. Suppose we have a 5 story building that is 50 feet tall and each floor is 10 foot high. The force on the 5th floor is 10 kips, on the 4th floor it's 8 kips, on the 3rd floor it's 6 kips, on the 2nd floor it's 4 kips and on the first floor it's 2 kips. Is there a routine you can use in Excel that will calculate this without much effort and what would it be. The fourth floor will have an overturning moment of 10*10=100; the third floor will have an overturning moment of 10*20+8*10=280; the second floor overturning moment is 10*30+8*20+6*10=520; the first floor's overturning moment is 10*40+8*30+6*20+4*10=800; the base overturning moment is 10*50+8*40+6*30+4*20+2*10=1100