Discussion

 

Topic( Minimum 300 words):

–   Discuss the primary factors that motivate companies to expand internationally.  

– Minimum two references. 

There should be no plagiarism. Attach a plagiarism report with 0 % similarity index

Exp22_Excel_Ch02_ML1 – Katherine's Coffee Shop Weekly Payroll

Exp22_Excel_Ch02_ML1 – Katherine’s Coffee Shop Weekly Payroll

  

Project Description:

You have been hired as the new manager of Katherine’s Coffee shop. As part of your responsibilities, you will be calculating the weekly payroll. The previous manager developed a partial worksheet, but you will enter the formulas to calculate the regular pay, overtime pay, gross pay, taxable pay, withholding tax, FICA, and net pay. In addition, you want to include total pay columns, calculate some basic statistics, and create an employee lookup section. As you construct formulas, make sure you use absolute, relative, and mixed cell references correctly in formulas.

     

Start Excel. Download and open   the file named Exp22_Excel_Ch02_ML1_Payroll.xlsx.   Grader has automatically added your last name to the beginning of the   filename. 

 

Use IF functions to calculate   the regular pay and overtime pay in columns E and F based on a regular   40-hour workweek. Be sure to use the appropriate absolute or mixed cell   references. Pay overtime only for overtime hours. Note employees receive 1.5   their hourly wage for overtime hours worked. Calculate the gross pay in cell   G5 based on the regular and overtime pay. Spencer’s regular pay is $440. With   five overtime hours, Spencer’s overtime pay is $82.50.

 

Create a formula in cell H5 to   calculate the taxable pay. Multiply the number of dependents by the deduction   per dependent and subtract that from the gross pay. With two dependents,   Spencer’s taxable pay is $422.50.

 

Insert a VLOOKUP function in   cell I5 to identify and calculate the federal withholding tax. With a taxable   pay of $422.50, Spencer’s tax rate is 25% and the withholding tax is $105.63.   The VLOOKUP function returns the applicable tax rate, which you must then   multiply by the taxable pay.

 

Calculate FICA in cell J5 based   on gross pay and the FICA rate, and calculate the net pay in cell K5. Copy   all formulas down their respective columns. Be sure to preserve the existing   formatting in the document. Based on the hours Spencer worked he paid $39.97   to FICA and had a weekly net pay of $376.90

 

Use Quick Analysis tools to   calculate the total regular pay, overtime pay, gross pay, taxable pay,   withholding tax, FICA, and net pay on row 17. (On a Mac, this step must be   completed using the AutoSum feature on the ribbon.)

 

Apply Accounting Number Format   to the range C5:C16. Apply Accounting Number Format to the first row of   monetary data and to the total row. Apply the Comma style to the monetary   values for the other employees. 

 

Insert appropriate functions to   calculate the average, highest, and lowest values in the Summary Statistics   area (the range I24:K26) of the worksheet. Format the # of hours calculations   as Number format with one decimal and the remaining calculations with   Accounting Number Format.

 

Use the XLOOKUP function to look   up the employee name in cell A20 (Wagner) in the payroll data and return the   specified information in row 20. Ensure the return array includes overtime   pay, gross pay, taxable pay, federal tax, FICA and net pay. 

 

Save and close the workbook.   Submit the file as directed. 

Annotation and Cluster Analysis

Q1. Read Chapter 9 in the textbook: Cluster Analysis

Textbook: Tan, Pang-Ning. Introduction to Data Mining

  1. What are the characteristics of anomaly detection? 
  2. What are the detection problems and methods?
  3. What are the statistical approaches when there is an anomaly found?
  4. Compare and contrast proximity and clustering based approaches.

Follow APA7 guidelines and answer in Q&A format.  There should be headings to each of the questions and include an introduction and conclusion.  Ensure there are at least two-peer reviewed sources to support your work. The paper should be at least 2-3 pages of content (this does not include the cover page or reference page).

Q2. Read ch. 8 in the textbook: Annotation

Textbook: Kirk, Andy.  Data Visualization: A Handbook for Data Driven Design

Select any example of a visualization or infographic. The task is to undertake a deep, detailed ‘forensic’ like assessment of the design choices made across each of the five layers of the chosen visualization’s anatomy. In each case your assessment is only concerned with one design layer at a time. For this task, take a close look at the annotation choices:

  1. Start by identifying all the annotation features deployed, listing them under the headers of either project or chart annotation.
  2. How suitable are the choices and deployment of these annotation features? If they are not, what do you think they should have been?
  3. Go through the set of ‘Influencing factors’ from the latter section of the book’s chapter to help shape your assessment and to possibly inform how you might tackle this design layer differently.
  4. Also, considering the range of potential annotation features, what would you do differently or additionally?

Be sure to show the visualization first and then thoroughly answer the above questions. 

Answer in a Q&A format in 2-3 pages. Ensure that there are at least two-peer reviewed sources utilized this week to support your work.

Arrays

Using the language C# in visual studios please complete the following Assignment:

The program for this assignment will consist of five sections, each headed by the three-line comment below:

//*********************************************************

//****Assignment 4 Section X

//*********************************************************

(where X stands for the portion of the assignment to follow.)

