please help me with az10 page apa formatted research paper. The topic is Developing algorithms for outlier detection and data cleaning. the paper should include an abstract introduction conclusion references and in text citations I need help with writing this.  

See the attached PDF for step by step instructions and see attached notepad for data needed for project.

Review NIST Special Publication 800-14 and write a summary of it including extra knowledge you gained
in not less than 500 words. Link for the article is given below.

https://nam02.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftsapps.nist.gov%2Fpublication%2Fget_pdf.cfm%3Fpub_id%3D890092&data=05%7C01%7Crneupane2%40go.stcloudstate.edu%7Cbc807492e5d445f48e8208daa821994e%7C5011c7c60ab446ab9ef4fae74a921a7f%7C0%7C0%7C638007159503601398%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=sT8JrSHKW4TkrpAhqO4sAzJxUmfafmcZdnwLJVf%2FQxs%3D&reserved=0

In this lab, you will use lists and list operations to process election results and to declare a winner or announce a runoff. The vote information (number of votes each candidate receives in each district) must be read from a comma-delimited file named votes.csv. An example of the data and its format is given below: 31,509,156,21 75,190,417,143 402,80,265,0 298,212,130,176 234,678,97,127 102,78,62,116 The data above, shown in the bold outline below, should be placed into a two-dimensional list named votes. The list is interpreted as follows (shaded headers are not part of the data that will be read from the file, and are shown, along with the shaded italicized totals, for information only):

The program will then process the vote count, and once the data is tabulated, it should announce the election results. There are two possible outcomes:

Runoff – In the event that none of the candidates gets 51% of the vote (the example above, in file votes1.csv is such a case), a runoff between the top two vote-getting candidates is declared through the following output (note the decreasing order of vote-getters in both categories): No candidate attained 51% of the 4,599 votes cast, and a runoff will be held between: Candidate5 received 1,136 votes (24.70%) Candidate2 received 825 votes (17.94%) Other candidate vote totals: Candidate4 received 816 votes (17.54%) Candidate3 received 747 votes (16.24%) Candidate1 received 717 votes (15.59%) Candidate6 received 358 votes (7.78%)

Clear winner – If the top vote-getter wins more than 51% of the total vote, that candidate is declared the winner. Totals for other candidates are presented in decreasing order of votes received, as shown in the following output (example based on file votes2.csv): Candidate5 won the election with 2,936 votes out of 4,599 cast (63.84%) Candidate2 received 439 votes (9.55%) Candidate4 received 416 votes (9.05%) Candidate6 received 346 votes (7.52%) Candidate3 received 247 votes (5.37%) Candidate1 received 215 votes (4.67%)

Requirements: You must observe the following requirements in designing and developing your program:

You must read the file and load the votes list in the main() function.·

You must have a function get_vote_totals() that accepts the two-dimensional votes list, and returns a two-dimensional list that you will store in the variable vote_totals. This list has the candidate number at column index 0, and that candidate’s vote total at column index 1. Using the votes1.csv example data above (shaded headers are for information only and are not part of the list), the list would be:·

You will then pass the vote_totals list to the function sort_it(), provided for you below. This function will return the list sorted, in descending order, by the value at index position 1 (the total number of votes). Store the returned value in list variable sorted_votes. Using the data above, this sorted list returned is:·Write the remainder of the program so that it provides the election results output shown above.·

You may not use any global variables (global constants are permitted)·

Your program will be tested with multiple input files. It must handle both the Clear Winner and Runoff cases.·

data from votes1.csv:

data from votes2.csv:

1. What or who do you think is the greatest threat to the security of information today? What computer security incidents have been in the news recently?
2. What policies govern your behavior currently, in school, work, or in other organizations? Are those policies enforced/followed? Why or why not?

Working on Finishing it up. Information provided in attachments 

Exp19_Excel_Ch03_CapAssessment_Movies

Project Description:

You are an assistant manager at Premiere Movie Source, an online company that enables customers to download movies for a fee. You need to track movie download sales by genre. You gathered the data for April 2021 and organized it in an Excel workbook. You are ready to create charts to help represent the data so that you can make a presentation to your manager later this week.

