review2

  Next, in your role as a peer reviewer, provide constructive feedback and suggestions through the group’s discussion board to help ensure that the best possible proposal is presented to the project sponsor. Feedback and suggestions should be posted no later than 2 days before the assignment is due.  

Python Project

 Task 1 (50 points): (Intro to Data Science: Survey Response Statistics) Twenty students were asked to rate on a scale of 1 to 5 the quality of the food in the student cafeteria, with 1 being “awful” and 5 being “excellent”. Place the 20 responses in a list. 1, 2, 5, 4, 3, 5, 2, 1, 3, 3, 1, 4, 3, 3, 3, 2, 3, 3, 2, 5 Write a program that does the following: (a) Determine and display the frequency of each rating. (b) Use the built-in functions, statistics module functions and NumPy or Panda functions cov ered in the course materials to display the following response statistics: minimum, maximum, range, mean, median, variance and standard deviation. (c) Display a bar chart showing the response frequencies and their percentages of the total responses. Grading Rubric – 10 points for defining functions. – 15 points for finishing Task1(a)-(c). – 5 points for appropriate comments. – 10 points for a runnable python program with correct data visualization. – 10 points for screenshots of the program. Task 2 (50 points): (Classification with k-Nearest Neighbors and the Digits Dataset) Read the file “09-02-MachineLearning.pdf” and the python program “CaseStudy1.py” to learn the algorithm of k-Nearest Neighbors with the Digits dataset for recognizing handwritten digits. Re-write the python program by doing the following subtasks: (a) Write code to display the two-dimensional array representing the sample image at index 24 and numeric value of the digit the image represents. (b) Write code to display the image for the sample image at index 24 of the Digits dataset. (c) For the Digits dataset, what numbers of samples would the following statement reserve for training and testing purposes? X train, X test, y train, y test = 1 train test split(digits.data, digits.target, random state=11, test size=0.60) 2 (d) Write code to get and display these numbers. (e) Rewrite the list comprehension in snippet [50] using a for loop. Hint: create an empty list and then use the built-in function “append”. Grading Rubric – 15 points for finishing Task2(a)-(e). – 5 points for appropriate comments. – 20 points for a runnable rewritten python program – 10 points for screenshots of the program. 

unit 9 db#1 + responses

 Initial post + 2 Reponses to classmates, see attached .

Computer attacks have gotten more common as time has gone by. How do you recognize that your systems have been attacked and how do you respond?

Topic 1: Malware

What would you do if you suspected malware on an organizational computer? Please use outside research to back up what you say and be sure to cite your sources.

INTERNSHIP AT THE RAM & SONS AUTO INC

 

Each week you are to enter content into an online journal provided in Blackboard that briefly summarizes (1) the tasks you performed during your internship that week and (2) total hours worked with days/times. The content can be brief and in outline form and use bullet or another list styling, but keep in mind that this content will form the basis of the two major papers that you will write for this course. Therefore, the more detailed you are in your weekly journal, the easier it will be to finish the two papers. Specifically, your weekly journal should contain: 

• The days and times you worked that week, as well as the total hours, worked. (Provide this information at the top of each weekly section so this will act as a de facto heading to separate each weekly entry that you make.) 

• The skills or skillsets used/required to complete each task 

• Each task you performed along with a brief description of what you did.

 • A brief explanation of why the task needed to be done.

 • Was there an outcome? If so, what was that outcome?

 • What new terminology did you learn this week? Provide the term and its definition.

excel test

QUESTION 1

  1. The ways that HLOOKUP formula works is searching down instead of across data. True
    False

0.9 points   

QUESTION 2

  1. The AND formula takes a list of Booleans and returns TRUE if all of them are true, and FALSE otherwise. True
    False

0.9 points   

QUESTION 3

  1. How would Excel evaluate the following formula? =OR(7<5, A2=6,NOT("zebra"<="tree"))? Assume that the formula is in cell D4, the workbook contains no circular references, and outside of cell D4 the workbook contains no errors.TRUEFALSEIt would return an errorThere is insufficient information to answer this question

1.4 points   

QUESTION 4

  1. One of the benefits of using the Table feature is that you’ll be able to see the column titles at every moment. True
    False

0.9 points   

QUESTION 5

  1. Use the brewery.xlsx file to answer the following question: How many total transactions took place at Beerland Amherst?3527425844258542194315939

0.9 points   

QUESTION 6

  1. Use the file Code_Enforcement_-_Building_and_Property_Violations.xlsx for this question.
    What is the total dollar amount of penalties for closed cases in Charlestown due to residents’ improper storage of trash (improper storage trash:res)?

1.4 points   

QUESTION 7

  1. Use the Brewery.xlsx file to answer the following question: What s the name of the beer with the highest Alcohol by Volume (ABV)?Half LordGear ShiftSheep MojoRed Salty HoserGnu Breath

0.9 points   

QUESTION 8

  1. The PivotTable functionality is located in the Data tab. True
    False

0.9 points   

QUESTION 9

  1. Use the Brewery.xlsx file to answer the following question: How many beers product names have order quantities between 3000 and 12000?75689

1.4 points   

QUESTION 10

  1. Which of the following functions returns a range of cells?OFFSETCOUNTAMATCHREDEFINENone of the given choices

0.9 points   

QUESTION 11

  1. A named range can be usedwhen creating chartsin formulasin functionsnone of the given choicesall of the given choices

0.9 points   

QUESTION 12

  1. Which of the following statements is correct if new data will be attached as a new row to the existing table?OFFSET( base cell, 0, 0, 1, COUNTA (larger range in row where potential data may appear) )OFFSET( base cell, 0, 0, COUNTA (larger range in row where potential data may appear),1)OFFSET( base cell, COUNTA (larger range in row where potential data may appear), 0, 0,1)OFFSET( base cell, 0, COUNTA (larger range in row where potential data may appear), 0,1)None of the given choices

1.4 points   

QUESTION 13

  1. One of the primarily characteristics of Solver is the mathematical relationship between the objective, the constraints, and the decision variables. True
    False

0.9 points   

QUESTION 14

  1. The Solver and Analysis Toolpak Add-ins are not built in to Excel. True
    False

0.9 points   

QUESTION 15

  1. Use solver to answer the following question: A manufacturing concern wishes to minimize its shipping costs between its 4 factories and 3 warehouses. Factory 1 supplies 1000 units per week and costs $5, $3, and $4 to ship each unit to Warehouses 1, 2, and 3 respectively. Factory 2 supplies 1200 units each week and costs $4, $3, and $3 to ship to Warehouses 1, 2, and 3. Factory 3 supplies 1500 units and costs $6, $2, and $5 to ship to the three warehouses. Factory 4 supplies 1800 units and costs $6, $2, and $4.
    If Warehouse 1 requires 3000 units per week, Warehouse 2 demands 1000, and Warehouse 3 demands 1500, what is the minimum it would cost them in shipping to fulfill each warehouse’s demand?