Assignment Requirements

Section 1:

  1. Enter the comment with the section title as described above.
  2. CarDealz used cars wants to build an app for their buyers to know what cars are on the approved list for purchase. You will create a structure with the string fields for Make and Model and one integer field ModelYear for the earliest acceptable model year for that car.
  3. Create an array of these structures. For testing purposes, we will begin with three and the values for them will be {Ford, Mustang, 2010}, {Chevrolet, Silverado, 2008}, and {Dodge, Charger, 2012}.
  4. Print to the console the statement, “Section 1: Array of Structures.”
  5. Using a loop, display the full contents of each structure in the array.

Section 2:

  1. Enter the comment with the section title as described above.
  2. The app from section 1 needs a means to check to see how many of each model CarDealz already has on the lot so that the buyers do not create a glut of any one model. In this section, you will create a dictionary named inventoryCount that will use the car model as the key and the inventory quantity as the value.
  3. Populate your dictionary with the following values:

Mustang

9

Silverado

13

Charger

4

  1. Print to the console a blank line and the statement, “Section 2: Inventory Count.”
  2. Using the methods available in the dictionary class, display the current number of each model in the inventoryCount dictionary.

Section 3:

  1. Enter the comment with the section title as described above.
  2. You are thinking of adding array lists for different work weeks to the CarDealz app because not all employees work the same days of the week. Create an arraylist called DaysofWeek and add all the days of the week to it.
  3. Print to the console the statement, “Section 3: Days of the Week.”
  4. Using a loop, display the days from the arraylist.
  5. Using a loop, display the days from the arraylist in reverse order.
  6. Create a second arraylist called WorkDays and copy the DaysofWeek arraylist to it.
  7. Delete “Saturday” and “Sunday” from the WorkDays arraylist.
  8. Print the contents of WorkDays.

Section 4:

  1. Enter the comment with the section title as described above.
  2. There is further discussion about features to be added to the CarDealz app at a later time. You think it is best that you get some practice with stacks and queues as you think you will likely need them.
  3. Print to the console the statement, “Section 4: Stack.”
  4. Create a stack.
  5. Using your stack, push the following values: 10,24, 31, 45, 19, 76
  6. Using methods of the stack class, print a message telling how many items are on the stack.
  7. Pop three items off of the stack and repeat your printed message telling how many items are in the stack.
  8. Display the next item in the stack to be popped.

Section 5:

  1. Enter the comment with the section title as described above.
  2. Print to the console the statement, “Section 5: Queue”
  3. Create a queue.
  4. Using your queue, enqueue the following values: 10,24, 31, 45, 19, 76 
  5. Using methods of the queue class, print a message telling how many items are on the queue.
  6. Dequeue three items off of the queue and repeat your printed message telling how many items are in the queue.
  7. Display the next item in the queue to be dequeued.

EXPECTED OUTPUT

Section 1: Array of Structures

Ford, Mustang, 2010

Chevrolet, Silverado, 2008

Dodge, Charger, 2012

Section 2: Inventory Count.

There are 9 Mustangs.

There are 13 Silverados.

There are 4 Chargers.

Section 3: Days of the Week

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Saturday

Friday

Thursday

Wednesday

Tuesday

Monday

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Section 4: Stack

There are 6 items in the stack.

There are 3 items in the stack.

The next item to be popped from the stack is 31.

Section 5: Queue

There are 6 items in the queue.

There are 3 items in the queue.

The next item to be dequeued from the queue is 45.

Step 1: Requirements

  

Step 1: Requirements

Write a program that will input a phrase and convert it to pig latin. Put each word in a separate element of a string array. Remove the first letter from each word and concatenate it to the end of the word followed by “ay.”

Sample Output from Program:

*****************************************************

* You will be prompted to enter a string of *

* words. The string will be converted into *

* Pig Latin and the results displayed. *

* Enter as many strings as you would like. * 

******************************************************

Enter a group of words or ENTER to quit: Computer Programming is fun to learn!

Original words: Computer Programming is fun to learn!

New Words: omputercay ogrammingpray isway unfay otay earnlay!

Enter a group of words or ENTER to quit: Quit

Pig Latin Hint: 

If a word begins with one or more consonants, move the consonant or consonant cluster to the end of the word. Add the letters “ay” to the end of the word. So, “pig” would be “igpay,” and “latin” would be “atinlay.”

Step 2:Processing Logic

Using the pseudocode below, write the code that will meet the requirements.

Main function

Display the heading

While the condition is true

Prompt the user for group of words or Enter to quit

Display original words

Call function pigLatinString( )

End while

pigLatinString( ) function

Declare and initialize string variables len, counter, start, begin, word and newString

While condition is true

Call find() and pass a space and start as parameters and return the returned value

to start

if start equals to string::npos

jump outside the loop permanently

call substr() function

display the word

update newString

increment start by one

assign start to begin

End While

Call substr()

Update newString

Return newString

Final project

 

Research Project Topic: “Relationship Between Cloud Invoice and DOS Attacks”

It must consist of:

1. Five source annotated bibliography

2. Slide presentation with 12 or more slides(ppt)

3. Summary or Abstract containing at least 750 words.(word)

add references