InstructionsScenario A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet that contains the following information: A listing of the jobs by title The salary (in dollars) for each job The client needs the preliminary findings by the end of the day, and your boss asks you to first compute some basic statistics.Background information on the DataThe data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Minnesota.What to SubmitYour boss wants you to submit the spreadsheet with the completed calculations. Your research and analysis should be present within the answers provided on the worksheet.

Part 2: Problem Solving - Consolidated FinancialsAssume that on 1/1/X0, a parent company acquires a 70% interest in its subsidiary for a price at $480,000 over book value. The excess is assigned as follows:AssetFair ValueUseful LifePatent$320,0008 yearsGoodwill160,000Indefinite70% of the goodwill is allocated to the parent. Included in the attached Excel spreadsheet are the pre-consolidation financial statements for both the parent and the subsidiary.Submission Requirements:Using the ACT470_Mod08-Portfolio_Option01.xlsx Excel spreadsheet in the Module 8 folder:Prepare the consolidated financial statements at 12/31/X6 by placing the appropriate entries in their respective debit/credit column cells.Indicate, in the blank column cell to the left of the debit and credit column cells if the entry is a [C], [E], [A], [D] or [I]entry.Use Excel formulas to derive the Consolidated column amounts and totals.Using the “Home” key in Excel, go to the “Styles” area and highlight the [C], [E], [A], [D] or [I]entry cells in different shades.I got some of the assignment completed but I keep confusing myself. I have attached what I have figured out so far and the original document without any of my work on it.