Attached document on how to do homework please follow instructions

Complete the Lab 9-5, “Programming Challenge 1 — Going Green,” of Starting Out with Programming Logic and Design.

Note: You are only required to create the flowchart for this activity; however, notice how the pseudocode compares to the given Python code for this assignment.

Submit your assignment using the Assignment Files tab.

ITS836 Assignment 1: Data Analysis in R

1) Read the income dataset, “zipIncomeAssignment.csv”, into R. (You can find the csv file in iLearn under the Content -> Week 2 folder.)

2) Change the column names of your data frame so that zcta becomes zipCode and meanhouseholdincome becomes income.

3) Analyze the summary of your data. What are the mean and median average incomes?

4) Plot a scatter plot of the data. Although this graph is not too informative, do you see any outlier values? If so, what are they?

5) In order to omit outliers, create a subset of the data so that:

 $7,000 < income < $200,000  (or in R syntax , income > 7000 & income < 200000)

6) What’s your new mean?

7) Create a simple box plot of your data. Be sure to add a title and label the axes.

HINT: Take a look at: https://www.tutorialspoint.com/r/r_boxplots.htm (specifically, Creating the Boxplot.) Instead of “mpg ~ cyl”, you want to use “income ~ zipCode”.

In the box plot you created, notice that all of the income data is pushed towards the bottom of the graph because most average incomes tend to be low. Create a new box plot where the y-axis uses a log scale. Be sure to add a title and label the axes. For the next 2 questions, use the ggplot library in R, which enables you to create graphs with several different types of plots layered over each other.

8) Make a ggplot that consists of just a scatter plot using the function geom_point() with position = “jitter”  so that the data points are grouped by zip code. Be sure to use ggplot’s function for taking the log10 of the y-axis data. (Hint: for geom_point, have alpha=0.2).

9) Create a new ggplot by adding a box plot layer to your previous graph. To do this, add the ggplot function geom_boxplot(). Also, add color to the scatter plot so that data points between different zip codes are different colors. Be sure to label the axes and add a title to the graph. (Hint: for geom_boxplot, have alpha=0.1 and outlier.size=0).

10) What can you conclude from this data analysis/visualization?

Prepared Exam
Exploring Microsoft Excel 2016, Application

Mark’s Construction and Realty

Mark’s Construction and Realty buys and flips houses. They have hired you to look at their sales numbers from last year to analyze the data. They have instructed you to see if there are any trends in the types of houses they typically purchase, if there is a correlation between the number of houses sold and sale date, and which sales should be included in the project managers’ year-end bonus. 

Perform Preliminary Work

You need to open the existing workbook they provided, save it with a new name, and make a few preliminary modifications.

a. Open the e00_cumexam_data workbook and save the workbook as e00_cumexam_LastFirst.

b. Change the width of column E to 15.00.

c. Insert a new row above row 1.

d. Enter the text 2017 Sales Data in cell A1, change the font size to 14 and apply bold.

e. Add a fill color of Blue, Accent 1 for cell A1.

f. Merge and center the range A1:I1.

g. Freeze the headers so when you scroll down the headers are always visible.

Calculate Profit and Determine if Project is Eligible for Bonus

You are ready to calculate the total costs. 

h. Insert two columns after Sale Price named Total Cost and Profit respectively.

i. Insert a function in cell H3 to calculated the total cost of each project. 

j. Insert a function in cell I3 to calculated the profit of each project. 

k. Create an IF statement in cell K3 where if the profit is greater than $50,000 it will display the text Yes, otherwise it will display the text No.

l. Copy the three formulas down their respective columns.

Organize Monthly Data

The company has already collected data about how many of each type of house they sold each month. You will convert the data into a table, apply a table style to make the data more visually appealing, and add total rows for use in the analysis grids later.

m. Click the Sheet2 worksheet and rename it Analysis.

n. Convert the entire dataset into a new table named Date with a table style of Table Style Medium 6.

o. Calculate a total for each house type in column N.

House Type Analysis

You will analyze each house type to determine if the company has a tendency to purchase a certain type of a house.

p. Create a 2D-Pie chart that displays the total number of houses by house type and apply chart type Style 7.

q. Move the chart to the left side of the screen directly under the table data.

r. Change the chart title to House Type.

s. Move the legend to the top-left corner.

t. Explode the largest piece of the pie to a Point Explosion of 20%

u. Add Data Callout data labels to the chart.

Sales Analysis

You will analyze the sales numbers across each month to determine in which months buyers tend to purchase houses.

v. Calculate a new total row for each month.

w. Create a 2D-Line chart that displays total house sales by Month and apply chart style Style 6 and move it to the right of the pie chart.

x. Change the chart title to Total Sales

y. Change the plotted line color to White, Background 1.

z. Add a column to the Date table after House Type called Sparkline.

aa. Add a sparkline for each house type over the 12-month period in the new Sparkline column.

Finalize the Workbook

You will make some small formatting changes.

bb. Set the page orientation to Landscape.

cc. Insert a footer with your instructor’s name on the left side, the date in the center, and your Last,First name on the right side.

dd. Save and close the workbook. Based on your instructor’s directions, submit e00_cumexam_LastFirst. 

Instructions

In order to complete assignment #4 you will need to answer the below questions. Please complete the questions in a Word document and then upload the assignment for grading. When assigning a name to your document please use the following format (last name_Assignment #4). Use examples from the readings, lecture notes and outside research to support your answers. The assignment must be a minimum of 1-full page in length with a minimum of 2 – outside sources. Please be sure to follow APA guidelines for citing and referencing source. Assignments are due by 11:59 pm Eastern time on Sunday.

RESEARCHING INTRUSION DETECTION SYSTEMS Using the Internet and other print material, gather data about intrusion-detection systems (IDSs). Research 3-5 different vendor systems. Compare their list of features (active IDS, passive IDS, network-based, host-based, anomaly systems, etc.). Create a table that compares the features. Based on your research, which system would you recommend and why? 

Part one Discussion 

In this discussion, you are going to research Vigenere Cipher. Use the Vigenere Table to encrypt the message using the key ORANGE:
  Hard work always pays. 
Now use the same key, to decrypt this message:
Oktnio ok dncr
Instructions:

1. Ignore all cases and punctuations
2. Do not encrypt or decrypt spaces
3. Post your answers and explain your experience and why Vigenere is not acceptable as an algorithm in today’s computing environment

PART TWO

Instructions

1. Data compression is used mostly in data storage. Examples of compression tools are WINZIP and 7Zip. Explain which of the following is better for security purposes – Encrypt and Zip or Zip and Encrypt

Analysis

0 – 40 points

41 – 90

Demonstrates a lack of understanding and inadequate analysis of encryption and compression

Demonstrates a general understanding of encryption and compression

Writing Quality & Adherence to Format Guidelines

0-6 points

9-10 points

Paper shows a below average/poor writing style lacking in elements of appropriate standard English and following proper APA guidelines.

Paper is well written and clear using APA guidelines and standard English characterized by elements of a strong writing style.

Please complete this assignment in a Word document and then upload the assignment for grading. When assigning a name to your document please use the following format (last name_Assignment #1). Use examples from the readings, lecture notes and outside research to support your answers. Please be sure to follow APA guidelines for citing and referencing source.