Full Instructions is in the attached documents Part I: Scenario: You are a policy analyst working for the Federal Government. You have been tasked with identifying if there is a gap in the future when it comes to the salaries for male and female employees in the industry. In addition, you will evaluate the ethical rules applicable to the IT industry that this gap might violate. You will use logical reasoning to list, step-by-step, the possible unethical results if the gap does exist. You are using the public dataset, available from one of the largest online job boards. You decided to use the multiple linear regression model for prediction. Locate the combined dataset. PT II You will compose a Python script and a one- or two-page report. Please note that if you are using PyCharm, you will need to save all your plots as .png files and submit them among the deliverables; if you are using Jupyter, you don’t need to do that. The requirements are as follows:
Part 1 – Data Tables Using the spreadsheet file that you created in Module 1, identify the food items, for which portion amounts are recorded as greater than ‘1’ in your food log. In a new sheet, create one-variable data tables for these food items. Data tables should calculate the amounts of calories relevant to the number of portions. The input values for the number of portions should run between ‘1’ and the value recorded in your food log. For example, if the number of portions for some food item has been recorded as ‘5’ in your food log, then input values in a data table would be integers from 1 to 5. For each previously selected food item, create a two-variable data table that calculates the amounts of calories based on various portion sizes and the number of portions. As in the previous step, the maximum number of portions should agree with the corresponding value of the item in your food log. Note: Refer to the Food Table sheet from Module 1 for alternative portion sizes for considered food items. Part 2 – Scenarios Using Scenario Manager, create a set of scenarios for projecting the results of calculations in your food log table. Note: Save the initial values as “Original values” scenario. Next, in a new sheet, generate a scenario summary report. Part 3 – Summary Report In a document, using 3-4 sentences, explain the role of one and two-variable data tables in a data analysis process as applied to your model. Briefly describe your approach for building scenarios. Clarify whether you chose to eliminate certain food items from your menu or to reduce the portion sizes, and why. In 3-4 sentences, discuss whether a scenario summary report contains all information necessary for making an adequate decision. Submit both the Excel workbook and a Word document for this activity.