sample1/sample 2

Use the XLMiner Analysis ToolPak to find descriptive statistics for Sample 1 and Sample 2. Select "Descriptive Statistics" in the ToolPak, place your cursor in the "Input Range" box, and then select the cell range A1 to B16 in the sheet. Next, place your cursor in the Output Range box and then click cell D1 (or just type D1). Finally make sure "Grouped By Columns" is selected and all other check-boxes are selected. Click OK. Your descriptive statistics should now fill the shaded region of D1:G18. Use your output to fill in the blanks below.

a.Sample 1 Mean:  (2 decimals)

Sample 1 Standard Deviation:  (2 decimals)

Sample 2 Mean:  (2 decimals)

Sample 2 Standard Deviation:  (2 decimals)

b. Use a combination of native Excel functions, constructed formulas, and the XLMiner ToolPak to find covariance and correlation.

In cell J3, find the covariance between Sample 1 and Sample 2 using the COVARIANCE.S function.

(2 decimals)

In cell J5, find the correlation between Sample 1 and Sample 2 using the CORREL function.
(2 decimals)

In cell J7, find the correlation between Sample 1 and Sample 2 algebraically, cov/(sx*sy), by constructing a formula using other cells that are necessary for the calculation.

(2 decimals)

Use the XLMiner Analysis ToolPak to find the correlation between Sample 1 and Sample 2. Place your output in cell I10.

(2 decimals)

c. Calculate z-scores using a mix of relative and absolute cell references. In cell A22, insert the formula =ROUND((A2-$E$3)/$E$7,2). Next grab the lower-right corner of A22 and drag down to fill in the remaining green cells of A23 to A36. Note how the formula changes by looking in Column D. Changing a cell from a relative reference such as E3 to an absolute reference such as $E$3 means that cell remains "fixed" as you drag. Therefore the formula you entered into A22 takes each data observation such as A2, A3, A4..., subtracts $E$3 and then divides by $E$7. Since the last two cells have absolute references they will not change as you drag. The ROUND function simply rounds the z-score to two digits.

Now find the z-scores for Sample 2 using the same method you learned above by editing the formula to refer to the correct cells for Sample 2. Make sure each z-score is rounded to 2 places.

Eli Orchid has designed a new pharmaceutical product, Orchid Relief, which improves the night sleep. Before initiating mass production of the product, Eli Orchid has been market-testing Orchid Relief in Orange County over the past 8 weeks. The daily demand values are recorded in the Excel file provided. Eli Orchid plans on using the sales data to predict sales for the upcoming week. An accurate forecast would be helpful in making arrangements for the company’s production processes and designing promotions.

Before a forecasting model is built and a forecast for the next week is generated, the COO of the company has asked the data analyst for an exploratory analysis of the demand.

Specifically, the COO has asked the analyst[1]:

[1] Round numbers to four decimal points (e.g. 0.1234), unless explicitly requested otherwise.

Suppose individual X scores in the population follow a normal distribution N(38, 20). A researcher draws numerous samples of sample size n = 100 from the population, and in each sample, she calculates the sample mean. Then 68% of these sample means should approximately fall within Group of answer choices (A) 34 and 40 (B) 34 and 38 (C) 38 and 44 (D) 36 and 40

Lori, who is single, purchased 5-year class property for $200,000 and 7-year class property for $410,000 on May 20, 2017. Lori expects the taxable income derived from her business (without regard to the amount expensed under § 179) to be about $800,000. Lori wants to elect immediate § 179 expensing, but she doesn't know which asset she should expense under § 179. She does not claim any available additional first-year depreciation. Click here to access Exhibit 8.1 and the depreciation table to use for this problem. If an amount is zero, enter "0". a. Determine Lori's total cost recovery deduction if the § 179 expense is first taken with respect to the 5-year class asset. 5-year class property Immediate expense deduction under § 179 $ Regular MACRS 7-year class property Immediate expense deduction under § 179 $ Regular MACRS Total deduction $ Feedback b. Determine Lori's total cost recovery deduction if the § 179 expense is first taken with respect to the 7-year class asset. 7-year class property Immediate expense deduction under § 179 $ Regular MACRS 5-year class property Immediate expense deduction under § 179 $ Regular MACRS Total deduction $ Feedback Correct c. If § 179 expense is first allocated to the seven-year class property, the deduction for the year would be $ larger. Feedback Correct For parts d. and e. Assume a 6% discount rate The present value factors for a 6% discount rate are as follows: Year 1: 1.000, Year 2: 0.9434; Year 3: 0.8900, Year 4: 0.8396, year 5: 0.7921, Year 6: 0.7473, Year 7: 0.7050, Year 8: 0.6651. Hint: Set up two analysis - on to find present value of tax saving with Section 179, and one without Section 179. Then compare them. If required, round computations to the nearest dollar.