Assignment #3 – Advanced Ruby

Objective

For this assignment, you will be creating a query API for a CSV file of students. The API will

query a ‘YAML-base’ which you generate from the CSV file. Your API will be tested with an API

client that is provided to you.

Models

1. You are given a CSV file named s t u d e n t s . c s v

. This file contains 15000 fake student

records (along with headers) containing the following fields: G i v e n N a m e

, S u r n a m e

,

S t r e e t A d d r e s s

, C i t y

, S t a t e

, Z i p C o d e

, E m a i l A d d r e s s

, G e n d e r

, P o u n d s

2. Create a c l a s s

 called C o u r s e

 in c o u r s e . r b

 which contains c o u r s e _ n a m e

 and c o u r s e _ i d

fields which are set via the class constructor. Provide appropriate read/write accessors

to those fields.

3. Create a c l a s s

 called S t u d e n t

 in s t u d e n t . r b

 which contains the following fields (with

appropriate read/write accessors): s t u d e n t _ i d

, f i r s t _ n a m e

, l a s t _ n a m e

, c i t y

, s t a t e

,

e m a i l

, g e n d e r

, p o u n d s

, g p a

 and t a k i n g _ c o u r s e s

.

4. The S t u d e n t

 class should have an empty constructor, but should provide an ability to be

initialized via a block initializer as discussed in the lecture materials.

5. Both C o u r s e

 and S t u d e n t

 classes should override the t o _ s

 method.

Database Generator

1. Create d b _ g e n e r a t o r . r b

 file which will:

Read in the CSV file using Ruby’s CSV library (see PickAxe for an example of

reading in a * . c s v

 file with headers).

Create an array of students, where each student will have its fields populated

based on the values of the * . c s v

 file with the exception of s t u d e n t _ i d

, g p a

, and

t a k i n g _ c o u r s e s

 fields. Keep in mind that pounds is a floating point number

and should be stored appropriately.

s t u d e n t _ i d

 should just be a value which starts with 1

 and gets incremented every

time a new instance of student is created (presumably finishing ~15000)

g p a

 should be a randomly generated floating point number with the lowest value

being 2 . 0

 and the highest 4 . 0

 (Hint: take a look at Ruby’s built-in r a n d

 function)

t a k i n g _ c o u r s e s

 should be an array of 0 to 4 C o u r s e

 objects. The idea here is that

each student is taking a different number of courses. Some students might not

taking any courses while others can be taking all four.

Create 4 courses with some id and name and randomly ‘assign’ 0 to 4 courses to

1 of 3

each created student. (Hint: Ruby has a wonderful s a m p l e

 method, which can

choose n

 random elements from an array.)

2. Serialize the students array to u n i v e r s i t y _ d b . y m l

 using Ruby’s YAML library (see

Pickaxe book for an example).

API

1. Create D b A p i

 class in d b _ a p i . r b

 which will serve as an API/DSL for selecting records

from the ‘YAML-base’ based on certain conditions. DO NOT re-load the YAML file

every time, rather store students loaded from the YAML file in a class variable called

s t u d e n t s

 that is retrievable from a class method called s t u d e n t s

.

2. D b A p i

 needs to have the following methods implemented:

r e q u i r e _ r e l a t i v e ‘ s t u d e n t ‘

r e q u i r e _ r e l a t i v e ‘ c o u r s e ‘

r e q u i r e ‘ y a m l ‘



c l a s s D b A p i

c l a s s

d e f s e l f . s t u d e n t s . . . e n d

d e f s e l f . s e l e c t _ b y _ g e n d e r ( g e n d e r ) . . . e n d

d e f s e l f . s e l e c t _ b y _ f i r s t _ n a m e ( f i r s t _ n a m e ) . . . e n d

d e f s e l f . s e l e c t _ b y _ l a s t _ n a m e ( l a s t _ n a m e ) . . . e n d

d e f s e l f . s e l e c t _ b y _ w e i g h t _ m o r e _ t h a n ( p o u n d s ) . . . e n d

e n d

3. The f i r s t _ n a m e

 and l a s t _ n a m e

 methods should accept a Regexp matcher as an

