Problem 24-1: Compute gross pay.

Using the information given for Archway Company, compute the employees' gross pay for the payroll week ending July 14 and the year-to-date gross pay as of July 14. Employees receive time-and-a-half for overtime hours (fill in the shaded areas).

VBA question, write a function check keyword in a string.

Question:

Function sentimentCalc(tweet As String) As Integer

This function should check each word in the tweet and if the word exists as one of the keywords in the positive list or negative list it should impact the overall sentiment value. The positive list and negative list words exist in the keywords sheet. Access the keywords as ranges within your VBA code. The case of the word is inconsequential. For instance, happy, HAPPY, or hApPy are all treated as positive words regardless of their case (Hint: StrComp).

We have a keyword excel show that which word is positive and which is negative. How to get the keyword please see the hit part below.

If the word is in the positive list, it should increase the sentiment value by 10, if it is in the negative list it should decrease it by 10.

For instance, if the positive list includes “happy”, “rally”, “growth” and the negative list includes “crash”, “scam”, “bad” then:

If the Tweet is “I am Happy that Bitcoin is showing growth.”. The sentiment value will be 10 + 10 = 20

If the Tweet is “I am happy that Bitcoin is a scam and will CRASH!” The sentiment value will be 10 – 10 – 10 = -10

You must remove the following punctuation characters from the tweet text in your VBA code before calculating the sentiment: ! . , ? : ) ( ;

You may do this using multiple lines each calling the Replace function or with an array, loop and one call to the Replace function. Both methods will be marked as correct.

HIT:

You will need to use the string functions StrCom p, Split and Replace In this function.To get the ranges from the keywords Sheet use Worksheet and Range object like so:

Dim positive As Range

Set positive = Worksheets("keywords").Range("A2:A76")

Dim negative As Range

Set negative = Worksheets("keywords").Range("B2:B76")

This will give you the range A2:A76.From the sheet namedkeywords As the variable named positive.You can do the same for the negative range (but with different cell references And variable names).

You will need to use nested loops. One to go through each word in the keywords and one to Go through each word in the tweet text.

Explain the following repair mechanisms:

-removal of thymine dimers

-base excision repair

-nucleotide excision repair.

1) An object's original position is 30 meters at an angle of 150 degrees and final position is 30 meters at 70 degrees. The object traveling at constant speed in a circular arc clockwise and makes the journey in 12 seconds.

a) Find the Displacement vector

b) find the total Distance traveled.

c)find the avg Velocity vector, avg Speed, and instantaneous Speed.

d) find the avg Acceleration vector and instantaneous Acceleration vector. Show that the avg Acceleration vector points towards the center when placed at the midpoint of the arc!

(a) Company EEF ltd is considering an investment of €100,000. The desired payback period is 3 years. The board of directors have identified two alternatives; project A and project B.

The expected annual cash flows are as follows:

Cash flow: Project A       Project B

(-)       (-)

Y0 100,000.00 100,000.00

Y1                          35,000.00          35,000.00

Y2                          28,000.00          35,000.00

Y3                      32,000.00          35,000.00

Y4                      40,000.00             35,000.00

Required: Calculate the Payback period of each project and advise EEF’s board of directors which project they should invest in.

A company has two different bonds currently outstanding. Both bonds have a face value of R100. Bond A matures in 10 years. The bond makes no coupon payments for the first four years and then pays R8.50 semi-annually for the subsequent four years, and finally pays R10.50 semi-annually for the last two years. Bond B also matures in 10 years; it makes coupon payments of R4.50 semi-annually over its life. The yield to maturity on both bonds is 12% per annum, compounded semi-annually.

What is the current price of each bond?

Describe some of Lewin's accomplishments regarding the promotion of social change during his lifetime. Explain Lewin's impact on social psychology as a science and on the society.

The initial rates listed in the following table were measured in methanol solution for
the reaction: A + 2 B + C ↔ 2 D + 2 E

Write the rate law for the reaction.

What is the numerical value of k? (don’t forget to include the units)

A company would like to determine the relationship between: the time (in years) spent at the company and the employee’s hourly pay. The data for 5 employees are listed in the table below. Calculate and interpret the correlation coefficient r. Include a plot of the data in your discussion.

a. Calculate the Pearson correlation coefficient for the data.

b. Use an appropriate 2-tailed hypothesis test (ɑ = .05) to determine whether this relationship is statistically significant.

c. Based on your calculations, what can we conclude about the relationship between the time spent at the company and hourly pay?

The 1.3 kg physics book in figure is connected by a string to a 250 g coffee cup. The book is given a push up the slope and released with a speed of 3.5 m/s . The coefficients of friction are μs =0.50 and μk =0.20.

Part A) How far does the book slide?

An 84.0 kg spacewalking astronaut pushes off a 640 kg satellite, exerting a 95.0 N force for the 0.600 s it takes him to straighten his arms.

Part B) How far apart are the astronaut and the satellite after 1.00 min ?

Can you use phenolphthalein to titrate a colored solution? Explain please! I can't figure this out.

What value resistor will discharge a 3.00 μF capacitor to 10.0% of its initial charge in 2.20 ms ?

The specific rate constant for the first-order decomposition of N2O5(g) to NO2(g) and O2(g) is 7.48×10−3s−1 at a given temperature.

Part A:

Find the length of time required for the total pressure in a system containing N2O5 at an initial pressure of 0.110 atm to rise to 0.150 atm . Express your answer using two significant figures.

Part B:

Find the length of time required for the total pressure in a system containing N2O5 at an initial pressure of 0.110 atm to rise to 0.220 atm .Express your answer using two significant figures.

Part C:

Find the total pressure after 120 s of reaction.

(1) Briefly explain the similarities and differences between nitric oxide oxidation and sulfur dioxide oxidation in the troposphere. (10 points possible)

Jordan Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Jordan’s policy is to maintain an ending inventory balance equal to 15 percent of the following month’s cost of goods sold. April’s budgeted cost of goods sold is $76,000. Complete the inventory purchases budget by filling in the missing amounts.

Complete the inventory purchases budget by filling in the missing amounts.

b. Cost of goods sold

c. Ending inventory