d. Assume that Lori is in the 25% marginal tax bracket and that she uses § 179 on the 7-year asset. The present value of the tax savings from the depreciation deductions for both assets $. Feedback Incorrect

e. Assume that Lori is in the 25% marginal tax bracket and that Lori decides not to use § 179 on either asset. The present value of the tax savings generated by using the § 179 deduction on the 7-year asset $.

pls help to solve part E

A steel product is manufactured by starting with raw material (carbon steel wire) and then processing it sequentially through five operations using machines A to E, respectively (see table below). This is the only use that the five machines are put to. The hourly rates for each machine are given in the table. Answer the following questions. Use the original output rates to answer each question (i.e., disregard any changes mentioned in previous questions).

a. What is the maximum output per hour of the steel product?

b. By how much would the output be improved if B was increased to 50?

c. By how much would the output be improved if C was increased to 40?

d. By how much would the output be improved if C was increased to 50?

e. What is the effect on the system if machine A can only manage an output of 20 in one hour?

f. What is the effect on the system if machine C can only manage an output of 20 in one hour?

g. What is the effect on the system if machine B is allowed to drop to an output of 30 in one hour?

Write a function hitRate(A, B) to return the percentage of elements in array A that match the elements with the same index in array B. A and B are 1darrays or 2darrays of the same shape. Sample: if X = np.array([1, 3, 5, 8]); Y = np.array([2, 1, 3, 8]), then hitRate(X, Y) returns 0.25. in python program

Gateway Tours is choosing between two bus models. One is more expensive to purchase and maintain, but lasts much longer than the other. Its discount rate is 12%. It plans to continue with one of the two models for the foreseeable future. Based on the costs of each model shown below, which should it choose?

Old ReliableShort or Sweet    

In C++

Define a base class called Person. The class should have two data members
to hold the first name and last name of a person, both of type string. The
Person class will have a default constructor to initialize both data members
to empty strings, a constructor to accept two string parameters and use them
to initialize the first and last name, and a copy constructor. Also include
appropriate accessor and mutator member functions. Overload the operators ==
and != such that two objects of class Person are considered equal if and only
if both first and last names are equal. Also overload operators >>, <<, and =.
Define a class called Doctor derived from the Person class. The class
should have a data member to hold the doctor's hourly rate (of type double), a
default constructor to initialize the rate to 0, and a constructor that takes
a double and a reference to an object of type Person and initializes the data
members to their appropriate values. Also include an accessor and mutator
member functions for the doctor's hourly rate. In Doctor class, redefine the
operator = such that it not only copies the first and last name, but also
copies the hourly rate.
Define another class called Patient derived from the Person class. This
class should have a data member to hold the patient's primary physician (of
class Doctor). Include a default constructor that would call the default
constructors of class Doctor and Person to initialize the object; also include
a constructor that accepts a reference to an object of class Doctor and Person
and initializes the Patient object's data members to their respective values.
Add accessor and mutator member functions to access or set the primary
physician.
Finally, define a class called Billing that would hold information about
medical bills. This class should have the following data members: an object of
type Doctor to hold the doctor to whom the money is paid, an object of type
Patient to hold the patient who pays the money, and a variable of type double
to hold the amount due. The Billing class will have a default constructor that
initializes amount due to 0.0 and calls the default constructors for Patient
and Doctor objects and a constructor that accepts references to Doctor and
Patient objects and the amount of hours (type int). The latter constructor
will calculate the amount due in the following fashion:

* if the doctor involved in the bill is the patient's primary physician,
then the amount due is hours multiplied by the doctor's hourly rate;

* if the doctor involved is not the patient's primary physician, then
the amount due is hours times doctor's hourly rate times 1.25.

Write a main function that would prompt the user to enter the patient's
name, their primary physician's name and rate, another doctor's name and rate,
and the amount of hours spent in the doctor's office. Then the program will
calculate and output the amount patient owes for doctor's services.

Note: two doctors are considered the same if and only if their names match
(i.e. you can assume no doctors with the same name and different rates exist).

Market participants use CAPM to form their expectations and require a rate of return of 13% for stock XYZ. Given the required rate of return, today the market price of XYZ is $40. Assume the company is expected to pay a dividend of $3 per share next year (which is year 1; todays is year 0) and then a constant dividend in perpetuity after that (year 2, 3, etc…).

1. What is the divided constant dividend the market is expecting?

2. After one year, the risk free rate is 7%, and the market risk premium is 8%. What will the market price of the security be if its beta doubles (and the rest is unchanged)?