argument.

4. d b _ c l i e n t . r b

 (provided) will use your API. A sample output from running d b _ c l i e n t . r b

is as follows:

2 of 3

The d b _ c l i e n t . r b

 prints an intersection of the number of males, the number of people whose

first name contains ‘Andr’, and the number of people who weigh more than 200 pounds.

Submission Guidelines

1. Commit all the files to you local repo and push your repo out to your private team repo

on gihub creating a remote branch called a s s i g n m e n t 3

2. You can do one of the following to accomplish the above:

Create a local branch called a s s i g n m e n t 3

 ($ g i t c h e c k o u t – b a s s i g n m e n t 3

) and

then push it out by doing $ g i t p u s h r e m o t e _ a l i a s a s s i g n m e n t 3

Work on a m a s t e r

 branch in your repo and then to $ g i t p u s h r e m o t e _ a l i a s

m a s t e r : a s s i g n m e n t 3

3. Feel free to include a README with any comments

3 of 3

Ch 1 and 3 help

  Project Description:

You work for the vice president’s office at a major university. Human Resources provided a list of deans and associate deans, the colleges or schools they represent, and other details. You will use text functions to manipulate text, apply an advanced filter to display selected records, insert database summary statistics, use lookup functions, and display formulas as text.

2

First, you want to combine the   year and number to create a unique ID.
 

  In cell C8, enter 2006-435 and use Flash Fill to complete the IDs for all the deans and   associate deans.

3

Next, you want to create a   three-character abbreviation for the college names.
 

  In cell E8, use the text function to display the first three characters of   the college name stored in the previous column. Copy the function to the   range E9:E28.

4

The college names are hard to   read in all capital letters.
 

  In cell F8, insert the correct text function to display the college name in   upper- and lowercase letters. Copy the function to the range F9:F28.

5

You want to display the names in   this format Last, First.
 

  In cell J8, insert either the CONCAT or TEXTJOIN function to combine the last   name, comma and space, and the first name. Copy the function to the range   J9:J28.

6

Columns K and L combine the   office building number and room with the office phone extension. You want to   separate the office extension.
 

  Select the range K8:K28 and convert the text to columns, separating the data   at commas.

7

You decide to create a criteria   area to perform an advanced filter soon.
 

  Copy the range A7:M7 and paste it starting in cell A30. Enter the criterion Associate Dean in the appropriate cell on row   31.

8

Now you are ready to perform the   advanced filter.
 

  Perform an advanced filter using the range A7:M28 as the data source, the   criteria range you just created, and copying the records to the output area   A34:M34.

9

The top-right section of the   worksheet contains a summary area. You will insert database functions to   provide summary details about the Associate Deans.
 

  In cell L2, insert the database function to calculate the average salary for   Associate Deans.

10

In cell L3, insert the database   function to display the lowest salary for Associate Deans.

11

In cell L4, insert the database   function to display the highest salary for Associate Deans.

12

Finally, you want to calculate   the total salaries for Associate Deans.
 

  In cell L5, insert the database function to calculate the total salary for   Associate Deans. 

13

Format the range L2:L5 with   Accounting Number Format with zero decimal places.

14

The range G1:H5 is designed to   be able to enter an ID to look up that person’s last name and salary.
 

  In cell H3, insert the MATCH function to look up the ID stored in cell H2,   compare it to the IDs in the range C8:C28, and return the position number.

15

Now that you have identified the   location of the ID, you can identify the person’s last name and salary.
 

  In cell H4, insert the INDEX function. Use the position number stored in cell   H3, the range C8:M28 for the array, and the correct column number within the   range. Use mixed references to keep the row numbers from changing. Copy the   function to cell H5 but preserve formatting. In cell H5, edit the column   number to display the salary.

16

In cell D2, insert the function   to display the formula stored in cell F8.
  In cell D3, insert the function to display the formula stored in cell H3.
  In cell D4, insert the function to display the formula stored in cell H4.
  In cell D5, insert the function to display the formula stored in cell L3.

17

Create a footer with your name   on the left side, the sheet name code in the center, and the file name code   on the right side.