So there are three tasks so I will be needing help to complete them.Task 1:I have attached an excel below. Review the attached file. Suzie has an issue. She can either move to NY or FL and needs to review some data that her agent gave her. The agent reviewed house prices and crime ratings for houses that Suzie would be interested in based on her selection criteria. She wants to live in an area with lower crime but wants to know a few things:Is it more expensive or less expensive to live in FL or NY?Is the crime rate higher in FL or NY (Note a low score in crime means lower crime)?Is the crime rate higher in lower or higher house price areas?Using the R tool, show the data in the tool to answer each of the questions. Also, show the data visualization to go along with the summary.If you were Suzie, where would you move based on the questions above?After you gave Suzie the answer above (to #4), she gave you some additional information that you need to consider:She has $100,000 to put down for the house.If she moves to NY she will have a job earning $120,000 per year.If she moves to FL she will have a job earning $75,000 per year.She wants to know the following:On average what location will she be able to pay off her house first based on average housing prices and income she will receive?Where should she move and why? Please show graphics and thoroughly explain your answer here based on the new information provided above.Note: The screenshots should be copied and pasted and must be legible. Only upload the word document. Be sure to answer all of the questions above and number the answers. Be sure to also explain the rational for each answer and also ensure that there are visuals for each question above. Use at least two peer reviewed sources to support your work. Task 2: Answer Six questions from the book in an apa format with references. The questions are displayed below. The book will be provided by me.

Details:The purpose of this assignment is to create a data story and communicate findings to key stakeholders.Part 1: For this assignment, you will use the "Arizona Incomes by Zip Code" dataset. You will use Tableau to create a data story that illustrates the median household incomes of Arizona residents. The data provided includes all zip codes in Arizona. Each record is a unique zip code. The data includes the following columns:Zip_Code: An Arizona zip code.Metro_Area: Whether or not the zip code is within the Phoenix-metro area.City: The city name of the zip code.Median_Income: The median household income of each zip code based on 5-year estimates (2010-2014) from the U.S. Census Bureau.The marketing manager has asked you to analyze income data for Arizona residents so that leaders in his department can determine the company's advertising strategy. The marketing manager intends to share this data with other decisions makers and the marketing department staff so that everyone has a thorough understanding of how the income information can be used to determine specific target markets in upcoming advertising campaigns. Because most of these individuals do not have a strong understanding of analytics, they must be able gain the information listed below from studying the charts. In the data story, use visualizations, heat maps, boxplots, etc. to describe the following:How do incomes differ across zip codes within the Phoenix-metro area (using geo-mapping)?What is the relative difference in incomes across zip codes within the Phoenix-metro area (use a heat map)?What are the distribution of incomes across Arizona?How do incomes within the Phoenix metro area differ from those outside of that area?Part 2: Demonstrate the ability to communicate the analytics story to key stakeholders, including the marketing manager, by creating a 6-10 slide PowerPoint presentation (with speaker notes for each slide). Use the charts generated in Tableau to illustrate the data story as it relates to the income of Arizona residents. The slides and speaker notes should address the following for each chart presented.What information is the chart providing to stakeholders?Why is the information in the chart important to key stakeholders?How can this information be used in making decisions about how marketing dollars can be allocated?Refer to the resource, "Creating Effective PowerPoint Presentations," located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.While APA format is not required for the body of this assignment solid academic writing is expected, and documentation of sources should be presented using APA formatting, guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

Week 13 i) In Chapter 11, you created an interactive RentalDemo class that obtains all the data for four rentals from Sammy's Seashore Rentals, including details about the contract number, length of the rental, and equipment type. Now, modify the class so that it becomes immune to user data entry errors by handling exceptions for each numeric entry. Each time the program requires numeric data—for example, for the rental period—continuously prompt the user until the data entered is the correct type. Save the revised program as RentalDemo.java. Create a zip file of the .java file(s) and submit the assignment. ii) a. In Chapter 12, you created an interactive RentalDemo class that obtains all the data for four rentals from Sammy's Seashore Rentals, including details about the contract number, length of the rental, and equipment type. Now, modify the program to create a data file that contains each contract number, rental time in hours and minutes, equipment type code and name, and price. Save the program as RentalDemoAndCreateFile.java. b. Write a program that displays the data saved in the file created in part 2a. Save the program as DisplayRentalFile.java. Create a zip file of the .java file(s) and submit the assignment. Week 14 i) In previous chapters, you have created a number of programs for Carly's Catering. Now, create an interactive GUI program that allows the user to enter the number of guests for an event into a text field; if the value entered is not numeric, set the event price to 0. Also allow the user to choose one entree from a group of at least four choices, up to two side dishes from a group of at least four choices, and one dessert from a group of at least three choices. Display the cost of the event as $35 per person; as the user continues to make selection changes, display a list of the current items chosen. If a user attempts to choose more than two side dishes, remove all the current side dish selections so that the user can start over. Save the program as JCarlysCatering.java. Create a zip file of the .java file(s) and submit the assignment. ii) . In previous chapters, you have created a number of programs for Sammy's Seashore Rentals. Now, create an interactive GUI program that allows the user to enter a rental time in hours into a text field; if the value entered is not numeric, set the rental price to 0. Also allow the user to choose one equipment type to rent from a group of seven choices. The rental fee is $40 per hour for a personal watercraft or pontoon boat; $20 per hour for a rowboat, canoe, or kayak; and $7 per hour for a beach chair or umbrella. Let the user add an equipment lesson for an extra $5. Display a message that indicates all the details for the rental, including the total price. Save the program as JSammysSeashore.java. Create a zip file of the .java file(s) and submit the assignment.